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.QA_SKIPLOT_RES_ENGINE dependencies on QA_SKIPLOT_UTILITY

Line 179: qa_skiplot_utility.insert_error_log (

175: p_from_locator_id => L_RTI_LOC_ID);
176:
177:
178: if x_return_status <> 'S' then
179: qa_skiplot_utility.insert_error_log (
180: p_module_name => 'QA_SKIPLOT_RES_ENGINE.LAUNCH_SHIPMENT_ACTION_INT',
181: p_error_message => 'QA_PO_INSP_ACTION_FAIL',
182: p_comments => x_msg_data);
183: fnd_message.clear;

Line 283: qa_skiplot_utility.insert_error_log (

279: p_product_transaction_id => l_rti_int_txn_id);
280:
281:
282: if x_return_status <> 'S' then
283: qa_skiplot_utility.insert_error_log (
284: p_module_name => 'QA_SKIPLOT_RES_ENGINE.LAUNCH_SHIPMENT_ACTION_INT',
285: p_error_message => 'QA_WMS_LOT_INSERT_FAIL',
286: p_comments => x_msg_data);
287: fnd_message.clear;

Line 330: qa_skiplot_utility.insert_error_log (

326: p_product_transaction_id => l_rti_int_txn_id);
327:
328:
329: if x_return_status <> 'S' then
330: qa_skiplot_utility.insert_error_log (
331: p_module_name => 'QA_SKIPLOT_RES_ENGINE.LAUNCH_SHIPMENT_ACTION_INT',
332: p_error_message => 'QA_WMS_SER_INSERT_FAIL',
333: p_comments => x_msg_data);
334: fnd_message.clear;

Line 353: col_ref qa_skiplot_utility.refCursorTyp;

349: --
350: function get_result_column(
351: p_plan_id in number) return varchar2 is
352:
353: col_ref qa_skiplot_utility.refCursorTyp;
354: res_col qa_plan_chars.result_column_name%type;
355:
356: begin
357: open col_ref for

