DBA Data[Home] [Help]

APPS.POS_PROFILE_CHANGE_REQUEST_PKG dependencies on FND_MESSAGE

Line 829: fnd_message.set_name('POS','POS_PRCR_BAD_ADDR_REQ_ID');

825: FETCH l_cur INTO l_rec;
826: IF l_cur%notfound THEN
827: CLOSE l_cur;
828: x_return_status := fnd_api.g_ret_sts_error;
829: fnd_message.set_name('POS','POS_PRCR_BAD_ADDR_REQ_ID');
830: fnd_message.set_token('ADDRRESS_REQUEST_ID', p_request_id);
831: fnd_msg_pub.ADD;
832: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
833: rollback to approve_address_req;

Line 830: fnd_message.set_token('ADDRRESS_REQUEST_ID', p_request_id);

826: IF l_cur%notfound THEN
827: CLOSE l_cur;
828: x_return_status := fnd_api.g_ret_sts_error;
829: fnd_message.set_name('POS','POS_PRCR_BAD_ADDR_REQ_ID');
830: fnd_message.set_token('ADDRRESS_REQUEST_ID', p_request_id);
831: fnd_msg_pub.ADD;
832: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
833: rollback to approve_address_req;
834: RETURN;

Line 840: fnd_message.set_name('POS','POS_PRCR_ADDRREQ_NOT_PEND');

836: CLOSE l_cur;
837:
838: IF l_rec.request_status IS NULL OR l_rec.request_status <> 'PENDING' THEN
839: x_return_status := fnd_api.g_ret_sts_error;
840: fnd_message.set_name('POS','POS_PRCR_ADDRREQ_NOT_PEND');
841: fnd_message.set_token('ADDRRESS_REQUEST_ID', p_request_id);
842: fnd_msg_pub.ADD;
843: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
844: rollback to approve_address_req;

Line 841: fnd_message.set_token('ADDRRESS_REQUEST_ID', p_request_id);

837:
838: IF l_rec.request_status IS NULL OR l_rec.request_status <> 'PENDING' THEN
839: x_return_status := fnd_api.g_ret_sts_error;
840: fnd_message.set_name('POS','POS_PRCR_ADDRREQ_NOT_PEND');
841: fnd_message.set_token('ADDRRESS_REQUEST_ID', p_request_id);
842: fnd_msg_pub.ADD;
843: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
844: rollback to approve_address_req;
845: RETURN;

Line 853: fnd_message.set_name('POS','POS_PRCR_BAD_MAPPING_ID');

849: FETCH l_cur2 INTO l_rec2;
850: IF l_cur2%notfound THEN
851: CLOSE l_cur2;
852: x_return_status := fnd_api.g_ret_sts_error;
853: fnd_message.set_name('POS','POS_PRCR_BAD_MAPPING_ID');
854: fnd_message.set_token('MAPPING_ID', l_rec.mapping_id);
855: fnd_msg_pub.ADD;
856: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
857: rollback to approve_address_req;

Line 854: fnd_message.set_token('MAPPING_ID', l_rec.mapping_id);

850: IF l_cur2%notfound THEN
851: CLOSE l_cur2;
852: x_return_status := fnd_api.g_ret_sts_error;
853: fnd_message.set_name('POS','POS_PRCR_BAD_MAPPING_ID');
854: fnd_message.set_token('MAPPING_ID', l_rec.mapping_id);
855: fnd_msg_pub.ADD;
856: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
857: rollback to approve_address_req;
858: RETURN;

Line 987: fnd_message.set_name('POS','POS_PRCR_BAD_CONT_REQ_ID');

983: FETCH l_cur INTO l_rec;
984: IF l_cur%notfound THEN
985: CLOSE l_cur;
986: x_return_status := fnd_api.g_ret_sts_error;
987: fnd_message.set_name('POS','POS_PRCR_BAD_CONT_REQ_ID');
988: fnd_message.set_token('CONTACT_REQUEST_ID', p_request_id);
989: fnd_msg_pub.ADD;
990: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
991: rollback to approve_contact_req;

Line 988: fnd_message.set_token('CONTACT_REQUEST_ID', p_request_id);

984: IF l_cur%notfound THEN
985: CLOSE l_cur;
986: x_return_status := fnd_api.g_ret_sts_error;
987: fnd_message.set_name('POS','POS_PRCR_BAD_CONT_REQ_ID');
988: fnd_message.set_token('CONTACT_REQUEST_ID', p_request_id);
989: fnd_msg_pub.ADD;
990: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
991: rollback to approve_contact_req;
992: RETURN;

Line 998: fnd_message.set_name('POS','POS_PRCR_CONTREQ_NOT_PEND');

994: CLOSE l_cur;
995:
996: IF l_rec.request_status IS NULL OR l_rec.request_status <> 'PENDING' THEN
997: x_return_status := fnd_api.g_ret_sts_error;
998: fnd_message.set_name('POS','POS_PRCR_CONTREQ_NOT_PEND');
999: fnd_message.set_token('CONTACT_REQUEST_ID', p_request_id);
1000: fnd_msg_pub.ADD;
1001: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1002: rollback to approve_contact_req;

