DBA Data[Home] [Help]

APPS.IGC_CC_PO_INTERFACE_PKG dependencies on FND_MESSAGE

Line 41: fnd_message.set_name('IGC','IGC_CC_PREPARER_EMPLOYEE_ID');

37: FROM fnd_user
38: WHERE user_id = p_cc_headers_rec.cc_preparer_user_id;
39: EXCEPTION
40: WHEN NO_DATA_FOUND THEN
41: fnd_message.set_name('IGC','IGC_CC_PREPARER_EMPLOYEE_ID');
42: fnd_message.set_token('PREPARER_ID',to_char(p_cc_headers_rec.cc_preparer_user_id),TRUE);
43: fnd_msg_pub.add;
44: RAISE E_EMPLOYEE_NOT_FOUND;
45: END;

Line 42: fnd_message.set_token('PREPARER_ID',to_char(p_cc_headers_rec.cc_preparer_user_id),TRUE);

38: WHERE user_id = p_cc_headers_rec.cc_preparer_user_id;
39: EXCEPTION
40: WHEN NO_DATA_FOUND THEN
41: fnd_message.set_name('IGC','IGC_CC_PREPARER_EMPLOYEE_ID');
42: fnd_message.set_token('PREPARER_ID',to_char(p_cc_headers_rec.cc_preparer_user_id),TRUE);
43: fnd_msg_pub.add;
44: RAISE E_EMPLOYEE_NOT_FOUND;
45: END;
46:

Line 49: fnd_message.set_name('IGC','IGC_CC_PREPARER_EMPLOYEE_ID');

45: END;
46:
47: -- bug 2973033 - ssmales 30-May-2003 added IF statement below for preparers without linked employee
48: IF l_employee_id IS NULL THEN
49: fnd_message.set_name('IGC','IGC_CC_PREPARER_EMPLOYEE_ID');
50: fnd_message.set_token('PREPARER_ID',to_char(p_cc_headers_rec.cc_preparer_user_id),TRUE);
51: fnd_msg_pub.add;
52: RAISE E_EMPLOYEE_NOT_FOUND;
53: END IF;

Line 50: fnd_message.set_token('PREPARER_ID',to_char(p_cc_headers_rec.cc_preparer_user_id),TRUE);

46:
47: -- bug 2973033 - ssmales 30-May-2003 added IF statement below for preparers without linked employee
48: IF l_employee_id IS NULL THEN
49: fnd_message.set_name('IGC','IGC_CC_PREPARER_EMPLOYEE_ID');
50: fnd_message.set_token('PREPARER_ID',to_char(p_cc_headers_rec.cc_preparer_user_id),TRUE);
51: fnd_msg_pub.add;
52: RAISE E_EMPLOYEE_NOT_FOUND;
53: END IF;
54:

Line 270: fnd_message.set_name('IGC','IGC_CC_PO_LINE_TYPE');

266: WHERE line_type_id = l_line_type_id;
267: -- bug 4097669, end 2
268: EXCEPTION
269: WHEN NO_DATA_FOUND THEN
270: fnd_message.set_name('IGC','IGC_CC_PO_LINE_TYPE');
271: fnd_message.set_token('PO_LINE_TYPE','IGC CONTRACT COMMITMENT',TRUE);
272: fnd_msg_pub.add;
273: RAISE E_CC_PO_LINE_TYPE;
274: END;

Line 271: fnd_message.set_token('PO_LINE_TYPE','IGC CONTRACT COMMITMENT',TRUE);

267: -- bug 4097669, end 2
268: EXCEPTION
269: WHEN NO_DATA_FOUND THEN
270: fnd_message.set_name('IGC','IGC_CC_PO_LINE_TYPE');
271: fnd_message.set_token('PO_LINE_TYPE','IGC CONTRACT COMMITMENT',TRUE);
272: fnd_msg_pub.add;
273: RAISE E_CC_PO_LINE_TYPE;
274: END;
275:

Line 644: fnd_message.set_name('IGC','IGC_CC_GL_PERIOD_NOT_FOUND');

640: (gp.end_date >= TRUNC(l_po_dist_rec.gl_encumbered_date) ) );
641:
642: EXCEPTION
643: WHEN NO_DATA_FOUND THEN
644: fnd_message.set_name('IGC','IGC_CC_GL_PERIOD_NOT_FOUND');
645: fnd_message.set_token('PF_LINE_NUM',p_cc_pmt_fcst_rec.cc_det_pf_line_num,TRUE);
646: fnd_msg_pub.add;
647: RAISE E_CC_GL_PERIOD;
648: END;

