DBA Data[Home] [Help]

APPS.CN_PAYMENT_SECURITY_PVT dependencies on FND_MESSAGE

Line 77: fnd_message.set_name ('CN', 'CN_INVALID_PAYBYMODE');

73:
74: IF l_ret_val NOT IN ('Y','N')
75: THEN
76: -- resource not exist for this user
77: fnd_message.set_name ('CN', 'CN_INVALID_PAYBYMODE');
78: fnd_msg_pub.ADD;
79: RAISE fnd_api.g_exc_error;
80: END IF ;
81: RETURN l_ret_val ;

Line 120: fnd_message.set_name ('CN', 'CN_USER_RESOURCE_NF');

116: EXCEPTION
117: WHEN NO_DATA_FOUND
118: THEN
119: -- resource not exist for this user
120: fnd_message.set_name ('CN', 'CN_USER_RESOURCE_NF');
121: fnd_msg_pub.ADD;
122: RAISE fnd_api.g_exc_error;
123: END;
124:

Line 193: fnd_message.set_name ('CN', 'CN_USER_RESOURCE_NF');

189: EXCEPTION
190: WHEN NO_DATA_FOUND
191: THEN
192: -- resource not exist for this user
193: fnd_message.set_name ('CN', 'CN_USER_RESOURCE_NF');
194: fnd_msg_pub.ADD;
195: RAISE fnd_api.g_exc_error;
196: END;
197:

Line 274: fnd_message.set_name('CN', 'CN_PAYSHEET_PAY_NOTE');

270: THEN
271: RAISE fnd_api.g_exc_error;
272: END IF;
273:
274: fnd_message.set_name('CN', 'CN_PAYSHEET_PAY_NOTE');
275: l_note_msg := fnd_message.get;
276:
277: -- for each worksheet in this payrun, add audit history to 'Pay Payrun'
278: FOR l_wksht_csr IN c_wksht_csr

Line 275: l_note_msg := fnd_message.get;

271: RAISE fnd_api.g_exc_error;
272: END IF;
273:
274: fnd_message.set_name('CN', 'CN_PAYSHEET_PAY_NOTE');
275: l_note_msg := fnd_message.get;
276:
277: -- for each worksheet in this payrun, add audit history to 'Pay Payrun'
278: FOR l_wksht_csr IN c_wksht_csr
279: LOOP

Line 615: fnd_message.set_name('CN', l_msg_name);

611: p_payrun_id => p_payrun_id,
612: p_worksheet_status => l_new_status
613: );
614:
615: fnd_message.set_name('CN', l_msg_name);
616: l_note_msg := fnd_message.get;
617: IF p_action <> 'REMOVE' THEN
618: jtf_notes_pub.create_note
619: (p_api_version => 1.0,

Line 616: l_note_msg := fnd_message.get;

612: p_worksheet_status => l_new_status
613: );
614:
615: fnd_message.set_name('CN', l_msg_name);
616: l_note_msg := fnd_message.get;
617: IF p_action <> 'REMOVE' THEN
618: jtf_notes_pub.create_note
619: (p_api_version => 1.0,
620: x_return_status => x_return_status,

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

761: WHEN NO_DATA_FOUND
762: THEN
763: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
764: THEN
765: fnd_message.set_name ('CN', 'CN_PAYRUN_DOES_NOT_EXIST');
766: fnd_msg_pub.ADD;
767: END IF;
768:
769: RAISE fnd_api.g_exc_error;

Line 795: fnd_message.set_name ('CN', 'CN_INVALID_OBJECT_VERSION');

791: err_num := SQLCODE;
792:
793: IF err_num = -54
794: THEN
795: fnd_message.set_name ('CN', 'CN_INVALID_OBJECT_VERSION');
796: fnd_msg_pub.ADD;
797: RAISE fnd_api.g_exc_error;
798: ELSE
799: RAISE;

Line 807: FND_MESSAGE.SET_NAME ('CN','CN_PAYRUN_NOT_SU');

803: -- Check if user is Super User. Only super user can perform payrun action
804: /* Comment out for R12 payment security
805: IF is_superuser(p_period_id => l_period_id) = 0 THEN
806: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
807: FND_MESSAGE.SET_NAME ('CN','CN_PAYRUN_NOT_SU');
808: FND_MSG_PUB.Add;
809: END IF;
810: RAISE FND_API.G_EXC_ERROR ;
811: END IF;

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

815: IF l_payrun_status = 'PAID'
816: THEN
817: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
818: THEN
819: fnd_message.set_name ('CN', 'CN_PAYRUN_PAID');
820: fnd_msg_pub.ADD;
821: END IF;
822:
823: RAISE fnd_api.g_exc_error;

Line 837: fnd_message.set_name ('CN', 'CN_WKSHT_STILL_PROCESSING');

833:
834: IF l_temp > 0 THEN
835: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
836: THEN
837: fnd_message.set_name ('CN', 'CN_WKSHT_STILL_PROCESSING');
838: fnd_msg_pub.ADD;
839: END IF;
840: RAISE fnd_api.g_exc_error;
841: END IF;

Line 879: fnd_message.set_name ('CN', 'CN_PAYRUN_ACTION_UNPAID');

875: IF l_payrun_status <> 'UNPAID'
876: THEN
877: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
878: THEN
879: fnd_message.set_name ('CN', 'CN_PAYRUN_ACTION_UNPAID');
880: fnd_msg_pub.ADD;
881: END IF;
882:
883: RAISE fnd_api.g_exc_error;

Line 901: fnd_message.set_name ('CN', 'CN_PAYRUN_ACTION_UNFREEZE');

897: IF l_payrun_status <> 'FROZEN'
898: THEN
899: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
900: THEN
901: fnd_message.set_name ('CN', 'CN_PAYRUN_ACTION_UNFREEZE');
902: fnd_msg_pub.ADD;
903: END IF;
904:
905: RAISE fnd_api.g_exc_error;

Line 932: fnd_message.set_name ('CN', 'CN_PAYRUN_ACTION_PAY');

928: WHERE payrun_id = p_payrun_id AND worksheet_status <> 'APPROVED');
929:
930: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
931: THEN
932: fnd_message.set_name ('CN', 'CN_PAYRUN_ACTION_PAY');
933: fnd_msg_pub.ADD;
934: END IF;
935:
936: RAISE fnd_api.g_exc_error;

Line 947: fnd_message.set_name ('CN', 'CN_PAYRUN_ACTION_PAY_FRZ');

943: IF l_payrun_status <> 'FROZEN'
944: THEN
945: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
946: THEN
947: fnd_message.set_name ('CN', 'CN_PAYRUN_ACTION_PAY_FRZ');
948: fnd_msg_pub.ADD;
949: END IF;
950:
951: RAISE fnd_api.g_exc_error;

Line 958: fnd_message.set_name ('CN', 'CN_PAYRUN_ACTION_NOT_EXIST');

954: ELSE
955: -- invalid p_action
956: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
957: THEN
958: fnd_message.set_name ('CN', 'CN_PAYRUN_ACTION_NOT_EXIST');
959: fnd_msg_pub.ADD;
960: END IF;
961:
962: RAISE fnd_api.g_exc_error;

Line 1134: fnd_message.set_name ('CN', 'CN_WKSHT_DOES_NOT_EXIST');

1130: WHEN NO_DATA_FOUND
1131: THEN
1132: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1133: THEN
1134: fnd_message.set_name ('CN', 'CN_WKSHT_DOES_NOT_EXIST');
1135: fnd_msg_pub.ADD;
1136: END IF;
1137:
1138: RAISE fnd_api.g_exc_error;

Line 1164: fnd_message.set_name ('CN', 'CN_INVALID_OBJECT_VERSION');

1160: err_num := SQLCODE;
1161:
1162: IF err_num = -54
1163: THEN
1164: fnd_message.set_name ('CN', 'CN_INVALID_OBJECT_VERSION');
1165: fnd_msg_pub.ADD;
1166: RAISE fnd_api.g_exc_error;
1167: ELSE
1168: RAISE;

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

1173: IF l_payrun_status = 'PAID'
1174: THEN
1175: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1176: THEN
1177: fnd_message.set_name ('CN', 'CN_PAYRUN_PAID');
1178: fnd_msg_pub.ADD;
1179: END IF;
1180:
1181: RAISE fnd_api.g_exc_error;

Line 1196: fnd_message.set_name ('CN', 'CN_USER_RESOURCE_NF');

1192: EXCEPTION
1193: WHEN NO_DATA_FOUND
1194: THEN
1195: -- resource not exist for this user
1196: fnd_message.set_name ('CN', 'CN_USER_RESOURCE_NF');
1197: fnd_msg_pub.ADD;
1198: RAISE fnd_api.g_exc_error;
1199: END;
1200:

Line 1254: fnd_message.set_name ('CN', 'CN_NO_SRP_ACCESS');

1250: WHEN NO_DATA_FOUND
1251: THEN
1252: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1253: THEN
1254: fnd_message.set_name ('CN', 'CN_NO_SRP_ACCESS');
1255: fnd_msg_pub.ADD;
1256: END IF;
1257:
1258: RAISE fnd_api.g_exc_error;

Line 1311: fnd_message.set_name ('CN', 'CN_WKSHT_ACTION_UNPAID');

1307: IF l_payrun_status <> 'UNPAID' OR l_worksheet_rec.worksheet_status <> 'UNPAID'
1308: THEN
1309: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1310: THEN
1311: fnd_message.set_name ('CN', 'CN_WKSHT_ACTION_UNPAID');
1312: fnd_msg_pub.ADD;
1313: END IF;
1314:
1315: RAISE fnd_api.g_exc_error;

Line 1323: fnd_message.set_name ('CN', 'CN_WKSHT_ACTION_UNPAID');

1319: IF l_payrun_status = 'PAID' OR l_worksheet_rec.worksheet_status <> 'UNPAID'
1320: THEN
1321: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1322: THEN
1323: fnd_message.set_name ('CN', 'CN_WKSHT_ACTION_UNPAID');
1324: fnd_msg_pub.ADD;
1325: END IF;
1326:
1327: RAISE fnd_api.g_exc_error;

Line 1347: fnd_message.set_name ('CN', 'CN_WKSHT_NOT_PROCESSING');

1343: IF l_payrun_status <> 'UNPAID' OR l_worksheet_rec.worksheet_status NOT IN ('PROCESSING', 'UNPAID')
1344: THEN
1345: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1346: THEN
1347: fnd_message.set_name ('CN', 'CN_WKSHT_NOT_PROCESSING');
1348: fnd_msg_pub.ADD;
1349: END IF;
1350:
1351: RAISE fnd_api.g_exc_error;

Line 1368: fnd_message.set_name ('CN', 'CN_WKSHT_NOT_PROCESSING');

1364: IF l_payrun_status <> 'UNPAID' OR (l_worksheet_rec.worksheet_status NOT IN ('PROCESSING','FAILED'))
1365: THEN
1366: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1367: THEN
1368: fnd_message.set_name ('CN', 'CN_WKSHT_NOT_PROCESSING');
1369: fnd_msg_pub.ADD;
1370: END IF;
1371:
1372: RAISE fnd_api.g_exc_error;

Line 1391: fnd_message.set_name ('CN', 'CN_WKSHT_ACTION_UNLOCK');

1387: IF l_payrun_status <> 'UNPAID' OR l_worksheet_rec.worksheet_status <> 'LOCKED'
1388: THEN
1389: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1390: THEN
1391: fnd_message.set_name ('CN', 'CN_WKSHT_ACTION_UNLOCK');
1392: fnd_msg_pub.ADD;
1393: END IF;
1394:
1395: RAISE fnd_api.g_exc_error;

Line 1413: fnd_message.set_name ('CN', 'CN_WKSHT_ACTION_SUBMIT');

1409: IF l_worksheet_rec.worksheet_status <> 'LOCKED'
1410: THEN
1411: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1412: THEN
1413: fnd_message.set_name ('CN', 'CN_WKSHT_ACTION_SUBMIT');
1414: fnd_msg_pub.ADD;
1415: END IF;
1416:
1417: RAISE fnd_api.g_exc_error;

Line 1450: fnd_message.set_name ('CN', 'CN_WKSHT_ACTION_APPROVE');

1446: IF l_worksheet_rec.worksheet_status <> 'SUBMITTED' AND l_worksheet_rec.worksheet_status <> 'APPROVED'
1447: THEN
1448: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1449: THEN
1450: fnd_message.set_name ('CN', 'CN_WKSHT_ACTION_APPROVE');
1451: fnd_msg_pub.ADD;
1452: END IF;
1453:
1454: RAISE fnd_api.g_exc_error;

Line 1464: FND_MESSAGE.SET_NAME ('CN','CN_WKSHT_NOT_MGR');

1460: -- Check if user is manager
1461: /* comment out as R12 payment security has been changed.
1462: IF is_superuser(p_period_id => l_pay_period_id) = 0 AND is_manager(p_period_id => l_pay_period_id) = 0 THEN
1463: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1464: FND_MESSAGE.SET_NAME ('CN','CN_WKSHT_NOT_MGR');
1465: FND_MSG_PUB.Add;
1466: END IF;
1467: RAISE FND_API.G_EXC_ERROR ;
1468: END IF;

Line 1527: fnd_message.set_name ('CN', 'CN_NO_SRP_ACCESS');

1523: WHEN NO_DATA_FOUND
1524: THEN
1525: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1526: THEN
1527: fnd_message.set_name ('CN', 'CN_NO_SRP_ACCESS');
1528: fnd_msg_pub.ADD;
1529: END IF;
1530:
1531: RAISE fnd_api.g_exc_error;

Line 1558: fnd_message.set_name ('CN', 'CN_SAME_USER_APPROVE');

1554: IF l_tmp > 0
1555: THEN
1556: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1557: THEN
1558: fnd_message.set_name ('CN', 'CN_SAME_USER_APPROVE');
1559: fnd_msg_pub.ADD;
1560: END IF;
1561:
1562: RAISE fnd_api.g_exc_error;

Line 1570: fnd_message.set_name ('CN', 'CN_WKSHT_ACTION_NOT_EXIST');

1566: ELSE
1567: -- invalid p_action
1568: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1569: THEN
1570: fnd_message.set_name ('CN', 'CN_WKSHT_ACTION_NOT_EXIST');
1571: fnd_msg_pub.ADD;
1572: END IF;
1573:
1574: RAISE fnd_api.g_exc_error;

Line 1660: fnd_message.set_name ('CN', 'CN_PMT_NO_ACCESS');

1656: l_access := LOWER (p_access);
1657:
1658: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1659: THEN
1660: fnd_message.set_name ('CN', 'CN_PMT_NO_ACCESS');
1661: fnd_message.set_token ('TYPE', l_type);
1662: fnd_message.set_token ('ACCESS', l_access);
1663: fnd_msg_pub.ADD;
1664: END IF;

Line 1661: fnd_message.set_token ('TYPE', l_type);

1657:
1658: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1659: THEN
1660: fnd_message.set_name ('CN', 'CN_PMT_NO_ACCESS');
1661: fnd_message.set_token ('TYPE', l_type);
1662: fnd_message.set_token ('ACCESS', l_access);
1663: fnd_msg_pub.ADD;
1664: END IF;
1665: END IF; --l_ret_val = FALSE

Line 1662: fnd_message.set_token ('ACCESS', l_access);

1658: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1659: THEN
1660: fnd_message.set_name ('CN', 'CN_PMT_NO_ACCESS');
1661: fnd_message.set_token ('TYPE', l_type);
1662: fnd_message.set_token ('ACCESS', l_access);
1663: fnd_msg_pub.ADD;
1664: END IF;
1665: END IF; --l_ret_val = FALSE
1666: