DBA Data[Home] [Help]

APPS.CN_PAYRUN_PVT dependencies on FND_MESSAGE

Line 80: fnd_message.set_name('CN', 'CN_PAYRUN_DOES_NOT_EXIST');

76:
77: IF get_old_record%rowcount = 0 THEN
78: --Error condition
79: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)THEN
80: fnd_message.set_name('CN', 'CN_PAYRUN_DOES_NOT_EXIST');
81: fnd_msg_pub.add;
82: END IF;
83: x_loading_status := 'CN_PAYRUN_DOES_NOT_EXIST';
84: RAISE FND_API.G_EXC_ERROR;

Line 92: fnd_message.set_name('CN', 'CN_PAYRUN_PAID');

88:
89: IF l_old_record.status IN ('PAID', 'RETURNED_FUNDS', 'PAID_WITH_RETURNS') THEN
90: --Error condition
91: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)THEN
92: fnd_message.set_name('CN', 'CN_PAYRUN_PAID');
93: fnd_msg_pub.add;
94: END IF;
95: x_loading_status := 'CN_PAYRUN_PAID';
96: RAISE FND_API.G_EXC_ERROR;

Line 102: fnd_message.set_name('CN', 'CN_PAYRUN_FROZEN');

98:
99: IF l_old_record.status = 'FROZEN' THEN
100: --Error condition
101: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)THEN
102: fnd_message.set_name('CN', 'CN_PAYRUN_FROZEN');
103: fnd_msg_pub.add;
104: END IF;
105: x_loading_status := 'CN_PAYRUN_FROZEN';
106: RAISE FND_API.G_EXC_ERROR;

Line 614: fnd_message.set_name('CN', 'CN_BATCH_HEADER_FAILED');

610: IF l_batch_id IS NULL THEN
611: --Error condition
612: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
613: THEN
614: fnd_message.set_name('CN', 'CN_BATCH_HEADER_FAILED');
615: fnd_msg_pub.add;
616: END IF;
617:
618: x_loading_status := 'CN_BATCH_HEADER_FAILED';

Line 658: fnd_message.set_name('CN', 'CN_BATCH_LINE_FAILED');

654: IF l_batch_line_id IS NULL THEN
655: --Error condition
656: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
657: THEN
658: fnd_message.set_name('CN', 'CN_BATCH_LINE_FAILED');
659: fnd_msg_pub.add;
660: END IF;
661:
662: x_loading_status := 'CN_BATCH_LINE_FAILED';

Line 751: fnd_message.set_name('CN', 'CN_INVALID_PAYRUN');

747: IF p_payrun_id IS NULL THEN
748: --Error condition
749: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
750: THEN
751: fnd_message.set_name('CN', 'CN_INVALID_PAYRUN');
752: fnd_msg_pub.add;
753: END IF;
754: x_loading_status := 'CN_INVALID_PAYRUN';
755: RAISE FND_API.G_EXC_ERROR;

Line 876: fnd_message.set_name('CN', 'CN_PE_PAYE_MAPPING');

872:
873: IF l_quota_payelements = 0 THEN
874: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
875: THEN
876: fnd_message.set_name('CN', 'CN_PE_PAYE_MAPPING');
877: fnd_msg_pub.add;
878: END IF;
879:
880: x_loading_status := 'CN_PE_PAYE_MAPPING';

Line 891: fnd_message.set_name('CN', 'CN_PE_MAPPING');

887:
888: IF l_num_pe_mapping = 0 THEN
889: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
890: THEN
891: fnd_message.set_name('CN', 'CN_PE_MAPPING');
892: fnd_message.set_token('PE_NAME', quotas.name);
893: fnd_msg_pub.add;
894: END IF;
895:

Line 892: fnd_message.set_token('PE_NAME', quotas.name);

888: IF l_num_pe_mapping = 0 THEN
889: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
890: THEN
891: fnd_message.set_name('CN', 'CN_PE_MAPPING');
892: fnd_message.set_token('PE_NAME', quotas.name);
893: fnd_msg_pub.add;
894: END IF;
895:
896: x_loading_status := 'CN_PE_MAPPING';

Line 955: fnd_message.set_name('CN', 'CN_INVALID_PAY_DATE');

951:
952: --Error condition
953: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
954: THEN
955: fnd_message.set_name('CN', 'CN_INVALID_PAY_DATE');
956: fnd_msg_pub.add;
957: END IF;
958:
959: x_loading_status := 'CN_INVALID_PAY_DATE';

Line 1016: fnd_message.set_name('CN', 'CN_INVALID_PAYRUN_STATUS');

1012:
1013: --Error condition
1014: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1015: THEN
1016: fnd_message.set_name('CN', 'CN_INVALID_PAYRUN_STATUS');
1017: fnd_msg_pub.add;
1018: END IF;
1019:
1020: x_loading_status := 'CN_INVALID_PAYRUN_STATUS';

