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 435: IF x_return_status <> fnd_api.g_ret_sts_success THEN

431: p_alt_phone_number => p_request_rec.alt_phone_number,
432: p_url => p_request_rec.url
433: );
434:
435: IF x_return_status <> fnd_api.g_ret_sts_success THEN
436: ROLLBACK TO approve_new_contact_req_sp;
437: RETURN;
438: END IF;
439:

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

464: x_user_id => l_fnd_user_id,
465: x_password => x_password
466: );
467:
468: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN
469: ROLLBACK TO approve_new_contact_req_sp;
470: RETURN;
471: END IF;
472:

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

511: x_msg_count => x_msg_count,
512: x_msg_data => x_msg_data
513: );
514:
515: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN
516: ROLLBACK TO approve_new_contact_req_sp;
517: RETURN;
518: END IF;
519:

Line 522: x_return_status := fnd_api.g_ret_sts_unexp_error;

518: END IF;
519:
520: EXCEPTION
521: WHEN OTHERS THEN
522: x_return_status := fnd_api.g_ret_sts_unexp_error;
523: x_msg_count := 1;
524: x_msg_data := Sqlerrm;
525: ROLLBACK TO approve_new_contact_req_sp;
526: pos_log.log_sqlerrm('POSCONTB', 'in approve_new_contact_req');

Line 562: x_return_status := fnd_api.g_ret_sts_error;

558: END;
559:
560: IF p_request_rec.request_type <> 'UPDATE' AND
561: p_request_rec.request_type <> 'DELETE' THEN
562: x_return_status := fnd_api.g_ret_sts_error;
563: x_msg_count := 1;
564: x_msg_data := 'request_type not UPDATED for contact request id '
565: || p_request_rec.contact_request_id;
566: ROLLBACK TO approve_update_contact_req_sp;

Line 571: x_return_status := fnd_api.g_ret_sts_error;

567: RETURN;
568: END IF;
569:
570: IF p_request_rec.request_status <> 'PENDING' THEN
571: x_return_status := fnd_api.g_ret_sts_error;
572: x_msg_count := 1;
573: x_msg_data := 'request_status not PENDING for contact request id '
574: || p_request_rec.contact_request_id;
575: ROLLBACK TO approve_update_contact_req_sp;

Line 580: x_return_status := fnd_api.g_ret_sts_error;

576: RETURN;
577: END IF;
578:
579: IF p_request_rec.contact_party_id IS NULL THEN
580: x_return_status := fnd_api.g_ret_sts_error;
581: x_msg_count := 1;
582: x_msg_data := 'contact_party_id is NULL for contact request id '
583: || p_request_rec.contact_request_id;
584: ROLLBACK TO approve_update_contact_req_sp;

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

615: p_alt_phone_number => p_request_rec.alt_phone_number,
616: p_url => p_request_rec.url
617: );
618:
619: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN
620: ROLLBACK TO approve_update_contact_req_sp;
621: RETURN;
622: END IF;
623:

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

635: x_msg_count => x_msg_count,
636: x_msg_data => x_msg_data
637: );
638:
639: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN
640: ROLLBACK TO approve_update_contact_req_sp;
641: RETURN;
642: END IF;
643:

Line 647: x_return_status := fnd_api.g_ret_sts_unexp_error;

643:
644: EXCEPTION
645: WHEN OTHERS THEN
646: ROLLBACK TO approve_update_contact_req_sp;
647: x_return_status := fnd_api.g_ret_sts_unexp_error;
648: x_msg_count := 1;
649: x_msg_data := Sqlerrm;
650: pos_log.log_sqlerrm('POSCONTB', 'in approve_update_contact_req');
651:

Line 734: x_return_status := fnd_api.g_ret_sts_success;

730: last_updated_by = fnd_global.user_id,
731: last_update_login = fnd_global.login_id
732: WHERE bus_class_request_id = p_request_rec.bus_class_request_id;
733:
734: x_return_status := fnd_api.g_ret_sts_success;
735:
736: EXCEPTION
737: WHEN OTHERS THEN
738: x_return_status :='E';

Line 798: x_return_status := fnd_api.g_ret_sts_success;

794: last_updated_by = fnd_global.user_id,
795: last_update_login = fnd_global.login_id
796: WHERE bus_class_request_id = p_request_rec.bus_class_request_id;
797:
798: x_return_status := fnd_api.g_ret_sts_success;
799: EXCEPTION
800: WHEN OTHERS THEN
801: x_return_status :='E';
802: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