Line 999: fnd_message.set_token('CONTACT_REQUEST_ID', p_request_id);

995:
996: IF l_rec.request_status IS NULL OR l_rec.request_status <> 'PENDING' THEN
997: x_return_status := fnd_api.g_ret_sts_error;
998: fnd_message.set_name('POS','POS_PRCR_CONTREQ_NOT_PEND');
999: fnd_message.set_token('CONTACT_REQUEST_ID', p_request_id);
1000: fnd_msg_pub.ADD;
1001: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1002: rollback to approve_contact_req;
1003: RETURN;

Line 1011: fnd_message.set_name('POS','POS_PRCR_BAD_MAPPING_ID');

1007: FETCH l_cur2 INTO l_rec2;
1008: IF l_cur2%notfound THEN
1009: CLOSE l_cur2;
1010: x_return_status := fnd_api.g_ret_sts_error;
1011: fnd_message.set_name('POS','POS_PRCR_BAD_MAPPING_ID');
1012: fnd_message.set_token('MAPPING_ID', l_rec.mapping_id);
1013: fnd_msg_pub.ADD;
1014: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1015: rollback to approve_contact_req;

Line 1012: fnd_message.set_token('MAPPING_ID', l_rec.mapping_id);

1008: IF l_cur2%notfound THEN
1009: CLOSE l_cur2;
1010: x_return_status := fnd_api.g_ret_sts_error;
1011: fnd_message.set_name('POS','POS_PRCR_BAD_MAPPING_ID');
1012: fnd_message.set_token('MAPPING_ID', l_rec.mapping_id);
1013: fnd_msg_pub.ADD;
1014: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1015: rollback to approve_contact_req;
1016: RETURN;

Line 1097: fnd_message.set_name('POS','POS_PRCR_BAD_BC_REQ_ID');

1093: FETCH l_cur INTO l_rec;
1094: IF l_cur%notfound THEN
1095: CLOSE l_cur;
1096: x_return_status := fnd_api.g_ret_sts_error;
1097: fnd_message.set_name('POS','POS_PRCR_BAD_BC_REQ_ID');
1098: fnd_message.set_token('BUS_CLASS_REQUEST_ID', p_request_id);
1099: fnd_msg_pub.ADD;
1100: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1101: rollback to approve_bus_class_req;

Line 1098: fnd_message.set_token('BUS_CLASS_REQUEST_ID', p_request_id);

1094: IF l_cur%notfound THEN
1095: CLOSE l_cur;
1096: x_return_status := fnd_api.g_ret_sts_error;
1097: fnd_message.set_name('POS','POS_PRCR_BAD_BC_REQ_ID');
1098: fnd_message.set_token('BUS_CLASS_REQUEST_ID', p_request_id);
1099: fnd_msg_pub.ADD;
1100: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1101: rollback to approve_bus_class_req;
1102: RETURN;

Line 1108: fnd_message.set_name('POS','POS_PRCR_BCREQ_NOT_PEND');

1104: CLOSE l_cur;
1105:
1106: IF l_rec.request_status IS NULL OR l_rec.request_status <> 'PENDING' THEN
1107: x_return_status := fnd_api.g_ret_sts_error;
1108: fnd_message.set_name('POS','POS_PRCR_BCREQ_NOT_PEND');
1109: fnd_message.set_token('BUS_CLASS_REQUEST_ID', p_request_id);
1110: fnd_msg_pub.ADD;
1111: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1112: rollback to approve_bus_class_req;

Line 1109: fnd_message.set_token('BUS_CLASS_REQUEST_ID', p_request_id);

1105:
1106: IF l_rec.request_status IS NULL OR l_rec.request_status <> 'PENDING' THEN
1107: x_return_status := fnd_api.g_ret_sts_error;
1108: fnd_message.set_name('POS','POS_PRCR_BCREQ_NOT_PEND');
1109: fnd_message.set_token('BUS_CLASS_REQUEST_ID', p_request_id);
1110: fnd_msg_pub.ADD;
1111: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1112: rollback to approve_bus_class_req;
1113: RETURN;

Line 1121: fnd_message.set_name('POS','POS_PRCR_BAD_MAPPING_ID');

1117: FETCH l_cur2 INTO l_rec2;
1118: IF l_cur2%notfound THEN
1119: CLOSE l_cur2;
1120: x_return_status := fnd_api.g_ret_sts_error;
1121: fnd_message.set_name('POS','POS_PRCR_BAD_MAPPING_ID');
1122: fnd_message.set_token('MAPPING_ID', l_rec.mapping_id);
1123: fnd_msg_pub.ADD;
1124: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1125: rollback to approve_bus_class_req;

Line 1122: fnd_message.set_token('MAPPING_ID', l_rec.mapping_id);

