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_SYNCITEMINBOUND_PVT dependencies on FND_API

Line 66: x_return_status := FND_API.G_RET_STS_SUCCESS;

62: l_reap_status VARCHAR2(20);
63: l_errmsg VARCHAR2(4000);
64: BEGIN
65: /* Initialize return status */
66: x_return_status := FND_API.G_RET_STS_SUCCESS;
67: g_action := 'Item synchronization';
68:
69: IF (l_Debug_Level <= 2) THEN
70: itg_debug_pub.Add('--- Entering Sync_Item ---' ,2);

Line 120: RAISE FND_API.G_EXC_ERROR;

116: END IF;
117:
118: IF l_param_name IS NOT NULL THEN
119: ITG_MSG.missing_element_value(l_param_name, l_param_value);
120: RAISE FND_API.G_EXC_ERROR;
121: END IF;
122:
123: SELECT count(1)
124: INTO l_cnt

Line 130: RAISE FND_API.G_EXC_ERROR;

126: WHERE UPPER(uom_code) = UPPER(p_uom);
127:
128: IF l_cnt = 0 THEN
129: ITG_MSG.uom_not_found(p_uom);
130: RAISE FND_API.G_EXC_ERROR;
131: END IF;
132: END;
133:
134: IF (l_Debug_Level <= 1) THEN

Line 177: RAISE FND_API.G_EXC_ERROR;

173: itg_debug_pub.Add('SI - No hazard class ID found',1);
174: END IF;
175:
176: itg_msg.no_hazard_class(p_hazrdmatl);
177: RAISE FND_API.G_EXC_ERROR;
178: END;
179: END IF;
180:
181: IF (p_commodity1 is null and p_commodity2 is not null)

Line 323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

319:
320:
321: IF l_ccm_request_id <= 0 THEN
322: itg_msg.inv_cp_fail('NONE','NONE');
323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
324: END IF;
325:
326: -- This was pulled from the original sync item code
327: IF (l_Debug_Level <= 1) THEN

Line 344: l_reap_status := FND_API.G_RET_STS_SUCCESS;

340: itg_debug_pub.Add( 'l_dev_status'||l_dev_status,1);
341: itg_debug_pub.Add( 'l_errmsg' ||l_errmsg,1);
342: END IF;
343:
344: l_reap_status := FND_API.G_RET_STS_SUCCESS;
345:
346: -- concurrent program has not completed
347: -- error the collaboration, loggin ccm_id to the
348: -- TODO: What are all the statuses and how do we react.

Line 351: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

347: -- error the collaboration, loggin ccm_id to the
348: -- TODO: What are all the statuses and how do we react.
349: IF upper(l_dev_phase) <> 'COMPLETE' THEN
350: itg_msg.item_import_pending(l_ccm_request_id, l_dev_status, l_dev_phase);
351: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
352: END IF;
353:
354: IF upper(l_dev_status) <> 'NORMAL' THEN
355: itg_msg.inv_cp_fail(l_dev_status,l_dev_phase);

Line 363: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

359: IF l_bool THEN
360: l_reap_status := Reap_BatchResults(l_ccm_request_id,l_sii_rowid,l_ici_rowid);
361: ELSE
362: g_action := 'Item import program status-retrival';
363: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
364: END IF;
365:
366: IF l_reap_status <> FND_API.G_RET_STS_SUCCESS THEN
367: IF (l_Debug_Level <= 1) THEN

Line 366: IF l_reap_status <> FND_API.G_RET_STS_SUCCESS THEN

362: g_action := 'Item import program status-retrival';
363: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
364: END IF;
365:
366: IF l_reap_status <> FND_API.G_RET_STS_SUCCESS THEN
367: IF (l_Debug_Level <= 1) THEN
368: itg_debug_pub.Add('SI - failure in Items Import concurrent request',1);
369: END IF;
370:

Line 371: RAISE FND_API.G_EXC_ERROR;

367: IF (l_Debug_Level <= 1) THEN
368: itg_debug_pub.Add('SI - failure in Items Import concurrent request',1);
369: END IF;
370:
371: RAISE FND_API.G_EXC_ERROR;
372: END IF;
373:
374: IF (l_Debug_Level <= 1) THEN
375: itg_debug_pub.Add('Committing work.',1);

Line 383: WHEN FND_API.G_EXC_ERROR THEN

379: IF (l_Debug_Level <= 2) THEN
380: itg_debug_pub.Add('--- Exiting Sync_Item ---',2);
381: END IF;
382: EXCEPTION
383: WHEN FND_API.G_EXC_ERROR THEN
384: ROLLBACK;
385: x_return_status := FND_API.G_RET_STS_ERROR;
386: ITG_msg.checked_error(g_action);
387: IF (l_Debug_Level <= 6) THEN

Line 385: x_return_status := FND_API.G_RET_STS_ERROR;

381: END IF;
382: EXCEPTION
383: WHEN FND_API.G_EXC_ERROR THEN
384: ROLLBACK;
385: x_return_status := FND_API.G_RET_STS_ERROR;
386: ITG_msg.checked_error(g_action);
387: IF (l_Debug_Level <= 6) THEN
388: itg_debug_pub.Add('--- Exiting Sync_Item ---ERROR',6);
389: END IF;

Line 393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

389: END IF;
390:
391: WHEN OTHERS THEN
392: ROLLBACK;
393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
394: ITG_Debug.msg('Unexpected error (Exchange-rate sync) - ' || substr(SQLERRM,1,255),true);
395: ITG_msg.unexpected_error(g_action);
396: IF (l_Debug_Level <= 6) THEN
397: itg_debug_pub.Add('--- Exiting Sync_Item ---OTHER ERROR',6);

Line 445: RAISE FND_API.G_EXC_ERROR;

441: EXCEPTION
442: WHEN OTHERS THEN
443: ITG_Debug.add_exc_error(G_PKG_NAME, 'Start_BatchProcess');
444: itg_msg.invalid_org(p_org_id);
445: RAISE FND_API.G_EXC_ERROR;
446: END;
447:
448: IF (l_Debug_Level <= 2) THEN
449: itg_debug_pub.Add('--- Exting Start_BatchProcess ---',2);

Line 505: return FND_API.G_RET_STS_ERROR;

501:
502: -- if item procssing not complete, log appropriate message and return
503: IF l_process_flag IN ('1','2') THEN
504: itg_msg.item_import_pending(p_request_id,null,null);
505: return FND_API.G_RET_STS_ERROR;
506: END IF;
507:
508: IF l_process_flag NOT IN ('6','7') OR l_process_flag IS NULL THEN
509: ITG_Debug.msg('Item-import errored out, request-id:' || p_request_id,TRUE);

Line 512: return FND_API.G_RET_STS_ERROR;

508: IF l_process_flag NOT IN ('6','7') OR l_process_flag IS NULL THEN
509: ITG_Debug.msg('Item-import errored out, request-id:' || p_request_id,TRUE);
510: itg_msg.item_import_errors;
511: error_transactions(p_request_id,'MTL_SYSTEM_ITEMS_INTERFACE');
512: return FND_API.G_RET_STS_ERROR;
513: END IF;
514:
515: IF p_mici_rid IS NOT NULL THEN
516: BEGIN

Line 534: return FND_API.G_RET_STS_SUCCESS;

530: END IF;
531:
532: IF l_process_flag IN ('1','2') THEN
533: itg_msg.itemcat_import_pending(p_request_id);
534: return FND_API.G_RET_STS_SUCCESS;
535: END IF;
536:
537: IF l_process_flag NOT IN ('6','7') OR l_process_flag IS NULL THEN
538: ITG_Debug.msg('Item-category import errored out, request-id:' || p_request_id,TRUE);

Line 541: return FND_API.G_RET_STS_SUCCESS;

537: IF l_process_flag NOT IN ('6','7') OR l_process_flag IS NULL THEN
538: ITG_Debug.msg('Item-category import errored out, request-id:' || p_request_id,TRUE);
539: itg_msg.mici_only_failed;
540: error_transactions(p_request_id,'MTL_ITEM_CATEGORIES_INTERFACE');
541: return FND_API.G_RET_STS_SUCCESS;
542: END IF;
543: END IF;
544: IF (l_Debug_Level <= 2) THEN
545: itg_debug_pub.Add('--- Exting Reap_BatchResults ---',2);

Line 548: return FND_API.G_RET_STS_SUCCESS;

544: IF (l_Debug_Level <= 2) THEN
545: itg_debug_pub.Add('--- Exting Reap_BatchResults ---',2);
546: END IF;
547: -- code reaches here iff both item and category import are success
548: return FND_API.G_RET_STS_SUCCESS;
549: END;
550:
551: --TODO: What are the process_flag values for
552: -- > Is txn id always returned??