66:
67: IF (l_unexp_level >= l_debug_level) THEN
68:
69: IF (P_error_type = 'DEFAULT') THEN
70: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
71: FND_MESSAGE.SET_TOKEN('CODE',sqlcode);
72: FND_MESSAGE.SET_TOKEN('MSG',sqlerrm);
73: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igidosl.' || P_module ,TRUE);
74: ELSIF (P_error_type = 'USER') THEN
67: IF (l_unexp_level >= l_debug_level) THEN
68:
69: IF (P_error_type = 'DEFAULT') THEN
70: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
71: FND_MESSAGE.SET_TOKEN('CODE',sqlcode);
72: FND_MESSAGE.SET_TOKEN('MSG',sqlerrm);
73: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igidosl.' || P_module ,TRUE);
74: ELSIF (P_error_type = 'USER') THEN
75: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igidosl.' || P_module ,TRUE);
68:
69: IF (P_error_type = 'DEFAULT') THEN
70: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
71: FND_MESSAGE.SET_TOKEN('CODE',sqlcode);
72: FND_MESSAGE.SET_TOKEN('MSG',sqlerrm);
73: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igidosl.' || P_module ,TRUE);
74: ELSIF (P_error_type = 'USER') THEN
75: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igidosl.' || P_module ,TRUE);
76: END IF;
824: /* =============== END DEBUG LOG ================== */
825:
826: EXCEPTION
827: WHEN OTHERS THEN
828: FND_MESSAGE.SET_NAME('IGI','IGI_DOS_WKF_NO_CURRENT_POS');
829: FND_MESSAGE.SET_TOKEN('USER_ID',g_userid);
830: /* =============== START DEBUG LOG ================ */
831: DEBUG_LOG_UNEXP_ERROR ('getparentposition.Unexp2','USER');
832: /* =============== END DEBUG LOG ================== */
825:
826: EXCEPTION
827: WHEN OTHERS THEN
828: FND_MESSAGE.SET_NAME('IGI','IGI_DOS_WKF_NO_CURRENT_POS');
829: FND_MESSAGE.SET_TOKEN('USER_ID',g_userid);
830: /* =============== START DEBUG LOG ================ */
831: DEBUG_LOG_UNEXP_ERROR ('getparentposition.Unexp2','USER');
832: /* =============== END DEBUG LOG ================== */
833: RAISE cur_pos_not_found;
893:
894: EXCEPTION
895:
896: WHEN OTHERS THEN
897: FND_MESSAGE.SET_NAME('IGI','IGI_DOS_WKF_NO_HIERARCHY');
898: FND_MESSAGE.SET_TOKEN('DOSSIER_ID',l_dossier_id);
899: /* =============== START DEBUG LOG ================ */
900: DEBUG_LOG_UNEXP_ERROR ('getparentposition.Unexp3','USER');
901: /* =============== END DEBUG LOG ================== */
894: EXCEPTION
895:
896: WHEN OTHERS THEN
897: FND_MESSAGE.SET_NAME('IGI','IGI_DOS_WKF_NO_HIERARCHY');
898: FND_MESSAGE.SET_TOKEN('DOSSIER_ID',l_dossier_id);
899: /* =============== START DEBUG LOG ================ */
900: DEBUG_LOG_UNEXP_ERROR ('getparentposition.Unexp3','USER');
901: /* =============== END DEBUG LOG ================== */
902: RAISE pos_hier_not_found;
926: CLOSE c_pos_hier_ver;
927:
928: EXCEPTION
929: WHEN OTHERS THEN
930: FND_MESSAGE.SET_NAME('IGI','IGI_DOS_WKF_NO_HIER_VER');
931: FND_MESSAGE.SET_TOKEN('HIERARCHY_ID',l_hierarchy_id);
932: FND_MESSAGE.SET_TOKEN('BUS_GRP_ID',l_business_group_id);
933: /* =============== START DEBUG LOG ================ */
934: DEBUG_LOG_UNEXP_ERROR ('getparentposition.Unexp4','USER');
927:
928: EXCEPTION
929: WHEN OTHERS THEN
930: FND_MESSAGE.SET_NAME('IGI','IGI_DOS_WKF_NO_HIER_VER');
931: FND_MESSAGE.SET_TOKEN('HIERARCHY_ID',l_hierarchy_id);
932: FND_MESSAGE.SET_TOKEN('BUS_GRP_ID',l_business_group_id);
933: /* =============== START DEBUG LOG ================ */
934: DEBUG_LOG_UNEXP_ERROR ('getparentposition.Unexp4','USER');
935: /* =============== END DEBUG LOG ================== */
928: EXCEPTION
929: WHEN OTHERS THEN
930: FND_MESSAGE.SET_NAME('IGI','IGI_DOS_WKF_NO_HIER_VER');
931: FND_MESSAGE.SET_TOKEN('HIERARCHY_ID',l_hierarchy_id);
932: FND_MESSAGE.SET_TOKEN('BUS_GRP_ID',l_business_group_id);
933: /* =============== START DEBUG LOG ================ */
934: DEBUG_LOG_UNEXP_ERROR ('getparentposition.Unexp4','USER');
935: /* =============== END DEBUG LOG ================== */
936: RAISE pos_hier_ver_not_found;
962: CLOSE c_get_top_position;
963:
964: EXCEPTION
965: WHEN OTHERS THEN
966: FND_MESSAGE.SET_NAME('IGI','IGI_DOS_WKF_NO_HIER_TOP');
967: FND_MESSAGE.SET_TOKEN('HIER_VER_ID',l_hierarchy_version_id);
968: FND_MESSAGE.SET_TOKEN('BUS_GRP_ID',l_business_group_id);
969: /* =============== START DEBUG LOG ================ */
970: DEBUG_LOG_UNEXP_ERROR ('getparentposition.Unexp5','USER');
963:
964: EXCEPTION
965: WHEN OTHERS THEN
966: FND_MESSAGE.SET_NAME('IGI','IGI_DOS_WKF_NO_HIER_TOP');
967: FND_MESSAGE.SET_TOKEN('HIER_VER_ID',l_hierarchy_version_id);
968: FND_MESSAGE.SET_TOKEN('BUS_GRP_ID',l_business_group_id);
969: /* =============== START DEBUG LOG ================ */
970: DEBUG_LOG_UNEXP_ERROR ('getparentposition.Unexp5','USER');
971: /* =============== END DEBUG LOG ================== */
964: EXCEPTION
965: WHEN OTHERS THEN
966: FND_MESSAGE.SET_NAME('IGI','IGI_DOS_WKF_NO_HIER_TOP');
967: FND_MESSAGE.SET_TOKEN('HIER_VER_ID',l_hierarchy_version_id);
968: FND_MESSAGE.SET_TOKEN('BUS_GRP_ID',l_business_group_id);
969: /* =============== START DEBUG LOG ================ */
970: DEBUG_LOG_UNEXP_ERROR ('getparentposition.Unexp5','USER');
971: /* =============== END DEBUG LOG ================== */
972: RAISE top_pos_not_found;
1025: CLOSE c_par_pos_id;
1026:
1027: EXCEPTION
1028: WHEN OTHERS THEN
1029: FND_MESSAGE.SET_NAME('IGI','IGI_DOS_WKF_NO_PARENT_POS');
1030: FND_MESSAGE.SET_TOKEN('HIERARCHY_ID',l_hierarchy_id);
1031: FND_MESSAGE.SET_TOKEN('BUS_GRP_ID',l_business_group_id);
1032: FND_MESSAGE.SET_TOKEN('POSITION_ID',l_position_id);
1033: /* =============== START DEBUG LOG ================ */
1026:
1027: EXCEPTION
1028: WHEN OTHERS THEN
1029: FND_MESSAGE.SET_NAME('IGI','IGI_DOS_WKF_NO_PARENT_POS');
1030: FND_MESSAGE.SET_TOKEN('HIERARCHY_ID',l_hierarchy_id);
1031: FND_MESSAGE.SET_TOKEN('BUS_GRP_ID',l_business_group_id);
1032: FND_MESSAGE.SET_TOKEN('POSITION_ID',l_position_id);
1033: /* =============== START DEBUG LOG ================ */
1034: DEBUG_LOG_UNEXP_ERROR ('getparentposition.Unexp6','USER');
1027: EXCEPTION
1028: WHEN OTHERS THEN
1029: FND_MESSAGE.SET_NAME('IGI','IGI_DOS_WKF_NO_PARENT_POS');
1030: FND_MESSAGE.SET_TOKEN('HIERARCHY_ID',l_hierarchy_id);
1031: FND_MESSAGE.SET_TOKEN('BUS_GRP_ID',l_business_group_id);
1032: FND_MESSAGE.SET_TOKEN('POSITION_ID',l_position_id);
1033: /* =============== START DEBUG LOG ================ */
1034: DEBUG_LOG_UNEXP_ERROR ('getparentposition.Unexp6','USER');
1035: /* =============== END DEBUG LOG ================== */
1028: WHEN OTHERS THEN
1029: FND_MESSAGE.SET_NAME('IGI','IGI_DOS_WKF_NO_PARENT_POS');
1030: FND_MESSAGE.SET_TOKEN('HIERARCHY_ID',l_hierarchy_id);
1031: FND_MESSAGE.SET_TOKEN('BUS_GRP_ID',l_business_group_id);
1032: FND_MESSAGE.SET_TOKEN('POSITION_ID',l_position_id);
1033: /* =============== START DEBUG LOG ================ */
1034: DEBUG_LOG_UNEXP_ERROR ('getparentposition.Unexp6','USER');
1035: /* =============== END DEBUG LOG ================== */
1036: RAISE par_pos_not_found;
1381:
1382: EXCEPTION
1383:
1384: WHEN encumbrance_error THEN
1385: FND_MESSAGE.SET_NAME('IGI','IGI_DOS_WKF_ENCMBRC_ERROR');
1386: FND_MESSAGE.SET_TOKEN('DOSSIER_NUM',l_dossier_num);
1387: FND_MESSAGE.SET_TOKEN('USER_ID',l_user_id);
1388: FND_MESSAGE.SET_TOKEN('RESP_ID',l_responsibility_id);
1389: FND_MESSAGE.SET_TOKEN('SOB_ID',l_sob_id);
1382: EXCEPTION
1383:
1384: WHEN encumbrance_error THEN
1385: FND_MESSAGE.SET_NAME('IGI','IGI_DOS_WKF_ENCMBRC_ERROR');
1386: FND_MESSAGE.SET_TOKEN('DOSSIER_NUM',l_dossier_num);
1387: FND_MESSAGE.SET_TOKEN('USER_ID',l_user_id);
1388: FND_MESSAGE.SET_TOKEN('RESP_ID',l_responsibility_id);
1389: FND_MESSAGE.SET_TOKEN('SOB_ID',l_sob_id);
1390: /* =============== START DEBUG LOG ================ */
1383:
1384: WHEN encumbrance_error THEN
1385: FND_MESSAGE.SET_NAME('IGI','IGI_DOS_WKF_ENCMBRC_ERROR');
1386: FND_MESSAGE.SET_TOKEN('DOSSIER_NUM',l_dossier_num);
1387: FND_MESSAGE.SET_TOKEN('USER_ID',l_user_id);
1388: FND_MESSAGE.SET_TOKEN('RESP_ID',l_responsibility_id);
1389: FND_MESSAGE.SET_TOKEN('SOB_ID',l_sob_id);
1390: /* =============== START DEBUG LOG ================ */
1391: DEBUG_LOG_UNEXP_ERROR ('approve.unexp1','USER');
1384: WHEN encumbrance_error THEN
1385: FND_MESSAGE.SET_NAME('IGI','IGI_DOS_WKF_ENCMBRC_ERROR');
1386: FND_MESSAGE.SET_TOKEN('DOSSIER_NUM',l_dossier_num);
1387: FND_MESSAGE.SET_TOKEN('USER_ID',l_user_id);
1388: FND_MESSAGE.SET_TOKEN('RESP_ID',l_responsibility_id);
1389: FND_MESSAGE.SET_TOKEN('SOB_ID',l_sob_id);
1390: /* =============== START DEBUG LOG ================ */
1391: DEBUG_LOG_UNEXP_ERROR ('approve.unexp1','USER');
1392: /* =============== END DEBUG LOG ================== */
1385: FND_MESSAGE.SET_NAME('IGI','IGI_DOS_WKF_ENCMBRC_ERROR');
1386: FND_MESSAGE.SET_TOKEN('DOSSIER_NUM',l_dossier_num);
1387: FND_MESSAGE.SET_TOKEN('USER_ID',l_user_id);
1388: FND_MESSAGE.SET_TOKEN('RESP_ID',l_responsibility_id);
1389: FND_MESSAGE.SET_TOKEN('SOB_ID',l_sob_id);
1390: /* =============== START DEBUG LOG ================ */
1391: DEBUG_LOG_UNEXP_ERROR ('approve.unexp1','USER');
1392: /* =============== END DEBUG LOG ================== */
1393:
1561:
1562:
1563: EXCEPTION
1564: WHEN unable_to_send_notify THEN
1565: FND_MESSAGE.SET_NAME('IGI','IGI_DOS_WKF_FAIL_SEND_NOTC');
1566: FND_MESSAGE.SET_TOKEN('NOTICE_ID',l_nid);
1567: /* =============== START DEBUG LOG ================ */
1568: DEBUG_LOG_UNEXP_ERROR ('SendApproved.Unexp1','USER');
1569: /* =============== END DEBUG LOG ================== */
1562:
1563: EXCEPTION
1564: WHEN unable_to_send_notify THEN
1565: FND_MESSAGE.SET_NAME('IGI','IGI_DOS_WKF_FAIL_SEND_NOTC');
1566: FND_MESSAGE.SET_TOKEN('NOTICE_ID',l_nid);
1567: /* =============== START DEBUG LOG ================ */
1568: DEBUG_LOG_UNEXP_ERROR ('SendApproved.Unexp1','USER');
1569: /* =============== END DEBUG LOG ================== */
1570: result := NULL;
1660:
1661:
1662: EXCEPTION
1663: WHEN unable_to_send_notify THEN
1664: FND_MESSAGE.SET_NAME('IGI','IGI_DOS_WKF_FAIL_SEND_NOTC');
1665: FND_MESSAGE.SET_TOKEN('NOTICE_ID',l_nid);
1666: /* =============== START DEBUG LOG ================ */
1667: DEBUG_LOG_UNEXP_ERROR ('SendRejected.Unexp1','USER');
1668: /* =============== END DEBUG LOG ================== */
1661:
1662: EXCEPTION
1663: WHEN unable_to_send_notify THEN
1664: FND_MESSAGE.SET_NAME('IGI','IGI_DOS_WKF_FAIL_SEND_NOTC');
1665: FND_MESSAGE.SET_TOKEN('NOTICE_ID',l_nid);
1666: /* =============== START DEBUG LOG ================ */
1667: DEBUG_LOG_UNEXP_ERROR ('SendRejected.Unexp1','USER');
1668: /* =============== END DEBUG LOG ================== */
1669: Wf_Core.Context ('IGIDOSL','SendRejected', itemtype, itemkey
1845: /* =============== END DEBUG LOG ================== */
1846:
1847: EXCEPTION
1848: WHEN e_user_list_not_found THEN
1849: FND_MESSAGE.SET_NAME('IGI','IGI_DOS_WKF_NO_USER_LIST');
1850: /* =============== START DEBUG LOG ================ */
1851: DEBUG_LOG_UNEXP_ERROR ('CreateList.Unexp2','USER');
1852: /* =============== END DEBUG LOG ================== */
1853: Wf_Core.Context ('IGIDOSL', 'CreateList cursor', itemtype, itemkey
2098: /* =============== END DEBUG LOG ================== */
2099:
2100: EXCEPTION
2101: WHEN unreserve_error THEN
2102: FND_MESSAGE.SET_NAME('IGI','IGI_DOS_WKF_UNRSRV_ERROR');
2103: FND_MESSAGE.SET_TOKEN('TRANS_NUM',l_trx_number);
2104: FND_MESSAGE.SET_TOKEN('USER_ID',l_user_id);
2105: FND_MESSAGE.SET_TOKEN('RESP_ID',l_responsibility_id);
2106: FND_MESSAGE.SET_TOKEN('SOB_ID',l_sob_id);
2099:
2100: EXCEPTION
2101: WHEN unreserve_error THEN
2102: FND_MESSAGE.SET_NAME('IGI','IGI_DOS_WKF_UNRSRV_ERROR');
2103: FND_MESSAGE.SET_TOKEN('TRANS_NUM',l_trx_number);
2104: FND_MESSAGE.SET_TOKEN('USER_ID',l_user_id);
2105: FND_MESSAGE.SET_TOKEN('RESP_ID',l_responsibility_id);
2106: FND_MESSAGE.SET_TOKEN('SOB_ID',l_sob_id);
2107: /* =============== START DEBUG LOG ================ */
2100: EXCEPTION
2101: WHEN unreserve_error THEN
2102: FND_MESSAGE.SET_NAME('IGI','IGI_DOS_WKF_UNRSRV_ERROR');
2103: FND_MESSAGE.SET_TOKEN('TRANS_NUM',l_trx_number);
2104: FND_MESSAGE.SET_TOKEN('USER_ID',l_user_id);
2105: FND_MESSAGE.SET_TOKEN('RESP_ID',l_responsibility_id);
2106: FND_MESSAGE.SET_TOKEN('SOB_ID',l_sob_id);
2107: /* =============== START DEBUG LOG ================ */
2108: DEBUG_LOG_UNEXP_ERROR ('UnreserveFunds.Unexp1','USER');
2101: WHEN unreserve_error THEN
2102: FND_MESSAGE.SET_NAME('IGI','IGI_DOS_WKF_UNRSRV_ERROR');
2103: FND_MESSAGE.SET_TOKEN('TRANS_NUM',l_trx_number);
2104: FND_MESSAGE.SET_TOKEN('USER_ID',l_user_id);
2105: FND_MESSAGE.SET_TOKEN('RESP_ID',l_responsibility_id);
2106: FND_MESSAGE.SET_TOKEN('SOB_ID',l_sob_id);
2107: /* =============== START DEBUG LOG ================ */
2108: DEBUG_LOG_UNEXP_ERROR ('UnreserveFunds.Unexp1','USER');
2109: /* =============== END DEBUG LOG ================== */
2102: FND_MESSAGE.SET_NAME('IGI','IGI_DOS_WKF_UNRSRV_ERROR');
2103: FND_MESSAGE.SET_TOKEN('TRANS_NUM',l_trx_number);
2104: FND_MESSAGE.SET_TOKEN('USER_ID',l_user_id);
2105: FND_MESSAGE.SET_TOKEN('RESP_ID',l_responsibility_id);
2106: FND_MESSAGE.SET_TOKEN('SOB_ID',l_sob_id);
2107: /* =============== START DEBUG LOG ================ */
2108: DEBUG_LOG_UNEXP_ERROR ('UnreserveFunds.Unexp1','USER');
2109: /* =============== END DEBUG LOG ================== */
2110: Wf_Core.Context ('IGIDOSL', 'UnreserveFunds -Unable to reserve funds for specified packet'
2151: DEBUG_LOG_STRING (l_proc_level, 'FrameDosTable.Msg2',
2152: ' Getting messages for Table Heading');
2153: /* =============== END DEBUG LOG ================== */
2154:
2155: -- Getting the Headings FROM fnd message.
2156:
2157: fnd_message.set_name ('IGI', 'IGI_DOS_TRAN_DETS');
2158: l_trans_dets_head := fnd_message.get;
2159: fnd_message.set_name ('IGI', 'IGI_DOS_LINE');
2153: /* =============== END DEBUG LOG ================== */
2154:
2155: -- Getting the Headings FROM fnd message.
2156:
2157: fnd_message.set_name ('IGI', 'IGI_DOS_TRAN_DETS');
2158: l_trans_dets_head := fnd_message.get;
2159: fnd_message.set_name ('IGI', 'IGI_DOS_LINE');
2160: l_line_head := fnd_message.get;
2161: fnd_message.set_name ('IGI', 'IGI_DOS_SOURCE_BUDGET');
2154:
2155: -- Getting the Headings FROM fnd message.
2156:
2157: fnd_message.set_name ('IGI', 'IGI_DOS_TRAN_DETS');
2158: l_trans_dets_head := fnd_message.get;
2159: fnd_message.set_name ('IGI', 'IGI_DOS_LINE');
2160: l_line_head := fnd_message.get;
2161: fnd_message.set_name ('IGI', 'IGI_DOS_SOURCE_BUDGET');
2162: l_source_budget_head := fnd_message.get;
2155: -- Getting the Headings FROM fnd message.
2156:
2157: fnd_message.set_name ('IGI', 'IGI_DOS_TRAN_DETS');
2158: l_trans_dets_head := fnd_message.get;
2159: fnd_message.set_name ('IGI', 'IGI_DOS_LINE');
2160: l_line_head := fnd_message.get;
2161: fnd_message.set_name ('IGI', 'IGI_DOS_SOURCE_BUDGET');
2162: l_source_budget_head := fnd_message.get;
2163: fnd_message.set_name ('IGI', 'IGI_DOS_SOURCE_ACCOUNT');
2156:
2157: fnd_message.set_name ('IGI', 'IGI_DOS_TRAN_DETS');
2158: l_trans_dets_head := fnd_message.get;
2159: fnd_message.set_name ('IGI', 'IGI_DOS_LINE');
2160: l_line_head := fnd_message.get;
2161: fnd_message.set_name ('IGI', 'IGI_DOS_SOURCE_BUDGET');
2162: l_source_budget_head := fnd_message.get;
2163: fnd_message.set_name ('IGI', 'IGI_DOS_SOURCE_ACCOUNT');
2164: l_source_account_head := fnd_message.get;
2157: fnd_message.set_name ('IGI', 'IGI_DOS_TRAN_DETS');
2158: l_trans_dets_head := fnd_message.get;
2159: fnd_message.set_name ('IGI', 'IGI_DOS_LINE');
2160: l_line_head := fnd_message.get;
2161: fnd_message.set_name ('IGI', 'IGI_DOS_SOURCE_BUDGET');
2162: l_source_budget_head := fnd_message.get;
2163: fnd_message.set_name ('IGI', 'IGI_DOS_SOURCE_ACCOUNT');
2164: l_source_account_head := fnd_message.get;
2165: fnd_message.set_name ('IGI', 'IGI_DOS_SOURCE_PERIOD');
2158: l_trans_dets_head := fnd_message.get;
2159: fnd_message.set_name ('IGI', 'IGI_DOS_LINE');
2160: l_line_head := fnd_message.get;
2161: fnd_message.set_name ('IGI', 'IGI_DOS_SOURCE_BUDGET');
2162: l_source_budget_head := fnd_message.get;
2163: fnd_message.set_name ('IGI', 'IGI_DOS_SOURCE_ACCOUNT');
2164: l_source_account_head := fnd_message.get;
2165: fnd_message.set_name ('IGI', 'IGI_DOS_SOURCE_PERIOD');
2166: l_source_period_head := fnd_message.get;
2159: fnd_message.set_name ('IGI', 'IGI_DOS_LINE');
2160: l_line_head := fnd_message.get;
2161: fnd_message.set_name ('IGI', 'IGI_DOS_SOURCE_BUDGET');
2162: l_source_budget_head := fnd_message.get;
2163: fnd_message.set_name ('IGI', 'IGI_DOS_SOURCE_ACCOUNT');
2164: l_source_account_head := fnd_message.get;
2165: fnd_message.set_name ('IGI', 'IGI_DOS_SOURCE_PERIOD');
2166: l_source_period_head := fnd_message.get;
2167: fnd_message.set_name ('IGI', 'IGI_DOS_SOURCE_AMOUNT');
2160: l_line_head := fnd_message.get;
2161: fnd_message.set_name ('IGI', 'IGI_DOS_SOURCE_BUDGET');
2162: l_source_budget_head := fnd_message.get;
2163: fnd_message.set_name ('IGI', 'IGI_DOS_SOURCE_ACCOUNT');
2164: l_source_account_head := fnd_message.get;
2165: fnd_message.set_name ('IGI', 'IGI_DOS_SOURCE_PERIOD');
2166: l_source_period_head := fnd_message.get;
2167: fnd_message.set_name ('IGI', 'IGI_DOS_SOURCE_AMOUNT');
2168: l_source_amount_head := fnd_message.get;
2161: fnd_message.set_name ('IGI', 'IGI_DOS_SOURCE_BUDGET');
2162: l_source_budget_head := fnd_message.get;
2163: fnd_message.set_name ('IGI', 'IGI_DOS_SOURCE_ACCOUNT');
2164: l_source_account_head := fnd_message.get;
2165: fnd_message.set_name ('IGI', 'IGI_DOS_SOURCE_PERIOD');
2166: l_source_period_head := fnd_message.get;
2167: fnd_message.set_name ('IGI', 'IGI_DOS_SOURCE_AMOUNT');
2168: l_source_amount_head := fnd_message.get;
2169: fnd_message.set_name ('IGI', 'IGI_DOS_DEST_BUDGET');
2162: l_source_budget_head := fnd_message.get;
2163: fnd_message.set_name ('IGI', 'IGI_DOS_SOURCE_ACCOUNT');
2164: l_source_account_head := fnd_message.get;
2165: fnd_message.set_name ('IGI', 'IGI_DOS_SOURCE_PERIOD');
2166: l_source_period_head := fnd_message.get;
2167: fnd_message.set_name ('IGI', 'IGI_DOS_SOURCE_AMOUNT');
2168: l_source_amount_head := fnd_message.get;
2169: fnd_message.set_name ('IGI', 'IGI_DOS_DEST_BUDGET');
2170: l_dest_budget_head := fnd_message.get;
2163: fnd_message.set_name ('IGI', 'IGI_DOS_SOURCE_ACCOUNT');
2164: l_source_account_head := fnd_message.get;
2165: fnd_message.set_name ('IGI', 'IGI_DOS_SOURCE_PERIOD');
2166: l_source_period_head := fnd_message.get;
2167: fnd_message.set_name ('IGI', 'IGI_DOS_SOURCE_AMOUNT');
2168: l_source_amount_head := fnd_message.get;
2169: fnd_message.set_name ('IGI', 'IGI_DOS_DEST_BUDGET');
2170: l_dest_budget_head := fnd_message.get;
2171: fnd_message.set_name ('IGI', 'IGI_DOS_DEST_ACCOUNT');
2164: l_source_account_head := fnd_message.get;
2165: fnd_message.set_name ('IGI', 'IGI_DOS_SOURCE_PERIOD');
2166: l_source_period_head := fnd_message.get;
2167: fnd_message.set_name ('IGI', 'IGI_DOS_SOURCE_AMOUNT');
2168: l_source_amount_head := fnd_message.get;
2169: fnd_message.set_name ('IGI', 'IGI_DOS_DEST_BUDGET');
2170: l_dest_budget_head := fnd_message.get;
2171: fnd_message.set_name ('IGI', 'IGI_DOS_DEST_ACCOUNT');
2172: l_dest_account_head := fnd_message.get;
2165: fnd_message.set_name ('IGI', 'IGI_DOS_SOURCE_PERIOD');
2166: l_source_period_head := fnd_message.get;
2167: fnd_message.set_name ('IGI', 'IGI_DOS_SOURCE_AMOUNT');
2168: l_source_amount_head := fnd_message.get;
2169: fnd_message.set_name ('IGI', 'IGI_DOS_DEST_BUDGET');
2170: l_dest_budget_head := fnd_message.get;
2171: fnd_message.set_name ('IGI', 'IGI_DOS_DEST_ACCOUNT');
2172: l_dest_account_head := fnd_message.get;
2173: fnd_message.set_name ('IGI', 'IGI_DOS_DEST_PERIOD');
2166: l_source_period_head := fnd_message.get;
2167: fnd_message.set_name ('IGI', 'IGI_DOS_SOURCE_AMOUNT');
2168: l_source_amount_head := fnd_message.get;
2169: fnd_message.set_name ('IGI', 'IGI_DOS_DEST_BUDGET');
2170: l_dest_budget_head := fnd_message.get;
2171: fnd_message.set_name ('IGI', 'IGI_DOS_DEST_ACCOUNT');
2172: l_dest_account_head := fnd_message.get;
2173: fnd_message.set_name ('IGI', 'IGI_DOS_DEST_PERIOD');
2174: l_dest_period_head := fnd_message.get;
2167: fnd_message.set_name ('IGI', 'IGI_DOS_SOURCE_AMOUNT');
2168: l_source_amount_head := fnd_message.get;
2169: fnd_message.set_name ('IGI', 'IGI_DOS_DEST_BUDGET');
2170: l_dest_budget_head := fnd_message.get;
2171: fnd_message.set_name ('IGI', 'IGI_DOS_DEST_ACCOUNT');
2172: l_dest_account_head := fnd_message.get;
2173: fnd_message.set_name ('IGI', 'IGI_DOS_DEST_PERIOD');
2174: l_dest_period_head := fnd_message.get;
2175: fnd_message.set_name ('IGI', 'IGI_DOS_DEST_AMOUNT');
2168: l_source_amount_head := fnd_message.get;
2169: fnd_message.set_name ('IGI', 'IGI_DOS_DEST_BUDGET');
2170: l_dest_budget_head := fnd_message.get;
2171: fnd_message.set_name ('IGI', 'IGI_DOS_DEST_ACCOUNT');
2172: l_dest_account_head := fnd_message.get;
2173: fnd_message.set_name ('IGI', 'IGI_DOS_DEST_PERIOD');
2174: l_dest_period_head := fnd_message.get;
2175: fnd_message.set_name ('IGI', 'IGI_DOS_DEST_AMOUNT');
2176: l_dest_amount_head := fnd_message.get;
2169: fnd_message.set_name ('IGI', 'IGI_DOS_DEST_BUDGET');
2170: l_dest_budget_head := fnd_message.get;
2171: fnd_message.set_name ('IGI', 'IGI_DOS_DEST_ACCOUNT');
2172: l_dest_account_head := fnd_message.get;
2173: fnd_message.set_name ('IGI', 'IGI_DOS_DEST_PERIOD');
2174: l_dest_period_head := fnd_message.get;
2175: fnd_message.set_name ('IGI', 'IGI_DOS_DEST_AMOUNT');
2176: l_dest_amount_head := fnd_message.get;
2177:
2170: l_dest_budget_head := fnd_message.get;
2171: fnd_message.set_name ('IGI', 'IGI_DOS_DEST_ACCOUNT');
2172: l_dest_account_head := fnd_message.get;
2173: fnd_message.set_name ('IGI', 'IGI_DOS_DEST_PERIOD');
2174: l_dest_period_head := fnd_message.get;
2175: fnd_message.set_name ('IGI', 'IGI_DOS_DEST_AMOUNT');
2176: l_dest_amount_head := fnd_message.get;
2177:
2178: /* =============== START DEBUG LOG ================ */
2171: fnd_message.set_name ('IGI', 'IGI_DOS_DEST_ACCOUNT');
2172: l_dest_account_head := fnd_message.get;
2173: fnd_message.set_name ('IGI', 'IGI_DOS_DEST_PERIOD');
2174: l_dest_period_head := fnd_message.get;
2175: fnd_message.set_name ('IGI', 'IGI_DOS_DEST_AMOUNT');
2176: l_dest_amount_head := fnd_message.get;
2177:
2178: /* =============== START DEBUG LOG ================ */
2179: DEBUG_LOG_STRING (l_proc_level, 'FrameDosTable.Msg3',
2172: l_dest_account_head := fnd_message.get;
2173: fnd_message.set_name ('IGI', 'IGI_DOS_DEST_PERIOD');
2174: l_dest_period_head := fnd_message.get;
2175: fnd_message.set_name ('IGI', 'IGI_DOS_DEST_AMOUNT');
2176: l_dest_amount_head := fnd_message.get;
2177:
2178: /* =============== START DEBUG LOG ================ */
2179: DEBUG_LOG_STRING (l_proc_level, 'FrameDosTable.Msg3',
2180: ' Heading Done - Now Framing the table ');
2426:
2427: l_source_total := 0;
2428:
2429: -- getting grand total test message.
2430: fnd_message.set_name ('IGI','IGI_DOS_TOTAL');
2431: g_total_text := fnd_message.get;
2432:
2433: FOR source_rec IN c_get_sources LOOP
2434:
2427: l_source_total := 0;
2428:
2429: -- getting grand total test message.
2430: fnd_message.set_name ('IGI','IGI_DOS_TOTAL');
2431: g_total_text := fnd_message.get;
2432:
2433: FOR source_rec IN c_get_sources LOOP
2434:
2435: /* =============== START DEBUG LOG ================ */
2555:
2556: END LOOP; -- sources
2557:
2558: -- getting grand total test message.
2559: fnd_message.set_name ('IGI','IGI_DOS_GRAND_TOTAL');
2560: g_total_text := fnd_message.get;
2561:
2562: /* =============== START DEBUG LOG ================ */
2563: DEBUG_LOG_STRING (l_proc_level, 'dossier_transaction_detail.Msg24.1',
2556: END LOOP; -- sources
2557:
2558: -- getting grand total test message.
2559: fnd_message.set_name ('IGI','IGI_DOS_GRAND_TOTAL');
2560: g_total_text := fnd_message.get;
2561:
2562: /* =============== START DEBUG LOG ================ */
2563: DEBUG_LOG_STRING (l_proc_level, 'dossier_transaction_detail.Msg24.1',
2564: ' Calling AddTotalToTable to set the grand total ');