Line 645: fnd_message.set_token('PF_LINE_NUM',p_cc_pmt_fcst_rec.cc_det_pf_line_num,TRUE);

641:
642: EXCEPTION
643: WHEN NO_DATA_FOUND THEN
644: fnd_message.set_name('IGC','IGC_CC_GL_PERIOD_NOT_FOUND');
645: fnd_message.set_token('PF_LINE_NUM',p_cc_pmt_fcst_rec.cc_det_pf_line_num,TRUE);
646: fnd_msg_pub.add;
647: RAISE E_CC_GL_PERIOD;
648: END;
649: ELSE

Line 871: fnd_message.set_name('IGC','IGC_CC_NOT_FOUND');

867:
868: EXCEPTION
869: WHEN no_data_found
870: THEN
871: fnd_message.set_name('IGC','IGC_CC_NOT_FOUND');
872: fnd_message.set_token('CC_NUM',to_char(p_cc_header_id),TRUE);
873: fnd_msg_pub.add;
874: RAISE E_CC_NOT_FOUND;
875: END;

Line 872: fnd_message.set_token('CC_NUM',to_char(p_cc_header_id),TRUE);

868: EXCEPTION
869: WHEN no_data_found
870: THEN
871: fnd_message.set_name('IGC','IGC_CC_NOT_FOUND');
872: fnd_message.set_token('CC_NUM',to_char(p_cc_header_id),TRUE);
873: fnd_msg_pub.add;
874: RAISE E_CC_NOT_FOUND;
875: END;
876:

Line 880: fnd_message.set_name('IGC','IGC_CC_INVALID_CC_TYPE');

876:
877: IF ( (l_cc_headers_rec.cc_type IS NOT NULL) AND
878: (l_cc_headers_rec.cc_type = 'C') )
879: THEN
880: fnd_message.set_name('IGC','IGC_CC_INVALID_CC_TYPE');
881: fnd_message.set_token('CC_NUM',l_cc_headers_rec.cc_num,TRUE);
882: fnd_msg_pub.add;
883: RAISE e_cc_type;
884: END IF;

Line 881: fnd_message.set_token('CC_NUM',l_cc_headers_rec.cc_num,TRUE);

877: IF ( (l_cc_headers_rec.cc_type IS NOT NULL) AND
878: (l_cc_headers_rec.cc_type = 'C') )
879: THEN
880: fnd_message.set_name('IGC','IGC_CC_INVALID_CC_TYPE');
881: fnd_message.set_token('CC_NUM',l_cc_headers_rec.cc_num,TRUE);
882: fnd_msg_pub.add;
883: RAISE e_cc_type;
884: END IF;
885:

Line 889: fnd_message.set_name('IGC','IGC_CC_INVALID_CC_STATE');

885:
886: IF ((l_cc_headers_rec.cc_state IS NOT NULL) AND
887: ((l_cc_headers_rec.cc_state = 'CL') OR (l_cc_headers_rec.cc_state = 'PR')))
888: THEN
889: fnd_message.set_name('IGC','IGC_CC_INVALID_CC_STATE');
890: fnd_message.set_token('CC_NUM',l_cc_headers_rec.cc_num,TRUE);
891: fnd_msg_pub.add;
892: RAISE e_cc_state;
893: END IF;

Line 890: fnd_message.set_token('CC_NUM',l_cc_headers_rec.cc_num,TRUE);

886: IF ((l_cc_headers_rec.cc_state IS NOT NULL) AND
887: ((l_cc_headers_rec.cc_state = 'CL') OR (l_cc_headers_rec.cc_state = 'PR')))
888: THEN
889: fnd_message.set_name('IGC','IGC_CC_INVALID_CC_STATE');
890: fnd_message.set_token('CC_NUM',l_cc_headers_rec.cc_num,TRUE);
891: fnd_msg_pub.add;
892: RAISE e_cc_state;
893: END IF;
894:

Line 923: fnd_message.set_name('IGC','IGC_CC_UNABLE_TO_OPEN_PO');

919: END;
920:
921: IF (l_curr_year_pf_lines = 0)
922: THEN
923: fnd_message.set_name('IGC','IGC_CC_UNABLE_TO_OPEN_PO');
924: fnd_message.set_token('CC_NUM',l_cc_headers_rec.cc_num,TRUE);
925: fnd_msg_pub.add;
926: RAISE e_unable_to_open_po;
927: ELSIF (l_curr_year_pf_lines > 0)

Line 924: fnd_message.set_token('CC_NUM',l_cc_headers_rec.cc_num,TRUE);