Line 1086: fnd_message.set_name('CN', 'CN_NUNIQUE_PAYRUN_NAME');

1082:
1083: --Error condition
1084: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1085: THEN
1086: fnd_message.set_name('CN', 'CN_NUNIQUE_PAYRUN_NAME');
1087: fnd_msg_pub.add;
1088: END IF;
1089:
1090: x_loading_status := 'CN_NUNIQUE_PAYRUN_NAME';

Line 1158: fnd_message.set_name('CN', 'CN_INVALID_PAY_GROUP');

1154:
1155: --Error condition
1156: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1157: THEN
1158: fnd_message.set_name('CN', 'CN_INVALID_PAY_GROUP');
1159: fnd_msg_pub.add;
1160: END IF;
1161:
1162: x_loading_status := 'CN_INVALID_PAY_GROUP';

Line 1235: fnd_message.set_name('CN', 'CN_INVALID_PAY_PERIOD');

1231:
1232: --Error condition
1233: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1234: THEN
1235: fnd_message.set_name('CN', 'CN_INVALID_PAY_PERIOD');
1236: fnd_msg_pub.add;
1237: END IF;
1238:
1239: x_loading_status := 'CN_INVALID_PAY_PERIOD';

Line 1307: fnd_message.set_name('CN', 'CN_UNPAID_PAYRUN_EXISTS');

1303:
1304: --Error condition
1305: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1306: THEN
1307: fnd_message.set_name('CN', 'CN_UNPAID_PAYRUN_EXISTS');
1308: fnd_msg_pub.add;
1309: END IF;
1310:
1311: x_loading_status := 'CN_UNPAID_PAYRUN_EXISTS';

Line 1402: fnd_message.set_name('CN', 'CN_NEWER_PAYRUN_EXISTS');

1398:
1399: --Error condition
1400: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1401: THEN
1402: fnd_message.set_name('CN', 'CN_NEWER_PAYRUN_EXISTS');
1403: fnd_msg_pub.add;
1404: END IF;
1405:
1406: x_loading_status := 'CN_NEWER_PAYRUN_EXISTS';

Line 1999: fnd_message.set_name('CN', 'CN_INVALID_INCENTIVE_TYPE');

1995: THEN
1996: --Error condition
1997: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1998: THEN
1999: fnd_message.set_name('CN', 'CN_INVALID_INCENTIVE_TYPE');
2000: fnd_msg_pub.add;
2001: END IF;
2002:
2003: x_loading_status := 'CN_INVALID_INCENTIVE_TYPE';

Line 2014: fnd_message.set_name('CN', 'CN_PAY_BY_TRANSACTION_PROFILE');

2010: THEN
2011:
2012: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2013: THEN
2014: fnd_message.set_name('CN', 'CN_PAY_BY_TRANSACTION_PROFILE');
2015: fnd_msg_pub.add;
2016: END IF;
2017: x_loading_status := 'CN_PAY_BY_TRANSACTION_PROFILE';
2018: RAISE FND_API.G_EXC_ERROR;

Line 2042: fnd_message.set_name('CN', 'CN_PMT_CRE_NOTE');

2038:
2039: x_loading_status := 'CN_INSERTED';
2040:
2041: -- End of API body.
2042: fnd_message.set_name('CN', 'CN_PMT_CRE_NOTE');
2043: fnd_message.set_token('PMTBATCH_NAME', rtrim(ltrim(p_payrun_rec.name)));
2044: l_note_msg := fnd_message.get;
2045:
2046: jtf_notes_pub.create_note

Line 2043: fnd_message.set_token('PMTBATCH_NAME', rtrim(ltrim(p_payrun_rec.name)));

