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.CZ_OM_ATP_CALLBACK dependencies on FND_LOG

Line 454: fnd_log.LEVEL_PROCEDURE);

450: BEGIN
451: l_ndebug := 0;
452: cz_utils.log_report('cz_om_atp_callback', 'call_atp', l_ndebug,
453: 'CZ session ' || p_config_session_key || ': starting cz_om_atp_callback.call_atp',
454: fnd_log.LEVEL_PROCEDURE);
455:
456: aps_version := MSC_ATP_GLOBAL.get_aps_version;
457: l_ndebug := 1;
458: cz_utils.log_report('cz_om_atp_callback', 'call_atp', l_ndebug,

Line 459: 'aps_version ' || aps_version, fnd_log.LEVEL_PROCEDURE);

455:
456: aps_version := MSC_ATP_GLOBAL.get_aps_version;
457: l_ndebug := 1;
458: cz_utils.log_report('cz_om_atp_callback', 'call_atp', l_ndebug,
459: 'aps_version ' || aps_version, fnd_log.LEVEL_PROCEDURE);
460:
461: g_atp_rec := empty_atp_rec;
462:
463: -- 11.5.1 limitation, warehouse_id is REQUIRED

Line 531: 'Before calling get_mandatory_comps.', fnd_log.LEVEL_PROCEDURE);

527:
528: IF (aps_version < APS_VERSION_PATCHSET_J) THEN
529: -- add mandatory components to g_atp_rec
530: cz_utils.log_report('cz_om_atp_callback', 'call_atp', l_ndebug,
531: 'Before calling get_mandatory_comps.', fnd_log.LEVEL_PROCEDURE);
532: l_model_inv_item_id := g_atp_rec.inventory_item_id(1);
533: l_mc_result :=
534: cto_config_item_pk.get_mandatory_components(g_atp_rec,
535: p_warehouse_id, l_model_inv_item_id, l_mc_atp_rec,

Line 540: 'After calling get_mandatory_comps.', fnd_log.LEVEL_PROCEDURE);

536: l_mc_error, l_mc_message_name, l_mc_tbl_name);
537:
538: l_ndebug := 4;
539: cz_utils.log_report('cz_om_atp_callback', 'call_atp', l_ndebug,
540: 'After calling get_mandatory_comps.', fnd_log.LEVEL_PROCEDURE);
541:
542: IF l_mc_result = 0 THEN
543: raise l_mc_exception;
544: END IF;

Line 592: || l_atp_session_id, fnd_log.LEVEL_PROCEDURE);

588:
589: l_ndebug := 6;
590: cz_utils.log_report('cz_om_atp_callback', 'call_atp', l_ndebug,
591: 'CZ session ' || p_config_session_key || ': calling mrp_atp_pub.call_atp with ATP session ID '
592: || l_atp_session_id, fnd_log.LEVEL_PROCEDURE);
593: l_atp_rec := g_atp_rec;
594: MRP_ATP_PUB.call_atp(l_atp_session_id, l_atp_rec,
595: g_atp_rec, l_atp_supply_demand,
596: l_atp_period, l_atp_details,

Line 602: || l_return_status, fnd_log.LEVEL_PROCEDURE);

598: l_msg_count);
599: l_ndebug := 7;
600: cz_utils.log_report('cz_om_atp_callback', 'call_atp', l_ndebug,
601: 'CZ session ' || p_config_session_key || ': mrp_atp_pub.call_atp - Ret.Status : '
602: || l_return_status, fnd_log.LEVEL_PROCEDURE);
603: cz_utils.log_report('cz_om_atp_callback', 'call_atp', l_ndebug,
604: 'CZ session ' || p_config_session_key || ': mrp_atp_pub.call_atp - Msg.Data : '
605: || l_msg_data, fnd_log.LEVEL_PROCEDURE);
606: cz_utils.log_report('cz_om_atp_callback', 'call_atp', l_ndebug,

Line 605: || l_msg_data, fnd_log.LEVEL_PROCEDURE);

601: 'CZ session ' || p_config_session_key || ': mrp_atp_pub.call_atp - Ret.Status : '
602: || l_return_status, fnd_log.LEVEL_PROCEDURE);
603: cz_utils.log_report('cz_om_atp_callback', 'call_atp', l_ndebug,
604: 'CZ session ' || p_config_session_key || ': mrp_atp_pub.call_atp - Msg.Data : '
605: || l_msg_data, fnd_log.LEVEL_PROCEDURE);
606: cz_utils.log_report('cz_om_atp_callback', 'call_atp', l_ndebug,
607: 'CZ session ' || p_config_session_key || ': mrp_atp_pub.call_atp - Msg.Count : '
608: || l_msg_count, fnd_log.LEVEL_PROCEDURE);
609:

Line 608: || l_msg_count, fnd_log.LEVEL_PROCEDURE);

