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_VENDOR_REG_PKG dependencies on FND_API

Line 33: x_return_status := fnd_api.g_ret_sts_error;

29: OPEN l_cur;
30: FETCH l_cur INTO x_supplier_reg_rec;
31: IF l_cur%notfound THEN
32: CLOSE l_cur;
33: x_return_status := fnd_api.g_ret_sts_error;
34: fnd_message.set_name('POS','POS_SUPPLIER_REG_INVALID_ID');
35: fnd_message.set_token('SUPPLIER_REG_ID', p_supplier_reg_id);
36: fnd_msg_pub.ADD;
37:

Line 47: x_return_status := fnd_api.g_ret_sts_success;

43: END IF;
44: ELSE
45: FETCH l_cur INTO x_supplier_reg_rec;
46: CLOSE l_cur;
47: x_return_status := fnd_api.g_ret_sts_success;
48: END IF;
49:
50: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
51:

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

46: CLOSE l_cur;
47: x_return_status := fnd_api.g_ret_sts_success;
48: END IF;
49:
50: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
51:
52: END lock_supplier_reg_row;
53:
54: PROCEDURE check_bus_class

Line 109: x_return_status := fnd_api.g_ret_sts_success;

105: l_rec l_cur%ROWTYPE;
106: l_profile_id NUMBER;
107: BEGIN
108: IF p_duns_number IS NULL THEN
109: x_return_status := fnd_api.g_ret_sts_success;
110: RETURN;
111: END IF;
112:
113: OPEN l_cur;

Line 117: x_return_status := fnd_api.g_ret_sts_unexp_error;

113: OPEN l_cur;
114: FETCH l_cur INTO l_rec;
115: IF l_cur%notfound THEN
116: CLOSE l_cur;
117: x_return_status := fnd_api.g_ret_sts_unexp_error;
118: x_msg_count := 1;
119: x_msg_data := 'can not find party for vendor ' || p_vendor_id;
120: RETURN;
121: END IF;

Line 129: (p_init_msg_list => fnd_api.g_false,

125: l_org_rec.party_rec := l_party_rec;
126: l_org_rec.duns_number_c := p_duns_number;
127:
128: hz_party_v2pub.update_organization
129: (p_init_msg_list => fnd_api.g_false,
130: p_organization_rec => l_org_rec,
131: p_party_object_version_number => l_rec.object_version_number,
132: x_profile_id => l_profile_id,
133: x_return_status => x_return_status,

Line 165: x_return_status := fnd_api.g_ret_sts_error;

161: /* End */
162:
163: BEGIN
164: l_method := 'create_vendor_and_party';
165: x_return_status := fnd_api.g_ret_sts_error;
166: x_msg_count := 0;
167: x_msg_data := NULL;
168:
169: FND_MSG_PUB.Count_And_Get(

Line 357: IF x_return_status = fnd_api.g_ret_sts_success THEN

353: || ' x_msg_data ' || x_msg_data
354: );
355: END IF;
356:
357: IF x_return_status = fnd_api.g_ret_sts_success THEN
358:
359: OPEN l_vendor_cur;
360: FETCH l_vendor_cur INTO l_number;
361: IF l_vendor_cur%notfound THEN

Line 379: x_return_status <> fnd_api.g_ret_sts_success THEN

375: x_msg_data => x_msg_data
376: );
377:
378: IF x_return_status IS NULL OR
379: x_return_status <> fnd_api.g_ret_sts_success THEN
380: RETURN;
381: END IF;
382:
383: l_step := 'update pos_supplier_mappings with ids';

Line 420: x_return_status := fnd_api.g_ret_sts_success;

416: last_update_date = Sysdate,
417: last_update_login = fnd_global.login_id
418: WHERE supplier_reg_id = p_supplier_reg_rec.supplier_reg_id;
419:
420: x_return_status := fnd_api.g_ret_sts_success;
421:
422: END IF;
423:
424: EXCEPTION

Line 434: x_return_status := fnd_api.g_ret_sts_error;

430: l_hzprofile_changed := 'N';
431: end if;
432: /* End */
433:
434: x_return_status := fnd_api.g_ret_sts_error;
435: raise_application_error (-20003, sqlerrm, true);
436:
437: END create_vendor_and_party;
438:

Line 463: x_return_status <> fnd_api.g_ret_sts_success THEN

459: x_msg_count => x_msg_count,
460: x_msg_data => x_msg_data
461: );
462: IF x_return_status IS NULL OR
463: x_return_status <> fnd_api.g_ret_sts_success THEN
464: RETURN;
465: END IF;
466: END LOOP;
467:

Line 468: x_return_status := fnd_api.g_ret_sts_success;

464: RETURN;
465: END IF;
466: END LOOP;
467:
468: x_return_status := fnd_api.g_ret_sts_success;
469:
470: END create_supplier_addrs_sites;
471:
472: PROCEDURE create_supplier_contacts

Line 534: x_return_status <> fnd_api.g_ret_sts_success THEN

530: x_password => l_temp_password
531: );
532:
533: IF x_return_status IS NULL OR
534: x_return_status <> fnd_api.g_ret_sts_success THEN
535: RETURN;
536: END IF;
537:
538: IF l_rec.create_user_account = 'Y' THEN

Line 574: x_return_status <> fnd_api.g_ret_sts_success THEN

570: x_msg_data => x_msg_data
571: );
572:
573: IF x_return_status IS NULL OR
574: x_return_status <> fnd_api.g_ret_sts_success THEN
575: RETURN;
576: END IF;
577: END IF;
578: END IF;

Line 581: x_return_status := fnd_api.g_ret_sts_success;

577: END IF;
578: END IF;
579: END LOOP;
580:
581: x_return_status := fnd_api.g_ret_sts_success;
582:
583: END create_supplier_contacts;
584:
585: PROCEDURE create_bus_class

Line 611: x_return_status <> fnd_api.g_ret_sts_success THEN

607: x_msg_count => x_msg_count,
608: x_msg_data => x_msg_data
609: );
610: IF x_return_status IS NULL OR
611: x_return_status <> fnd_api.g_ret_sts_success THEN
612: RETURN;
613: END IF;
614: END LOOP;
615:

Line 616: x_return_status := fnd_api.g_ret_sts_success;

612: RETURN;
613: END IF;
614: END LOOP;
615:
616: x_return_status := fnd_api.g_ret_sts_success;
617:
618: END create_bus_class;
619:
620: PROCEDURE create_product_service

Line 646: x_return_status <> fnd_api.g_ret_sts_success THEN

642: x_msg_count => x_msg_count,
643: x_msg_data => x_msg_data
644: );
645: IF x_return_status IS NULL OR
646: x_return_status <> fnd_api.g_ret_sts_success THEN
647: RETURN;
648: END IF;
649: END LOOP;
650:

Line 651: x_return_status := fnd_api.g_ret_sts_success;

647: RETURN;
648: END IF;
649: END LOOP;
650:
651: x_return_status := fnd_api.g_ret_sts_success;
652:
653: END create_product_service;
654:
655: PROCEDURE get_reg_primary_user

Line 697: x_return_status := fnd_api.g_ret_sts_success;

693: x_itemtype => l_itemtype,
694: x_itemkey => l_itemkey,
695: x_receiver => l_receiver
696: ) ;
697: x_return_status := fnd_api.g_ret_sts_success;
698:
699: EXCEPTION
700: WHEN OTHERS THEN
701: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 701: x_return_status := fnd_api.g_ret_sts_unexp_error;

697: x_return_status := fnd_api.g_ret_sts_success;
698:
699: EXCEPTION
700: WHEN OTHERS THEN
701: x_return_status := fnd_api.g_ret_sts_unexp_error;
702: x_msg_count := 1;
703: x_msg_data := Sqlerrm;
704:
705: END notify_banking_approver;

Line 727: x_return_status := fnd_api.g_ret_sts_error;

723: x_user_name => l_user_name,
724: x_user_id => l_user_id
725: );
726: IF l_user_name IS NULL THEN
727: x_return_status := fnd_api.g_ret_sts_error;
728: x_msg_count := 1;
729: x_msg_data := 'can not find the primary supplier user';
730: RETURN;
731: END IF;

Line 772: x_return_status := fnd_api.g_ret_sts_success;

768: end if;
769: END IF;
770: END LOOP;
771:
772: x_return_status := fnd_api.g_ret_sts_success;
773:
774: EXCEPTION
775: WHEN OTHERS THEN
776: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 776: x_return_status := fnd_api.g_ret_sts_unexp_error;

772: x_return_status := fnd_api.g_ret_sts_success;
773:
774: EXCEPTION
775: WHEN OTHERS THEN
776: x_return_status := fnd_api.g_ret_sts_unexp_error;
777: x_msg_count := 1;
778: x_msg_data := Sqlerrm;
779:
780: END notify_supplier_approved;

