eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_UTILITIES_PKG dependencies on FND_MESSAGE

Line 277: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');

273: EXCEPTION
274: WHEN OTHERS THEN
275: --AP_LOGGING_PKG.AP_End_Block(l_debug_loc);
276: IF (SQLCODE <> -20001) THEN
277: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
278: FND_MESSAGE.SET_TOKEN('ERROR', 'SQLERRM');
279: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
280: FND_MESSAGE.SET_TOKEN('PARAMETERS',
281: 'Amount to Round = '||to_char(p_amount)

Line 278: FND_MESSAGE.SET_TOKEN('ERROR', 'SQLERRM');

274: WHEN OTHERS THEN
275: --AP_LOGGING_PKG.AP_End_Block(l_debug_loc);
276: IF (SQLCODE <> -20001) THEN
277: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
278: FND_MESSAGE.SET_TOKEN('ERROR', 'SQLERRM');
279: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
280: FND_MESSAGE.SET_TOKEN('PARAMETERS',
281: 'Amount to Round = '||to_char(p_amount)
282: ||', Currency Code = '||p_currency_code

Line 279: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);

275: --AP_LOGGING_PKG.AP_End_Block(l_debug_loc);
276: IF (SQLCODE <> -20001) THEN
277: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
278: FND_MESSAGE.SET_TOKEN('ERROR', 'SQLERRM');
279: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
280: FND_MESSAGE.SET_TOKEN('PARAMETERS',
281: 'Amount to Round = '||to_char(p_amount)
282: ||', Currency Code = '||p_currency_code
283: ||', Rounding Rule = '||p_round_rule);

Line 280: FND_MESSAGE.SET_TOKEN('PARAMETERS',

276: IF (SQLCODE <> -20001) THEN
277: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
278: FND_MESSAGE.SET_TOKEN('ERROR', 'SQLERRM');
279: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
280: FND_MESSAGE.SET_TOKEN('PARAMETERS',
281: 'Amount to Round = '||to_char(p_amount)
282: ||', Currency Code = '||p_currency_code
283: ||', Rounding Rule = '||p_round_rule);
284: END IF;

Line 358: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');

354: EXCEPTION
355: WHEN OTHERS THEN
356: --AP_LOGGING_PKG.AP_End_Block(l_debug_loc);
357: IF (SQLCODE <> -20001) THEN
358: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
359: FND_MESSAGE.SET_TOKEN('ERROR', 'SQLERRM');
360: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence
361: );
362: FND_MESSAGE.SET_TOKEN('PARAMETERS',

Line 359: FND_MESSAGE.SET_TOKEN('ERROR', 'SQLERRM');

355: WHEN OTHERS THEN
356: --AP_LOGGING_PKG.AP_End_Block(l_debug_loc);
357: IF (SQLCODE <> -20001) THEN
358: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
359: FND_MESSAGE.SET_TOKEN('ERROR', 'SQLERRM');
360: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence
361: );
362: FND_MESSAGE.SET_TOKEN('PARAMETERS',
363: 'Amount to Round = '||to_char(p_amount)

Line 360: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence

356: --AP_LOGGING_PKG.AP_End_Block(l_debug_loc);
357: IF (SQLCODE <> -20001) THEN
358: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
359: FND_MESSAGE.SET_TOKEN('ERROR', 'SQLERRM');
360: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence
361: );
362: FND_MESSAGE.SET_TOKEN('PARAMETERS',
363: 'Amount to Round = '||to_char(p_amount)
364: ||', Currency Code = '||p_currency_code

Line 362: FND_MESSAGE.SET_TOKEN('PARAMETERS',

358: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
359: FND_MESSAGE.SET_TOKEN('ERROR', 'SQLERRM');
360: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence
361: );
362: FND_MESSAGE.SET_TOKEN('PARAMETERS',
363: 'Amount to Round = '||to_char(p_amount)
364: ||', Currency Code = '||p_currency_code
365: ||', Rounding Rule = '||p_round_rule);
366: END IF;

Line 700: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');

696: query. Therefore, I am commenting it out NOCOPY and simply
697: returning null if no record is retrieved.
698:
699: if (SQLCODE <> -20001) then
700: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
701: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
702: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
703: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_from_currency_code = '||p_from_currency_code
704: ||', p_to_currency_code = '||p_to_currency_code

Line 701: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);

697: returning null if no record is retrieved.
698:
699: if (SQLCODE <> -20001) then
700: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
701: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
702: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
703: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_from_currency_code = '||p_from_currency_code
704: ||', p_to_currency_code = '||p_to_currency_code
705: ||', p_exchange_rate_type = ' ||p_exchange_rate_type

Line 702: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);

