DBA Data[Home] [Help]

APPS.IGIDOSL dependencies on FND_MESSAGE

Line 70: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');

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

Line 71: FND_MESSAGE.SET_TOKEN('CODE',sqlcode);

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);

Line 72: FND_MESSAGE.SET_TOKEN('MSG',sqlerrm);

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;

Line 828: FND_MESSAGE.SET_NAME('IGI','IGI_DOS_WKF_NO_CURRENT_POS');

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 ================== */

Line 829: FND_MESSAGE.SET_TOKEN('USER_ID',g_userid);

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;

Line 897: FND_MESSAGE.SET_NAME('IGI','IGI_DOS_WKF_NO_HIERARCHY');

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 ================== */

Line 898: FND_MESSAGE.SET_TOKEN('DOSSIER_ID',l_dossier_id);

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;

Line 930: FND_MESSAGE.SET_NAME('IGI','IGI_DOS_WKF_NO_HIER_VER');

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');

Line 931: FND_MESSAGE.SET_TOKEN('HIERARCHY_ID',l_hierarchy_id);

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 ================== */

Line 932: FND_MESSAGE.SET_TOKEN('BUS_GRP_ID',l_business_group_id);

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;

Line 966: FND_MESSAGE.SET_NAME('IGI','IGI_DOS_WKF_NO_HIER_TOP');

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');

Line 967: FND_MESSAGE.SET_TOKEN('HIER_VER_ID',l_hierarchy_version_id);

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 ================== */

Line 968: FND_MESSAGE.SET_TOKEN('BUS_GRP_ID',l_business_group_id);

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;

Line 1029: FND_MESSAGE.SET_NAME('IGI','IGI_DOS_WKF_NO_PARENT_POS');

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 ================ */

Line 1030: FND_MESSAGE.SET_TOKEN('HIERARCHY_ID',l_hierarchy_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 ================ */
1034: DEBUG_LOG_UNEXP_ERROR ('getparentposition.Unexp6','USER');

Line 1031: FND_MESSAGE.SET_TOKEN('BUS_GRP_ID',l_business_group_id);

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 ================== */

Line 1032: FND_MESSAGE.SET_TOKEN('POSITION_ID',l_position_id);

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;

Line 1385: FND_MESSAGE.SET_NAME('IGI','IGI_DOS_WKF_ENCMBRC_ERROR');

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);

Line 1386: FND_MESSAGE.SET_TOKEN('DOSSIER_NUM',l_dossier_num);

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 ================ */

Line 1387: FND_MESSAGE.SET_TOKEN('USER_ID',l_user_id);

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');

Line 1388: FND_MESSAGE.SET_TOKEN('RESP_ID',l_responsibility_id);

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 ================== */

Line 1389: FND_MESSAGE.SET_TOKEN('SOB_ID',l_sob_id);

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:

Line 1565: FND_MESSAGE.SET_NAME('IGI','IGI_DOS_WKF_FAIL_SEND_NOTC');

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 ================== */

Line 1566: FND_MESSAGE.SET_TOKEN('NOTICE_ID',l_nid);

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;

Line 1664: FND_MESSAGE.SET_NAME('IGI','IGI_DOS_WKF_FAIL_SEND_NOTC');

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 ================== */

Line 1665: FND_MESSAGE.SET_TOKEN('NOTICE_ID',l_nid);

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

Line 1849: FND_MESSAGE.SET_NAME('IGI','IGI_DOS_WKF_NO_USER_LIST');

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

Line 2102: FND_MESSAGE.SET_NAME('IGI','IGI_DOS_WKF_UNRSRV_ERROR');

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);

Line 2103: FND_MESSAGE.SET_TOKEN('TRANS_NUM',l_trx_number);

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 ================ */

Line 2104: FND_MESSAGE.SET_TOKEN('USER_ID',l_user_id);

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');

Line 2105: FND_MESSAGE.SET_TOKEN('RESP_ID',l_responsibility_id);

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 ================== */

Line 2106: FND_MESSAGE.SET_TOKEN('SOB_ID',l_sob_id);

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'

Line 2155: -- Getting the Headings FROM fnd message.

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');

Line 2157: fnd_message.set_name ('IGI', 'IGI_DOS_TRAN_DETS');

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');

Line 2158: l_trans_dets_head := fnd_message.get;

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;

Line 2159: fnd_message.set_name ('IGI', 'IGI_DOS_LINE');

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');

Line 2160: l_line_head := fnd_message.get;

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;

Line 2161: fnd_message.set_name ('IGI', 'IGI_DOS_SOURCE_BUDGET');

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');

Line 2162: l_source_budget_head := fnd_message.get;

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;

Line 2163: fnd_message.set_name ('IGI', 'IGI_DOS_SOURCE_ACCOUNT');

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');

Line 2164: l_source_account_head := fnd_message.get;

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;

Line 2165: fnd_message.set_name ('IGI', 'IGI_DOS_SOURCE_PERIOD');

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');

Line 2166: l_source_period_head := fnd_message.get;

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;

Line 2167: fnd_message.set_name ('IGI', 'IGI_DOS_SOURCE_AMOUNT');

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');

Line 2168: l_source_amount_head := fnd_message.get;

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;

Line 2169: fnd_message.set_name ('IGI', 'IGI_DOS_DEST_BUDGET');

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');

Line 2170: l_dest_budget_head := fnd_message.get;

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;

Line 2171: fnd_message.set_name ('IGI', 'IGI_DOS_DEST_ACCOUNT');

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');

Line 2172: l_dest_account_head := fnd_message.get;

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;

Line 2173: fnd_message.set_name ('IGI', 'IGI_DOS_DEST_PERIOD');

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:

Line 2174: l_dest_period_head := fnd_message.get;

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 ================ */

Line 2175: fnd_message.set_name ('IGI', 'IGI_DOS_DEST_AMOUNT');

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',

Line 2176: l_dest_amount_head := fnd_message.get;

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 ');

Line 2430: fnd_message.set_name ('IGI','IGI_DOS_TOTAL');

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:

Line 2431: g_total_text := fnd_message.get;

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 ================ */

Line 2559: fnd_message.set_name ('IGI','IGI_DOS_GRAND_TOTAL');

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',

Line 2560: g_total_text := fnd_message.get;

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 ');