604: 'CZ session ' || p_config_session_key || ': mrp_atp_pub.call_atp - Msg.Data : '
605: || l_msg_data, fnd_log.LEVEL_PROCEDURE);
606: cz_utils.log_report('cz_om_atp_callback', 'call_atp', l_ndebug,
607: 'CZ session ' || p_config_session_key || ': mrp_atp_pub.call_atp - Msg.Count : '
608: || l_msg_count, fnd_log.LEVEL_PROCEDURE);
609:
610: -- For expected errors, ATP populates the error_code for each record in atp_rec_typ.
611: -- The error_code is defined by the lookup_type 'MTL_DEMAND_INTERFACE_ERRORS' in the
612: -- table mfg_lookups.

Line 618: 'Known Error ... Count : ' || l_error_msg_count, fnd_log.LEVEL_STATEMENT);

614: -- bug 2737013 fix: retrieve any possible error message even when the return status is success
615: IF l_return_status = FND_API.G_RET_STS_ERROR OR l_return_status = FND_API.G_RET_STS_SUCCESS THEN
616: l_error_msg_count := g_atp_rec.error_code.COUNT;
617: cz_utils.log_report('cz_om_atp_callback', 'call_atp', l_ndebug,
618: 'Known Error ... Count : ' || l_error_msg_count, fnd_log.LEVEL_STATEMENT);
619:
620: -- Note: In aps patchset j, the returned g_atp_rec.message from MRP is uninitialized
621: -- (see bug 3358937). So here we use l_atp_rec.message for storing err msg instead.
622: -- here we are assuming g_atp_rec.error_code always initialized

Line 626: fnd_log.LEVEL_STATEMENT);

622: -- here we are assuming g_atp_rec.error_code always initialized
623: FOR i in 1..l_error_msg_count LOOP
624: cz_utils.log_report('cz_om_atp_callback', 'call_atp', l_ndebug,
625: 'Get err message ' || i || ' Err Code :' || g_atp_rec.error_code(i),
626: fnd_log.LEVEL_STATEMENT);
627: if g_atp_rec.error_code(i) is null or g_atp_rec.error_code(i) = -99
628: OR g_atp_rec.error_code(i) = 61 -- filter out "atp not applicable" message
629: OR g_atp_rec.error_code(i) = 0 then
630: l_atp_rec.message(i) := NULL;

Line 639: fnd_log.LEVEL_STATEMENT);

635: AND lookup_code = g_atp_rec.error_code(i);
636: end if;
637: cz_utils.log_report('cz_om_atp_callback', 'call_atp', l_ndebug,
638: 'Lookup Err. Message : ' || l_atp_rec.message(i),
639: fnd_log.LEVEL_STATEMENT);
640: END LOOP;
641:
642: -- will display error message using x_msg_data returned from MRP_ATP_PUB.CALL_ATP
643: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 645: 'UnExpected Error from ...', fnd_log.LEVEL_STATEMENT);

641:
642: -- will display error message using x_msg_data returned from MRP_ATP_PUB.CALL_ATP
643: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
644: cz_utils.log_report('cz_om_atp_callback', 'call_atp', l_ndebug,
645: 'UnExpected Error from ...', fnd_log.LEVEL_STATEMENT);
646: RAISE l_call_atp_exc;
647: END IF;
648:
649: -- run through results, populate cz_atp_requests

Line 666: fnd_log.LEVEL_STATEMENT);

662:
663: cz_utils.log_report('cz_om_atp_callback', 'call_atp', l_ndebug,
664: p_config_session_key || ': updating ATP requests rec, l_ship_date: ' ||
665: to_char(l_ship_date, 'MM-DD-YYYY HH24:MI:SS'),
666: fnd_log.LEVEL_STATEMENT);
667:
668: cz_utils.log_report('cz_om_atp_callback', 'call_atp', l_ndebug,
669: 'Updating ATP requests rec, message: ' || l_atp_rec.message(l_counter),
670: fnd_log.LEVEL_STATEMENT);

Line 670: fnd_log.LEVEL_STATEMENT);

666: fnd_log.LEVEL_STATEMENT);
667:
668: cz_utils.log_report('cz_om_atp_callback', 'call_atp', l_ndebug,
669: 'Updating ATP requests rec, message: ' || l_atp_rec.message(l_counter),
670: fnd_log.LEVEL_STATEMENT);
671:
672: -- if atp returns need_by_date and days_late in g_atp_rec
673: -- we will update the fields here
674:

Line 694: 'Top model is a pto? ' || l_pto_model_flag, fnd_log.LEVEL_STATEMENT);

690: WHERE inventory_item_id = g_atp_rec.inventory_item_id(1)
691: AND organization_id = l_validation_org;
692:
693: cz_utils.log_report('cz_om_atp_callback', 'call_atp', l_ndebug,
694: 'Top model is a pto? ' || l_pto_model_flag, fnd_log.LEVEL_STATEMENT);
695:
696: IF (upper(l_pto_model_flag) <> 'Y') THEN
697: p_ship_to_group_date := g_atp_rec.ship_date(1);
698: END IF;

Line 708: || To_char(p_ship_to_group_date), fnd_log.LEVEL_PROCEDURE);

704:
705: l_ndebug := 10;
706: cz_utils.log_report('cz_om_atp_callback', 'call_atp', l_ndebug,
707: 'CZ session ' || p_config_session_key || ': returning group ship date: '
708: || To_char(p_ship_to_group_date), fnd_log.LEVEL_PROCEDURE);
709: g_atp_rec := empty_atp_rec;
710:
711: EXCEPTION
712: WHEN extend_atp_rec_exc THEN

Line 716: fnd_log.LEVEL_ERROR);

712: WHEN extend_atp_rec_exc THEN
713: g_atp_rec := empty_atp_rec;
714: cz_utils.log_report('cz_om_atp_callback', 'call_atp', l_ndebug,
715: 'Unexpected error in cz_om_atp_callback returned from MSC_SATP_FUNC.extend_atp',
716: fnd_log.LEVEL_ERROR);
717: UPDATE cz_atp_requests SET msg_data = 'Error in executing MSC_SATP_FUNC.extend_atp'
718: WHERE configurator_session_key = p_config_session_key
719: AND seq_no = 1;
720: COMMIT;

Line 726: 'oe_sys_parameters.value(MASTER_ORGANIZATION_ID)', fnd_log.LEVEL_ERROR);

722: WHEN l_validation_org_exc THEN
723: g_atp_rec := empty_atp_rec;
724: cz_utils.log_report('cz_om_atp_callback', 'call_atp', l_ndebug,
725: 'Unexpected error in cz_om_atp_callback: NULL organization id returned from ' ||
726: 'oe_sys_parameters.value(MASTER_ORGANIZATION_ID)', fnd_log.LEVEL_ERROR);
727: UPDATE cz_atp_requests SET msg_data = 'Error in executing oe_sys_parameters.value for ' ||
728: 'MASTER_ORGANIZATION_ID: Null value returned'
729: WHERE configurator_session_key = p_config_session_key
730: AND seq_no = 1;

Line 737: fnd_log.LEVEL_ERROR);

733: WHEN l_mc_exception THEN
734: g_atp_rec := empty_atp_rec;
735: cz_utils.log_report('cz_om_atp_callback', 'call_atp', l_ndebug,
736: 'Error in mandatory comp expl proc: '|| l_mc_error,
737: fnd_log.LEVEL_ERROR);
738: UPDATE cz_atp_requests SET msg_data =
739: 'Mandatory comp expl error: ' || l_mc_error
740: WHERE configurator_session_key = p_config_session_key
741: AND seq_no = 1;

Line 745: 'No warehouse supplied to ATP call.', fnd_log.LEVEL_ERROR);

741: AND seq_no = 1;
742: COMMIT;
743: WHEN l_warehouse_id_exc THEN
744: cz_utils.log_report('cz_om_atp_callback', 'call_atp', l_ndebug,
745: 'No warehouse supplied to ATP call.', fnd_log.LEVEL_ERROR);
746: UPDATE cz_atp_requests SET msg_data = CZ_UTILS.GET_TEXT('CZ_ATP_NO_WAREHOUSE')
747: WHERE configurator_session_key = p_config_session_key
748: AND seq_no = 1;
749: COMMIT;

Line 754: l_msg_data, fnd_log.LEVEL_ERROR);

750:
751: WHEN l_atp_session_id_exc THEN
752: l_msg_data := 'Fail in getting an atp session id from MSC_ATP_GLOBAL';
753: cz_utils.log_report('cz_om_atp_callback', 'call_atp', l_ndebug,
754: l_msg_data, fnd_log.LEVEL_ERROR);
755: UPDATE cz_atp_requests SET msg_data = l_msg_data
756: WHERE configurator_session_key = p_config_session_key
757: AND seq_no = 1;
758: COMMIT;

Line 764: fnd_log.LEVEL_ERROR);

760: WHEN l_call_atp_exc THEN
761: g_atp_rec := empty_atp_rec;
762: cz_utils.log_report('cz_om_atp_callback', 'call_atp', l_ndebug,
763: 'Unexpected error in cz_om_atp_callback returned from mrp_atp_pub: ' || l_msg_data,
764: fnd_log.LEVEL_ERROR);
765:
766: UPDATE cz_atp_requests SET msg_data =
767: 'Unexpected error in cz_om_atp_callback returned from mrp_atp_pub: ' || l_msg_data
768: WHERE configurator_session_key = p_config_session_key

Line 776: fnd_log.LEVEL_UNEXPECTED);

772: g_atp_rec := empty_atp_rec;
773: l_msg_data := 'Unexpected error in cz_om_atp_callback statement ' || l_ndebug || ': '
774: || substr(SQLERRM, 1, 1500);
775: cz_utils.log_report('cz_om_atp_callback', 'call_atp', l_ndebug, l_msg_data,
776: fnd_log.LEVEL_UNEXPECTED);
777: UPDATE cz_atp_requests SET msg_data = l_msg_data
778: WHERE configurator_session_key = p_config_session_key
779: AND seq_no = 1;
780: COMMIT;