DBA Data[Home] [Help]

APPS.POS_PROFILE_CHANGE_REQUEST_PKG dependencies on FND_MSG_PUB

Line 831: fnd_msg_pub.ADD;

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;
835: END IF;

Line 832: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);

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;
835: END IF;
836: CLOSE l_cur;

Line 842: fnd_msg_pub.ADD;

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;
846: END IF;

Line 843: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);

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;
846: END IF;
847:

Line 855: fnd_msg_pub.ADD;

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;
859: END IF;

Line 856: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);

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;
859: END IF;
860: CLOSE l_cur2;

Line 989: fnd_msg_pub.ADD;

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;
993: END IF;

Line 990: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);

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;
993: END IF;
994: CLOSE l_cur;

Line 1000: fnd_msg_pub.ADD;

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;
1004: END IF;

Line 1001: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);

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;
1004: END IF;
1005:

Line 1013: fnd_msg_pub.ADD;

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;
1017: END IF;

Line 1014: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);

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;
1017: END IF;
1018: CLOSE l_cur2;

Line 1099: fnd_msg_pub.ADD;

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;
1103: END IF;

Line 1100: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);

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;
1103: END IF;
1104: CLOSE l_cur;

Line 1110: fnd_msg_pub.ADD;

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;
1114: END IF;

Line 1111: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);

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;
1114: END IF;
1115:

Line 1123: fnd_msg_pub.ADD;

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;
1127: END IF;

Line 1124: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);

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;
1127: END IF;
1128: CLOSE l_cur2;

Line 1206: fnd_msg_pub.ADD;

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;
1210: END IF;

Line 1207: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);

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;
1210: END IF;
1211: CLOSE l_cur;

Line 1217: fnd_msg_pub.ADD;

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;
1221: END IF;

Line 1218: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);

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;
1221: END IF;
1222:

Line 1227: fnd_msg_pub.ADD;

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;
1231: END IF;

Line 1228: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);

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;
1231: END IF;
1232:

Line 1240: fnd_msg_pub.ADD;

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;
1244: END IF;

Line 1241: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);

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;
1244: END IF;
1245: CLOSE l_cur2;