Line 812: x_return_status := fnd_api.g_ret_sts_error;

808: SAVEPOINT approve_supplier_reg;
809:
810: l_method := 'approve_supplier';
811:
812: x_return_status := fnd_api.g_ret_sts_error;
813:
814: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
815: fnd_log.string
816: (fnd_log.level_procedure

Line 838: AND x_return_status = fnd_api.g_ret_sts_success) THEN

834: x_supplier_reg_rec => l_supplier_reg_rec
835: );
836:
837: IF NOT (x_return_status IS NOT NULL
838: AND x_return_status = fnd_api.g_ret_sts_success) THEN
839: ROLLBACK TO approve_supplier_reg;
840: RETURN;
841: END IF;
842:

Line 854: x_return_status := fnd_api.g_ret_sts_error;

850:
851: IF l_supplier_reg_rec.registration_status IS NULL OR
852: l_supplier_reg_rec.registration_status NOT IN ('PENDING_APPROVAL','RIF_SUPPLIER')
853: THEN
854: x_return_status := fnd_api.g_ret_sts_error;
855: fnd_message.set_name('POS','POS_SUPPLIER_REG_NOT_PENDING');
856: fnd_msg_pub.ADD;
857: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
858:

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

853: THEN
854: x_return_status := fnd_api.g_ret_sts_error;
855: fnd_message.set_name('POS','POS_SUPPLIER_REG_NOT_PENDING');
856: fnd_msg_pub.ADD;
857: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
858:
859: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
860: fnd_log.string
861: (fnd_log.level_error

Line 888: AND x_return_status = fnd_api.g_ret_sts_success) THEN

884: x_party_id => l_vendor_party_id
885: );
886:
887: IF NOT (x_return_status IS NOT NULL
888: AND x_return_status = fnd_api.g_ret_sts_success) THEN
889: ROLLBACK TO approve_supplier_reg;
890: RETURN;
891: END IF;
892:

Line 970: OR x_return_status <> fnd_api.g_ret_sts_success THEN

966: p_registration_type_code => l_supplier_reg_rec.tax_reg_type,
967: p_country_code => l_supplier_reg_rec.tax_reg_country_code
968: );
969: IF x_return_status IS NULL
970: OR x_return_status <> fnd_api.g_ret_sts_success THEN
971: ROLLBACK TO approve_supplier_reg;
972: x_msg_count := 1;
973: x_msg_data := 'call to zx_party_tax_profile_pkg.update_row failed';
974: RETURN;

Line 989: OR x_return_status <> fnd_api.g_ret_sts_success THEN

985: x_msg_data => x_msg_data
986: );
987:
988: IF x_return_status IS NULL
989: OR x_return_status <> fnd_api.g_ret_sts_success THEN
990: ROLLBACK TO approve_supplier_reg;
991: RETURN;
992: END IF;
993:

Line 1011: AND x_return_status = fnd_api.g_ret_sts_success) THEN

1007: x_username_pwds => l_username_pwds
1008: );
1009:
1010: IF NOT (x_return_status IS NOT NULL
1011: AND x_return_status = fnd_api.g_ret_sts_success) THEN
1012: ROLLBACK TO approve_supplier_reg;
1013: RETURN;
1014: END IF;
1015:

Line 1032: AND x_return_status = fnd_api.g_ret_sts_success) THEN

1028: x_msg_data => x_msg_data
1029: );
1030:
1031: IF NOT (x_return_status IS NOT NULL
1032: AND x_return_status = fnd_api.g_ret_sts_success) THEN
1033: ROLLBACK TO approve_supplier_reg;
1034: RETURN;
1035: END IF;
1036:

Line 1053: AND x_return_status = fnd_api.g_ret_sts_success) THEN

1049: x_msg_data => x_msg_data
1050: );
1051:
1052: IF NOT (x_return_status IS NOT NULL
1053: AND x_return_status = fnd_api.g_ret_sts_success) THEN
1054: ROLLBACK TO approve_supplier_reg;
1055: RETURN;
1056: END IF;
1057:

Line 1085: AND x_return_status = fnd_api.g_ret_sts_success) THEN

1081: x_msg_data => x_msg_data
1082: );
1083:
1084: IF NOT (x_return_status IS NOT NULL
1085: AND x_return_status = fnd_api.g_ret_sts_success) THEN
1086: ROLLBACK TO approve_supplier_reg;
1087: RETURN;
1088: END IF;
1089:

Line 1131: AND x_return_status = fnd_api.g_ret_sts_success) THEN