Line 838: x_return_status := fnd_api.g_ret_sts_error;

834: OPEN l_cur;
835: FETCH l_cur INTO l_rec;
836: IF l_cur%notfound THEN
837: CLOSE l_cur;
838: x_return_status := fnd_api.g_ret_sts_error;
839: fnd_message.set_name('POS','POS_PRCR_BAD_ADDR_REQ_ID');
840: fnd_message.set_token('ADDRRESS_REQUEST_ID', p_request_id);
841: fnd_msg_pub.ADD;
842: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);

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

838: x_return_status := fnd_api.g_ret_sts_error;
839: fnd_message.set_name('POS','POS_PRCR_BAD_ADDR_REQ_ID');
840: fnd_message.set_token('ADDRRESS_REQUEST_ID', p_request_id);
841: fnd_msg_pub.ADD;
842: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
843: rollback to approve_address_req;
844: RETURN;
845: END IF;
846: CLOSE l_cur;

Line 849: x_return_status := fnd_api.g_ret_sts_error;

845: END IF;
846: CLOSE l_cur;
847:
848: IF l_rec.request_status IS NULL OR l_rec.request_status <> 'PENDING' THEN
849: x_return_status := fnd_api.g_ret_sts_error;
850: fnd_message.set_name('POS','POS_PRCR_ADDRREQ_NOT_PEND');
851: fnd_message.set_token('ADDRRESS_REQUEST_ID', p_request_id);
852: fnd_msg_pub.ADD;
853: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);

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

849: x_return_status := fnd_api.g_ret_sts_error;
850: fnd_message.set_name('POS','POS_PRCR_ADDRREQ_NOT_PEND');
851: fnd_message.set_token('ADDRRESS_REQUEST_ID', p_request_id);
852: fnd_msg_pub.ADD;
853: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
854: rollback to approve_address_req;
855: RETURN;
856: END IF;
857:

Line 862: x_return_status := fnd_api.g_ret_sts_error;

858: OPEN l_cur2;
859: FETCH l_cur2 INTO l_rec2;
860: IF l_cur2%notfound THEN
861: CLOSE l_cur2;
862: x_return_status := fnd_api.g_ret_sts_error;
863: fnd_message.set_name('POS','POS_PRCR_BAD_MAPPING_ID');
864: fnd_message.set_token('MAPPING_ID', l_rec.mapping_id);
865: fnd_msg_pub.ADD;
866: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);

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

862: x_return_status := fnd_api.g_ret_sts_error;
863: fnd_message.set_name('POS','POS_PRCR_BAD_MAPPING_ID');
864: fnd_message.set_token('MAPPING_ID', l_rec.mapping_id);
865: fnd_msg_pub.ADD;
866: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
867: rollback to approve_address_req;
868: RETURN;
869: END IF;
870: CLOSE l_cur2;

Line 901: x_return_status := fnd_api.g_ret_sts_error;

897: last_update_login = fnd_global.login_id
898: WHERE address_request_id = p_request_id;
899:
900: ELSE
901: x_return_status := fnd_api.g_ret_sts_error;
902: x_msg_count := 1;
903: x_msg_data := l_rec.request_type || ' is not yet supported';
904: END IF;
905:

Line 1006: x_return_status := fnd_api.g_ret_sts_error;

1002: OPEN l_cur;
1003: FETCH l_cur INTO l_rec;
1004: IF l_cur%notfound THEN
1005: CLOSE l_cur;
1006: x_return_status := fnd_api.g_ret_sts_error;
1007: fnd_message.set_name('POS','POS_PRCR_BAD_CONT_REQ_ID');
1008: fnd_message.set_token('CONTACT_REQUEST_ID', p_request_id);
1009: fnd_msg_pub.ADD;
1010: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);

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

1006: x_return_status := fnd_api.g_ret_sts_error;
1007: fnd_message.set_name('POS','POS_PRCR_BAD_CONT_REQ_ID');
1008: fnd_message.set_token('CONTACT_REQUEST_ID', p_request_id);
1009: fnd_msg_pub.ADD;
1010: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1011: rollback to approve_contact_req;
1012: RETURN;
1013: END IF;
1014: CLOSE l_cur;

Line 1017: x_return_status := fnd_api.g_ret_sts_error;