920:
921: IF (l_curr_year_pf_lines = 0)
922: THEN
923: fnd_message.set_name('IGC','IGC_CC_UNABLE_TO_OPEN_PO');
924: fnd_message.set_token('CC_NUM',l_cc_headers_rec.cc_num,TRUE);
925: fnd_msg_pub.add;
926: RAISE e_unable_to_open_po;
927: ELSIF (l_curr_year_pf_lines > 0)
928: THEN

Line 942: fnd_message.set_name('IGC','IGC_CC_PO_NOT_FOUND');

938: org_id = l_cc_headers_rec.org_id;
939: EXCEPTION
940: WHEN no_data_found
941: THEN
942: fnd_message.set_name('IGC','IGC_CC_PO_NOT_FOUND');
943: fnd_message.set_token('CC_NUM',l_cc_headers_rec.cc_num,TRUE);
944: fnd_msg_pub.add;
945: RAISE e_po_not_found;
946: END;

Line 943: fnd_message.set_token('CC_NUM',l_cc_headers_rec.cc_num,TRUE);

939: EXCEPTION
940: WHEN no_data_found
941: THEN
942: fnd_message.set_name('IGC','IGC_CC_PO_NOT_FOUND');
943: fnd_message.set_token('CC_NUM',l_cc_headers_rec.cc_num,TRUE);
944: fnd_msg_pub.add;
945: RAISE e_po_not_found;
946: END;
947: END IF;

Line 1281: fnd_message.set_name('IGC','IGC_CC_NOT_FOUND');

1277:
1278: EXCEPTION
1279: WHEN no_data_found
1280: THEN
1281: fnd_message.set_name('IGC','IGC_CC_NOT_FOUND');
1282: fnd_message.set_token('CC_NUM',to_char(p_cc_header_id),TRUE);
1283: fnd_msg_pub.add;
1284: RAISE E_CC_NOT_FOUND;
1285: END;

Line 1282: fnd_message.set_token('CC_NUM',to_char(p_cc_header_id),TRUE);

1278: EXCEPTION
1279: WHEN no_data_found
1280: THEN
1281: fnd_message.set_name('IGC','IGC_CC_NOT_FOUND');
1282: fnd_message.set_token('CC_NUM',to_char(p_cc_header_id),TRUE);
1283: fnd_msg_pub.add;
1284: RAISE E_CC_NOT_FOUND;
1285: END;
1286:

Line 1290: fnd_message.set_name('IGC','IGC_CC_INVALID_CC_TYPE');

1286:
1287: IF ( (l_cc_headers_rec.cc_type IS NOT NULL) AND
1288: (l_cc_headers_rec.cc_type = 'C') )
1289: THEN
1290: fnd_message.set_name('IGC','IGC_CC_INVALID_CC_TYPE');
1291: fnd_message.set_token('CC_NUM',l_cc_headers_rec.cc_num,TRUE);
1292: fnd_msg_pub.add;
1293: RAISE e_cc_type;
1294: END IF;

Line 1291: fnd_message.set_token('CC_NUM',l_cc_headers_rec.cc_num,TRUE);

1287: IF ( (l_cc_headers_rec.cc_type IS NOT NULL) AND
1288: (l_cc_headers_rec.cc_type = 'C') )
1289: THEN
1290: fnd_message.set_name('IGC','IGC_CC_INVALID_CC_TYPE');
1291: fnd_message.set_token('CC_NUM',l_cc_headers_rec.cc_num,TRUE);
1292: fnd_msg_pub.add;
1293: RAISE e_cc_type;
1294: END IF;
1295:

Line 1299: fnd_message.set_name('IGC','IGC_CC_INVALID_CC_STATE');

1295:
1296: IF ((l_cc_headers_rec.cc_state IS NOT NULL) AND
1297: ((l_cc_headers_rec.cc_state = 'CL') OR (l_cc_headers_rec.cc_state = 'PR')))
1298: THEN
1299: fnd_message.set_name('IGC','IGC_CC_INVALID_CC_STATE');
1300: fnd_message.set_token('CC_NUM',l_cc_headers_rec.cc_num,TRUE);
1301: fnd_msg_pub.add;
1302: RAISE e_cc_state;
1303: END IF;

Line 1300: fnd_message.set_token('CC_NUM',l_cc_headers_rec.cc_num,TRUE);

