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.ITG_SYNCSUPPLIERINBOUND_PVT dependencies on FND_API

Line 108: RAISE FND_API.G_EXC_ERROR;

104: END IF;
105: EXCEPTION
106: WHEN NO_DATA_FOUND THEN
107: itg_msg.no_vendor_site(p_vendorsite_id);
108: RAISE FND_API.G_EXC_ERROR;
109: WHEN OTHERS THEN
110: IF l_debug_level <= 1 THEN
111: itg_debug_pub.add('Error in get_vendorsite_rec ' || SQLCODE || ' - ' || SQLERRM,1);
112: END IF;

Line 188: RAISE FND_API.G_EXC_ERROR;

184: END IF;
185: EXCEPTION
186: WHEN NO_DATA_FOUND THEN
187: itg_msg.vendor_not_found(p_vendor_id);
188: RAISE FND_API.G_EXC_ERROR;
189: WHEN OTHERS THEN
190: IF l_debug_level <= 1 THEN
191: itg_debug_pub.add('Error in get_vendor_rec ' || SQLCODE || ' - ' || SQLERRM,1);
192: END IF;

Line 252: RAISE FND_API.G_EXC_ERROR;

248: END IF;
249:
250: IF p_org IS NULL THEN -- MOAC
251: itg_msg.invalid_org(p_org);
252: RAISE FND_API.G_EXC_ERROR;
253: END IF;
254:
255: IF NVL(UPPER(p_syncind), 'z') NOT IN ('A', 'C', 'D') THEN
256: l_param_name := 'SYNCIND';

Line 264: RAISE FND_API.G_EXC_ERROR;

260: END IF;
261:
262: IF l_param_name IS NOT NULL THEN
263: ITG_MSG.missing_element_value(l_param_name, l_param_value);
264: RAISE FND_API.G_EXC_ERROR;
265: END IF;
266:
267: IF p_paymethod IS NOT NULL THEN
268: IF (l_Debug_Level <= 1) THEN

Line 282: RAISE FND_API.G_EXC_ERROR;

278: AND lookup_type = 'PAYMENT METHOD';
279: EXCEPTION
280: WHEN NO_DATA_FOUND THEN
281: ITG_MSG.missing_element_value('PAYMETHOD', p_paymethod);
282: RAISE FND_API.G_EXC_ERROR;
283: END;
284: END IF;
285:
286: IF p_termid IS NOT NULL THEN

Line 299: RAISE FND_API.G_EXC_ERROR;

295: WHERE upper(name) = upper(p_termid);
296: EXCEPTION
297: WHEN OTHERs THEN
298: ITG_MSG.missing_element_value('TERMID', p_termid);
299: RAISE FND_API.G_EXC_ERROR;
300: END;
301:
302: END IF;
303:

Line 309: RAISE FND_API.G_EXC_ERROR;

305: l_var := to_number(p_onetime);
306: EXCEPTION
307: WHEN OTHERS THEN
308: ITG_MSG.missing_element_value('ONETIME', p_onetime);
309: RAISE FND_API.G_EXC_ERROR;
310: END;
311:
312: IF UPPER(p_syncind) = 'A' THEN
313: select count(*)

Line 320: RAISE FND_API.G_EXC_ERROR;

316: Where upper(vendor_name) = upper(p_name);
317:
318: IF to_number(l_var) > 0 THEN
319: itg_msg.dup_vendor;
320: RAISE FND_API.G_EXC_ERROR;
321: END IF;
322: END IF;
323:
324: IF p_currency IS NOT NULL THEN

Line 333: RAISE FND_API.G_EXC_ERROR;

329: where currency_code = nvl(p_currency,'USD');
330:
331: IF to_number(l_var) = 0 THEN
332: ITG_MSG.missing_element_value('CURRENCY', p_currency);
333: RAISE FND_API.G_EXC_ERROR;
334: END IF;
335: END IF;
336:
337: select count(*)

Line 344: RAISE FND_API.G_EXC_ERROR;

340: where organization_id = p_org;
341:
342: IF to_number(l_var) = 0 THEN
343: ITG_MSG.missing_element_value('ORGID', p_org);
344: RAISE FND_API.G_EXC_ERROR;
345: END IF;
346:
347: -- change
348: select count(*)

Line 356: RAISE FND_API.G_EXC_ERROR;

