APPS.IGIDOSL dependencies on FND_MESSAGE

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

72:
73: IF (l_unexp_level >= l_debug_level) THEN
74:
75: IF (P_error_type = 'DEFAULT') THEN
76: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
77: FND_MESSAGE.SET_TOKEN('CODE',sqlcode);
78: FND_MESSAGE.SET_TOKEN('MSG',sqlerrm);
79: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igidosl.' || P_module ,TRUE);
80: ELSIF (P_error_type = 'USER') THEN

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

73: IF (l_unexp_level >= l_debug_level) THEN
74:
75: IF (P_error_type = 'DEFAULT') THEN
76: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
77: FND_MESSAGE.SET_TOKEN('CODE',sqlcode);
78: FND_MESSAGE.SET_TOKEN('MSG',sqlerrm);
79: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igidosl.' || P_module ,TRUE);
80: ELSIF (P_error_type = 'USER') THEN
81: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igidosl.' || P_module ,TRUE);

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

74:
75: IF (P_error_type = 'DEFAULT') THEN
76: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
77: FND_MESSAGE.SET_TOKEN('CODE',sqlcode);
78: FND_MESSAGE.SET_TOKEN('MSG',sqlerrm);
79: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igidosl.' || P_module ,TRUE);
80: ELSIF (P_error_type = 'USER') THEN
81: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igidosl.' || P_module ,TRUE);
82: END IF;

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

839: /* =============== END DEBUG LOG ================== */
840:
841: EXCEPTION
842: WHEN OTHERS THEN
843: FND_MESSAGE.SET_NAME('IGI','IGI_DOS_WKF_NO_CURRENT_POS');
844: FND_MESSAGE.SET_TOKEN('USER_ID',g_userid);
845: /* =============== START DEBUG LOG ================ */
846: DEBUG_LOG_UNEXP_ERROR ('getparentposition.Unexp2','USER');
847: /* =============== END DEBUG LOG ================== */

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

840:
841: EXCEPTION
842: WHEN OTHERS THEN
843: FND_MESSAGE.SET_NAME('IGI','IGI_DOS_WKF_NO_CURRENT_POS');
844: FND_MESSAGE.SET_TOKEN('USER_ID',g_userid);
845: /* =============== START DEBUG LOG ================ */
846: DEBUG_LOG_UNEXP_ERROR ('getparentposition.Unexp2','USER');
847: /* =============== END DEBUG LOG ================== */
848: RAISE cur_pos_not_found;

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

908:
909: EXCEPTION
910:
911: WHEN OTHERS THEN
912: FND_MESSAGE.SET_NAME('IGI','IGI_DOS_WKF_NO_HIERARCHY');
913: FND_MESSAGE.SET_TOKEN('DOSSIER_ID',l_dossier_id);
914: /* =============== START DEBUG LOG ================ */
915: DEBUG_LOG_UNEXP_ERROR ('getparentposition.Unexp3','USER');
916: /* =============== END DEBUG LOG ================== */

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

909: EXCEPTION
910:
911: WHEN OTHERS THEN
912: FND_MESSAGE.SET_NAME('IGI','IGI_DOS_WKF_NO_HIERARCHY');
913: FND_MESSAGE.SET_TOKEN('DOSSIER_ID',l_dossier_id);
914: /* =============== START DEBUG LOG ================ */
915: DEBUG_LOG_UNEXP_ERROR ('getparentposition.Unexp3','USER');
916: /* =============== END DEBUG LOG ================== */
917: RAISE pos_hier_not_found;

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

941: CLOSE c_pos_hier_ver;
942:
943: EXCEPTION
944: WHEN OTHERS THEN
945: FND_MESSAGE.SET_NAME('IGI','IGI_DOS_WKF_NO_HIER_VER');
946: FND_MESSAGE.SET_TOKEN('HIERARCHY_ID',l_hierarchy_id);
947: FND_MESSAGE.SET_TOKEN('BUS_GRP_ID',l_business_group_id);
948: /* =============== START DEBUG LOG ================ */
949: DEBUG_LOG_UNEXP_ERROR ('getparentposition.Unexp4','USER');

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

942:
943: EXCEPTION
944: WHEN OTHERS THEN
945: FND_MESSAGE.SET_NAME('IGI','IGI_DOS_WKF_NO_HIER_VER');
946: FND_MESSAGE.SET_TOKEN('HIERARCHY_ID',l_hierarchy_id);
947: FND_MESSAGE.SET_TOKEN('BUS_GRP_ID',l_business_group_id);
948: /* =============== START DEBUG LOG ================ */
949: DEBUG_LOG_UNEXP_ERROR ('getparentposition.Unexp4','USER');
950: /* =============== END DEBUG LOG ================== */

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

943: EXCEPTION
944: WHEN OTHERS THEN
945: FND_MESSAGE.SET_NAME('IGI','IGI_DOS_WKF_NO_HIER_VER');
946: FND_MESSAGE.SET_TOKEN('HIERARCHY_ID',l_hierarchy_id);
947: FND_MESSAGE.SET_TOKEN('BUS_GRP_ID',l_business_group_id);
948: /* =============== START DEBUG LOG ================ */
949: DEBUG_LOG_UNEXP_ERROR ('getparentposition.Unexp4','USER');
950: /* =============== END DEBUG LOG ================== */
951: RAISE pos_hier_ver_not_found;

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

977: CLOSE c_get_top_position;
978:
979: EXCEPTION
980: WHEN OTHERS THEN
981: FND_MESSAGE.SET_NAME('IGI','IGI_DOS_WKF_NO_HIER_TOP');
982: FND_MESSAGE.SET_TOKEN('HIER_VER_ID',l_hierarchy_version_id);
983: FND_MESSAGE.SET_TOKEN('BUS_GRP_ID',l_business_group_id);
984: /* =============== START DEBUG LOG ================ */
985: DEBUG_LOG_UNEXP_ERROR ('getparentposition.Unexp5','USER');

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

978:
979: EXCEPTION
980: WHEN OTHERS THEN
981: FND_MESSAGE.SET_NAME('IGI','IGI_DOS_WKF_NO_HIER_TOP');
982: FND_MESSAGE.SET_TOKEN('HIER_VER_ID',l_hierarchy_version_id);
983: FND_MESSAGE.SET_TOKEN('BUS_GRP_ID',l_business_group_id);
984: /* =============== START DEBUG LOG ================ */
985: DEBUG_LOG_UNEXP_ERROR ('getparentposition.Unexp5','USER');
986: /* =============== END DEBUG LOG ================== */

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

979: EXCEPTION
980: WHEN OTHERS THEN
981: FND_MESSAGE.SET_NAME('IGI','IGI_DOS_WKF_NO_HIER_TOP');
982: FND_MESSAGE.SET_TOKEN('HIER_VER_ID',l_hierarchy_version_id);
983: FND_MESSAGE.SET_TOKEN('BUS_GRP_ID',l_business_group_id);
984: /* =============== START DEBUG LOG ================ */
985: DEBUG_LOG_UNEXP_ERROR ('getparentposition.Unexp5','USER');
986: /* =============== END DEBUG LOG ================== */
987: RAISE top_pos_not_found;

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

1040: CLOSE c_par_pos_id;
1041:
1042: EXCEPTION
1043: WHEN OTHERS THEN
1044: FND_MESSAGE.SET_NAME('IGI','IGI_DOS_WKF_NO_PARENT_POS');
1045: FND_MESSAGE.SET_TOKEN('HIERARCHY_ID',l_hierarchy_id);
1046: FND_MESSAGE.SET_TOKEN('BUS_GRP_ID',l_business_group_id);
1047: FND_MESSAGE.SET_TOKEN('POSITION_ID',l_position_id);
1048: /* =============== START DEBUG LOG ================ */

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

1041:
1042: EXCEPTION
1043: WHEN OTHERS THEN
1044: FND_MESSAGE.SET_NAME('IGI','IGI_DOS_WKF_NO_PARENT_POS');
1045: FND_MESSAGE.SET_TOKEN('HIERARCHY_ID',l_hierarchy_id);
1046: FND_MESSAGE.SET_TOKEN('BUS_GRP_ID',l_business_group_id);
1047: FND_MESSAGE.SET_TOKEN('POSITION_ID',l_position_id);
1048: /* =============== START DEBUG LOG ================ */
1049: DEBUG_LOG_UNEXP_ERROR ('getparentposition.Unexp6','USER');

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

1042: EXCEPTION
1043: WHEN OTHERS THEN
1044: FND_MESSAGE.SET_NAME('IGI','IGI_DOS_WKF_NO_PARENT_POS');
1045: FND_MESSAGE.SET_TOKEN('HIERARCHY_ID',l_hierarchy_id);
1046: FND_MESSAGE.SET_TOKEN('BUS_GRP_ID',l_business_group_id);
1047: FND_MESSAGE.SET_TOKEN('POSITION_ID',l_position_id);
1048: /* =============== START DEBUG LOG ================ */
1049: DEBUG_LOG_UNEXP_ERROR ('getparentposition.Unexp6','USER');
1050: /* =============== END DEBUG LOG ================== */

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

1043: WHEN OTHERS THEN
1044: FND_MESSAGE.SET_NAME('IGI','IGI_DOS_WKF_NO_PARENT_POS');
1045: FND_MESSAGE.SET_TOKEN('HIERARCHY_ID',l_hierarchy_id);
1046: FND_MESSAGE.SET_TOKEN('BUS_GRP_ID',l_business_group_id);
1047: FND_MESSAGE.SET_TOKEN('POSITION_ID',l_position_id);
1048: /* =============== START DEBUG LOG ================ */
1049: DEBUG_LOG_UNEXP_ERROR ('getparentposition.Unexp6','USER');
1050: /* =============== END DEBUG LOG ================== */
1051: RAISE par_pos_not_found;

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

1447:
1448: EXCEPTION
1449: --bug 9128478
1450: /* WHEN encumbrance_error THEN
1451: FND_MESSAGE.SET_NAME('IGI','IGI_DOS_WKF_ENCMBRC_ERROR');
1452: FND_MESSAGE.SET_TOKEN('DOSSIER_NUM',l_dossier_num);
1453: FND_MESSAGE.SET_TOKEN('USER_ID',l_user_id);
1454: FND_MESSAGE.SET_TOKEN('RESP_ID',l_responsibility_id);
1455: FND_MESSAGE.SET_TOKEN('SOB_ID',l_sob_id);

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

1448: EXCEPTION
1449: --bug 9128478
1450: /* WHEN encumbrance_error THEN
1451: FND_MESSAGE.SET_NAME('IGI','IGI_DOS_WKF_ENCMBRC_ERROR');
1452: FND_MESSAGE.SET_TOKEN('DOSSIER_NUM',l_dossier_num);
1453: FND_MESSAGE.SET_TOKEN('USER_ID',l_user_id);
1454: FND_MESSAGE.SET_TOKEN('RESP_ID',l_responsibility_id);
1455: FND_MESSAGE.SET_TOKEN('SOB_ID',l_sob_id);
1456: /* =============== START DEBUG LOG ================ */

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

1449: --bug 9128478
1450: /* WHEN encumbrance_error THEN
1451: FND_MESSAGE.SET_NAME('IGI','IGI_DOS_WKF_ENCMBRC_ERROR');
1452: FND_MESSAGE.SET_TOKEN('DOSSIER_NUM',l_dossier_num);
1453: FND_MESSAGE.SET_TOKEN('USER_ID',l_user_id);
1454: FND_MESSAGE.SET_TOKEN('RESP_ID',l_responsibility_id);
1455: FND_MESSAGE.SET_TOKEN('SOB_ID',l_sob_id);
1456: /* =============== START DEBUG LOG ================ */
1457: -- DEBUG_LOG_UNEXP_ERROR ('approve.unexp1','USER');

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

1450: /* WHEN encumbrance_error THEN
1451: FND_MESSAGE.SET_NAME('IGI','IGI_DOS_WKF_ENCMBRC_ERROR');
1452: FND_MESSAGE.SET_TOKEN('DOSSIER_NUM',l_dossier_num);
1453: FND_MESSAGE.SET_TOKEN('USER_ID',l_user_id);
1454: FND_MESSAGE.SET_TOKEN('RESP_ID',l_responsibility_id);
1455: FND_MESSAGE.SET_TOKEN('SOB_ID',l_sob_id);
1456: /* =============== START DEBUG LOG ================ */
1457: -- DEBUG_LOG_UNEXP_ERROR ('approve.unexp1','USER');
1458: /* =============== END DEBUG LOG ================== */

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

1451: FND_MESSAGE.SET_NAME('IGI','IGI_DOS_WKF_ENCMBRC_ERROR');
1452: FND_MESSAGE.SET_TOKEN('DOSSIER_NUM',l_dossier_num);
1453: FND_MESSAGE.SET_TOKEN('USER_ID',l_user_id);
1454: FND_MESSAGE.SET_TOKEN('RESP_ID',l_responsibility_id);
1455: FND_MESSAGE.SET_TOKEN('SOB_ID',l_sob_id);
1456: /* =============== START DEBUG LOG ================ */
1457: -- DEBUG_LOG_UNEXP_ERROR ('approve.unexp1','USER');
1458: /* =============== END DEBUG LOG ================== */
1459:

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