Line 622: qa_skiplot_utility.init_plan_states(

618: --
619: if p_reinsp_flag = fnd_api.g_true then
620:
621: if p_prev_txn_type = 'ACCEPT' and p_insp_result = 'REJECT' then
622: qa_skiplot_utility.init_plan_states(
623: p_process_id => pid,
624: p_criteria_id => p_criteria_id,
625: p_txn => p_txn);
626: end if;

Line 633: qa_skiplot_utility.init_plan_states(

629: -- 1st inspection failed
630: --
631: elsif p_insp_result = 'REJECT' then
632:
633: qa_skiplot_utility.init_plan_states(
634: p_process_id => pid,
635: p_criteria_id => p_criteria_id,
636: p_txn => p_txn);
637:

Line 793: txn := QA_SKIPLOT_UTILITY.WIP;

789: --
790: -- update plan state table for each plan
791: --
792: if p_shipment_line_id is null then
793: txn := QA_SKIPLOT_UTILITY.WIP;
794: else
795: txn := QA_SKIPLOT_UTILITY.RCV;
796: end if;
797:

Line 795: txn := QA_SKIPLOT_UTILITY.RCV;

791: --
792: if p_shipment_line_id is null then
793: txn := QA_SKIPLOT_UTILITY.WIP;
794: else
795: txn := QA_SKIPLOT_UTILITY.RCV;
796: end if;
797:
798: update_plan_states(
799: p_insp_result => lot_result,

Line 814: qa_skiplot_utility.insert_error_log (

810:
811:
812: EXCEPTION
813: WHEN OTHERS THEN
814: qa_skiplot_utility.insert_error_log (
815: p_module_name => 'QA_SKIPLOT_RES_ENGINE.PROCESS_SKIPLOT_RESULT',
816: p_error_message => 'QA_SKIPLOT_PROCESS_RES_ERROR',
817: p_comments => SUBSTR (SQLERRM , 1 , 240));
818:

Line 1277: qa_skiplot_utility.insert_error_log (

1273: end if;
1274:
1275: EXCEPTION
1276: WHEN OTHERS THEN
1277: qa_skiplot_utility.insert_error_log (
1278: p_module_name => 'QA_SKIPLOT_RES_ENGINE.UPDATE_LOT_PLANS',
1279: p_error_message => 'QA_SKIPLOT_RES_UPDATE_PLANS_ERR',
1280: p_comments => SUBSTR (SQLERRM , 1 , 240));
1281: fnd_message.clear;

Line 1532: qa_skiplot_utility.insert_error_log (

1528:
1529:
1530: EXCEPTION
1531: WHEN OTHERS THEN
1532: qa_skiplot_utility.insert_error_log (
1533: p_module_name => 'QA_SKIPLOT_RES_ENGINE.UPDATE_SKIPLOT_RESULT',
1534: p_error_message => 'QA_SKIPLOT_RES_UPDATE_RESULT_ERR',
1535: p_comments => SUBSTR (SQLERRM , 1 , 240));
1536: fnd_message.clear;

Line 1552: plan_state qa_skiplot_utility.plan_state_rec;

1548: p_txn IN NUMBER,
1549: p_prev_txn_type IN VARCHAR2 DEFAULT NULL,
1550: p_reinsp_flag IN VARCHAR2 DEFAULT NULL) IS
1551:
1552: plan_state qa_skiplot_utility.plan_state_rec;
1553: forward_lot number;
1554: pp_id number;
1555: next_rule number;
1556:

Line 1559: qa_skiplot_utility.fetch_plan_state(

1555: next_rule number;
1556:
1557: BEGIN
1558:
1559: qa_skiplot_utility.fetch_plan_state(
1560: p_plan_id => p_lot_plan.plan_id,
1561: p_criteria_id => p_criteria_id,
1562: p_process_id => p_process_id,
1563: p_txn => p_txn,

Line 1574: qa_skiplot_utility.init_plan_state(

1570: if p_prev_txn_type = 'ACCEPT' and p_insp_result = 'REJECT' then
1571: --
1572: -- reset plan states if re-inspection failed
1573: --
1574: qa_skiplot_utility.init_plan_state(
1575: p_plan_id => p_lot_plan.plan_id,
1576: p_criteria_id => p_criteria_id,
1577: p_process_id => plan_state.process_id,
1578: p_lot_id => p_lot_plan.insp_lot_id,

Line 1590: qa_skiplot_utility.init_plan_state(

1586: elsif p_insp_result = 'REJECT' then
1587: --
1588: -- if lot is rejected, reset every inspection plan state
1589: --
1590: qa_skiplot_utility.init_plan_state(
1591: p_plan_id => p_lot_plan.plan_id,
1592: p_criteria_id => p_criteria_id,
1593: p_process_id => plan_state.process_id,
1594: p_lot_id => p_lot_plan.insp_lot_id,

Line 1601: elsif qa_skiplot_utility.insp_round_finished(plan_state)

1597:
1598: --
1599: -- if round is not finished, update the round parameters
1600: --
1601: elsif qa_skiplot_utility.insp_round_finished(plan_state)
1602: = fnd_api.g_false then
1603:
1604: if qa_skiplot_utility.enough_lot_accepted (plan_state)
1605: = fnd_api.g_false then

Line 1604: if qa_skiplot_utility.enough_lot_accepted (plan_state)

1600: --
1601: elsif qa_skiplot_utility.insp_round_finished(plan_state)
1602: = fnd_api.g_false then
1603:
1604: if qa_skiplot_utility.enough_lot_accepted (plan_state)
1605: = fnd_api.g_false then
1606: forward_lot := 1;
1607: --
1608: -- if this is over inspection, do not forward the

Line 1615: qa_skiplot_utility.update_plan_state(

1611: else
1612: forward_lot := 0;
1613: end if;
1614:
1615: qa_skiplot_utility.update_plan_state(
1616: p_process_plan_id => plan_state.process_plan_id,
1617: p_criteria_id => plan_state.criteria_id,
1618: p_next_lot => plan_state.current_lot + forward_lot,
1619: p_lot_accepted => plan_state.lot_accepted + 1,

Line 1629: elsif qa_skiplot_utility.more_rounds(plan_state)

1625: -- if this rule is done and there are no more rules or
1626: -- if date span exceeded then
1627: -- start a new round for this rule
1628: --
1629: elsif qa_skiplot_utility.more_rounds(plan_state)
1630: = fnd_api.g_true OR
1631: qa_skiplot_utility.get_next_insp_rule(plan_state) = -1 OR
1632: qa_skiplot_utility.date_reasonable (
1633: p_check_mode => qa_skiplot_utility.DATE_SPAN_CHECK,

Line 1631: qa_skiplot_utility.get_next_insp_rule(plan_state) = -1 OR

1627: -- start a new round for this rule
1628: --
1629: elsif qa_skiplot_utility.more_rounds(plan_state)
1630: = fnd_api.g_true OR
1631: qa_skiplot_utility.get_next_insp_rule(plan_state) = -1 OR
1632: qa_skiplot_utility.date_reasonable (
1633: p_check_mode => qa_skiplot_utility.DATE_SPAN_CHECK,
1634: p_plan_state => plan_state) = fnd_api.g_false then
1635:

Line 1632: qa_skiplot_utility.date_reasonable (

1628: --
1629: elsif qa_skiplot_utility.more_rounds(plan_state)
1630: = fnd_api.g_true OR
1631: qa_skiplot_utility.get_next_insp_rule(plan_state) = -1 OR
1632: qa_skiplot_utility.date_reasonable (
1633: p_check_mode => qa_skiplot_utility.DATE_SPAN_CHECK,
1634: p_plan_state => plan_state) = fnd_api.g_false then
1635:
1636: qa_skiplot_utility.update_plan_state(

Line 1633: p_check_mode => qa_skiplot_utility.DATE_SPAN_CHECK,

1629: elsif qa_skiplot_utility.more_rounds(plan_state)
1630: = fnd_api.g_true OR
1631: qa_skiplot_utility.get_next_insp_rule(plan_state) = -1 OR
1632: qa_skiplot_utility.date_reasonable (
1633: p_check_mode => qa_skiplot_utility.DATE_SPAN_CHECK,
1634: p_plan_state => plan_state) = fnd_api.g_false then
1635:
1636: qa_skiplot_utility.update_plan_state(
1637: p_process_plan_id => plan_state.process_plan_id,

Line 1636: qa_skiplot_utility.update_plan_state(

1632: qa_skiplot_utility.date_reasonable (
1633: p_check_mode => qa_skiplot_utility.DATE_SPAN_CHECK,
1634: p_plan_state => plan_state) = fnd_api.g_false then
1635:
1636: qa_skiplot_utility.update_plan_state(
1637: p_process_plan_id => plan_state.process_plan_id,
1638: p_criteria_id => plan_state.criteria_id,
1639: p_next_round => plan_state.current_round + 1,
1640: p_next_lot => 1,

Line 1651: next_rule := qa_skiplot_utility.get_next_insp_rule(plan_state);

1647: -- date span is reasonable
1648: -- then go to next rule
1649: --
1650: else
1651: next_rule := qa_skiplot_utility.get_next_insp_rule(plan_state);
1652:
1653: qa_skiplot_utility.update_plan_state(
1654: p_process_plan_id => plan_state.process_plan_id,
1655: p_criteria_id => plan_state.criteria_id,

Line 1653: qa_skiplot_utility.update_plan_state(

1649: --
1650: else
1651: next_rule := qa_skiplot_utility.get_next_insp_rule(plan_state);
1652:
1653: qa_skiplot_utility.update_plan_state(
1654: p_process_plan_id => plan_state.process_plan_id,
1655: p_criteria_id => plan_state.criteria_id,
1656: p_next_rule => next_rule,
1657: p_next_round => 1,

Line 1665: qa_skiplot_utility.insert_error_log (

1661:
1662: end if;
1663: EXCEPTION
1664: WHEN OTHERS THEN
1665: qa_skiplot_utility.insert_error_log (
1666: p_module_name => 'QA_SKIPLOT_RES_ENGINE.UPDATE_PLAN_STATE',
1667: p_error_message => 'QA_SKIPLOT_RES_UPDATE_STATE_ERR',
1668: p_comments => SUBSTR (SQLERRM , 1 , 240));
1669: fnd_message.clear;

Line 1870: qa_skiplot_utility.insert_error_log (

1866: p_msg_data => x_msg_data);
1867: end if;
1868:
1869: if x_return_status <> 'S' then
1870: qa_skiplot_utility.insert_error_log (
1871: p_module_name => 'QA_SKIPLOT_RES_ENGINE.LAUNCH_SHIPMENT_ACTION',
1872: p_error_message => 'QA_SKIPLOT_REJECTION_ACTION_ERROR',
1873: p_comments => x_msg_data);
1874: fnd_message.clear;

Line 1911: qa_skiplot_utility.insert_error_log (

1907: p_msg_count => x_msg_count,
1908: p_msg_data => x_msg_data);
1909: end if;
1910: if x_return_status <> 'S' then
1911: qa_skiplot_utility.insert_error_log (
1912: p_module_name => 'QA_SKIPLOT_RES_ENGINE.LAUNCH_SHIPMENT_ACTION',
1913: p_error_message => 'QA_SKIPLOT_ACCEPTANCE_ACTION_ERROR',
1914: p_comments => x_msg_data);
1915: fnd_message.clear;