1118: IF l_cur2%notfound THEN
1119: CLOSE l_cur2;
1120: x_return_status := fnd_api.g_ret_sts_error;
1121: fnd_message.set_name('POS','POS_PRCR_BAD_MAPPING_ID');
1122: fnd_message.set_token('MAPPING_ID', l_rec.mapping_id);
1123: fnd_msg_pub.ADD;
1124: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1125: rollback to approve_bus_class_req;
1126: RETURN;

Line 1204: fnd_message.set_name('POS','POS_PRCR_BAD_PS_REQ_ID');

1200: FETCH l_cur INTO l_rec;
1201: IF l_cur%notfound THEN
1202: CLOSE l_cur;
1203: x_return_status := fnd_api.g_ret_sts_error;
1204: fnd_message.set_name('POS','POS_PRCR_BAD_PS_REQ_ID');
1205: fnd_message.set_token('PS_REQUEST_ID', p_request_id);
1206: fnd_msg_pub.ADD;
1207: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1208: rollback to approve_ps_req;

Line 1205: fnd_message.set_token('PS_REQUEST_ID', p_request_id);

1201: IF l_cur%notfound THEN
1202: CLOSE l_cur;
1203: x_return_status := fnd_api.g_ret_sts_error;
1204: fnd_message.set_name('POS','POS_PRCR_BAD_PS_REQ_ID');
1205: fnd_message.set_token('PS_REQUEST_ID', p_request_id);
1206: fnd_msg_pub.ADD;
1207: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1208: rollback to approve_ps_req;
1209: RETURN;

Line 1215: fnd_message.set_name('POS','POS_PRCR_PSREQ_NOT_PEND');

1211: CLOSE l_cur;
1212:
1213: IF l_rec.request_status IS NULL OR l_rec.request_status <> 'PENDING' THEN
1214: x_return_status := fnd_api.g_ret_sts_error;
1215: fnd_message.set_name('POS','POS_PRCR_PSREQ_NOT_PEND');
1216: fnd_message.set_token('PS_REQUEST_ID', p_request_id);
1217: fnd_msg_pub.ADD;
1218: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1219: rollback to approve_ps_req;

Line 1216: fnd_message.set_token('PS_REQUEST_ID', p_request_id);

1212:
1213: IF l_rec.request_status IS NULL OR l_rec.request_status <> 'PENDING' THEN
1214: x_return_status := fnd_api.g_ret_sts_error;
1215: fnd_message.set_name('POS','POS_PRCR_PSREQ_NOT_PEND');
1216: fnd_message.set_token('PS_REQUEST_ID', p_request_id);
1217: fnd_msg_pub.ADD;
1218: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1219: rollback to approve_ps_req;
1220: RETURN;

Line 1225: fnd_message.set_name('POS','POS_PRCR_PSREQ_TYPE_NOT_ADD');

1221: END IF;
1222:
1223: IF l_rec.request_type IS NULL OR l_rec.request_type <> 'ADD' THEN
1224: x_return_status := fnd_api.g_ret_sts_error;
1225: fnd_message.set_name('POS','POS_PRCR_PSREQ_TYPE_NOT_ADD');
1226: fnd_message.set_token('PS_REQUEST_ID', p_request_id);
1227: fnd_msg_pub.ADD;
1228: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1229: rollback to approve_ps_req;

Line 1226: fnd_message.set_token('PS_REQUEST_ID', p_request_id);

1222:
1223: IF l_rec.request_type IS NULL OR l_rec.request_type <> 'ADD' THEN
1224: x_return_status := fnd_api.g_ret_sts_error;
1225: fnd_message.set_name('POS','POS_PRCR_PSREQ_TYPE_NOT_ADD');
1226: fnd_message.set_token('PS_REQUEST_ID', p_request_id);
1227: fnd_msg_pub.ADD;
1228: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1229: rollback to approve_ps_req;
1230: RETURN;

Line 1238: fnd_message.set_name('POS','POS_PRCR_BAD_MAPPING_ID');

1234: FETCH l_cur2 INTO l_rec2;
1235: IF l_cur2%notfound THEN
1236: CLOSE l_cur2;
1237: x_return_status := fnd_api.g_ret_sts_error;
1238: fnd_message.set_name('POS','POS_PRCR_BAD_MAPPING_ID');
1239: fnd_message.set_token('MAPPING_ID', l_rec.mapping_id);
1240: fnd_msg_pub.ADD;
1241: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1242: rollback to approve_ps_req;

Line 1239: fnd_message.set_token('MAPPING_ID', l_rec.mapping_id);

1235: IF l_cur2%notfound THEN
1236: CLOSE l_cur2;
1237: x_return_status := fnd_api.g_ret_sts_error;
1238: fnd_message.set_name('POS','POS_PRCR_BAD_MAPPING_ID');
1239: fnd_message.set_token('MAPPING_ID', l_rec.mapping_id);
1240: fnd_msg_pub.ADD;
1241: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1242: rollback to approve_ps_req;
1243: RETURN;