1627:
1628:
1629: EXCEPTION
1630: WHEN unable_to_send_notify THEN
1631: FND_MESSAGE.SET_NAME('IGI','IGI_DOS_WKF_FAIL_SEND_NOTC');
1632: FND_MESSAGE.SET_TOKEN('NOTICE_ID',l_nid);
1633: /* =============== START DEBUG LOG ================ */
1634: DEBUG_LOG_UNEXP_ERROR ('SendApproved.Unexp1','USER');
1635: /* =============== END DEBUG LOG ================== */

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

1628:
1629: EXCEPTION
1630: WHEN unable_to_send_notify THEN
1631: FND_MESSAGE.SET_NAME('IGI','IGI_DOS_WKF_FAIL_SEND_NOTC');
1632: FND_MESSAGE.SET_TOKEN('NOTICE_ID',l_nid);
1633: /* =============== START DEBUG LOG ================ */
1634: DEBUG_LOG_UNEXP_ERROR ('SendApproved.Unexp1','USER');
1635: /* =============== END DEBUG LOG ================== */
1636: result := NULL;

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

1730:
1731: EXCEPTION
1732: --start commented for bug 9104180
1733: -- WHEN unable_to_send_notify THEN
1734: -- FND_MESSAGE.SET_NAME('IGI','IGI_DOS_WKF_FAIL_SEND_NOTC');
1735: -- FND_MESSAGE.SET_TOKEN('NOTICE_ID',l_nid);
1736: /* =============== START DEBUG LOG ================ */
1737: -- DEBUG_LOG_UNEXP_ERROR ('SendRejected.Unexp1','USER');
1738: /* =============== END DEBUG LOG ================== */

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