1013: END IF;
1014: CLOSE l_cur;
1015:
1016: IF l_rec.request_status IS NULL OR l_rec.request_status <> 'PENDING' THEN
1017: x_return_status := fnd_api.g_ret_sts_error;
1018: fnd_message.set_name('POS','POS_PRCR_CONTREQ_NOT_PEND');
1019: fnd_message.set_token('CONTACT_REQUEST_ID', p_request_id);
1020: fnd_msg_pub.ADD;
1021: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);

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

1017: x_return_status := fnd_api.g_ret_sts_error;
1018: fnd_message.set_name('POS','POS_PRCR_CONTREQ_NOT_PEND');
1019: fnd_message.set_token('CONTACT_REQUEST_ID', p_request_id);
1020: fnd_msg_pub.ADD;
1021: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1022: rollback to approve_contact_req;
1023: RETURN;
1024: END IF;
1025:

Line 1030: x_return_status := fnd_api.g_ret_sts_error;

1026: OPEN l_cur2;
1027: FETCH l_cur2 INTO l_rec2;
1028: IF l_cur2%notfound THEN
1029: CLOSE l_cur2;
1030: x_return_status := fnd_api.g_ret_sts_error;
1031: fnd_message.set_name('POS','POS_PRCR_BAD_MAPPING_ID');
1032: fnd_message.set_token('MAPPING_ID', l_rec.mapping_id);
1033: fnd_msg_pub.ADD;
1034: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);

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

1030: x_return_status := fnd_api.g_ret_sts_error;
1031: fnd_message.set_name('POS','POS_PRCR_BAD_MAPPING_ID');
1032: fnd_message.set_token('MAPPING_ID', l_rec.mapping_id);
1033: fnd_msg_pub.ADD;
1034: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1035: rollback to approve_contact_req;
1036: RETURN;
1037: END IF;
1038: CLOSE l_cur2;

Line 1088: x_return_status <> fnd_api.g_ret_sts_success) THEN

1084: x_msg_data => x_msg_data);
1085:
1086:
1087: IF (x_return_status IS NULL OR
1088: x_return_status <> fnd_api.g_ret_sts_success) THEN
1089: ROLLBACK TO approve_new_contact_req_sp;
1090: RETURN;
1091: END IF;
1092:

Line 1104: x_return_status := fnd_api.g_ret_sts_error;

1100: /*End Supplier Hub -- Supplier Management */
1101:
1102: ELSE
1103:
1104: x_return_status := fnd_api.g_ret_sts_error;
1105: x_msg_count := 1;
1106: x_msg_data := l_rec.request_type || ' is not yet supported';
1107: END IF;
1108:

Line 1150: x_return_status := fnd_api.g_ret_sts_error;

1146: OPEN l_cur;
1147: FETCH l_cur INTO l_rec;
1148: IF l_cur%notfound THEN
1149: CLOSE l_cur;
1150: x_return_status := fnd_api.g_ret_sts_error;
1151: fnd_message.set_name('POS','POS_PRCR_BAD_BC_REQ_ID');
1152: fnd_message.set_token('BUS_CLASS_REQUEST_ID', p_request_id);
1153: fnd_msg_pub.ADD;
1154: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);

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

1150: x_return_status := fnd_api.g_ret_sts_error;
1151: fnd_message.set_name('POS','POS_PRCR_BAD_BC_REQ_ID');
1152: fnd_message.set_token('BUS_CLASS_REQUEST_ID', p_request_id);
1153: fnd_msg_pub.ADD;
1154: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1155: rollback to approve_bus_class_req;
1156: RETURN;
1157: END IF;
1158: CLOSE l_cur;

Line 1161: x_return_status := fnd_api.g_ret_sts_error;

1157: END IF;
1158: CLOSE l_cur;
1159:
1160: IF l_rec.request_status IS NULL OR l_rec.request_status <> 'PENDING' THEN
1161: x_return_status := fnd_api.g_ret_sts_error;
1162: fnd_message.set_name('POS','POS_PRCR_BCREQ_NOT_PEND');
1163: fnd_message.set_token('BUS_CLASS_REQUEST_ID', p_request_id);
1164: fnd_msg_pub.ADD;
1165: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);

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

1161: x_return_status := fnd_api.g_ret_sts_error;
1162: fnd_message.set_name('POS','POS_PRCR_BCREQ_NOT_PEND');
1163: fnd_message.set_token('BUS_CLASS_REQUEST_ID', p_request_id);
1164: fnd_msg_pub.ADD;
1165: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1166: rollback to approve_bus_class_req;
1167: RETURN;
1168: END IF;
1169:

Line 1174: x_return_status := fnd_api.g_ret_sts_error;

1170: OPEN l_cur2;
1171: FETCH l_cur2 INTO l_rec2;
1172: IF l_cur2%notfound THEN
1173: CLOSE l_cur2;
1174: x_return_status := fnd_api.g_ret_sts_error;
1175: fnd_message.set_name('POS','POS_PRCR_BAD_MAPPING_ID');
1176: fnd_message.set_token('MAPPING_ID', l_rec.mapping_id);
1177: fnd_msg_pub.ADD;
1178: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);

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

1174: x_return_status := fnd_api.g_ret_sts_error;
1175: fnd_message.set_name('POS','POS_PRCR_BAD_MAPPING_ID');
1176: fnd_message.set_token('MAPPING_ID', l_rec.mapping_id);
1177: fnd_msg_pub.ADD;
1178: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1179: rollback to approve_bus_class_req;
1180: RETURN;
1181: END IF;
1182: CLOSE l_cur2;

Line 1211: x_return_status := fnd_api.g_ret_sts_error;

1207: pPartyId => l_rec2.party_id,
1208: pVendorId => l_rec2.vendor_id);
1209:
1210: ELSE
1211: x_return_status := fnd_api.g_ret_sts_error;
1212: x_msg_count := 1;
1213: x_msg_data := l_rec.request_type || ' is not yet supported';
1214: END IF;
1215:

Line 1257: x_return_status := fnd_api.g_ret_sts_error;

1253: OPEN l_cur;
1254: FETCH l_cur INTO l_rec;
1255: IF l_cur%notfound THEN
1256: CLOSE l_cur;
1257: x_return_status := fnd_api.g_ret_sts_error;
1258: fnd_message.set_name('POS','POS_PRCR_BAD_PS_REQ_ID');
1259: fnd_message.set_token('PS_REQUEST_ID', p_request_id);
1260: fnd_msg_pub.ADD;
1261: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);

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

1257: x_return_status := fnd_api.g_ret_sts_error;
1258: fnd_message.set_name('POS','POS_PRCR_BAD_PS_REQ_ID');
1259: fnd_message.set_token('PS_REQUEST_ID', p_request_id);
1260: fnd_msg_pub.ADD;
1261: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1262: rollback to approve_ps_req;
1263: RETURN;
1264: END IF;
1265: CLOSE l_cur;

Line 1268: x_return_status := fnd_api.g_ret_sts_error;

1264: END IF;
1265: CLOSE l_cur;
1266:
1267: IF l_rec.request_status IS NULL OR l_rec.request_status <> 'PENDING' THEN
1268: x_return_status := fnd_api.g_ret_sts_error;
1269: fnd_message.set_name('POS','POS_PRCR_PSREQ_NOT_PEND');
1270: fnd_message.set_token('PS_REQUEST_ID', p_request_id);
1271: fnd_msg_pub.ADD;
1272: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);

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

1268: x_return_status := fnd_api.g_ret_sts_error;
1269: fnd_message.set_name('POS','POS_PRCR_PSREQ_NOT_PEND');
1270: fnd_message.set_token('PS_REQUEST_ID', p_request_id);
1271: fnd_msg_pub.ADD;
1272: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1273: rollback to approve_ps_req;
1274: RETURN;
1275: END IF;
1276:

Line 1278: x_return_status := fnd_api.g_ret_sts_error;

1274: RETURN;
1275: END IF;
1276:
1277: IF l_rec.request_type IS NULL OR l_rec.request_type <> 'ADD' THEN
1278: x_return_status := fnd_api.g_ret_sts_error;
1279: fnd_message.set_name('POS','POS_PRCR_PSREQ_TYPE_NOT_ADD');
1280: fnd_message.set_token('PS_REQUEST_ID', p_request_id);
1281: fnd_msg_pub.ADD;
1282: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);

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

1278: x_return_status := fnd_api.g_ret_sts_error;
1279: fnd_message.set_name('POS','POS_PRCR_PSREQ_TYPE_NOT_ADD');
1280: fnd_message.set_token('PS_REQUEST_ID', p_request_id);
1281: fnd_msg_pub.ADD;
1282: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1283: rollback to approve_ps_req;
1284: RETURN;
1285: END IF;
1286:

Line 1291: x_return_status := fnd_api.g_ret_sts_error;

1287: OPEN l_cur2;
1288: FETCH l_cur2 INTO l_rec2;
1289: IF l_cur2%notfound THEN
1290: CLOSE l_cur2;
1291: x_return_status := fnd_api.g_ret_sts_error;
1292: fnd_message.set_name('POS','POS_PRCR_BAD_MAPPING_ID');
1293: fnd_message.set_token('MAPPING_ID', l_rec.mapping_id);
1294: fnd_msg_pub.ADD;
1295: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);

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

1291: x_return_status := fnd_api.g_ret_sts_error;
1292: fnd_message.set_name('POS','POS_PRCR_BAD_MAPPING_ID');
1293: fnd_message.set_token('MAPPING_ID', l_rec.mapping_id);
1294: fnd_msg_pub.ADD;
1295: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1296: rollback to approve_ps_req;
1297: RETURN;
1298: END IF;
1299: CLOSE l_cur2;

Line 1373: x_return_status := fnd_api.g_ret_sts_success;

1369: last_updated_by = fnd_global.user_id,
1370: last_update_login = fnd_global.login_id
1371: WHERE ps_request_id = p_request_id;
1372:
1373: x_return_status := fnd_api.g_ret_sts_success;
1374:
1375: EXCEPTION
1376: WHEN OTHERS THEN
1377: x_return_status :='E';

Line 1435: x_return_status := fnd_api.g_ret_sts_success;

1431: last_updated_by = fnd_global.user_id,
1432: last_update_login = fnd_global.login_id
1433: WHERE address_req_id = p_request_id;
1434:
1435: x_return_status := fnd_api.g_ret_sts_success;
1436:
1437: EXCEPTION
1438: WHEN OTHERS THEN
1439: x_return_status :='E';

Line 1491: x_return_status := fnd_api.g_ret_sts_success;

1487: last_updated_by = fnd_global.user_id,
1488: last_update_login = fnd_global.login_id
1489: WHERE contact_request_id = p_request_id;
1490:
1491: x_return_status := fnd_api.g_ret_sts_success;
1492: EXCEPTION
1493: WHEN OTHERS THEN
1494: x_return_status :='E';
1495: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

Line 1539: x_return_status := fnd_api.g_ret_sts_success;

1535: last_updated_by = fnd_global.user_id,
1536: last_update_login = fnd_global.login_id
1537: WHERE bus_class_request_id = p_request_id;
1538:
1539: x_return_status := fnd_api.g_ret_sts_success;
1540: EXCEPTION
1541: WHEN OTHERS THEN
1542: x_return_status :='E';
1543: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

Line 1585: x_return_status := fnd_api.g_ret_sts_success;

1581: last_updated_by = fnd_global.user_id,
1582: last_update_login = fnd_global.login_id
1583: WHERE ps_request_id = p_request_id;
1584:
1585: x_return_status := fnd_api.g_ret_sts_success;
1586:
1587: EXCEPTION
1588: WHEN OTHERS THEN
1589: x_return_status :='E';

Line 1638: OR x_return_status <> fnd_api.g_ret_sts_success THEN

1634: x_msg_count => x_msg_count,
1635: x_msg_data => x_msg_data
1636: );
1637: IF x_return_status IS NULL
1638: OR x_return_status <> fnd_api.g_ret_sts_success THEN
1639: rollback to reject_mult_address_reqs;
1640: RETURN;
1641: END IF;
1642: END LOOP;

Line 1644: x_return_status := FND_API.G_RET_STS_SUCCESS;

1640: RETURN;
1641: END IF;
1642: END LOOP;
1643:
1644: x_return_status := FND_API.G_RET_STS_SUCCESS;
1645: EXCEPTION
1646: WHEN OTHERS THEN
1647: x_return_status :='E';
1648: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

Line 1696: OR x_return_status <> fnd_api.g_ret_sts_success THEN

1692: x_msg_count => x_msg_count,
1693: x_msg_data => x_msg_data
1694: );
1695: IF x_return_status IS NULL
1696: OR x_return_status <> fnd_api.g_ret_sts_success THEN
1697: rollback to reject_mult_contact_reqs;
1698: RETURN;
1699: END IF;
1700: END LOOP;

Line 1702: x_return_status := FND_API.G_RET_STS_SUCCESS;

1698: RETURN;
1699: END IF;
1700: END LOOP;
1701:
1702: x_return_status := FND_API.G_RET_STS_SUCCESS;
1703:
1704: EXCEPTION
1705: WHEN OTHERS THEN
1706: x_return_status :='E';

Line 1757: OR x_return_status <> fnd_api.g_ret_sts_success THEN

1753: x_msg_count => x_msg_count,
1754: x_msg_data => x_msg_data
1755: );
1756: IF x_return_status IS NULL
1757: OR x_return_status <> fnd_api.g_ret_sts_success THEN
1758: rollback to reject_mult_bus_class_reqs;
1759: RETURN;
1760: END IF;
1761: END LOOP;

Line 1763: x_return_status := FND_API.G_RET_STS_SUCCESS;

1759: RETURN;
1760: END IF;
1761: END LOOP;
1762:
1763: x_return_status := FND_API.G_RET_STS_SUCCESS;
1764:
1765: EXCEPTION
1766: WHEN OTHERS THEN
1767: x_return_status :='E';

Line 1817: OR x_return_status <> fnd_api.g_ret_sts_success THEN

1813: x_msg_count => x_msg_count,
1814: x_msg_data => x_msg_data
1815: );
1816: IF x_return_status IS NULL
1817: OR x_return_status <> fnd_api.g_ret_sts_success THEN
1818: rollback to reject_mult_ps_reqs;
1819: RETURN;
1820: END IF;
1821: END LOOP;

Line 1823: x_return_status := FND_API.G_RET_STS_SUCCESS;

1819: RETURN;
1820: END IF;
1821: END LOOP;
1822:
1823: x_return_status := FND_API.G_RET_STS_SUCCESS;
1824: EXCEPTION
1825: WHEN OTHERS THEN
1826: x_return_status :='E';
1827: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

Line 1875: OR x_return_status <> fnd_api.g_ret_sts_success THEN

1871: x_msg_count => x_msg_count,
1872: x_msg_data => x_msg_data
1873: );
1874: IF x_return_status IS NULL
1875: OR x_return_status <> fnd_api.g_ret_sts_success THEN
1876: rollback to approve_mult_address_reqs;
1877: RETURN;
1878: END IF;
1879: END LOOP;

Line 1881: x_return_status := FND_API.G_RET_STS_SUCCESS;

1877: RETURN;
1878: END IF;
1879: END LOOP;
1880:
1881: x_return_status := FND_API.G_RET_STS_SUCCESS;
1882:
1883: EXCEPTION
1884: WHEN OTHERS THEN
1885: x_return_status :='E';

Line 2040: OR x_return_status <> fnd_api.g_ret_sts_success THEN

2036: x_msg_data => x_msg_data,
2037: x_password => l_password
2038: );
2039: IF x_return_status IS NULL
2040: OR x_return_status <> fnd_api.g_ret_sts_success THEN
2041: rollback to approve_mult_contact_reqs;
2042: RETURN;
2043: END IF;
2044: END LOOP;

Line 2046: x_return_status := FND_API.G_RET_STS_SUCCESS;

2042: RETURN;
2043: END IF;
2044: END LOOP;
2045:
2046: x_return_status := FND_API.G_RET_STS_SUCCESS;
2047:
2048: EXCEPTION
2049: WHEN OTHERS THEN
2050: x_return_status :='E';

Line 2098: OR x_return_status <> fnd_api.g_ret_sts_success THEN

2094: x_msg_count => x_msg_count,
2095: x_msg_data => x_msg_data
2096: );
2097: IF x_return_status IS NULL
2098: OR x_return_status <> fnd_api.g_ret_sts_success THEN
2099: rollback to approve_mult_bus_class_reqs;
2100: RETURN;
2101: END IF;
2102: END LOOP;

Line 2104: x_return_status := FND_API.G_RET_STS_SUCCESS;

2100: RETURN;
2101: END IF;
2102: END LOOP;
2103:
2104: x_return_status := FND_API.G_RET_STS_SUCCESS;
2105:
2106: EXCEPTION
2107: WHEN OTHERS THEN
2108: x_return_status :='E';

Line 2158: OR x_return_status <> fnd_api.g_ret_sts_success THEN

2154: x_msg_count => x_msg_count,
2155: x_msg_data => x_msg_data
2156: );
2157: IF x_return_status IS NULL
2158: OR x_return_status <> fnd_api.g_ret_sts_success THEN
2159: rollback to approve_mult_ps_reqs;
2160: RETURN;
2161: END IF;
2162: END LOOP;

Line 2164: x_return_status := FND_API.G_RET_STS_SUCCESS;

2160: RETURN;
2161: END IF;
2162: END LOOP;
2163:
2164: x_return_status := FND_API.G_RET_STS_SUCCESS;
2165:
2166: EXCEPTION
2167: WHEN OTHERS THEN
2168: x_return_status :='E';

Line 2296: x_return_status := FND_API.G_RET_STS_SUCCESS;

2292: END IF;
2293: raise_application_error(-20061, x_msg_data, true);
2294: END;
2295:
2296: x_return_status := FND_API.G_RET_STS_SUCCESS;
2297:
2298: l_step := 1;
2299:
2300: UPDATE POS_ADDRESS_REQUESTS

Line 2466: x_return_status := FND_API.G_RET_STS_SUCCESS;

2462: END IF;
2463: raise_application_error(-20061, x_msg_data, true);
2464: END;
2465:
2466: x_return_status := FND_API.G_RET_STS_SUCCESS;
2467:
2468:
2469: UPDATE POS_CONTACT_REQUESTS
2470: SET CONTACT_TITLE = p_contact_title,

Line 2558: x_return_status := FND_API.G_RET_STS_SUCCESS;

2554: and CONTACT_REQ_ID = p_cont_req_id;
2555:
2556: END LOOP;
2557:
2558: x_return_status := FND_API.G_RET_STS_SUCCESS;
2559:
2560: EXCEPTION
2561: WHEN OTHERS THEN
2562: x_return_status :='E';

Line 2620: x_return_status := FND_API.G_RET_STS_SUCCESS;

2616: END IF;
2617: raise_application_error(-20058, x_msg_data, true);
2618: END;
2619:
2620: x_return_status := FND_API.G_RET_STS_SUCCESS;
2621: x_user_id := -1 ;
2622: x_cont_party_id := -1 ;
2623: UPDATE POS_CONTACT_REQUESTS
2624: SET CONTACT_TITLE = p_contact_title,

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

2649: x_password => l_password,
2650: p_inactive_date => p_inactive_date
2651: );
2652:
2653: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN
2654: rollback to new_contact_req_approval;
2655: RETURN;
2656: END IF;
2657:

Line 2706: OR x_return_status <> fnd_api.g_ret_sts_success THEN

2702: x_msg_count => x_msg_count,
2703: x_msg_data => x_msg_data
2704: );
2705: IF x_return_status IS NULL
2706: OR x_return_status <> fnd_api.g_ret_sts_success THEN
2707: RETURN;
2708: END IF;
2709: END LOOP;
2710:

Line 2711: x_return_status := FND_API.G_RET_STS_SUCCESS;

2707: RETURN;
2708: END IF;
2709: END LOOP;
2710:
2711: x_return_status := FND_API.G_RET_STS_SUCCESS;
2712: END assign_mult_address_to_contact;
2713:
2714: PROCEDURE assign_user_sec_attr
2715: ( p_req_id_tbl IN po_tbl_number,

Line 2732: x_return_status := FND_API.G_RET_STS_SUCCESS;

2728: p_app_id => 177,
2729: p_number_value => p_req_id_tbl(i)
2730: );
2731: END LOOP;
2732: x_return_status := FND_API.G_RET_STS_SUCCESS;
2733: END assign_user_sec_attr;
2734:
2735: PROCEDURE update_addr_req_status
2736: (p_request_id IN NUMBER,

Line 2802: x_return_status := fnd_api.g_ret_sts_success;

2798: , x_exception_msg => x_msg_data
2799: );
2800: end if;
2801:
2802: x_return_status := fnd_api.g_ret_sts_success;
2803:
2804: EXCEPTION
2805: WHEN OTHERS THEN
2806: x_return_status :='E';

Line 2826: x_return_status := fnd_api.g_ret_sts_success;

2822: IS
2823: l_ou_ids pos_security_profile_utl_pkg.number_table;
2824: BEGIN
2825: pos_security_profile_utl_pkg.get_current_ous (l_ou_ids, x_ou_count);
2826: x_return_status := fnd_api.g_ret_sts_success;
2827: END get_ou_count ;
2828:
2829: PROCEDURE upd_address_to_contact_rel
2830: ( p_mapping_id IN NUMBER,