352: and nvl(upper(p_name),'@@') <> nvl(Upper(vendor_name),'@@');
353:
354: IF to_number(l_var) > 0 THEN
355: itg_msg.sup_number_exists(p_partnerid);
356: RAISE FND_API.G_EXC_ERROR;
357: END IF;
358:
359: IF (l_Debug_Level <= 1) THEN
360: itg_debug_pub.Add('Validation complete', 1);

Line 468: RAISE FND_API.G_EXC_ERROR;

464: IF l_debug_level <= 1 THEN
465: itg_debug_pub.add('Error in default_vendor_params ' || SQLCODE || ' - ' || SQLERRM,1);
466: END IF;
467: itg_msg.apicallret('AP_Apxvdmvd_PKG.Initialize','U',substr((SQLCODE || SQLERRM),1,200));
468: RAISE FND_API.G_EXC_ERROR;
469: END;
470:
471:
472:

Line 510: x_return_status := FND_API.G_RET_STS_SUCCESS;

506: l_num_1099 varchar2(200);
507: l_org varchar2(20);
508: l_override_vendornum NUMBER;
509: BEGIN
510: x_return_status := FND_API.G_RET_STS_SUCCESS;
511: g_action := 'Supplier synchronization';
512: SAVEPOINT Sync_Vendor_PVT;
513:
514: -- now in wrapperFND_MSG_PUB.Initialize;

Line 542: RAISE FND_API.G_EXC_ERROR;

538: itg_msg.invalid_org(p_org);
539: IF l_debug_level <= 6 THEN
540: itg_debug_pub.Add('MO_GLOBAL.set_policy_context ' || SQLCODE || ' - ' || SQLERRM,6);
541: END IF;
542: RAISE FND_API.G_EXC_ERROR;
543: END;
544:
545: IF l_debug_level <= 1 THEN
546: itg_debug_pub.add('Before sync vendor, parameter validation ',1);

Line 642: IF l_ret_status <> FND_API.G_RET_STS_SUCCESS THEN

638: itg_debug_pub.add('Create vendor returns - ' || l_ret_status || ' - ' || l_ret_msg ,1);
639: ITG_Debug_pub.add('SV - vendor_id ' || r_vendor_rec.vendor_id,1);
640: END IF;
641:
642: IF l_ret_status <> FND_API.G_RET_STS_SUCCESS THEN
643: IF l_debug_level <= 6 THEN
644: itg_debug_pub.add('Error occured in Create Vendor',6);
645: END IF;
646: itg_msg.apicallret('Ap_vendor_pub_pkg.Create_Vendor',l_ret_status,substr(l_ret_msg,1,200));

Line 647: RAISE FND_API.G_EXC_ERROR;

643: IF l_debug_level <= 6 THEN
644: itg_debug_pub.add('Error occured in Create Vendor',6);
645: END IF;
646: itg_msg.apicallret('Ap_vendor_pub_pkg.Create_Vendor',l_ret_status,substr(l_ret_msg,1,200));
647: RAISE FND_API.G_EXC_ERROR;
648: END IF;
649:
650: g_action := 'verifying vendor_number';
651: BEGIN

Line 664: RAISE FND_API.G_EXC_ERROR;

660: WHEN OTHERS THEN
661: IF l_debug_level <= 6 THEN
662: itg_debug_pub.add('Error occured while retrieving vendor_number',6);
663: END IF;
664: RAISE FND_API.G_EXC_ERROR;
665: END;
666:
667: itg_debug_pub.Add('SV - p_partnerid '||p_partnerid ,1);
668:

Line 697: RAISE FND_API.G_EXC_ERROR;

693: END IF;
694: EXCEPTION
695: WHEN NO_DATA_FOUND THEN
696: itg_msg.vendor_not_found(p_name);
697: RAISE FND_API.G_EXC_ERROR;
698: END;
699: END IF; -- syncind conidition block ends
700:
701:

Line 791: RAISE FND_API.G_EXC_ERROR;

787: WHEN NO_DATA_FOUND THEN
788: IF (l_Debug_Level <= 1) THEN
789: itg_debug_pub.Add('Couldn''t find party_id from ap_suppliers or obj_ver,party_num,duns_num from hz_parties ');
790: END IF;
791: RAISE FND_API.G_EXC_ERROR;
792: END;
793:
794: l_org_rec.duns_number_c := NVL(p_dunsnumber ,l_duns_number);
795: l_org_rec.party_rec.party_number :=l_party_number;

Line 798: p_init_msg_list => FND_API.G_FALSE,

794: l_org_rec.duns_number_c := NVL(p_dunsnumber ,l_duns_number);
795: l_org_rec.party_rec.party_number :=l_party_number;
796: l_org_rec.party_rec.party_id := l_party_id;
797: HZ_PARTY_V2PUB.update_organization (
798: p_init_msg_list => FND_API.G_FALSE,
799: p_organization_rec => l_org_rec,
800: p_party_object_version_number => l_party_object_version_number,
801: x_profile_id => l_party_id,
802: x_return_status => l_ret_status,

Line 809: IF l_ret_status <> FND_API.G_RET_STS_SUCCESS THEN

805: );
806:
807:
808:
809: IF l_ret_status <> FND_API.G_RET_STS_SUCCESS THEN
810: IF l_debug_level <= 6 THEN
811: itg_debug_pub.add('Error occured in update Vendor or update organization',6);
812: END IF;
813: itg_msg.apicallret('ap_vendor_pub_pkg.Update_vendor or hz_party_v2pub.update_organization returns-',l_ret_status,substr(l_ret_msg,1,200));

Line 814: RAISE FND_API.G_EXC_ERROR;

810: IF l_debug_level <= 6 THEN
811: itg_debug_pub.add('Error occured in update Vendor or update organization',6);
812: END IF;
813: itg_msg.apicallret('ap_vendor_pub_pkg.Update_vendor or hz_party_v2pub.update_organization returns-',l_ret_status,substr(l_ret_msg,1,200));
814: RAISE FND_API.G_EXC_ERROR;
815: END IF;
816:
817:
818: END IF;

Line 830: WHEN FND_API.G_EXC_ERROR THEN

826: IF (l_Debug_Level <= 2) THEN
827: itg_debug_pub.Add('EXITING - Sync_Vendor.', 2);
828: END IF;
829: EXCEPTION
830: WHEN FND_API.G_EXC_ERROR THEN
831: ROLLBACK TO Sync_Vendor_PVT;
832: COMMIT;
833: x_return_status := FND_API.G_RET_STS_ERROR;
834: ITG_msg.checked_error(g_action);

Line 833: x_return_status := FND_API.G_RET_STS_ERROR;

829: EXCEPTION
830: WHEN FND_API.G_EXC_ERROR THEN
831: ROLLBACK TO Sync_Vendor_PVT;
832: COMMIT;
833: x_return_status := FND_API.G_RET_STS_ERROR;
834: ITG_msg.checked_error(g_action);
835: IF (l_Debug_Level <= 6) THEN
836: itg_debug_pub.Add('EXITING - Sync_Vendor:: ERROR', 6);
837: END IF;

Line 842: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

838:
839: WHEN OTHERS THEN
840: ROLLBACK TO Sync_Vendor_PVT;
841: COMMIT;
842: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
843: itg_debug.msg('Unexpected error (Vendor sync) - ' || substr(SQLERRM,1,255),true);
844: ITG_msg.unexpected_error(g_action);
845: IF (l_Debug_Level <= 6) THEN
846: itg_debug_pub.Add('EXITING - Sync_Vendor:: ERROR', 6);

Line 888: RAISE FND_API.G_EXC_ERROR;

884: AND OBSOLETE_FLAG = 'N';
885: EXCEPTION
886: WHEN OTHERS THEN
887: itg_msg.missing_element_value('COUNTRY',p_country);
888: RAISE FND_API.G_EXC_ERROR;
889:
890: END;
891:
892: l_element := null;

Line 913: RAISE FND_API.G_EXC_ERROR;

909: END IF;
910:
911: IF l_element IS NOT NULL THEN
912: itg_msg.missing_element_value(l_element,l_value);
913: RAISE FND_API.G_EXC_ERROR;
914: END IF;
915:
916: select count(*)
917: into l_var

Line 923: RAISE FND_API.G_EXC_ERROR;

919: where organization_id = p_org;
920:
921: IF to_number(l_var) = 0 THEN
922: ITG_MSG.missing_element_value('ORGID', p_org);
923: RAISE FND_API.G_EXC_ERROR;
924: END IF;
925:
926: END;
927:

Line 996: x_return_status := FND_API.G_RET_STS_SUCCESS;

992: FROM financials_system_params_all
993: WHERE set_of_books_id = p_sob_id;
994:
995: BEGIN
996: x_return_status := FND_API.G_RET_STS_SUCCESS;
997: g_action := 'Vendor-site sync';
998:
999: SAVEPOINT Sync_VendorSite_PVT;
1000:

Line 1062: RAISE FND_API.G_EXC_ERROR;

1058: IF (l_Debug_Level <= 1) THEN
1059: itg_debug_pub.Add('Vendor not found - erroring out' ,1);
1060: END IF;
1061: itg_msg.vendor_not_found('vendorid:' ||p_vinfo_rec.vendor_id);
1062: RAISE FND_API.G_EXC_ERROR;
1063: END;
1064:
1065:
1066: g_action := 'check for vendor site';

Line 1265: RAISE FND_API.G_EXC_ERROR;

1261: WHEN NO_DATA_FOUND THEN
1262: IF (l_Debug_Level <= 1) THEN
1263: itg_debug_pub.Add('Couldn''t find location_id ');
1264: END IF;
1265: RAISE FND_API.G_EXC_ERROR;
1266: END;
1267:
1268:
1269: BEGIN

Line 1284: RAISE FND_API.G_EXC_ERROR;

1280: WHEN NO_DATA_FOUND THEN
1281: IF (l_Debug_Level <= 1) THEN
1282: itg_debug_pub.Add('Couldn''t find object_version_number');
1283: END IF;
1284: RAISE FND_API.G_EXC_ERROR;
1285:
1286: END;
1287:
1288: p_location_rec.orig_system_reference := '';

Line 1308: p_init_msg_list => FND_API.G_FALSE,

1304: END IF;
1305: l_api_name := 'hz_location_v2pub.update_location';
1306: hz_location_v2pub.update_location
1307: (
1308: p_init_msg_list => FND_API.G_FALSE,
1309: p_location_rec => p_location_rec,
1310: p_object_version_number => p_object_version_number,
1311: x_return_status => l_return_status,
1312: x_msg_count => l_msg_count,

Line 1324: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1320: itg_debug_pub.add('l_ret_msg ' || l_ret_msg);
1321: End if;
1322: END IF;
1323:
1324: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1325:
1326: IF (l_Debug_Level <= 1) THEN
1327: itg_debug_pub.add('Create/Update_vendor_site/update_location API returns - ' || l_return_status || ' - ' || l_ret_msg);
1328: END IF;

Line 1330: RAISE FND_API.G_EXC_ERROR;

1326: IF (l_Debug_Level <= 1) THEN
1327: itg_debug_pub.add('Create/Update_vendor_site/update_location API returns - ' || l_return_status || ' - ' || l_ret_msg);
1328: END IF;
1329: itg_msg.apicallret(l_api_name, l_return_status, l_ret_msg);
1330: RAISE FND_API.G_EXC_ERROR;
1331: END IF;
1332:
1333: IF (l_Debug_Level <= 1) THEN
1334: itg_debug_pub.Add('Commiting work',1);

Line 1344: WHEN FND_API.G_EXC_ERROR THEN

1340: itg_debug_pub.Add('EXITING - Sync_VendorSite.', 2);
1341: END IF;
1342:
1343: EXCEPTION
1344: WHEN FND_API.G_EXC_ERROR THEN
1345: ROLLBACK TO Sync_VendorSite_PVT;
1346: commit;
1347: x_return_status := FND_API.G_RET_STS_ERROR;
1348: ITG_msg.checked_error(g_action);

Line 1347: x_return_status := FND_API.G_RET_STS_ERROR;

1343: EXCEPTION
1344: WHEN FND_API.G_EXC_ERROR THEN
1345: ROLLBACK TO Sync_VendorSite_PVT;
1346: commit;
1347: x_return_status := FND_API.G_RET_STS_ERROR;
1348: ITG_msg.checked_error(g_action);
1349: itg_msg.vendor_site_only;
1350: IF (l_Debug_Level <= 6) THEN
1351: itg_debug_pub.Add('EXITING - Sync_VendorSite :ERROR', 6);

Line 1359: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1355: WHEN OTHERS THEN
1356: ROLLBACK TO Sync_VendorSite_PVT;
1357: commit;
1358: ITG_msg.unexpected_error(g_action);
1359: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1360: itg_msg.vendor_site_only;
1361: itg_debug.msg('Unexpected error (VendorSite sync) - ' || substr(SQLERRM,1,255),true);
1362: IF (l_Debug_Level <= 6) THEN
1363: itg_debug_pub.Add('EXITING - Sync_VendorSite :ERROR', 6);

Line 1403: x_return_status := FND_API.G_RET_STS_SUCCESS;

1399: l_profile_id NUMBER;
1400: l_party_rec HZ_PARTY_V2PUB.party_rec_type;
1401: l_per_rec HZ_PARTY_V2PUB.person_rec_type;
1402: BEGIN
1403: x_return_status := FND_API.G_RET_STS_SUCCESS;
1404: g_action := 'Vendor-contact parameter validation';
1405:
1406: IF (l_Debug_Level <= 2) THEN
1407: itg_debug_pub.Add('ENTERING - Sync_VendorContact', 2);

Line 1436: RAISE FND_API.G_EXC_ERROR;

1432: END IF;
1433: EXCEPTION
1434: WHEN NO_DATA_FOUND THEN
1435: itg_msg.no_vendor_site('vendor-sitecode:' || p_site_code);
1436: RAISE FND_API.G_EXC_ERROR;
1437: END;
1438:
1439: BEGIN
1440:

Line 1507: IF l_ret_status <> FND_API.G_RET_STS_SUCCESS THEN

1503: itg_debug_pub.Add('l_org_contact_id - ' || l_org_contact_id,1 );
1504: itg_debug_pub.Add('l_party_site_id - ' || l_party_site_id,1 );
1505: END IF;
1506:
1507: IF l_ret_status <> FND_API.G_RET_STS_SUCCESS THEN
1508: itg_msg.apicallret('Ap_vendor_pub_pkg.Create_Vendor_Contact',l_ret_status,l_msg_data);
1509: RAISE FND_API.G_EXC_ERROR;
1510: END IF;
1511: ELSE

Line 1509: RAISE FND_API.G_EXC_ERROR;

1505: END IF;
1506:
1507: IF l_ret_status <> FND_API.G_RET_STS_SUCCESS THEN
1508: itg_msg.apicallret('Ap_vendor_pub_pkg.Create_Vendor_Contact',l_ret_status,l_msg_data);
1509: RAISE FND_API.G_EXC_ERROR;
1510: END IF;
1511: ELSE
1512: g_action := 'Vendor-contact record update';
1513: l_party_rec.party_id := l_party_id;

Line 1538: IF l_ret_status <> FND_API.G_RET_STS_SUCCESS THEN

1534: itg_debug_pub.Add('l_msg_count - ' || l_profile_id,1 );
1535:
1536: END IF;
1537:
1538: IF l_ret_status <> FND_API.G_RET_STS_SUCCESS THEN
1539: itg_msg.apicallret('HZ_PARTY_V2PUB.update_person',l_ret_status,l_msg_data);
1540: RAISE FND_API.G_EXC_ERROR;
1541: END IF;
1542:

Line 1540: RAISE FND_API.G_EXC_ERROR;

1536: END IF;
1537:
1538: IF l_ret_status <> FND_API.G_RET_STS_SUCCESS THEN
1539: itg_msg.apicallret('HZ_PARTY_V2PUB.update_person',l_ret_status,l_msg_data);
1540: RAISE FND_API.G_EXC_ERROR;
1541: END IF;
1542:
1543: END IF;
1544:

Line 1557: WHEN FND_API.G_EXC_ERROR THEN

1553: END IF;
1554:
1555:
1556: EXCEPTION
1557: WHEN FND_API.G_EXC_ERROR THEN
1558: ROLLBACK TO Sync_VendorContact_PVT;
1559: commit;
1560: x_return_status := FND_API.G_RET_STS_ERROR;
1561: ITG_msg.checked_error(g_action);

Line 1560: x_return_status := FND_API.G_RET_STS_ERROR;

1556: EXCEPTION
1557: WHEN FND_API.G_EXC_ERROR THEN
1558: ROLLBACK TO Sync_VendorContact_PVT;
1559: commit;
1560: x_return_status := FND_API.G_RET_STS_ERROR;
1561: ITG_msg.checked_error(g_action);
1562: itg_msg.vendor_contact_only;
1563: IF (l_Debug_Level <= 6) THEN
1564: itg_debug_pub.Add('EXTING - Sync_VendorContact :OTHER ERROR', 6);

Line 1571: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1567:
1568: WHEN OTHERS THEN
1569: ROLLBACK TO Sync_VendorContact_PVT;
1570: commit;
1571: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1572: ITG_msg.unexpected_error(g_action);
1573: itg_msg.vendor_contact_only;
1574: itg_debug.msg('Unexpected error (VendorContact sync) - ' || substr(SQLERRM,1,255),true);
1575: IF (l_Debug_Level <= 6) THEN