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

360: end if;
361: /* End */
362:
363: IF x_return_status IS NULL OR
364: x_return_status <> fnd_api.g_ret_sts_success THEN
365: RETURN;
366: END IF;
367:
368: IF x_vendor_id IS NULL THEN

Line 386: IF x_return_status = fnd_api.g_ret_sts_success THEN

382: || ' x_msg_data ' || x_msg_data
383: );
384: END IF;
385:
386: IF x_return_status = fnd_api.g_ret_sts_success THEN
387:
388: OPEN l_vendor_cur;
389: FETCH l_vendor_cur INTO l_number;
390: IF l_vendor_cur%notfound THEN

Line 408: x_return_status <> fnd_api.g_ret_sts_success THEN

404: x_msg_data => x_msg_data
405: );
406:
407: IF x_return_status IS NULL OR
408: x_return_status <> fnd_api.g_ret_sts_success THEN
409: RETURN;
410: END IF;
411:
412: l_step := 'update pos_supplier_mappings with ids';

Line 495: x_return_status := fnd_api.g_ret_sts_success;

491: last_update_date = Sysdate,
492: last_update_login = fnd_global.login_id
493: WHERE supplier_reg_id = p_supplier_reg_rec.supplier_reg_id;
494:
495: x_return_status := fnd_api.g_ret_sts_success;
496:
497: END IF;
498:
499: EXCEPTION

Line 509: x_return_status := fnd_api.g_ret_sts_error;

505: l_hzprofile_changed := 'N';
506: end if;
507: /* End */
508:
509: x_return_status := fnd_api.g_ret_sts_error;
510: raise_application_error (-20003, sqlerrm, true);
511:
512: END create_vendor_and_party;
513:

Line 538: x_return_status <> fnd_api.g_ret_sts_success THEN

534: x_msg_count => x_msg_count,
535: x_msg_data => x_msg_data
536: );
537: IF x_return_status IS NULL OR
538: x_return_status <> fnd_api.g_ret_sts_success THEN
539: RETURN;
540: END IF;
541: END LOOP;
542:

Line 543: x_return_status := fnd_api.g_ret_sts_success;

539: RETURN;
540: END IF;
541: END LOOP;
542:
543: x_return_status := fnd_api.g_ret_sts_success;
544:
545: END create_supplier_addrs_sites;
546:
547: PROCEDURE create_supplier_contacts

Line 617: x_return_status <> fnd_api.g_ret_sts_success THEN

613: x_password => l_temp_password
614: );
615:
616: IF x_return_status IS NULL OR
617: x_return_status <> fnd_api.g_ret_sts_success THEN
618: RETURN;
619: END IF;
620:
621: IF l_rec.create_user_account = 'Y' THEN

Line 657: x_return_status <> fnd_api.g_ret_sts_success THEN

653: x_msg_data => x_msg_data
654: );
655:
656: IF x_return_status IS NULL OR
657: x_return_status <> fnd_api.g_ret_sts_success THEN
658: RETURN;
659: END IF;
660: END IF;
661: END IF;

Line 664: x_return_status := fnd_api.g_ret_sts_success;

660: END IF;
661: END IF;
662: END LOOP;
663:
664: x_return_status := fnd_api.g_ret_sts_success;
665:
666: END create_supplier_contacts;
667:
668: PROCEDURE create_bus_class

Line 694: x_return_status <> fnd_api.g_ret_sts_success THEN

690: x_msg_count => x_msg_count,
691: x_msg_data => x_msg_data
692: );
693: IF x_return_status IS NULL OR
694: x_return_status <> fnd_api.g_ret_sts_success THEN
695: RETURN;
696: END IF;
697: END LOOP;
698:

Line 699: x_return_status := fnd_api.g_ret_sts_success;

695: RETURN;
696: END IF;
697: END LOOP;
698:
699: x_return_status := fnd_api.g_ret_sts_success;
700:
701: END create_bus_class;
702:
703: PROCEDURE create_product_service

Line 729: x_return_status <> fnd_api.g_ret_sts_success THEN

725: x_msg_count => x_msg_count,
726: x_msg_data => x_msg_data
727: );
728: IF x_return_status IS NULL OR
729: x_return_status <> fnd_api.g_ret_sts_success THEN
730: RETURN;
731: END IF;
732: END LOOP;
733:

Line 734: x_return_status := fnd_api.g_ret_sts_success;

730: RETURN;
731: END IF;
732: END LOOP;
733:
734: x_return_status := fnd_api.g_ret_sts_success;
735:
736: END create_product_service;
737:
738: PROCEDURE get_reg_primary_user

Line 790: x_return_status <> fnd_api.g_ret_sts_success THEN

786: x_itemkey => l_itemkey,
787: x_receiver => l_receiver
788: ) ;
789: IF x_return_status IS NULL OR
790: x_return_status <> fnd_api.g_ret_sts_success THEN
791: RETURN;
792: END IF;
793: END IF;
794: x_return_status := fnd_api.g_ret_sts_success;

Line 794: x_return_status := fnd_api.g_ret_sts_success;

790: x_return_status <> fnd_api.g_ret_sts_success THEN
791: RETURN;
792: END IF;
793: END IF;
794: x_return_status := fnd_api.g_ret_sts_success;
795:
796: EXCEPTION
797: WHEN OTHERS THEN
798: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 798: x_return_status := fnd_api.g_ret_sts_unexp_error;

794: x_return_status := fnd_api.g_ret_sts_success;
795:
796: EXCEPTION
797: WHEN OTHERS THEN
798: x_return_status := fnd_api.g_ret_sts_unexp_error;
799: x_msg_count := 1;
800: x_msg_data := Sqlerrm;
801:
802: END notify_banking_approver;

Line 824: x_return_status := fnd_api.g_ret_sts_error;

820: x_user_name => l_user_name,
821: x_user_id => l_user_id
822: );
823: IF l_user_name IS NULL THEN
824: x_return_status := fnd_api.g_ret_sts_error;
825: x_msg_count := 1;
826: x_msg_data := 'can not find the primary supplier user';
827: RETURN;
828: END IF;

Line 869: x_return_status := fnd_api.g_ret_sts_success;

865: end if;
866: END IF;
867: END LOOP;
868:
869: x_return_status := fnd_api.g_ret_sts_success;
870:
871: EXCEPTION
872: WHEN OTHERS THEN
873: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 873: x_return_status := fnd_api.g_ret_sts_unexp_error;

869: x_return_status := fnd_api.g_ret_sts_success;
870:
871: EXCEPTION
872: WHEN OTHERS THEN
873: x_return_status := fnd_api.g_ret_sts_unexp_error;
874: x_msg_count := 1;
875: x_msg_data := Sqlerrm;
876:
877: END notify_supplier_approved;

Line 960: x_return_status := fnd_api.g_ret_sts_success;

956: AND data_level_id = l_supp_addr_level_id;
957:
958: END LOOP;
959:
960: x_return_status := fnd_api.g_ret_sts_success;
961:
962: EXCEPTION
963: WHEN OTHERS THEN
964: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 964: x_return_status := fnd_api.g_ret_sts_unexp_error;

960: x_return_status := fnd_api.g_ret_sts_success;
961:
962: EXCEPTION
963: WHEN OTHERS THEN
964: x_return_status := fnd_api.g_ret_sts_unexp_error;
965: x_msg_count := 1;
966: x_msg_data := SQLERRM;
967:
968: END update_supplier_reg_uda;

Line 1001: x_return_status := fnd_api.g_ret_sts_error;

997: SAVEPOINT approve_supplier_reg;
998:
999: l_method := 'approve_supplier';
1000:
1001: x_return_status := fnd_api.g_ret_sts_error;
1002:
1003: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1004: fnd_log.string
1005: (fnd_log.level_procedure

Line 1027: AND x_return_status = fnd_api.g_ret_sts_success) THEN

1023: x_supplier_reg_rec => l_supplier_reg_rec
1024: );
1025:
1026: IF NOT (x_return_status IS NOT NULL
1027: AND x_return_status = fnd_api.g_ret_sts_success) THEN
1028: ROLLBACK TO approve_supplier_reg;
1029: RETURN;
1030: END IF;
1031:

Line 1043: x_return_status := fnd_api.g_ret_sts_error;

1039:
1040: IF l_supplier_reg_rec.registration_status IS NULL OR
1041: l_supplier_reg_rec.registration_status NOT IN ('PENDING_APPROVAL','RIF_SUPPLIER')
1042: THEN
1043: x_return_status := fnd_api.g_ret_sts_error;
1044: fnd_message.set_name('POS','POS_SUPPLIER_REG_NOT_PENDING');
1045: fnd_msg_pub.ADD;
1046: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1047:

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

1042: THEN
1043: x_return_status := fnd_api.g_ret_sts_error;
1044: fnd_message.set_name('POS','POS_SUPPLIER_REG_NOT_PENDING');
1045: fnd_msg_pub.ADD;
1046: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1047:
1048: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
1049: fnd_log.string
1050: (fnd_log.level_error

Line 1077: AND x_return_status = fnd_api.g_ret_sts_success) THEN