698:
699: if (SQLCODE <> -20001) then
700: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
701: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
702: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
703: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_from_currency_code = '||p_from_currency_code
704: ||', p_to_currency_code = '||p_to_currency_code
705: ||', p_exchange_rate_type = ' ||p_exchange_rate_type
706: ||', p_exchange_date = ' ||TO_CHAR(p_exchange_date));

Line 703: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_from_currency_code = '||p_from_currency_code

699: if (SQLCODE <> -20001) then
700: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
701: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
702: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
703: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_from_currency_code = '||p_from_currency_code
704: ||', p_to_currency_code = '||p_to_currency_code
705: ||', p_exchange_rate_type = ' ||p_exchange_rate_type
706: ||', p_exchange_date = ' ||TO_CHAR(p_exchange_date));
707: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);

Line 707: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);

703: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_from_currency_code = '||p_from_currency_code
704: ||', p_to_currency_code = '||p_to_currency_code
705: ||', p_exchange_rate_type = ' ||p_exchange_rate_type
706: ||', p_exchange_date = ' ||TO_CHAR(p_exchange_date));
707: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
708: end if;
709: APP_EXCEPTION.RAISE_EXCEPTION;
710: */
711: return(l_rate);

Line 735: p_err_txt := fnd_message.get;

731:
732: PROCEDURE AP_Get_Message(p_err_txt OUT NOCOPY VARCHAR2) IS
733: BEGIN
734:
735: p_err_txt := fnd_message.get;
736:
737: END AP_Get_Message;
738:
739: --MO Access Control: Added the following new function for the

Line 939: l_reason_unbuilt_flex := FND_MESSAGE.GET;

935:
936:
937:
938: IF (l_segment_delimiter IS NULL) THEN
939: l_reason_unbuilt_flex := FND_MESSAGE.GET;
940: END IF;
941:
942: -- Get Segment array for the input ccid
943: --

Line 958: l_reason_unbuilt_flex := FND_MESSAGE.GET;

954: l_segments);
955:
956:
957: IF (NOT l_result) THEN
958: l_reason_unbuilt_flex := FND_MESSAGE.GET;
959: END IF;
960:
961: END IF; -- l_ccid not null
962: --

Line 970: l_reason_unbuilt_flex := FND_MESSAGE.GET;

966: l_segments,
967: l_segment_delimiter);
968:
969: IF (NOT l_result) THEN
970: l_reason_unbuilt_flex := FND_MESSAGE.GET;
971: l_ccid := -1;
972: END IF;
973:
974: p_ccid := l_ccid;

Line 1046: l_reason_unbuilt_flex := FND_MESSAGE.GET;

1042: l_account_segment_num);
1043:
1044:
1045: IF (NOT l_result) THEN
1046: l_reason_unbuilt_flex := FND_MESSAGE.GET;
1047: END IF;
1048:
1049:
1050: l_result := FND_FLEX_KEY_API.GET_SEG_ORDER_BY_QUAL_NAME(

Line 1059: l_reason_unbuilt_flex := FND_MESSAGE.GET;

1055: l_balancing_segment_num);
1056:
1057:
1058: IF (NOT l_result) THEN
1059: l_reason_unbuilt_flex := FND_MESSAGE.GET;
1060: END IF;
1061:
1062:
1063: l_result := FND_FLEX_KEY_API.GET_SEG_ORDER_BY_QUAL_NAME(

Line 1072: l_reason_unbuilt_flex := FND_MESSAGE.GET;

1068: l_cost_center_segment_num);
1069:
1070:
1071: IF (NOT l_result) THEN
1072: l_reason_unbuilt_flex := FND_MESSAGE.GET;
1073: END IF;
1074:
1075:
1076:

Line 1112: l_reason_unbuilt_flex := FND_MESSAGE.GET;

1108: l_segments,
1109: l_segment_delimiter);
1110:
1111: IF (NOT l_result) THEN
1112: l_reason_unbuilt_flex := FND_MESSAGE.GET;
1113: END IF;
1114:
1115:
1116:

Line 1249: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');

1245: WHEN OTHERS THEN
1246:
1247:
1248: if (SQLCODE <> -20001) then
1249: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
1250: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
1251: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
1252: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
1253: end if;

Line 1250: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);

1246:
1247:
1248: if (SQLCODE <> -20001) then
1249: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
1250: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
1251: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
1252: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
1253: end if;
1254:

Line 1251: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);

1247:
1248: if (SQLCODE <> -20001) then
1249: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
1250: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
1251: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
1252: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
1253: end if;
1254:
1255:

Line 1252: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);

1248: if (SQLCODE <> -20001) then
1249: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
1250: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
1251: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
1252: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
1253: end if;
1254:
1255:
1256: RETURN(FALSE);

Line 1327: l_reason_unbuilt_flex := FND_MESSAGE.GET;

1323:
1324:
1325:
1326: IF (l_segment_delimiter IS NULL) THEN
1327: l_reason_unbuilt_flex := FND_MESSAGE.GET;
1328: END IF;
1329:
1330: -- Get Segment array for the input ccid
1331: --

Line 1346: l_reason_unbuilt_flex := FND_MESSAGE.GET;

1342: l_segments);
1343:
1344:
1345: IF (NOT l_result) THEN
1346: l_reason_unbuilt_flex := FND_MESSAGE.GET;
1347: END IF;
1348:
1349: END IF; -- l_ccid not null
1350: --

Line 1358: l_reason_unbuilt_flex := FND_MESSAGE.GET;

1354: l_segments,
1355: l_segment_delimiter);
1356:
1357: IF (NOT l_result) THEN
1358: l_reason_unbuilt_flex := FND_MESSAGE.GET;
1359: l_ccid := -1;
1360: END IF;
1361:
1362: p_ccid := l_ccid;

Line 1434: l_reason_unbuilt_flex := FND_MESSAGE.GET;

1430: l_account_segment_num);
1431:
1432:
1433: IF (NOT l_result) THEN
1434: l_reason_unbuilt_flex := FND_MESSAGE.GET;
1435: END IF;
1436:
1437:
1438: l_result := FND_FLEX_KEY_API.GET_SEG_ORDER_BY_QUAL_NAME(

Line 1447: l_reason_unbuilt_flex := FND_MESSAGE.GET;

1443: l_balancing_segment_num);
1444:
1445:
1446: IF (NOT l_result) THEN
1447: l_reason_unbuilt_flex := FND_MESSAGE.GET;
1448: END IF;
1449:
1450:
1451: l_result := FND_FLEX_KEY_API.GET_SEG_ORDER_BY_QUAL_NAME(

Line 1460: l_reason_unbuilt_flex := FND_MESSAGE.GET;

1456: l_cost_center_segment_num);
1457:
1458:
1459: IF (NOT l_result) THEN
1460: l_reason_unbuilt_flex := FND_MESSAGE.GET;
1461: END IF;
1462:
1463:
1464:

Line 1500: l_reason_unbuilt_flex := FND_MESSAGE.GET;

1496: l_segments,
1497: l_segment_delimiter);
1498:
1499: IF (NOT l_result) THEN
1500: l_reason_unbuilt_flex := FND_MESSAGE.GET;
1501: END IF;
1502:
1503:
1504:

Line 1631: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');

1627: WHEN OTHERS THEN
1628:
1629:
1630: if (SQLCODE <> -20001) then
1631: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
1632: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
1633: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
1634: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
1635: end if;

Line 1632: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);

1628:
1629:
1630: if (SQLCODE <> -20001) then
1631: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
1632: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
1633: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
1634: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
1635: end if;
1636:

Line 1633: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);

1629:
1630: if (SQLCODE <> -20001) then
1631: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
1632: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
1633: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
1634: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
1635: end if;
1636:
1637:

Line 1634: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);

1630: if (SQLCODE <> -20001) then
1631: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
1632: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
1633: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
1634: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
1635: end if;
1636:
1637:
1638: RETURN(FALSE);

Line 1685: p_error_message:= FND_MESSAGE.GET;

1681:
1682:
1683:
1684: IF (l_segment_delimiter IS NULL) THEN
1685: p_error_message:= FND_MESSAGE.GET;
1686: END IF;
1687:
1688: debug_info := 'Break Segments';
1689: l_num_segments := FND_FLEX_EXT.breakup_segments(p_concatenated_segments,

Line 1715: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');

1711:
1712: WHEN OTHERS THEN
1713:
1714: if (SQLCODE <> -20001) then
1715: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
1716: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
1717: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
1718: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
1719: end if;

Line 1716: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);

1712: WHEN OTHERS THEN
1713:
1714: if (SQLCODE <> -20001) then
1715: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
1716: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
1717: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
1718: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
1719: end if;
1720: RETURN(FALSE);

Line 1717: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);

1713:
1714: if (SQLCODE <> -20001) then
1715: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
1716: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
1717: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
1718: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
1719: end if;
1720: RETURN(FALSE);
1721:

Line 1718: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);

1714: if (SQLCODE <> -20001) then
1715: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
1716: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
1717: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
1718: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
1719: end if;
1720: RETURN(FALSE);
1721:
1722: END Check_partial;

Line 1802: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');

1798:
1799: WHEN OTHERS THEN
1800:
1801: if (SQLCODE <> -20001) then
1802: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
1803: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
1804: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
1805: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
1806: end if;

Line 1803: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);

1799: WHEN OTHERS THEN
1800:
1801: if (SQLCODE <> -20001) then
1802: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
1803: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
1804: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
1805: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
1806: end if;
1807: RETURN(FALSE);

Line 1804: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);

1800:
1801: if (SQLCODE <> -20001) then
1802: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
1803: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
1804: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
1805: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
1806: end if;
1807: RETURN(FALSE);
1808:

Line 1805: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);

1801: if (SQLCODE <> -20001) then
1802: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
1803: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
1804: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
1805: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
1806: end if;
1807: RETURN(FALSE);
1808:
1809: END IS_CCID_VALID;

Line 1881: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');

1877:
1878: p_mc_flag_enabled := NULL;
1879:
1880: if (SQLCODE <> -20001) then
1881: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
1882: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
1883: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
1884: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
1885: end if;

Line 1882: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);

1878: p_mc_flag_enabled := NULL;
1879:
1880: if (SQLCODE <> -20001) then
1881: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
1882: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
1883: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
1884: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
1885: end if;
1886:

Line 1883: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);

1879:
1880: if (SQLCODE <> -20001) then
1881: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
1882: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
1883: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
1884: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
1885: end if;
1886:
1887: END mc_flag_enabled;

Line 1884: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);

1880: if (SQLCODE <> -20001) then
1881: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
1882: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
1883: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
1884: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
1885: end if;
1886:
1887: END mc_flag_enabled;
1888:

Line 1928: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');

1924: EXCEPTION
1925: WHEN OTHERS THEN
1926:
1927: if (SQLCODE <> -20001) then
1928: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
1929: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
1930: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
1931: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
1932: end if;

Line 1929: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);

1925: WHEN OTHERS THEN
1926:
1927: if (SQLCODE <> -20001) then
1928: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
1929: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
1930: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
1931: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
1932: end if;
1933: return NULL;

Line 1930: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);

1926:
1927: if (SQLCODE <> -20001) then
1928: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
1929: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
1930: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
1931: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
1932: end if;
1933: return NULL;
1934:

Line 1931: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);

1927: if (SQLCODE <> -20001) then
1928: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
1929: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
1930: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
1931: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
1932: end if;
1933: return NULL;
1934:
1935: end AP_Get_Sob_Order_Col;

Line 1970: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');

1966: EXCEPTION
1967: WHEN OTHERS THEN
1968:
1969: if (SQLCODE <> -20001) then
1970: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
1971: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
1972: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
1973: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
1974: end if;

Line 1971: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);

1967: WHEN OTHERS THEN
1968:
1969: if (SQLCODE <> -20001) then
1970: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
1971: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
1972: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
1973: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
1974: end if;
1975: return NULL;

Line 1972: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);

1968:
1969: if (SQLCODE <> -20001) then
1970: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
1971: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
1972: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
1973: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
1974: end if;
1975: return NULL;
1976:

Line 1973: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);

1969: if (SQLCODE <> -20001) then
1970: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
1971: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
1972: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
1973: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
1974: end if;
1975: return NULL;
1976:
1977: END get_charge_account;

Line 2153: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');

2149: RETURN(invoice_status);
2150: EXCEPTION
2151: WHEN OTHERS THEN
2152: if (SQLCODE <> -20001) then
2153: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
2154: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
2155: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
2156: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2157: 'Invoice id = '||to_char(p_invoice_id)

Line 2154: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);

2150: EXCEPTION
2151: WHEN OTHERS THEN
2152: if (SQLCODE <> -20001) then
2153: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
2154: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
2155: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
2156: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2157: 'Invoice id = '||to_char(p_invoice_id)
2158: ||', Org id = '||l_org_id

Line 2155: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);

2151: WHEN OTHERS THEN
2152: if (SQLCODE <> -20001) then
2153: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
2154: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
2155: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
2156: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2157: 'Invoice id = '||to_char(p_invoice_id)
2158: ||', Org id = '||l_org_id
2159: ||', Encumbrance flag = '||encumbrance_flag);

Line 2156: FND_MESSAGE.SET_TOKEN('PARAMETERS',

2152: if (SQLCODE <> -20001) then
2153: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
2154: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
2155: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
2156: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2157: 'Invoice id = '||to_char(p_invoice_id)
2158: ||', Org id = '||l_org_id
2159: ||', Encumbrance flag = '||encumbrance_flag);
2160: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

Line 2160: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

2156: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2157: 'Invoice id = '||to_char(p_invoice_id)
2158: ||', Org id = '||l_org_id
2159: ||', Encumbrance flag = '||encumbrance_flag);
2160: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2161: end if;
2162: APP_EXCEPTION.RAISE_EXCEPTION;
2163: END get_invoice_status;
2164: ---------------------------------------------------------------------

Line 2626: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');

2622: return TRUE;
2623: EXCEPTION
2624: WHEN OTHERS THEN
2625: if (SQLCODE <> -20001) then
2626: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
2627: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
2628: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
2629: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
2630: end if;

Line 2627: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);

2623: EXCEPTION
2624: WHEN OTHERS THEN
2625: if (SQLCODE <> -20001) then
2626: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
2627: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
2628: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
2629: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
2630: end if;
2631: RETURN(FALSE);

Line 2628: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);

2624: WHEN OTHERS THEN
2625: if (SQLCODE <> -20001) then
2626: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
2627: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
2628: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
2629: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
2630: end if;
2631: RETURN(FALSE);
2632: END delete_invoice_from_interface ;

Line 2629: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);

2625: if (SQLCODE <> -20001) then
2626: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
2627: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
2628: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
2629: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
2630: end if;
2631: RETURN(FALSE);
2632: END delete_invoice_from_interface ;
2633:

Line 2783: FND_MESSAGE.SET_NAME('SQLAP', 'AP_CANCEL_NO_OPEN_FUT_PERIOD');

2779: end if;
2780: return l_open_gl_date;
2781: EXCEPTION
2782: WHEN NO_DATA_FOUND THEN
2783: FND_MESSAGE.SET_NAME('SQLAP', 'AP_CANCEL_NO_OPEN_FUT_PERIOD');
2784: FND_MESSAGE.SET_TOKEN('DATE', to_char(p_date, 'dd-mon-yyyy'));
2785: APP_EXCEPTION.RAISE_EXCEPTION;
2786: End get_reversal_gl_date;
2787:

Line 2784: FND_MESSAGE.SET_TOKEN('DATE', to_char(p_date, 'dd-mon-yyyy'));

2780: return l_open_gl_date;
2781: EXCEPTION
2782: WHEN NO_DATA_FOUND THEN
2783: FND_MESSAGE.SET_NAME('SQLAP', 'AP_CANCEL_NO_OPEN_FUT_PERIOD');
2784: FND_MESSAGE.SET_TOKEN('DATE', to_char(p_date, 'dd-mon-yyyy'));
2785: APP_EXCEPTION.RAISE_EXCEPTION;
2786: End get_reversal_gl_date;
2787:
2788: --Bug2610252 The function get_reversal_period is added to get

Line 2818: FND_MESSAGE.SET_NAME('SQLAP', 'AP_CANCEL_NO_OPEN_FUT_PERIOD');

2814: end if;
2815: return l_period_name;
2816: EXCEPTION
2817: WHEN NO_DATA_FOUND THEN
2818: FND_MESSAGE.SET_NAME('SQLAP', 'AP_CANCEL_NO_OPEN_FUT_PERIOD');
2819: FND_MESSAGE.SET_TOKEN('DATE', to_char(p_date, 'dd-mon-yyyy'));
2820: APP_EXCEPTION.RAISE_EXCEPTION;
2821: End get_reversal_period;
2822:

Line 2819: FND_MESSAGE.SET_TOKEN('DATE', to_char(p_date, 'dd-mon-yyyy'));

2815: return l_period_name;
2816: EXCEPTION
2817: WHEN NO_DATA_FOUND THEN
2818: FND_MESSAGE.SET_NAME('SQLAP', 'AP_CANCEL_NO_OPEN_FUT_PERIOD');
2819: FND_MESSAGE.SET_TOKEN('DATE', to_char(p_date, 'dd-mon-yyyy'));
2820: APP_EXCEPTION.RAISE_EXCEPTION;
2821: End get_reversal_period;
2822:
2823: /* =======================================================================*/

Line 2986: fnd_message.parse_encoded(l_errmsg, l_app_short_name, l_message_name);

2982: p_debug_info := debug_info || ': Error encountered';*/
2983:
2984: --start bug 8980626
2985: /*p_debug_info := l_errmsg;*/ --bug 8320268
2986: fnd_message.parse_encoded(l_errmsg, l_app_short_name, l_message_name);
2987: fnd_message.set_name(l_app_short_name, l_message_name);
2988: p_debug_info := fnd_message.get;
2989: --end bug 8980626
2990:

Line 2987: fnd_message.set_name(l_app_short_name, l_message_name);

2983:
2984: --start bug 8980626
2985: /*p_debug_info := l_errmsg;*/ --bug 8320268
2986: fnd_message.parse_encoded(l_errmsg, l_app_short_name, l_message_name);
2987: fnd_message.set_name(l_app_short_name, l_message_name);
2988: p_debug_info := fnd_message.get;
2989: --end bug 8980626
2990:
2991: p_debug_Context := current_calling_sequence;

Line 2988: p_debug_info := fnd_message.get;

