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.

[Home] [Help]

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 470: RAISE FND_API.G_EXC_ERROR;

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

Line 512: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 544: RAISE FND_API.G_EXC_ERROR;

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

Line 644: IF l_ret_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 649: RAISE FND_API.G_EXC_ERROR;

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

Line 666: RAISE FND_API.G_EXC_ERROR;

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

Line 699: RAISE FND_API.G_EXC_ERROR;

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

Line 793: RAISE FND_API.G_EXC_ERROR;

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

Line 800: p_init_msg_list => FND_API.G_FALSE,

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

Line 811: IF l_ret_status <> FND_API.G_RET_STS_SUCCESS THEN

807: );
808:
809:
810:
811: IF l_ret_status <> FND_API.G_RET_STS_SUCCESS THEN
812: IF l_debug_level <= 6 THEN
813: itg_debug_pub.add('Error occured in update Vendor or update organization',6);
814: END IF;
815: 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 816: RAISE FND_API.G_EXC_ERROR;

812: IF l_debug_level <= 6 THEN
813: itg_debug_pub.add('Error occured in update Vendor or update organization',6);
814: END IF;
815: 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));
816: RAISE FND_API.G_EXC_ERROR;
817: END IF;
818:
819:
820: END IF;

Line 832: WHEN FND_API.G_EXC_ERROR THEN

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

Line 835: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 844: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 890: RAISE FND_API.G_EXC_ERROR;

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

Line 915: RAISE FND_API.G_EXC_ERROR;

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

Line 925: RAISE FND_API.G_EXC_ERROR;

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

Line 998: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 1064: RAISE FND_API.G_EXC_ERROR;

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

Line 1267: RAISE FND_API.G_EXC_ERROR;

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

Line 1286: RAISE FND_API.G_EXC_ERROR;

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

Line 1310: p_init_msg_list => FND_API.G_FALSE,

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

Line 1326: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 1332: RAISE FND_API.G_EXC_ERROR;

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

Line 1346: WHEN FND_API.G_EXC_ERROR THEN

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

Line 1349: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1405: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 1438: RAISE FND_API.G_EXC_ERROR;

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

Line 1509: IF l_ret_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 1511: RAISE FND_API.G_EXC_ERROR;

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

Line 1540: IF l_ret_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 1542: RAISE FND_API.G_EXC_ERROR;

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

Line 1559: WHEN FND_API.G_EXC_ERROR THEN

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

Line 1562: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1573: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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