1073: x_party_id => l_vendor_party_id
1074: );
1075:
1076: IF NOT (x_return_status IS NOT NULL
1077: AND x_return_status = fnd_api.g_ret_sts_success) THEN
1078: ROLLBACK TO approve_supplier_reg;
1079: RETURN;
1080: END IF;
1081:

Line 1159: OR x_return_status <> fnd_api.g_ret_sts_success THEN

1155: p_registration_type_code => l_supplier_reg_rec.tax_reg_type,
1156: p_country_code => l_supplier_reg_rec.tax_reg_country_code
1157: );
1158: IF x_return_status IS NULL
1159: OR x_return_status <> fnd_api.g_ret_sts_success THEN
1160: ROLLBACK TO approve_supplier_reg;
1161: x_msg_count := 1;
1162: x_msg_data := 'call to zx_party_tax_profile_pkg.update_row failed';
1163: RETURN;

Line 1178: OR x_return_status <> fnd_api.g_ret_sts_success THEN

1174: x_msg_data => x_msg_data
1175: );
1176:
1177: IF x_return_status IS NULL
1178: OR x_return_status <> fnd_api.g_ret_sts_success THEN
1179: ROLLBACK TO approve_supplier_reg;
1180: RETURN;
1181: END IF;
1182:

Line 1200: AND x_return_status = fnd_api.g_ret_sts_success) THEN

1196: x_username_pwds => l_username_pwds
1197: );
1198:
1199: IF NOT (x_return_status IS NOT NULL
1200: AND x_return_status = fnd_api.g_ret_sts_success) THEN
1201: ROLLBACK TO approve_supplier_reg;
1202: RETURN;
1203: END IF;
1204:

Line 1221: AND x_return_status = fnd_api.g_ret_sts_success) THEN

1217: x_msg_data => x_msg_data
1218: );
1219:
1220: IF NOT (x_return_status IS NOT NULL
1221: AND x_return_status = fnd_api.g_ret_sts_success) THEN
1222: ROLLBACK TO approve_supplier_reg;
1223: RETURN;
1224: END IF;
1225:

Line 1242: AND x_return_status = fnd_api.g_ret_sts_success) THEN

1238: x_msg_data => x_msg_data
1239: );
1240:
1241: IF NOT (x_return_status IS NOT NULL
1242: AND x_return_status = fnd_api.g_ret_sts_success) THEN
1243: ROLLBACK TO approve_supplier_reg;
1244: RETURN;
1245: END IF;
1246:

Line 1274: AND x_return_status = fnd_api.g_ret_sts_success) THEN

1270: x_msg_data => x_msg_data
1271: );
1272:
1273: IF NOT (x_return_status IS NOT NULL
1274: AND x_return_status = fnd_api.g_ret_sts_success) THEN
1275: ROLLBACK TO approve_supplier_reg;
1276: RETURN;
1277: END IF;
1278:

Line 1320: AND x_return_status = fnd_api.g_ret_sts_success) THEN

1316: p_user_id => l_user_id
1317: );
1318:
1319: IF NOT (x_return_status IS NOT NULL
1320: AND x_return_status = fnd_api.g_ret_sts_success) THEN
1321: ROLLBACK TO approve_supplier_reg;
1322: RETURN;
1323: END IF;
1324:

Line 1335: AND x_return_status = fnd_api.g_ret_sts_success) THEN

1331: x_msg_data => x_msg_data
1332: );
1333:
1334: IF NOT (x_return_status IS NOT NULL
1335: AND x_return_status = fnd_api.g_ret_sts_success) THEN
1336: ROLLBACK TO approve_supplier_reg;
1337: RETURN;
1338: END IF;
1339:

Line 1345: AND x_return_status = fnd_api.g_ret_sts_success) THEN

1341: PON_ATTR_MAPPING.Sync_User_Attrs_Data(NULL, l_vendor_id, x_return_status, x_msg_data);
1342: END IF;
1343:
1344: IF NOT (x_return_status IS NOT NULL
1345: AND x_return_status = fnd_api.g_ret_sts_success) THEN
1346: ROLLBACK TO approve_supplier_reg;
1347: RETURN;
1348: END IF;
1349: -- End Supplier Hub: Supplier Management

Line 1351: x_return_status := fnd_api.g_ret_sts_success;

1347: RETURN;
1348: END IF;
1349: -- End Supplier Hub: Supplier Management
1350:
1351: x_return_status := fnd_api.g_ret_sts_success;
1352: x_msg_count := 0;
1353: x_msg_data := NULL;
1354:
1355: EXCEPTION

Line 1402: AND x_return_status = fnd_api.g_ret_sts_success) THEN

1398: x_supplier_reg_rec => l_supplier_reg_rec
1399: );
1400:
1401: IF NOT (x_return_status IS NOT NULL
1402: AND x_return_status = fnd_api.g_ret_sts_success) THEN
1403: RETURN;
1404: END IF;
1405:
1406: l_step := 'check reg status';

Line 1416: x_return_status := fnd_api.g_ret_sts_error;

1412: END IF;
1413:
1414: IF l_supplier_reg_rec.registration_status IS NULL OR
1415: l_supplier_reg_rec.registration_status <> 'PENDING_APPROVAL' THEN
1416: x_return_status := fnd_api.g_ret_sts_error;
1417: fnd_message.set_name('POS','POS_SUPPLIER_REG_NOT_PENDING');
1418: fnd_msg_pub.ADD;
1419: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1420:

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

1415: l_supplier_reg_rec.registration_status <> 'PENDING_APPROVAL' THEN
1416: x_return_status := fnd_api.g_ret_sts_error;
1417: fnd_message.set_name('POS','POS_SUPPLIER_REG_NOT_PENDING');
1418: fnd_msg_pub.ADD;
1419: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1420:
1421: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
1422: fnd_log.string
1423: (fnd_log.level_error

Line 1515: x_return_status := fnd_api.g_ret_sts_success;

1511: x_itemkey => l_itemkey,
1512: x_receiver => l_receiver
1513: );
1514:
1515: x_return_status := fnd_api.g_ret_sts_success;
1516: x_msg_count := 0;
1517: x_msg_data := NULL;
1518: /* Begin Supplier Hub - Supplier Data Publication */
1519: /* Raise Supplier User Creation event */

Line 1555: OR x_return_status <> fnd_api.g_ret_sts_success THEN

1551: x_supplier_reg_rec => l_supplier_reg_rec
1552: );
1553:
1554: IF x_return_status IS NULL
1555: OR x_return_status <> fnd_api.g_ret_sts_success THEN
1556: RETURN;
1557: END IF;
1558:
1559: l_step := 'check reg status';

Line 1571: x_return_status := fnd_api.g_ret_sts_error;

1567: IF l_supplier_reg_rec.registration_status IS NULL OR
1568: (l_supplier_reg_rec.registration_status <> 'DRAFT' AND
1569: l_supplier_reg_rec.registration_status <> 'RIF_SUPPLIER')
1570: THEN
1571: x_return_status := fnd_api.g_ret_sts_error;
1572: fnd_message.set_name('POS','POS_SUPPLIER_REG_NOT_DRAFT');
1573: fnd_msg_pub.ADD;
1574: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1575:

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

1570: THEN
1571: x_return_status := fnd_api.g_ret_sts_error;
1572: fnd_message.set_name('POS','POS_SUPPLIER_REG_NOT_DRAFT');
1573: fnd_msg_pub.ADD;
1574: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1575:
1576: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
1577: fnd_log.string
1578: (fnd_log.level_error

Line 1593: x_return_status := fnd_api.g_ret_sts_success;

1589: last_updated_by = fnd_global.user_id,
1590: last_update_login = fnd_global.login_id
1591: WHERE supplier_reg_id = p_supplier_reg_id;
1592:
1593: x_return_status := fnd_api.g_ret_sts_success;
1594: x_msg_count := 0;
1595: x_msg_data := NULL;
1596:
1597: END submit_supplier_reg;

Line 1611: x_return_status := fnd_api.g_ret_sts_success;

1607:
1608: pos_spm_wf_pkg1.send_supplier_reg_saved_ntf
1609: (p_supplier_reg_id => p_supplier_reg_id);
1610:
1611: x_return_status := fnd_api.g_ret_sts_success;
1612: x_msg_count := 0;
1613: x_msg_data := NULL;
1614:
1615: END send_save_for_later_ntf;

Line 2214: x_return_status := FND_API.G_RET_STS_SUCCESS;

2210: );
2211:
2212: BEGIN
2213:
2214: x_return_status := FND_API.G_RET_STS_SUCCESS;
2215:
2216:
2217: l_object_id := EGO_EXT_FWK_PUB.Get_Object_Id_From_Name('HZ_PARTIES');
2218:

Line 2363: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2359: x_msg_count => x_msg_count,
2360: x_msg_data => x_msg_data
2361: );
2362:
2363: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2364: RETURN;
2365: END IF;
2366:
2367: -- If attribute has value, add an entry in l_has_value_tbl

Line 2421: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2417: END LOOP;
2418:
2419: EXCEPTION
2420: WHEN OTHERS THEN
2421: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2422: x_msg_data := SQLERRM;
2423:
2424: END validate_required_user_attrs;
2425: -- End Supplier Management: Bug 12849540