2039: x_loading_status := 'CN_INSERTED';
2040:
2041: -- End of API body.
2042: fnd_message.set_name('CN', 'CN_PMT_CRE_NOTE');
2043: fnd_message.set_token('PMTBATCH_NAME', rtrim(ltrim(p_payrun_rec.name)));
2044: l_note_msg := fnd_message.get;
2045:
2046: jtf_notes_pub.create_note
2047: (p_api_version => 1.0,

Line 2044: l_note_msg := fnd_message.get;

2040:
2041: -- End of API body.
2042: fnd_message.set_name('CN', 'CN_PMT_CRE_NOTE');
2043: fnd_message.set_token('PMTBATCH_NAME', rtrim(ltrim(p_payrun_rec.name)));
2044: l_note_msg := fnd_message.get;
2045:
2046: jtf_notes_pub.create_note
2047: (p_api_version => 1.0,
2048: x_return_status => x_return_status,

Line 2204: fnd_message.set_name ('CN', 'CN_RECORD_CHANGED');

2200: IF l_old_record.object_version_number <> p_x_obj_ver_number
2201: THEN
2202: IF (fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error))
2203: THEN
2204: fnd_message.set_name ('CN', 'CN_RECORD_CHANGED');
2205: fnd_msg_pub.ADD;
2206: END IF;
2207:
2208: RAISE fnd_api.g_exc_error;

Line 2298: fnd_message.set_name('CN', 'CN_PMT_UPD_NOTE');

2294: FETCH get_old_record INTO l_old_record;
2295: close get_old_record;
2296:
2297: IF p_action <> 'REFRESH' THEN
2298: fnd_message.set_name('CN', 'CN_PMT_UPD_NOTE');
2299: fnd_message.set_token('NEW', l_old_record.statusmeaning);
2300: fnd_message.set_token('OLD', l_status_meaning);
2301: l_note_msg := fnd_message.get;
2302: ELSE

Line 2299: fnd_message.set_token('NEW', l_old_record.statusmeaning);

2295: close get_old_record;
2296:
2297: IF p_action <> 'REFRESH' THEN
2298: fnd_message.set_name('CN', 'CN_PMT_UPD_NOTE');
2299: fnd_message.set_token('NEW', l_old_record.statusmeaning);
2300: fnd_message.set_token('OLD', l_status_meaning);
2301: l_note_msg := fnd_message.get;
2302: ELSE
2303: fnd_message.set_name('CN', 'CN_PMT_REF_NOTE');

Line 2300: fnd_message.set_token('OLD', l_status_meaning);

2296:
2297: IF p_action <> 'REFRESH' THEN
2298: fnd_message.set_name('CN', 'CN_PMT_UPD_NOTE');
2299: fnd_message.set_token('NEW', l_old_record.statusmeaning);
2300: fnd_message.set_token('OLD', l_status_meaning);
2301: l_note_msg := fnd_message.get;
2302: ELSE
2303: fnd_message.set_name('CN', 'CN_PMT_REF_NOTE');
2304: fnd_message.set_token('PMTBATCH_NAME', l_old_record.name);

Line 2301: l_note_msg := fnd_message.get;

2297: IF p_action <> 'REFRESH' THEN
2298: fnd_message.set_name('CN', 'CN_PMT_UPD_NOTE');
2299: fnd_message.set_token('NEW', l_old_record.statusmeaning);
2300: fnd_message.set_token('OLD', l_status_meaning);
2301: l_note_msg := fnd_message.get;
2302: ELSE
2303: fnd_message.set_name('CN', 'CN_PMT_REF_NOTE');
2304: fnd_message.set_token('PMTBATCH_NAME', l_old_record.name);
2305: l_note_msg := fnd_message.get;

Line 2303: fnd_message.set_name('CN', 'CN_PMT_REF_NOTE');

2299: fnd_message.set_token('NEW', l_old_record.statusmeaning);
2300: fnd_message.set_token('OLD', l_status_meaning);
2301: l_note_msg := fnd_message.get;
2302: ELSE
2303: fnd_message.set_name('CN', 'CN_PMT_REF_NOTE');
2304: fnd_message.set_token('PMTBATCH_NAME', l_old_record.name);
2305: l_note_msg := fnd_message.get;
2306: END IF;
2307: jtf_notes_pub.create_note

Line 2304: fnd_message.set_token('PMTBATCH_NAME', l_old_record.name);

2300: fnd_message.set_token('OLD', l_status_meaning);
2301: l_note_msg := fnd_message.get;
2302: ELSE
2303: fnd_message.set_name('CN', 'CN_PMT_REF_NOTE');
2304: fnd_message.set_token('PMTBATCH_NAME', l_old_record.name);
2305: l_note_msg := fnd_message.get;
2306: END IF;
2307: jtf_notes_pub.create_note
2308: (p_api_version => 1.0,

Line 2305: l_note_msg := fnd_message.get;

2301: l_note_msg := fnd_message.get;
2302: ELSE
2303: fnd_message.set_name('CN', 'CN_PMT_REF_NOTE');
2304: fnd_message.set_token('PMTBATCH_NAME', l_old_record.name);
2305: l_note_msg := fnd_message.get;
2306: END IF;
2307: jtf_notes_pub.create_note
2308: (p_api_version => 1.0,
2309: x_return_status => x_return_status,

Line 2457: fnd_message.set_name('CN', 'CN_PAYRUN_DOES_NOT_EXIST');

2453:
2454: --Error condition
2455: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2456: THEN
2457: fnd_message.set_name('CN', 'CN_PAYRUN_DOES_NOT_EXIST');
2458: fnd_msg_pub.add;
2459: END IF;
2460:
2461: x_loading_status := 'CN_PAYRUN_DOES_NOT_EXIST';

Line 2475: fnd_message.set_name('CN', 'CN_PAYRUN_PAID');

2471: THEN
2472: --Error condition
2473: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2474: THEN
2475: fnd_message.set_name('CN', 'CN_PAYRUN_PAID');
2476: fnd_msg_pub.add;
2477: END IF;
2478:
2479: x_loading_status := 'CN_PAYRUN_PAID';

Line 2535: fnd_message.set_name ('CN', 'CN_PMT_DEL_NOTE');

2531:
2532: -- End of API body.
2533: -- Standard check of p_commit.
2534: IF (l_org_id <> -999) THEN
2535: fnd_message.set_name ('CN', 'CN_PMT_DEL_NOTE');
2536: fnd_message.set_token ('PMTBATCH_NAME', l_pmtbatch_name);
2537: l_note_msg := fnd_message.get;
2538: jtf_notes_pub.create_note
2539: (p_api_version => 1.0,

Line 2536: fnd_message.set_token ('PMTBATCH_NAME', l_pmtbatch_name);

2532: -- End of API body.
2533: -- Standard check of p_commit.
2534: IF (l_org_id <> -999) THEN
2535: fnd_message.set_name ('CN', 'CN_PMT_DEL_NOTE');
2536: fnd_message.set_token ('PMTBATCH_NAME', l_pmtbatch_name);
2537: l_note_msg := fnd_message.get;
2538: jtf_notes_pub.create_note
2539: (p_api_version => 1.0,
2540: x_return_status => x_return_status,

Line 2537: l_note_msg := fnd_message.get;

2533: -- Standard check of p_commit.
2534: IF (l_org_id <> -999) THEN
2535: fnd_message.set_name ('CN', 'CN_PMT_DEL_NOTE');
2536: fnd_message.set_token ('PMTBATCH_NAME', l_pmtbatch_name);
2537: l_note_msg := fnd_message.get;
2538: jtf_notes_pub.create_note
2539: (p_api_version => 1.0,
2540: x_return_status => x_return_status,
2541: x_msg_count => x_msg_count,

Line 3022: fnd_message.set_name('CN', 'CN_INVALID_PAYRUN');

3018: IF get_payrun%rowcount = 0 THEN
3019: --Error condition
3020: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
3021: THEN
3022: fnd_message.set_name('CN', 'CN_INVALID_PAYRUN');
3023: fnd_msg_pub.add;
3024: END IF;
3025:
3026: x_loading_status := 'CN_INVALID_PAYRUN';

Line 3377: fnd_message.set_name('CN', 'CN_PMT_UPD_NOTE');

3373: OPEN get_payrun;
3374: FETCH get_payrun INTO l_payrun_rec;
3375: CLOSE get_payrun;
3376:
3377: fnd_message.set_name('CN', 'CN_PMT_UPD_NOTE');
3378: fnd_message.set_token('NEW', l_payrun_rec.statusmeaning);
3379: fnd_message.set_token('OLD', l_status_meaning);
3380: l_note_msg := fnd_message.get;
3381: jtf_notes_pub.create_note

Line 3378: fnd_message.set_token('NEW', l_payrun_rec.statusmeaning);

3374: FETCH get_payrun INTO l_payrun_rec;
3375: CLOSE get_payrun;
3376:
3377: fnd_message.set_name('CN', 'CN_PMT_UPD_NOTE');
3378: fnd_message.set_token('NEW', l_payrun_rec.statusmeaning);
3379: fnd_message.set_token('OLD', l_status_meaning);
3380: l_note_msg := fnd_message.get;
3381: jtf_notes_pub.create_note
3382: (p_api_version => 1.0,

Line 3379: fnd_message.set_token('OLD', l_status_meaning);

3375: CLOSE get_payrun;
3376:
3377: fnd_message.set_name('CN', 'CN_PMT_UPD_NOTE');
3378: fnd_message.set_token('NEW', l_payrun_rec.statusmeaning);
3379: fnd_message.set_token('OLD', l_status_meaning);
3380: l_note_msg := fnd_message.get;
3381: jtf_notes_pub.create_note
3382: (p_api_version => 1.0,
3383: x_return_status => x_return_status,

Line 3380: l_note_msg := fnd_message.get;

3376:
3377: fnd_message.set_name('CN', 'CN_PMT_UPD_NOTE');
3378: fnd_message.set_token('NEW', l_payrun_rec.statusmeaning);
3379: fnd_message.set_token('OLD', l_status_meaning);
3380: l_note_msg := fnd_message.get;
3381: jtf_notes_pub.create_note
3382: (p_api_version => 1.0,
3383: x_return_status => x_return_status,
3384: x_msg_count => x_msg_count,