1731: EXCEPTION
1732: --start commented for bug 9104180
1733: -- WHEN unable_to_send_notify THEN
1734: -- FND_MESSAGE.SET_NAME('IGI','IGI_DOS_WKF_FAIL_SEND_NOTC');
1735: -- FND_MESSAGE.SET_TOKEN('NOTICE_ID',l_nid);
1736: /* =============== START DEBUG LOG ================ */
1737: -- DEBUG_LOG_UNEXP_ERROR ('SendRejected.Unexp1','USER');
1738: /* =============== END DEBUG LOG ================== */
1739: -- Wf_Core.Context ('IGIDOSL','SendRejected', itemtype, itemkey

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

1916: /* =============== END DEBUG LOG ================== */
1917:
1918: EXCEPTION
1919: WHEN e_user_list_not_found THEN
1920: FND_MESSAGE.SET_NAME('IGI','IGI_DOS_WKF_NO_USER_LIST');
1921: /* =============== START DEBUG LOG ================ */
1922: DEBUG_LOG_UNEXP_ERROR ('CreateList.Unexp2','USER');
1923: /* =============== END DEBUG LOG ================== */
1924: Wf_Core.Context ('IGIDOSL', 'CreateList cursor', itemtype, itemkey

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

2223: /* =============== END DEBUG LOG ================== */
2224:
2225: EXCEPTION
2226: /* WHEN unreserve_error THEN
2227: FND_MESSAGE.SET_NAME('IGI','IGI_DOS_WKF_UNRSRV_ERROR');
2228: FND_MESSAGE.SET_TOKEN('TRANS_NUM',l_trx_number);
2229: FND_MESSAGE.SET_TOKEN('USER_ID',l_user_id);
2230: FND_MESSAGE.SET_TOKEN('RESP_ID',l_responsibility_id);
2231: FND_MESSAGE.SET_TOKEN('SOB_ID',l_sob_id);

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

2224:
2225: EXCEPTION
2226: /* WHEN unreserve_error THEN
2227: FND_MESSAGE.SET_NAME('IGI','IGI_DOS_WKF_UNRSRV_ERROR');
2228: FND_MESSAGE.SET_TOKEN('TRANS_NUM',l_trx_number);
2229: FND_MESSAGE.SET_TOKEN('USER_ID',l_user_id);
2230: FND_MESSAGE.SET_TOKEN('RESP_ID',l_responsibility_id);
2231: FND_MESSAGE.SET_TOKEN('SOB_ID',l_sob_id);
2232: /* =============== START DEBUG LOG ================ */

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

2225: EXCEPTION
2226: /* WHEN unreserve_error THEN
2227: FND_MESSAGE.SET_NAME('IGI','IGI_DOS_WKF_UNRSRV_ERROR');
2228: FND_MESSAGE.SET_TOKEN('TRANS_NUM',l_trx_number);
2229: FND_MESSAGE.SET_TOKEN('USER_ID',l_user_id);
2230: FND_MESSAGE.SET_TOKEN('RESP_ID',l_responsibility_id);
2231: FND_MESSAGE.SET_TOKEN('SOB_ID',l_sob_id);
2232: /* =============== START DEBUG LOG ================ */
2233: -- DEBUG_LOG_UNEXP_ERROR ('UnreserveFunds.Unexp1','USER');

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

2226: /* WHEN unreserve_error THEN
2227: FND_MESSAGE.SET_NAME('IGI','IGI_DOS_WKF_UNRSRV_ERROR');
2228: FND_MESSAGE.SET_TOKEN('TRANS_NUM',l_trx_number);
2229: FND_MESSAGE.SET_TOKEN('USER_ID',l_user_id);
2230: FND_MESSAGE.SET_TOKEN('RESP_ID',l_responsibility_id);
2231: FND_MESSAGE.SET_TOKEN('SOB_ID',l_sob_id);
2232: /* =============== START DEBUG LOG ================ */
2233: -- DEBUG_LOG_UNEXP_ERROR ('UnreserveFunds.Unexp1','USER');
2234: /* =============== END DEBUG LOG ================== */

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

2227: FND_MESSAGE.SET_NAME('IGI','IGI_DOS_WKF_UNRSRV_ERROR');
2228: FND_MESSAGE.SET_TOKEN('TRANS_NUM',l_trx_number);
2229: FND_MESSAGE.SET_TOKEN('USER_ID',l_user_id);
2230: FND_MESSAGE.SET_TOKEN('RESP_ID',l_responsibility_id);
2231: FND_MESSAGE.SET_TOKEN('SOB_ID',l_sob_id);
2232: /* =============== START DEBUG LOG ================ */
2233: -- DEBUG_LOG_UNEXP_ERROR ('UnreserveFunds.Unexp1','USER');
2234: /* =============== END DEBUG LOG ================== */
2235: /* Wf_Core.Context ('IGIDOSL', 'UnreserveFunds -Unable to reserve funds for specified packet'

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

2278: DEBUG_LOG_STRING (l_proc_level, 'FrameDosTable.Msg2',
2279: ' Getting messages for Table Heading');
2280: /* =============== END DEBUG LOG ================== */
2281:
2282: -- Getting the Headings FROM fnd message.
2283:
2284: fnd_message.set_name ('IGI', 'IGI_DOS_TRAN_DETS');
2285: l_trans_dets_head := fnd_message.get;
2286: fnd_message.set_name ('IGI', 'IGI_DOS_LINE');

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

2280: /* =============== END DEBUG LOG ================== */
2281:
2282: -- Getting the Headings FROM fnd message.
2283:
2284: fnd_message.set_name ('IGI', 'IGI_DOS_TRAN_DETS');
2285: l_trans_dets_head := fnd_message.get;
2286: fnd_message.set_name ('IGI', 'IGI_DOS_LINE');
2287: l_line_head := fnd_message.get;
2288: fnd_message.set_name ('IGI', 'IGI_DOS_SOURCE_BUDGET');

Line 2285: l_trans_dets_head := fnd_message.get;

2281:
2282: -- Getting the Headings FROM fnd message.
2283:
2284: fnd_message.set_name ('IGI', 'IGI_DOS_TRAN_DETS');
2285: l_trans_dets_head := fnd_message.get;
2286: fnd_message.set_name ('IGI', 'IGI_DOS_LINE');
2287: l_line_head := fnd_message.get;
2288: fnd_message.set_name ('IGI', 'IGI_DOS_SOURCE_BUDGET');
2289: l_source_budget_head := fnd_message.get;

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

2282: -- Getting the Headings FROM fnd message.
2283:
2284: fnd_message.set_name ('IGI', 'IGI_DOS_TRAN_DETS');
2285: l_trans_dets_head := fnd_message.get;
2286: fnd_message.set_name ('IGI', 'IGI_DOS_LINE');
2287: l_line_head := fnd_message.get;
2288: fnd_message.set_name ('IGI', 'IGI_DOS_SOURCE_BUDGET');
2289: l_source_budget_head := fnd_message.get;
2290: fnd_message.set_name ('IGI', 'IGI_DOS_SOURCE_ACCOUNT');

Line 2287: l_line_head := fnd_message.get;

2283:
2284: fnd_message.set_name ('IGI', 'IGI_DOS_TRAN_DETS');
2285: l_trans_dets_head := fnd_message.get;
2286: fnd_message.set_name ('IGI', 'IGI_DOS_LINE');
2287: l_line_head := fnd_message.get;
2288: fnd_message.set_name ('IGI', 'IGI_DOS_SOURCE_BUDGET');
2289: l_source_budget_head := fnd_message.get;
2290: fnd_message.set_name ('IGI', 'IGI_DOS_SOURCE_ACCOUNT');
2291: l_source_account_head := fnd_message.get;

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

2284: fnd_message.set_name ('IGI', 'IGI_DOS_TRAN_DETS');
2285: l_trans_dets_head := fnd_message.get;
2286: fnd_message.set_name ('IGI', 'IGI_DOS_LINE');
2287: l_line_head := fnd_message.get;
2288: fnd_message.set_name ('IGI', 'IGI_DOS_SOURCE_BUDGET');
2289: l_source_budget_head := fnd_message.get;
2290: fnd_message.set_name ('IGI', 'IGI_DOS_SOURCE_ACCOUNT');
2291: l_source_account_head := fnd_message.get;
2292: fnd_message.set_name ('IGI', 'IGI_DOS_SOURCE_PERIOD');

Line 2289: l_source_budget_head := fnd_message.get;

2285: l_trans_dets_head := fnd_message.get;
2286: fnd_message.set_name ('IGI', 'IGI_DOS_LINE');
2287: l_line_head := fnd_message.get;
2288: fnd_message.set_name ('IGI', 'IGI_DOS_SOURCE_BUDGET');
2289: l_source_budget_head := fnd_message.get;
2290: fnd_message.set_name ('IGI', 'IGI_DOS_SOURCE_ACCOUNT');
2291: l_source_account_head := fnd_message.get;
2292: fnd_message.set_name ('IGI', 'IGI_DOS_SOURCE_PERIOD');
2293: l_source_period_head := fnd_message.get;

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

2286: fnd_message.set_name ('IGI', 'IGI_DOS_LINE');
2287: l_line_head := fnd_message.get;
2288: fnd_message.set_name ('IGI', 'IGI_DOS_SOURCE_BUDGET');
2289: l_source_budget_head := fnd_message.get;
2290: fnd_message.set_name ('IGI', 'IGI_DOS_SOURCE_ACCOUNT');
2291: l_source_account_head := fnd_message.get;
2292: fnd_message.set_name ('IGI', 'IGI_DOS_SOURCE_PERIOD');
2293: l_source_period_head := fnd_message.get;
2294: fnd_message.set_name ('IGI', 'IGI_DOS_SOURCE_AMOUNT');

Line 2291: l_source_account_head := fnd_message.get;

2287: l_line_head := fnd_message.get;
2288: fnd_message.set_name ('IGI', 'IGI_DOS_SOURCE_BUDGET');
2289: l_source_budget_head := fnd_message.get;
2290: fnd_message.set_name ('IGI', 'IGI_DOS_SOURCE_ACCOUNT');
2291: l_source_account_head := fnd_message.get;
2292: fnd_message.set_name ('IGI', 'IGI_DOS_SOURCE_PERIOD');
2293: l_source_period_head := fnd_message.get;
2294: fnd_message.set_name ('IGI', 'IGI_DOS_SOURCE_AMOUNT');
2295: l_source_amount_head := fnd_message.get;

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

2288: fnd_message.set_name ('IGI', 'IGI_DOS_SOURCE_BUDGET');
2289: l_source_budget_head := fnd_message.get;
2290: fnd_message.set_name ('IGI', 'IGI_DOS_SOURCE_ACCOUNT');
2291: l_source_account_head := fnd_message.get;
2292: fnd_message.set_name ('IGI', 'IGI_DOS_SOURCE_PERIOD');
2293: l_source_period_head := fnd_message.get;
2294: fnd_message.set_name ('IGI', 'IGI_DOS_SOURCE_AMOUNT');
2295: l_source_amount_head := fnd_message.get;
2296: fnd_message.set_name ('IGI', 'IGI_DOS_DEST_BUDGET');

Line 2293: l_source_period_head := fnd_message.get;

2289: l_source_budget_head := fnd_message.get;
2290: fnd_message.set_name ('IGI', 'IGI_DOS_SOURCE_ACCOUNT');
2291: l_source_account_head := fnd_message.get;
2292: fnd_message.set_name ('IGI', 'IGI_DOS_SOURCE_PERIOD');
2293: l_source_period_head := fnd_message.get;
2294: fnd_message.set_name ('IGI', 'IGI_DOS_SOURCE_AMOUNT');
2295: l_source_amount_head := fnd_message.get;
2296: fnd_message.set_name ('IGI', 'IGI_DOS_DEST_BUDGET');
2297: l_dest_budget_head := fnd_message.get;

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

2290: fnd_message.set_name ('IGI', 'IGI_DOS_SOURCE_ACCOUNT');
2291: l_source_account_head := fnd_message.get;
2292: fnd_message.set_name ('IGI', 'IGI_DOS_SOURCE_PERIOD');
2293: l_source_period_head := fnd_message.get;
2294: fnd_message.set_name ('IGI', 'IGI_DOS_SOURCE_AMOUNT');
2295: l_source_amount_head := fnd_message.get;
2296: fnd_message.set_name ('IGI', 'IGI_DOS_DEST_BUDGET');
2297: l_dest_budget_head := fnd_message.get;
2298: fnd_message.set_name ('IGI', 'IGI_DOS_DEST_ACCOUNT');

Line 2295: l_source_amount_head := fnd_message.get;

2291: l_source_account_head := fnd_message.get;
2292: fnd_message.set_name ('IGI', 'IGI_DOS_SOURCE_PERIOD');
2293: l_source_period_head := fnd_message.get;
2294: fnd_message.set_name ('IGI', 'IGI_DOS_SOURCE_AMOUNT');
2295: l_source_amount_head := fnd_message.get;
2296: fnd_message.set_name ('IGI', 'IGI_DOS_DEST_BUDGET');
2297: l_dest_budget_head := fnd_message.get;
2298: fnd_message.set_name ('IGI', 'IGI_DOS_DEST_ACCOUNT');
2299: l_dest_account_head := fnd_message.get;

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

2292: fnd_message.set_name ('IGI', 'IGI_DOS_SOURCE_PERIOD');
2293: l_source_period_head := fnd_message.get;
2294: fnd_message.set_name ('IGI', 'IGI_DOS_SOURCE_AMOUNT');
2295: l_source_amount_head := fnd_message.get;
2296: fnd_message.set_name ('IGI', 'IGI_DOS_DEST_BUDGET');
2297: l_dest_budget_head := fnd_message.get;
2298: fnd_message.set_name ('IGI', 'IGI_DOS_DEST_ACCOUNT');
2299: l_dest_account_head := fnd_message.get;
2300: fnd_message.set_name ('IGI', 'IGI_DOS_DEST_PERIOD');

Line 2297: l_dest_budget_head := fnd_message.get;

2293: l_source_period_head := fnd_message.get;
2294: fnd_message.set_name ('IGI', 'IGI_DOS_SOURCE_AMOUNT');
2295: l_source_amount_head := fnd_message.get;
2296: fnd_message.set_name ('IGI', 'IGI_DOS_DEST_BUDGET');
2297: l_dest_budget_head := fnd_message.get;
2298: fnd_message.set_name ('IGI', 'IGI_DOS_DEST_ACCOUNT');
2299: l_dest_account_head := fnd_message.get;
2300: fnd_message.set_name ('IGI', 'IGI_DOS_DEST_PERIOD');
2301: l_dest_period_head := fnd_message.get;

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

2294: fnd_message.set_name ('IGI', 'IGI_DOS_SOURCE_AMOUNT');
2295: l_source_amount_head := fnd_message.get;
2296: fnd_message.set_name ('IGI', 'IGI_DOS_DEST_BUDGET');
2297: l_dest_budget_head := fnd_message.get;
2298: fnd_message.set_name ('IGI', 'IGI_DOS_DEST_ACCOUNT');
2299: l_dest_account_head := fnd_message.get;
2300: fnd_message.set_name ('IGI', 'IGI_DOS_DEST_PERIOD');
2301: l_dest_period_head := fnd_message.get;
2302: fnd_message.set_name ('IGI', 'IGI_DOS_DEST_AMOUNT');

Line 2299: l_dest_account_head := fnd_message.get;

2295: l_source_amount_head := fnd_message.get;
2296: fnd_message.set_name ('IGI', 'IGI_DOS_DEST_BUDGET');
2297: l_dest_budget_head := fnd_message.get;
2298: fnd_message.set_name ('IGI', 'IGI_DOS_DEST_ACCOUNT');
2299: l_dest_account_head := fnd_message.get;
2300: fnd_message.set_name ('IGI', 'IGI_DOS_DEST_PERIOD');
2301: l_dest_period_head := fnd_message.get;
2302: fnd_message.set_name ('IGI', 'IGI_DOS_DEST_AMOUNT');
2303: l_dest_amount_head := fnd_message.get;

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

2296: fnd_message.set_name ('IGI', 'IGI_DOS_DEST_BUDGET');
2297: l_dest_budget_head := fnd_message.get;
2298: fnd_message.set_name ('IGI', 'IGI_DOS_DEST_ACCOUNT');
2299: l_dest_account_head := fnd_message.get;
2300: fnd_message.set_name ('IGI', 'IGI_DOS_DEST_PERIOD');
2301: l_dest_period_head := fnd_message.get;
2302: fnd_message.set_name ('IGI', 'IGI_DOS_DEST_AMOUNT');
2303: l_dest_amount_head := fnd_message.get;
2304:

Line 2301: l_dest_period_head := fnd_message.get;

2297: l_dest_budget_head := fnd_message.get;
2298: fnd_message.set_name ('IGI', 'IGI_DOS_DEST_ACCOUNT');
2299: l_dest_account_head := fnd_message.get;
2300: fnd_message.set_name ('IGI', 'IGI_DOS_DEST_PERIOD');
2301: l_dest_period_head := fnd_message.get;
2302: fnd_message.set_name ('IGI', 'IGI_DOS_DEST_AMOUNT');
2303: l_dest_amount_head := fnd_message.get;
2304:
2305: /* =============== START DEBUG LOG ================ */

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

2298: fnd_message.set_name ('IGI', 'IGI_DOS_DEST_ACCOUNT');
2299: l_dest_account_head := fnd_message.get;
2300: fnd_message.set_name ('IGI', 'IGI_DOS_DEST_PERIOD');
2301: l_dest_period_head := fnd_message.get;
2302: fnd_message.set_name ('IGI', 'IGI_DOS_DEST_AMOUNT');
2303: l_dest_amount_head := fnd_message.get;
2304:
2305: /* =============== START DEBUG LOG ================ */
2306: DEBUG_LOG_STRING (l_proc_level, 'FrameDosTable.Msg3',

Line 2303: l_dest_amount_head := fnd_message.get;

2299: l_dest_account_head := fnd_message.get;
2300: fnd_message.set_name ('IGI', 'IGI_DOS_DEST_PERIOD');
2301: l_dest_period_head := fnd_message.get;
2302: fnd_message.set_name ('IGI', 'IGI_DOS_DEST_AMOUNT');
2303: l_dest_amount_head := fnd_message.get;
2304:
2305: /* =============== START DEBUG LOG ================ */
2306: DEBUG_LOG_STRING (l_proc_level, 'FrameDosTable.Msg3',
2307: ' Heading Done - Now Framing the table ');

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

2571:
2572: l_source_total := 0;
2573:
2574: -- getting grand total test message.
2575: fnd_message.set_name ('IGI','IGI_DOS_TOTAL');
2576: g_total_text := fnd_message.get;
2577:
2578: FOR source_rec IN c_get_sources LOOP
2579:

Line 2576: g_total_text := fnd_message.get;

2572: l_source_total := 0;
2573:
2574: -- getting grand total test message.
2575: fnd_message.set_name ('IGI','IGI_DOS_TOTAL');
2576: g_total_text := fnd_message.get;
2577:
2578: FOR source_rec IN c_get_sources LOOP
2579:
2580: /* =============== START DEBUG LOG ================ */

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

2689:
2690: END LOOP; -- sources
2691:
2692: -- getting grand total test message.
2693: fnd_message.set_name ('IGI','IGI_DOS_GRAND_TOTAL');
2694: g_total_text := fnd_message.get;
2695:
2696: /* =============== START DEBUG LOG ================ */
2697: DEBUG_LOG_STRING (l_proc_level, 'dossier_transaction_detail.Msg24.1',

Line 2694: g_total_text := fnd_message.get;

2690: END LOOP; -- sources
2691:
2692: -- getting grand total test message.
2693: fnd_message.set_name ('IGI','IGI_DOS_GRAND_TOTAL');
2694: g_total_text := fnd_message.get;
2695:
2696: /* =============== START DEBUG LOG ================ */
2697: DEBUG_LOG_STRING (l_proc_level, 'dossier_transaction_detail.Msg24.1',
2698: ' Calling AddTotalToTable to set the grand total ');