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 MRP_ATP_PUB

Line 138: PROCEDURE append_mandatory_comps(p_mc_atp_rec IN MRP_ATP_PUB.atp_rec_typ) IS

134:
135: --------------------------------------------------------------------------------
136: -- Appends mandatory components returned from cto_config_item_pk
137: -- to the original ATP record generated from cz_atp_requests
138: PROCEDURE append_mandatory_comps(p_mc_atp_rec IN MRP_ATP_PUB.atp_rec_typ) IS
139: l_atp_rec_length NUMBER;
140: l_atp_rec_index NUMBER;
141: l_num_mandatory_comps NUMBER;
142: i NUMBER;

Line 408: l_atp_rec MRP_ATP_PUB.atp_rec_typ;

404: l_ship_date DATE;
405: l_atp_row_count NUMBER;
406: l_atp_row atp_requests%ROWTYPE;
407: l_atp_update_row update_atp_requests%ROWTYPE;
408: l_atp_rec MRP_ATP_PUB.atp_rec_typ;
409: l_ship_set_name VARCHAR2(30);
410: l_top_model_line_id NUMBER;
411: l_validation_org NUMBER;
412: l_pto_model_flag mtl_system_items.pick_components_flag%TYPE;

Line 416: l_mc_atp_rec MRP_ATP_PUB.atp_rec_typ;

412: l_pto_model_flag mtl_system_items.pick_components_flag%TYPE;
413:
414: -- variables used for mandatory component addition
415: l_mc_result NUMBER;
416: l_mc_atp_rec MRP_ATP_PUB.atp_rec_typ;
417: l_mc_error VARCHAR2(2000);
418: l_mc_message_name VARCHAR2(100);
419: l_mc_tbl_name VARCHAR2(100);
420: l_mc_exception EXCEPTION;

Line 434: l_atp_supply_demand MRP_ATP_PUB.atp_supply_demand_typ;

430:
431: l_action NUMBER;
432: l_cz_appl_id NUMBER;
433: l_atp_session_id NUMBER;
434: l_atp_supply_demand MRP_ATP_PUB.atp_supply_demand_typ;
435: l_atp_period MRP_ATP_PUB.atp_period_typ;
436: l_atp_details MRP_ATP_PUB.atp_details_typ;
437: l_return_status VARCHAR2(10);
438: l_msg_data VARCHAR2(2000);

Line 435: l_atp_period MRP_ATP_PUB.atp_period_typ;

431: l_action NUMBER;
432: l_cz_appl_id NUMBER;
433: l_atp_session_id NUMBER;
434: l_atp_supply_demand MRP_ATP_PUB.atp_supply_demand_typ;
435: l_atp_period MRP_ATP_PUB.atp_period_typ;
436: l_atp_details MRP_ATP_PUB.atp_details_typ;
437: l_return_status VARCHAR2(10);
438: l_msg_data VARCHAR2(2000);
439: l_msg_count NUMBER;

Line 436: l_atp_details MRP_ATP_PUB.atp_details_typ;

432: l_cz_appl_id NUMBER;
433: l_atp_session_id NUMBER;
434: l_atp_supply_demand MRP_ATP_PUB.atp_supply_demand_typ;
435: l_atp_period MRP_ATP_PUB.atp_period_typ;
436: l_atp_details MRP_ATP_PUB.atp_details_typ;
437: l_return_status VARCHAR2(10);
438: l_msg_data VARCHAR2(2000);
439: l_msg_count NUMBER;
440: l_error_msg_count NUMBER;

Line 449: empty_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;

445: l_atp_session_id_exc EXCEPTION;
446:
447: l_ndebug NUMBER;
448:
449: empty_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
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',

Line 591: 'CZ session ' || p_config_session_key || ': calling mrp_atp_pub.call_atp with ATP session ID '

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

Line 594: MRP_ATP_PUB.call_atp(l_atp_session_id, l_atp_rec,

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,
597: l_return_status, l_msg_data,
598: l_msg_count);

Line 601: 'CZ session ' || p_config_session_key || ': mrp_atp_pub.call_atp - Ret.Status : '

597: l_return_status, l_msg_data,
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);

Line 604: 'CZ session ' || p_config_session_key || ': mrp_atp_pub.call_atp - Msg.Data : '

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,
607: 'CZ session ' || p_config_session_key || ': mrp_atp_pub.call_atp - Msg.Count : '
608: || l_msg_count, fnd_log.LEVEL_PROCEDURE);

Line 607: 'CZ session ' || p_config_session_key || ': mrp_atp_pub.call_atp - Msg.Count : '

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

Line 642: -- will display error message using x_msg_data returned from MRP_ATP_PUB.CALL_ATP

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

Line 763: 'Unexpected error in cz_om_atp_callback returned from mrp_atp_pub: ' || l_msg_data,

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

Line 767: 'Unexpected error in cz_om_atp_callback returned from mrp_atp_pub: ' || l_msg_data

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
769: AND seq_no = 1;
770: COMMIT;
771: WHEN OTHERS THEN