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 467: itg_msg.apicallret('AP_Apxvdmvd_PKG.Initialize','U',substr((SQLCODE || SQLERRM),1,200));

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

Line 538: itg_msg.invalid_org(p_org);

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

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

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

Line 696: itg_msg.vendor_not_found(p_name);

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

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

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

Line 834: ITG_msg.checked_error(g_action);

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

Line 844: ITG_msg.unexpected_error(g_action);

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

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

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

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

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

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

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

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

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

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

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

Line 1348: ITG_msg.checked_error(g_action);

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

Line 1349: itg_msg.vendor_site_only;

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

Line 1358: ITG_msg.unexpected_error(g_action);

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

Line 1360: itg_msg.vendor_site_only;

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

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

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

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

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

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

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

Line 1561: ITG_msg.checked_error(g_action);

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

Line 1562: itg_msg.vendor_contact_only;

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

Line 1572: ITG_msg.unexpected_error(g_action);

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

Line 1573: itg_msg.vendor_contact_only;

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