APPS.XTR_CSH_FCST_POP dependencies on XTR_CSH_FCST_POP

Line 1: PACKAGE BODY XTR_CSH_FCST_POP AS

1: PACKAGE BODY XTR_CSH_FCST_POP AS
2: /* $Header: xtrfpclb.pls 115.15 2003/05/12 16:58:55 rvallams ship $ */
3:
4:
5: /* ---------------------------------------------------------------------

Line 356: xtr_debug_pkg.debug('<

352: END LOOP;
353: CLOSE C1;
354: END IF;
355: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
356: xtr_debug_pkg.debug('< 357: END IF;
358: EXCEPTION
359: WHEN OTHERS THEN
360: IF C1%ISOPEN THEN CLOSE C1; END IF;

Line 669: xtr_debug_pkg.debug('>>XTR_CSH_FCST_POP.Execute_Main_Query');

665: error_msg fnd_new_messages.message_text%TYPE;
666: BEGIN
667:
668: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
669: xtr_debug_pkg.debug('>>XTR_CSH_FCST_POP.Execute_Main_Query');
670: END IF;
671:
672: cursor_id := DBMS_SQL.open_cursor;
673: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

Line 968: xtr_debug_pkg.debug('<

964:
965: Execute_Main_Query (main_query);
966:
967: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
968: xtr_debug_pkg.debug('< 969: END IF;
970: EXCEPTION
971: WHEN OTHERS THEN
972: XTR_DEBUG_PKG.DEBUG('EXCEPTION:Build_AP_Invoice_Query');

Line 1039: xtr_debug_pkg.debug('<

1035: main_query := select_clause || from_clause || where_clause ||group_clause;
1036:
1037: Execute_Main_Query (main_query);
1038: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1039: xtr_debug_pkg.debug('< 1040: END IF;
1041: EXCEPTION
1042: WHEN OTHERS THEN
1043: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

Line 1152: xtr_debug_pkg.debug('<

1148: commit;
1149:
1150: Execute_Main_Query (main_query);
1151: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1152: xtr_debug_pkg.debug('< 1153: END IF;
1154: EXCEPTION
1155: WHEN OTHERS THEN
1156: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

Line 1241: xtr_debug_pkg.debug('<

1237: main_query := select_clause || from_clause || where_clause || group_clause;
1238:
1239: Execute_Main_Query (main_query);
1240: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1241: xtr_debug_pkg.debug('< 1242: END IF;
1243:
1244: END Build_Pay_Exp_Query;
1245:

Line 1300: xtr_debug_pkg.debug('<

1296: main_query := select_clause || from_clause || where_clause || group_clause;
1297:
1298: Execute_Main_Query (main_query);
1299: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1300: xtr_debug_pkg.debug('< 1301: END IF;
1302: EXCEPTION
1303: WHEN OTHERS THEN
1304: XTR_DEBUG_PKG.DEBUG('EXCEPTION:Build_PO_Orders_Query');

Line 1361: xtr_debug_pkg.debug('<

1357: main_query := select_clause || from_clause || where_clause || group_clause;
1358:
1359: Execute_Main_Query (main_query);
1360: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1361: xtr_debug_pkg.debug('< 1362: END IF;
1363: EXCEPTION
1364: WHEN OTHERS THEN
1365: XTR_DEBUG_PKG.DEBUG('EXCEPTION:Build_PO_req_Query');

Line 1436: xtr_debug_pkg.debug('<

1432: main_query := select_clause || from_clause || where_clause || group_clause;
1433:
1434: Execute_Main_Query (main_query);
1435: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1436: xtr_debug_pkg.debug('< 1437: END IF;
1438: EXCEPTION
1439: WHEN OTHERS THEN
1440: XTR_DEBUG_PKG.DEBUG('EXCEPTION:Build_Sales_Order_Query');

Line 1597: xtr_debug_pkg.debug('<

1593: XTR_CASH_FCST.G_forecast_row_id, 'CE_FC_RMT_DB_EXCEPTION', error_msg);
1594: return;
1595: END;
1596: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1597: xtr_debug_pkg.debug('< 1598: END IF;
1599: EXCEPTION
1600: WHEN OTHERS THEN
1601: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

Line 1631: xtr_debug_pkg.debug('>>XTR_CSH_FCST_POP.Populate_Cells');

1627: -- Based on the source_trx_type call the different procedures
1628: -- to build the queries dynamically
1629: --
1630: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1631: xtr_debug_pkg.debug('>>XTR_CSH_FCST_POP.Populate_Cells');
1632: END IF;
1633:
1634: IF (XTR_CASH_FCST.G_trx_type = 'API') THEN
1635: Build_AP_Invoice_Query;

Line 1658: END XTR_CSH_FCST_POP;

1654: END IF;
1655:
1656: END Populate_Cells;
1657:
1658: END XTR_CSH_FCST_POP;
1659: