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 1309: fnd_message.set_name ('CN', 'CN_WKSHT_ACTION_UNPAID');

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

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

1325: IF l_payrun_status <> 'UNPAID' OR l_worksheet_rec.worksheet_status NOT IN ('PROCESSING', 'UNPAID')
1326: THEN
1327: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1328: THEN
1329: fnd_message.set_name ('CN', 'CN_WKSHT_NOT_PROCESSING');
1330: fnd_msg_pub.ADD;
1331: END IF;
1332:
1333: RAISE fnd_api.g_exc_error;

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

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

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

1369: IF l_payrun_status <> 'UNPAID' OR l_worksheet_rec.worksheet_status <> 'LOCKED'
1370: THEN
1371: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1372: THEN
1373: fnd_message.set_name ('CN', 'CN_WKSHT_ACTION_UNLOCK');
1374: fnd_msg_pub.ADD;
1375: END IF;
1376:
1377: RAISE fnd_api.g_exc_error;

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

1391: IF l_worksheet_rec.worksheet_status <> 'LOCKED'
1392: THEN
1393: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1394: THEN
1395: fnd_message.set_name ('CN', 'CN_WKSHT_ACTION_SUBMIT');
1396: fnd_msg_pub.ADD;
1397: END IF;
1398:
1399: RAISE fnd_api.g_exc_error;

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

1425: IF l_worksheet_rec.worksheet_status <> 'SUBMITTED' AND l_worksheet_rec.worksheet_status <> 'APPROVED'
1426: THEN
1427: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1428: THEN
1429: fnd_message.set_name ('CN', 'CN_WKSHT_ACTION_APPROVE');
1430: fnd_msg_pub.ADD;
1431: END IF;
1432:
1433: RAISE fnd_api.g_exc_error;

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

1437: -- Check if user is manager
1438: /* comment out as R12 payment security has been changed.
1439: IF is_superuser(p_period_id => l_pay_period_id) = 0 AND is_manager(p_period_id => l_pay_period_id) = 0 THEN
1440: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1441: FND_MESSAGE.SET_NAME ('CN','CN_WKSHT_NOT_MGR');
1442: FND_MSG_PUB.Add;
1443: END IF;
1444: RAISE FND_API.G_EXC_ERROR ;
1445: END IF;

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

1500: WHEN NO_DATA_FOUND
1501: THEN
1502: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1503: THEN
1504: fnd_message.set_name ('CN', 'CN_NO_SRP_ACCESS');
1505: fnd_msg_pub.ADD;
1506: END IF;
1507:
1508: RAISE fnd_api.g_exc_error;

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

1531: IF l_tmp > 0
1532: THEN
1533: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1534: THEN
1535: fnd_message.set_name ('CN', 'CN_SAME_USER_APPROVE');
1536: fnd_msg_pub.ADD;
1537: END IF;
1538:
1539: RAISE fnd_api.g_exc_error;

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

1543: ELSE
1544: -- invalid p_action
1545: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1546: THEN
1547: fnd_message.set_name ('CN', 'CN_WKSHT_ACTION_NOT_EXIST');
1548: fnd_msg_pub.ADD;
1549: END IF;
1550:
1551: RAISE fnd_api.g_exc_error;

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

1633: l_access := LOWER (p_access);
1634:
1635: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1636: THEN
1637: fnd_message.set_name ('CN', 'CN_PMT_NO_ACCESS');
1638: fnd_message.set_token ('TYPE', l_type);
1639: fnd_message.set_token ('ACCESS', l_access);
1640: fnd_msg_pub.ADD;
1641: END IF;

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

1634:
1635: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1636: THEN
1637: fnd_message.set_name ('CN', 'CN_PMT_NO_ACCESS');
1638: fnd_message.set_token ('TYPE', l_type);
1639: fnd_message.set_token ('ACCESS', l_access);
1640: fnd_msg_pub.ADD;
1641: END IF;
1642: END IF; --l_ret_val = FALSE

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

1635: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1636: THEN
1637: fnd_message.set_name ('CN', 'CN_PMT_NO_ACCESS');
1638: fnd_message.set_token ('TYPE', l_type);
1639: fnd_message.set_token ('ACCESS', l_access);
1640: fnd_msg_pub.ADD;
1641: END IF;
1642: END IF; --l_ret_val = FALSE
1643: