eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.POS_PROFILE_CHANGE_REQUEST_PKG dependencies on FND_API

Line 86: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN

82: x_msg_data => x_msg_data,
83: x_party_site_id => l_party_site_id
84: );
85:
86: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN
87: rollback to approve_new_address_req;
88: RETURN;
89: END IF;
90:

Line 127: x_return_status := fnd_api.g_ret_sts_success;

123: , x_status => x_return_status
124: , x_exception_msg => x_msg_data
125: );
126:
127: x_return_status := fnd_api.g_ret_sts_success;
128:
129: EXCEPTION
130: WHEN OTHERS THEN
131: x_return_status :='E';

Line 195: x_return_status := fnd_api.g_ret_sts_error;

191: FETCH l_cur INTO l_rec;
192: IF l_cur%notfound THEN
193: CLOSE l_cur;
194: -- prepare err msg
195: x_return_status := fnd_api.g_ret_sts_error;
196: rollback to approve_update_address_req;
197: RETURN;
198: END IF;
199: CLOSE l_cur;

Line 206: x_return_status := fnd_api.g_ret_sts_error;

202: FETCH l_cur2 INTO l_rec2;
203: IF l_cur2%notfound THEN
204: CLOSE l_cur2;
205: -- prepare err msg
206: x_return_status := fnd_api.g_ret_sts_error;
207: rollback to approve_update_address_req;
208: RETURN;
209: END IF;
210: CLOSE l_cur2;

Line 297: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN

293: x_msg_count => x_msg_count,
294: x_msg_data => x_msg_data
295: );
296:
297: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN
298: rollback to approve_cont_addr_requests;
299: RETURN;
300: END IF;
301:

Line 312: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN

308: x_msg_count => x_msg_count,
309: x_msg_data => x_msg_data
310: );
311:
312: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN
313: rollback to approve_cont_addr_requests;
314: RETURN;
315: END IF;
316:

Line 319: x_return_status := fnd_api.g_ret_sts_error;

315: END IF;
316:
317:
318: ELSE
319: x_return_status := fnd_api.g_ret_sts_error;
320: x_msg_count := 1;
321: x_msg_data := 'invalid request type ' || l_rec.request_type
322: || ' in pos_cont_addr_requests table with cont_addr_request_id = '
323: || l_rec.cont_addr_request_id;

Line 347: x_return_status := fnd_api.g_ret_sts_success;

343: AND psm.vendor_id = pv.vendor_id
344: AND pcar.contact_req_id = pcr.contact_request_id
345: );
346:
347: x_return_status := fnd_api.g_ret_sts_success;
348:
349: EXCEPTION
350:
351: WHEN OTHERS THEN

Line 430: IF x_return_status <> fnd_api.g_ret_sts_success THEN

426: x_msg_data => x_msg_data,
427: x_person_party_id => l_person_party_id
428: );
429:
430: IF x_return_status <> fnd_api.g_ret_sts_success THEN
431: ROLLBACK TO approve_new_contact_req_sp;
432: RETURN;
433: END IF;
434:

Line 463: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN

459: x_user_id => l_fnd_user_id,
460: x_password => x_password
461: );
462:
463: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN
464: ROLLBACK TO approve_new_contact_req_sp;
465: RETURN;
466: END IF;
467:

Line 510: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN

506: x_msg_count => x_msg_count,
507: x_msg_data => x_msg_data
508: );
509:
510: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN
511: ROLLBACK TO approve_new_contact_req_sp;
512: RETURN;
513: END IF;
514:

Line 517: x_return_status := fnd_api.g_ret_sts_unexp_error;

513: END IF;
514:
515: EXCEPTION
516: WHEN OTHERS THEN
517: x_return_status := fnd_api.g_ret_sts_unexp_error;
518: x_msg_count := 1;
519: x_msg_data := Sqlerrm;
520: ROLLBACK TO approve_new_contact_req_sp;
521: pos_log.log_sqlerrm('POSCONTB', 'in approve_new_contact_req');

Line 557: x_return_status := fnd_api.g_ret_sts_error;

553: END;
554:
555: IF p_request_rec.request_type <> 'UPDATE' AND
556: p_request_rec.request_type <> 'DELETE' THEN
557: x_return_status := fnd_api.g_ret_sts_error;
558: x_msg_count := 1;
559: x_msg_data := 'request_type not UPDATED for contact request id '
560: || p_request_rec.contact_request_id;
561: ROLLBACK TO approve_update_contact_req_sp;

Line 566: x_return_status := fnd_api.g_ret_sts_error;

562: RETURN;
563: END IF;
564:
565: IF p_request_rec.request_status <> 'PENDING' THEN
566: x_return_status := fnd_api.g_ret_sts_error;
567: x_msg_count := 1;
568: x_msg_data := 'request_status not PENDING for contact request id '
569: || p_request_rec.contact_request_id;
570: ROLLBACK TO approve_update_contact_req_sp;

Line 575: x_return_status := fnd_api.g_ret_sts_error;

571: RETURN;
572: END IF;
573:
574: IF p_request_rec.contact_party_id IS NULL THEN
575: x_return_status := fnd_api.g_ret_sts_error;
576: x_msg_count := 1;
577: x_msg_data := 'contact_party_id is NULL for contact request id '
578: || p_request_rec.contact_request_id;
579: ROLLBACK TO approve_update_contact_req_sp;

Line 609: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN

605: x_msg_count => x_msg_count,
606: x_msg_data => x_msg_data
607: );
608:
609: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN
610: ROLLBACK TO approve_update_contact_req_sp;
611: RETURN;
612: END IF;
613:

Line 629: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN

625: x_msg_count => x_msg_count,
626: x_msg_data => x_msg_data
627: );
628:
629: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN
630: ROLLBACK TO approve_update_contact_req_sp;
631: RETURN;
632: END IF;
633:

Line 637: x_return_status := fnd_api.g_ret_sts_unexp_error;

633:
634: EXCEPTION
635: WHEN OTHERS THEN
636: ROLLBACK TO approve_update_contact_req_sp;
637: x_return_status := fnd_api.g_ret_sts_unexp_error;
638: x_msg_count := 1;
639: x_msg_data := Sqlerrm;
640: pos_log.log_sqlerrm('POSCONTB', 'in approve_update_contact_req');
641:

Line 724: x_return_status := fnd_api.g_ret_sts_success;

720: last_updated_by = fnd_global.user_id,
721: last_update_login = fnd_global.login_id
722: WHERE bus_class_request_id = p_request_rec.bus_class_request_id;
723:
724: x_return_status := fnd_api.g_ret_sts_success;
725:
726: EXCEPTION
727: WHEN OTHERS THEN
728: x_return_status :='E';

Line 788: x_return_status := fnd_api.g_ret_sts_success;

784: last_updated_by = fnd_global.user_id,
785: last_update_login = fnd_global.login_id
786: WHERE bus_class_request_id = p_request_rec.bus_class_request_id;
787:
788: x_return_status := fnd_api.g_ret_sts_success;
789: EXCEPTION
790: WHEN OTHERS THEN
791: x_return_status :='E';
792: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

Line 828: x_return_status := fnd_api.g_ret_sts_error;

824: OPEN l_cur;
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);

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 839: x_return_status := fnd_api.g_ret_sts_error;

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

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 852: x_return_status := fnd_api.g_ret_sts_error;

848: OPEN l_cur2;
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);

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 891: x_return_status := fnd_api.g_ret_sts_error;

887: last_update_login = fnd_global.login_id
888: WHERE address_request_id = p_request_id;
889:
890: ELSE
891: x_return_status := fnd_api.g_ret_sts_error;
892: x_msg_count := 1;
893: x_msg_data := l_rec.request_type || ' is not yet supported';
894: END IF;
895:

Line 986: x_return_status := fnd_api.g_ret_sts_error;

982: OPEN l_cur;
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);

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 997: x_return_status := fnd_api.g_ret_sts_error;

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

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 1010: x_return_status := fnd_api.g_ret_sts_error;

1006: OPEN l_cur2;
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);

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 1050: x_return_status := fnd_api.g_ret_sts_error;

1046: x_msg_count => x_msg_count,
1047: x_msg_data => x_msg_data
1048: );
1049: ELSE
1050: x_return_status := fnd_api.g_ret_sts_error;
1051: x_msg_count := 1;
1052: x_msg_data := l_rec.request_type || ' is not yet supported';
1053: END IF;
1054:

Line 1096: x_return_status := fnd_api.g_ret_sts_error;

1092: OPEN l_cur;
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);

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 1107: x_return_status := fnd_api.g_ret_sts_error;

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

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 1120: x_return_status := fnd_api.g_ret_sts_error;

1116: OPEN l_cur2;
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);

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 1157: x_return_status := fnd_api.g_ret_sts_error;

1153: pPartyId => l_rec2.party_id,
1154: pVendorId => l_rec2.vendor_id);
1155:
1156: ELSE
1157: x_return_status := fnd_api.g_ret_sts_error;
1158: x_msg_count := 1;
1159: x_msg_data := l_rec.request_type || ' is not yet supported';
1160: END IF;
1161:

Line 1203: x_return_status := fnd_api.g_ret_sts_error;

1199: OPEN l_cur;
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);

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 1214: x_return_status := fnd_api.g_ret_sts_error;

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

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 1224: x_return_status := fnd_api.g_ret_sts_error;

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

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 1237: x_return_status := fnd_api.g_ret_sts_error;

1233: OPEN l_cur2;
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);

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;

Line 1319: x_return_status := fnd_api.g_ret_sts_success;

1315: last_updated_by = fnd_global.user_id,
1316: last_update_login = fnd_global.login_id
1317: WHERE ps_request_id = p_request_id;
1318:
1319: x_return_status := fnd_api.g_ret_sts_success;
1320:
1321: EXCEPTION
1322: WHEN OTHERS THEN
1323: x_return_status :='E';

Line 1381: x_return_status := fnd_api.g_ret_sts_success;

1377: last_updated_by = fnd_global.user_id,
1378: last_update_login = fnd_global.login_id
1379: WHERE address_req_id = p_request_id;
1380:
1381: x_return_status := fnd_api.g_ret_sts_success;
1382:
1383: EXCEPTION
1384: WHEN OTHERS THEN
1385: x_return_status :='E';

Line 1437: x_return_status := fnd_api.g_ret_sts_success;

1433: last_updated_by = fnd_global.user_id,
1434: last_update_login = fnd_global.login_id
1435: WHERE contact_request_id = p_request_id;
1436:
1437: x_return_status := fnd_api.g_ret_sts_success;
1438: EXCEPTION
1439: WHEN OTHERS THEN
1440: x_return_status :='E';
1441: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

Line 1485: x_return_status := fnd_api.g_ret_sts_success;

1481: last_updated_by = fnd_global.user_id,
1482: last_update_login = fnd_global.login_id
1483: WHERE bus_class_request_id = p_request_id;
1484:
1485: x_return_status := fnd_api.g_ret_sts_success;
1486: EXCEPTION
1487: WHEN OTHERS THEN
1488: x_return_status :='E';
1489: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

Line 1531: x_return_status := fnd_api.g_ret_sts_success;

1527: last_updated_by = fnd_global.user_id,
1528: last_update_login = fnd_global.login_id
1529: WHERE ps_request_id = p_request_id;
1530:
1531: x_return_status := fnd_api.g_ret_sts_success;
1532:
1533: EXCEPTION
1534: WHEN OTHERS THEN
1535: x_return_status :='E';

Line 1584: OR x_return_status <> fnd_api.g_ret_sts_success THEN

1580: x_msg_count => x_msg_count,
1581: x_msg_data => x_msg_data
1582: );
1583: IF x_return_status IS NULL
1584: OR x_return_status <> fnd_api.g_ret_sts_success THEN
1585: rollback to reject_mult_address_reqs;
1586: RETURN;
1587: END IF;
1588: END LOOP;

Line 1590: x_return_status := FND_API.G_RET_STS_SUCCESS;

1586: RETURN;
1587: END IF;
1588: END LOOP;
1589:
1590: x_return_status := FND_API.G_RET_STS_SUCCESS;
1591: EXCEPTION
1592: WHEN OTHERS THEN
1593: x_return_status :='E';
1594: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

Line 1642: OR x_return_status <> fnd_api.g_ret_sts_success THEN

1638: x_msg_count => x_msg_count,
1639: x_msg_data => x_msg_data
1640: );
1641: IF x_return_status IS NULL
1642: OR x_return_status <> fnd_api.g_ret_sts_success THEN
1643: rollback to reject_mult_contact_reqs;
1644: RETURN;
1645: END IF;
1646: END LOOP;

Line 1648: x_return_status := FND_API.G_RET_STS_SUCCESS;

1644: RETURN;
1645: END IF;
1646: END LOOP;
1647:
1648: x_return_status := FND_API.G_RET_STS_SUCCESS;
1649:
1650: EXCEPTION
1651: WHEN OTHERS THEN
1652: x_return_status :='E';

Line 1703: OR x_return_status <> fnd_api.g_ret_sts_success THEN

1699: x_msg_count => x_msg_count,
1700: x_msg_data => x_msg_data
1701: );
1702: IF x_return_status IS NULL
1703: OR x_return_status <> fnd_api.g_ret_sts_success THEN
1704: rollback to reject_mult_bus_class_reqs;
1705: RETURN;
1706: END IF;
1707: END LOOP;

Line 1709: x_return_status := FND_API.G_RET_STS_SUCCESS;

1705: RETURN;
1706: END IF;
1707: END LOOP;
1708:
1709: x_return_status := FND_API.G_RET_STS_SUCCESS;
1710:
1711: EXCEPTION
1712: WHEN OTHERS THEN
1713: x_return_status :='E';

Line 1763: OR x_return_status <> fnd_api.g_ret_sts_success THEN

1759: x_msg_count => x_msg_count,
1760: x_msg_data => x_msg_data
1761: );
1762: IF x_return_status IS NULL
1763: OR x_return_status <> fnd_api.g_ret_sts_success THEN
1764: rollback to reject_mult_ps_reqs;
1765: RETURN;
1766: END IF;
1767: END LOOP;

Line 1769: x_return_status := FND_API.G_RET_STS_SUCCESS;

1765: RETURN;
1766: END IF;
1767: END LOOP;
1768:
1769: x_return_status := FND_API.G_RET_STS_SUCCESS;
1770: EXCEPTION
1771: WHEN OTHERS THEN
1772: x_return_status :='E';
1773: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

Line 1821: OR x_return_status <> fnd_api.g_ret_sts_success THEN

1817: x_msg_count => x_msg_count,
1818: x_msg_data => x_msg_data
1819: );
1820: IF x_return_status IS NULL
1821: OR x_return_status <> fnd_api.g_ret_sts_success THEN
1822: rollback to approve_mult_address_reqs;
1823: RETURN;
1824: END IF;
1825: END LOOP;

Line 1827: x_return_status := FND_API.G_RET_STS_SUCCESS;

1823: RETURN;
1824: END IF;
1825: END LOOP;
1826:
1827: x_return_status := FND_API.G_RET_STS_SUCCESS;
1828:
1829: EXCEPTION
1830: WHEN OTHERS THEN
1831: x_return_status :='E';

Line 1986: OR x_return_status <> fnd_api.g_ret_sts_success THEN

1982: x_msg_data => x_msg_data,
1983: x_password => l_password
1984: );
1985: IF x_return_status IS NULL
1986: OR x_return_status <> fnd_api.g_ret_sts_success THEN
1987: rollback to approve_mult_contact_reqs;
1988: RETURN;
1989: END IF;
1990: END LOOP;

Line 1992: x_return_status := FND_API.G_RET_STS_SUCCESS;

1988: RETURN;
1989: END IF;
1990: END LOOP;
1991:
1992: x_return_status := FND_API.G_RET_STS_SUCCESS;
1993:
1994: EXCEPTION
1995: WHEN OTHERS THEN
1996: x_return_status :='E';

Line 2044: OR x_return_status <> fnd_api.g_ret_sts_success THEN

2040: x_msg_count => x_msg_count,
2041: x_msg_data => x_msg_data
2042: );
2043: IF x_return_status IS NULL
2044: OR x_return_status <> fnd_api.g_ret_sts_success THEN
2045: rollback to approve_mult_bus_class_reqs;
2046: RETURN;
2047: END IF;
2048: END LOOP;

Line 2050: x_return_status := FND_API.G_RET_STS_SUCCESS;

2046: RETURN;
2047: END IF;
2048: END LOOP;
2049:
2050: x_return_status := FND_API.G_RET_STS_SUCCESS;
2051:
2052: EXCEPTION
2053: WHEN OTHERS THEN
2054: x_return_status :='E';

Line 2104: OR x_return_status <> fnd_api.g_ret_sts_success THEN

2100: x_msg_count => x_msg_count,
2101: x_msg_data => x_msg_data
2102: );
2103: IF x_return_status IS NULL
2104: OR x_return_status <> fnd_api.g_ret_sts_success THEN
2105: rollback to approve_mult_ps_reqs;
2106: RETURN;
2107: END IF;
2108: END LOOP;

Line 2110: x_return_status := FND_API.G_RET_STS_SUCCESS;

2106: RETURN;
2107: END IF;
2108: END LOOP;
2109:
2110: x_return_status := FND_API.G_RET_STS_SUCCESS;
2111:
2112: EXCEPTION
2113: WHEN OTHERS THEN
2114: x_return_status :='E';

Line 2242: x_return_status := FND_API.G_RET_STS_SUCCESS;

2238: END IF;
2239: raise_application_error(-20061, x_msg_data, true);
2240: END;
2241:
2242: x_return_status := FND_API.G_RET_STS_SUCCESS;
2243:
2244: l_step := 1;
2245:
2246: UPDATE POS_ADDRESS_REQUESTS

Line 2407: x_return_status := FND_API.G_RET_STS_SUCCESS;

2403: END IF;
2404: raise_application_error(-20061, x_msg_data, true);
2405: END;
2406:
2407: x_return_status := FND_API.G_RET_STS_SUCCESS;
2408:
2409:
2410: UPDATE POS_CONTACT_REQUESTS
2411: SET CONTACT_TITLE = p_contact_title,

Line 2494: x_return_status := FND_API.G_RET_STS_SUCCESS;

2490: and CONTACT_REQ_ID = p_cont_req_id;
2491:
2492: END LOOP;
2493:
2494: x_return_status := FND_API.G_RET_STS_SUCCESS;
2495:
2496: EXCEPTION
2497: WHEN OTHERS THEN
2498: x_return_status :='E';

Line 2551: x_return_status := FND_API.G_RET_STS_SUCCESS;

2547: END IF;
2548: raise_application_error(-20058, x_msg_data, true);
2549: END;
2550:
2551: x_return_status := FND_API.G_RET_STS_SUCCESS;
2552: x_user_id := -1 ;
2553: x_cont_party_id := -1 ;
2554: UPDATE POS_CONTACT_REQUESTS
2555: SET CONTACT_TITLE = p_contact_title,

Line 2579: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN

2575: x_password => l_password,
2576: p_inactive_date => p_inactive_date
2577: );
2578:
2579: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN
2580: rollback to new_contact_req_approval;
2581: RETURN;
2582: END IF;
2583:

Line 2632: OR x_return_status <> fnd_api.g_ret_sts_success THEN

2628: x_msg_count => x_msg_count,
2629: x_msg_data => x_msg_data
2630: );
2631: IF x_return_status IS NULL
2632: OR x_return_status <> fnd_api.g_ret_sts_success THEN
2633: RETURN;
2634: END IF;
2635: END LOOP;
2636:

Line 2637: x_return_status := FND_API.G_RET_STS_SUCCESS;

2633: RETURN;
2634: END IF;
2635: END LOOP;
2636:
2637: x_return_status := FND_API.G_RET_STS_SUCCESS;
2638: END assign_mult_address_to_contact;
2639:
2640: PROCEDURE assign_user_sec_attr
2641: ( p_req_id_tbl IN po_tbl_number,

Line 2658: x_return_status := FND_API.G_RET_STS_SUCCESS;

2654: p_app_id => 177,
2655: p_number_value => p_req_id_tbl(i)
2656: );
2657: END LOOP;
2658: x_return_status := FND_API.G_RET_STS_SUCCESS;
2659: END assign_user_sec_attr;
2660:
2661: PROCEDURE update_addr_req_status
2662: (p_request_id IN NUMBER,

Line 2728: x_return_status := fnd_api.g_ret_sts_success;

2724: , x_exception_msg => x_msg_data
2725: );
2726: end if;
2727:
2728: x_return_status := fnd_api.g_ret_sts_success;
2729:
2730: EXCEPTION
2731: WHEN OTHERS THEN
2732: x_return_status :='E';

Line 2752: x_return_status := fnd_api.g_ret_sts_success;

2748: IS
2749: l_ou_ids pos_security_profile_utl_pkg.number_table;
2750: BEGIN
2751: pos_security_profile_utl_pkg.get_current_ous (l_ou_ids, x_ou_count);
2752: x_return_status := fnd_api.g_ret_sts_success;
2753: END get_ou_count ;
2754:
2755: PROCEDURE upd_address_to_contact_rel
2756: ( p_mapping_id IN NUMBER,