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 ITG_MSG

Line 107: itg_msg.no_vendor_site(p_vendorsite_id);

103: itg_debug_pub.add('Exiting get_vendorsite_rec normal');
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);

Line 187: itg_msg.vendor_not_found(p_vendor_id);

183: itg_debug_pub.add('Exiting get_vendor_rec normal');
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);

Line 251: itg_msg.invalid_org(p_org);

247: itg_debug_pub.Add(g_action,1);
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

Line 263: ITG_MSG.missing_element_value(l_param_name, l_param_value);

259: l_param_name := 'NAME';
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

Line 281: ITG_MSG.missing_element_value('PAYMETHOD', p_paymethod);

277: WHERE upper(lookup_code) = upper(p_paymethod)
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:

Line 298: ITG_MSG.missing_element_value('TERMID', p_termid);

294: FROM ap_terms
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;

Line 308: ITG_MSG.missing_element_value('ONETIME', p_onetime);

304: BEGIN
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

Line 319: itg_msg.dup_vendor;

315: from ap_vendors_v
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:

Line 332: ITG_MSG.missing_element_value('CURRENCY', p_currency);

328: from fnd_currencies
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:

Line 343: ITG_MSG.missing_element_value('ORGID', p_org);

339: from HR_ALL_ORGANIZATION_UNITS
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

Line 355: itg_msg.sup_number_exists(p_partnerid);

351: where nvl(vendor_number,'@@') = nvl(to_char(p_partnerid),'@@')
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

Line 469: itg_msg.apicallret('AP_Apxvdmvd_PKG.Initialize','U',substr((SQLCODE || SQLERRM),1,200));

465: WHEN OTHERS THEN
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:

Line 540: itg_msg.invalid_org(p_org);

536: BEGIN
537: MO_GLOBAL.set_policy_context('S', p_org); -- MOAC
538: EXCEPTION
539: WHEN OTHERS THEN
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;

Line 648: itg_msg.apicallret('Ap_vendor_pub_pkg.Create_Vendor',l_ret_status,substr(l_ret_msg,1,200));

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));
649: RAISE FND_API.G_EXC_ERROR;
650: END IF;
651:
652: g_action := 'verifying vendor_number';

Line 698: itg_msg.vendor_not_found(p_name);

694: itg_debug_pub.Add('x_vinfo_rec.vendor_id - '|| x_vinfo_rec.vendor_id,1);
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:

Line 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));

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));
816: RAISE FND_API.G_EXC_ERROR;
817: END IF;
818:
819:

Line 836: ITG_msg.checked_error(g_action);

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;
840:

Line 846: ITG_msg.unexpected_error(g_action);

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);
849: END IF;
850:

Line 889: itg_msg.missing_element_value('COUNTRY',p_country);

885: WHERE TERRITORY_CODE = p_country
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:

Line 914: itg_msg.missing_element_value(l_element,l_value);

910: l_value := 'null';
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(*)

Line 924: ITG_MSG.missing_element_value('ORGID', p_org);

920: from HR_ALL_ORGANIZATION_UNITS
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;

Line 1063: itg_msg.vendor_not_found('vendorid:' ||p_vinfo_rec.vendor_id);

1059: WHEN NO_DATA_FOUND THEN
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:

Line 1331: itg_msg.apicallret(l_api_name, l_return_status, l_ret_msg);

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;
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

Line 1350: ITG_msg.checked_error(g_action);

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);
1354: END IF;

Line 1351: itg_msg.vendor_site_only;

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);
1354: END IF;
1355:

Line 1360: ITG_msg.unexpected_error(g_action);

1356:
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

Line 1362: itg_msg.vendor_site_only;

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);
1366: END IF;

Line 1437: itg_msg.no_vendor_site('vendor-sitecode:' || p_site_code);

1433: itg_debug_pub.Add('Getting vendor site ID - ' || l_vsite_id ,1);
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

Line 1510: itg_msg.apicallret('Ap_vendor_pub_pkg.Create_Vendor_Contact',l_ret_status,l_msg_data);

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
1514: g_action := 'Vendor-contact record update';

Line 1541: itg_msg.apicallret('HZ_PARTY_V2PUB.update_person',l_ret_status,l_msg_data);

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:
1545: END IF;

Line 1563: ITG_msg.checked_error(g_action);

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);
1567: END IF;

Line 1564: itg_msg.vendor_contact_only;

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);
1567: END IF;
1568:

Line 1574: ITG_msg.unexpected_error(g_action);

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
1578: itg_debug_pub.Add('EXTING - Sync_VendorContact :OTHER ERROR', 6);

Line 1575: itg_msg.vendor_contact_only;

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
1578: itg_debug_pub.Add('EXTING - Sync_VendorContact :OTHER ERROR', 6);
1579: END IF;