1296: IF ((l_cc_headers_rec.cc_state IS NOT NULL) AND
1297: ((l_cc_headers_rec.cc_state = 'CL') OR (l_cc_headers_rec.cc_state = 'PR')))
1298: THEN
1299: fnd_message.set_name('IGC','IGC_CC_INVALID_CC_STATE');
1300: fnd_message.set_token('CC_NUM',l_cc_headers_rec.cc_num,TRUE);
1301: fnd_msg_pub.add;
1302: RAISE e_cc_state;
1303: END IF;
1304:

Line 1341: fnd_message.set_name('IGC','IGC_CC_CC_NOT_ENCUMBERED');

1337: THEN
1338: /* Check whether Contract Commitment is encumbered */
1339: IF (l_cc_headers_rec.cc_encmbrnc_status <> 'C')
1340: THEN
1341: fnd_message.set_name('IGC','IGC_CC_CC_NOT_ENCUMBERED');
1342: fnd_message.set_token('CC_NUM',l_cc_headers_rec.cc_num,TRUE);
1343: fnd_msg_pub.add;
1344: RAISE e_cc_not_encumbered;
1345: END IF;

Line 1342: fnd_message.set_token('CC_NUM',l_cc_headers_rec.cc_num,TRUE);

1338: /* Check whether Contract Commitment is encumbered */
1339: IF (l_cc_headers_rec.cc_encmbrnc_status <> 'C')
1340: THEN
1341: fnd_message.set_name('IGC','IGC_CC_CC_NOT_ENCUMBERED');
1342: fnd_message.set_token('CC_NUM',l_cc_headers_rec.cc_num,TRUE);
1343: fnd_msg_pub.add;
1344: RAISE e_cc_not_encumbered;
1345: END IF;
1346: END IF;

Line 1350: fnd_message.set_name('IGC','IGC_CC_CC_NOT_APPROVED');

1346: END IF;
1347: END IF;
1348: ELSE
1349: /* Contract Commitment is not approved */
1350: fnd_message.set_name('IGC','IGC_CC_CC_NOT_APPROVED');
1351: fnd_message.set_token('CC_NUM',l_cc_headers_rec.cc_num,TRUE);
1352: fnd_msg_pub.add;
1353: RAISE e_cc_not_approved;
1354: END IF;

Line 1351: fnd_message.set_token('CC_NUM',l_cc_headers_rec.cc_num,TRUE);

1347: END IF;
1348: ELSE
1349: /* Contract Commitment is not approved */
1350: fnd_message.set_name('IGC','IGC_CC_CC_NOT_APPROVED');
1351: fnd_message.set_token('CC_NUM',l_cc_headers_rec.cc_num,TRUE);
1352: fnd_msg_pub.add;
1353: RAISE e_cc_not_approved;
1354: END IF;
1355: END IF;

Line 1996: fnd_message.set_name('IGC','IGC_CC_NOT_FOUND');

1992:
1993: EXCEPTION
1994: WHEN no_data_found
1995: THEN
1996: fnd_message.set_name('IGC','IGC_CC_NOT_FOUND');
1997: fnd_message.set_token('CC_NUM',to_char(p_cc_header_id),TRUE);
1998: fnd_msg_pub.add;
1999: RAISE E_CC_NOT_FOUND;
2000: END;

Line 1997: fnd_message.set_token('CC_NUM',to_char(p_cc_header_id),TRUE);

1993: EXCEPTION
1994: WHEN no_data_found
1995: THEN
1996: fnd_message.set_name('IGC','IGC_CC_NOT_FOUND');
1997: fnd_message.set_token('CC_NUM',to_char(p_cc_header_id),TRUE);
1998: fnd_msg_pub.add;
1999: RAISE E_CC_NOT_FOUND;
2000: END;
2001:

Line 2009: fnd_message.set_name('IGC','IGC_CC_PO_NOT_FOUND');

2005:
2006: IF (C%NOTFOUND)
2007: THEN
2008: CLOSE C;
2009: fnd_message.set_name('IGC','IGC_CC_PO_NOT_FOUND');
2010: fnd_message.set_token('CC_NUM',l_cc_headers_rec.cc_num,TRUE);
2011: fnd_msg_pub.add;
2012: RAISE e_po_not_found;
2013:

Line 2010: fnd_message.set_token('CC_NUM',l_cc_headers_rec.cc_num,TRUE);

2006: IF (C%NOTFOUND)
2007: THEN
2008: CLOSE C;
2009: fnd_message.set_name('IGC','IGC_CC_PO_NOT_FOUND');
2010: fnd_message.set_token('CC_NUM',l_cc_headers_rec.cc_num,TRUE);
2011: fnd_msg_pub.add;
2012: RAISE e_po_not_found;
2013:
2014: END IF;