2984: --start bug 8980626
2985: /*p_debug_info := l_errmsg;*/ --bug 8320268
2986: fnd_message.parse_encoded(l_errmsg, l_app_short_name, l_message_name);
2987: fnd_message.set_name(l_app_short_name, l_message_name);
2988: p_debug_info := fnd_message.get;
2989: --end bug 8980626
2990:
2991: p_debug_Context := current_calling_sequence;
2992: RETURN(FALSE);

Line 3057: fnd_message.parse_encoded(l_errmsg, l_app_short_name, l_message_name);

3053: p_debug_info := debug_info || ': Error encountered';*/
3054:
3055: --start bug 8980626
3056: /*p_debug_info := l_errmsg;*/ --bug 8320268
3057: fnd_message.parse_encoded(l_errmsg, l_app_short_name, l_message_name);
3058: fnd_message.set_name(l_app_short_name, l_message_name);
3059: p_debug_info := fnd_message.get;
3060: --end bug 8980626
3061:

Line 3058: fnd_message.set_name(l_app_short_name, l_message_name);

3054:
3055: --start bug 8980626
3056: /*p_debug_info := l_errmsg;*/ --bug 8320268
3057: fnd_message.parse_encoded(l_errmsg, l_app_short_name, l_message_name);
3058: fnd_message.set_name(l_app_short_name, l_message_name);
3059: p_debug_info := fnd_message.get;
3060: --end bug 8980626
3061:
3062: p_debug_Context := current_calling_sequence;

Line 3059: p_debug_info := fnd_message.get;

3055: --start bug 8980626
3056: /*p_debug_info := l_errmsg;*/ --bug 8320268
3057: fnd_message.parse_encoded(l_errmsg, l_app_short_name, l_message_name);
3058: fnd_message.set_name(l_app_short_name, l_message_name);
3059: p_debug_info := fnd_message.get;
3060: --end bug 8980626
3061:
3062: p_debug_Context := current_calling_sequence;
3063: RETURN(FALSE);

Line 3771: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

3767:
3768: EXCEPTION
3769: WHEN OTHERS THEN
3770: IF (SQLCODE <> -20001 ) THEN
3771: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3772: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3773: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence);
3774: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
3775:

Line 3772: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

3768: EXCEPTION
3769: WHEN OTHERS THEN
3770: IF (SQLCODE <> -20001 ) THEN
3771: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3772: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3773: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence);
3774: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
3775:
3776: APP_EXCEPTION.RAISE_EXCEPTION;

Line 3773: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence);

3769: WHEN OTHERS THEN
3770: IF (SQLCODE <> -20001 ) THEN
3771: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3772: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3773: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence);
3774: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
3775:
3776: APP_EXCEPTION.RAISE_EXCEPTION;
3777:

Line 3774: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );

3770: IF (SQLCODE <> -20001 ) THEN
3771: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3772: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3773: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence);
3774: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
3775:
3776: APP_EXCEPTION.RAISE_EXCEPTION;
3777:
3778: END IF;

Line 3838: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

3834:
3835: EXCEPTION
3836: WHEN OTHERS THEN
3837: IF (SQLCODE <> -20001 ) THEN
3838: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3839: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3840: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence);
3841: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
3842:

Line 3839: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

3835: EXCEPTION
3836: WHEN OTHERS THEN
3837: IF (SQLCODE <> -20001 ) THEN
3838: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3839: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3840: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence);
3841: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
3842:
3843: APP_EXCEPTION.RAISE_EXCEPTION;

Line 3840: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence);

3836: WHEN OTHERS THEN
3837: IF (SQLCODE <> -20001 ) THEN
3838: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3839: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3840: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence);
3841: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
3842:
3843: APP_EXCEPTION.RAISE_EXCEPTION;
3844:

Line 3841: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );

3837: IF (SQLCODE <> -20001 ) THEN
3838: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3839: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3840: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence);
3841: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
3842:
3843: APP_EXCEPTION.RAISE_EXCEPTION;
3844:
3845: END IF;