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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;