1127: p_user_id => l_user_id
1128: );
1129:
1130: IF NOT (x_return_status IS NOT NULL
1131: AND x_return_status = fnd_api.g_ret_sts_success) THEN
1132: ROLLBACK TO approve_supplier_reg;
1133: RETURN;
1134: END IF;
1135:

Line 1136: x_return_status := fnd_api.g_ret_sts_success;

1132: ROLLBACK TO approve_supplier_reg;
1133: RETURN;
1134: END IF;
1135:
1136: x_return_status := fnd_api.g_ret_sts_success;
1137: x_msg_count := 0;
1138: x_msg_data := NULL;
1139:
1140: EXCEPTION

Line 1185: AND x_return_status = fnd_api.g_ret_sts_success) THEN

1181: x_supplier_reg_rec => l_supplier_reg_rec
1182: );
1183:
1184: IF NOT (x_return_status IS NOT NULL
1185: AND x_return_status = fnd_api.g_ret_sts_success) THEN
1186: RETURN;
1187: END IF;
1188:
1189: l_step := 'check reg status';

Line 1199: x_return_status := fnd_api.g_ret_sts_error;

1195: END IF;
1196:
1197: IF l_supplier_reg_rec.registration_status IS NULL OR
1198: l_supplier_reg_rec.registration_status <> 'PENDING_APPROVAL' THEN
1199: x_return_status := fnd_api.g_ret_sts_error;
1200: fnd_message.set_name('POS','POS_SUPPLIER_REG_NOT_PENDING');
1201: fnd_msg_pub.ADD;
1202: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1203:

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

1198: l_supplier_reg_rec.registration_status <> 'PENDING_APPROVAL' THEN
1199: x_return_status := fnd_api.g_ret_sts_error;
1200: fnd_message.set_name('POS','POS_SUPPLIER_REG_NOT_PENDING');
1201: fnd_msg_pub.ADD;
1202: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1203:
1204: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
1205: fnd_log.string
1206: (fnd_log.level_error

Line 1258: x_return_status := fnd_api.g_ret_sts_success;

1254: x_itemkey => l_itemkey,
1255: x_receiver => l_receiver
1256: );
1257:
1258: x_return_status := fnd_api.g_ret_sts_success;
1259: x_msg_count := 0;
1260: x_msg_data := NULL;
1261:
1262: END reject_supplier_reg;

Line 1294: OR x_return_status <> fnd_api.g_ret_sts_success THEN

1290: x_supplier_reg_rec => l_supplier_reg_rec
1291: );
1292:
1293: IF x_return_status IS NULL
1294: OR x_return_status <> fnd_api.g_ret_sts_success THEN
1295: RETURN;
1296: END IF;
1297:
1298: l_step := 'check reg status';

Line 1310: x_return_status := fnd_api.g_ret_sts_error;

1306: IF l_supplier_reg_rec.registration_status IS NULL OR
1307: (l_supplier_reg_rec.registration_status <> 'DRAFT' AND
1308: l_supplier_reg_rec.registration_status <> 'RIF_SUPPLIER')
1309: THEN
1310: x_return_status := fnd_api.g_ret_sts_error;
1311: fnd_message.set_name('POS','POS_SUPPLIER_REG_NOT_DRAFT');
1312: fnd_msg_pub.ADD;
1313: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1314:

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

1309: THEN
1310: x_return_status := fnd_api.g_ret_sts_error;
1311: fnd_message.set_name('POS','POS_SUPPLIER_REG_NOT_DRAFT');
1312: fnd_msg_pub.ADD;
1313: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1314:
1315: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
1316: fnd_log.string
1317: (fnd_log.level_error

Line 1332: x_return_status := fnd_api.g_ret_sts_success;

1328: last_updated_by = fnd_global.user_id,
1329: last_update_login = fnd_global.login_id
1330: WHERE supplier_reg_id = p_supplier_reg_id;
1331:
1332: x_return_status := fnd_api.g_ret_sts_success;
1333: x_msg_count := 0;
1334: x_msg_data := NULL;
1335:
1336: END submit_supplier_reg;

Line 1350: x_return_status := fnd_api.g_ret_sts_success;

1346:
1347: pos_spm_wf_pkg1.send_supplier_reg_saved_ntf
1348: (p_supplier_reg_id => p_supplier_reg_id);
1349:
1350: x_return_status := fnd_api.g_ret_sts_success;
1351: x_msg_count := 0;
1352: x_msg_data := NULL;
1353:
1354: END send_save_for_later_ntf;