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 165: qa_skiplot_utility.insert_error_log (

161: p_from_locator_id => L_RTI_LOC_ID);
162:
163:
164: if x_return_status <> 'S' then
165: qa_skiplot_utility.insert_error_log (
166: p_module_name => 'QA_SKIPLOT_RES_ENGINE.LAUNCH_SHIPMENT_ACTION_INT',
167: p_error_message => 'QA_PO_INSP_ACTION_FAIL',
168: p_comments => x_msg_data);
169: fnd_message.clear;

Line 265: qa_skiplot_utility.insert_error_log (

261: p_product_transaction_id => l_rti_int_txn_id);
262:
263:
264: if x_return_status <> 'S' then
265: qa_skiplot_utility.insert_error_log (
266: p_module_name => 'QA_SKIPLOT_RES_ENGINE.LAUNCH_SHIPMENT_ACTION_INT',
267: p_error_message => 'QA_WMS_LOT_INSERT_FAIL',
268: p_comments => x_msg_data);
269: fnd_message.clear;

Line 312: qa_skiplot_utility.insert_error_log (

308: p_product_transaction_id => l_rti_int_txn_id);
309:
310:
311: if x_return_status <> 'S' then
312: qa_skiplot_utility.insert_error_log (
313: p_module_name => 'QA_SKIPLOT_RES_ENGINE.LAUNCH_SHIPMENT_ACTION_INT',
314: p_error_message => 'QA_WMS_SER_INSERT_FAIL',
315: p_comments => x_msg_data);
316: fnd_message.clear;

Line 335: col_ref qa_skiplot_utility.refCursorTyp;

331: --
332: function get_result_column(
333: p_plan_id in number) return varchar2 is
334:
335: col_ref qa_skiplot_utility.refCursorTyp;
336: res_col qa_plan_chars.result_column_name%type;
337:
338: begin
339: open col_ref for

Line 604: qa_skiplot_utility.init_plan_states(

600: --
601: if p_reinsp_flag = fnd_api.g_true then
602:
603: if p_prev_txn_type = 'ACCEPT' and p_insp_result = 'REJECT' then
604: qa_skiplot_utility.init_plan_states(
605: p_process_id => pid,
606: p_criteria_id => p_criteria_id,
607: p_txn => p_txn);
608: end if;

Line 615: qa_skiplot_utility.init_plan_states(

611: -- 1st inspection failed
612: --
613: elsif p_insp_result = 'REJECT' then
614:
615: qa_skiplot_utility.init_plan_states(
616: p_process_id => pid,
617: p_criteria_id => p_criteria_id,
618: p_txn => p_txn);
619:

Line 763: txn := QA_SKIPLOT_UTILITY.WIP;

759: --
760: -- update plan state table for each plan
761: --
762: if p_shipment_line_id is null then
763: txn := QA_SKIPLOT_UTILITY.WIP;
764: else
765: txn := QA_SKIPLOT_UTILITY.RCV;
766: end if;
767:

Line 765: txn := QA_SKIPLOT_UTILITY.RCV;

761: --
762: if p_shipment_line_id is null then
763: txn := QA_SKIPLOT_UTILITY.WIP;
764: else
765: txn := QA_SKIPLOT_UTILITY.RCV;
766: end if;
767:
768: update_plan_states(
769: p_insp_result => lot_result,

Line 784: qa_skiplot_utility.insert_error_log (

780:
781:
782: EXCEPTION
783: WHEN OTHERS THEN
784: qa_skiplot_utility.insert_error_log (
785: p_module_name => 'QA_SKIPLOT_RES_ENGINE.PROCESS_SKIPLOT_RESULT',
786: p_error_message => 'QA_SKIPLOT_PROCESS_RES_ERROR',
787: p_comments => SUBSTR (SQLERRM , 1 , 240));
788:

Line 1197: qa_skiplot_utility.insert_error_log (

1193: end if;
1194:
1195: EXCEPTION
1196: WHEN OTHERS THEN
1197: qa_skiplot_utility.insert_error_log (
1198: p_module_name => 'QA_SKIPLOT_RES_ENGINE.UPDATE_LOT_PLANS',
1199: p_error_message => 'QA_SKIPLOT_RES_UPDATE_PLANS_ERR',
1200: p_comments => SUBSTR (SQLERRM , 1 , 240));
1201: fnd_message.clear;

Line 1371: qa_skiplot_utility.insert_error_log (

1367:
1368:
1369: EXCEPTION
1370: WHEN OTHERS THEN
1371: qa_skiplot_utility.insert_error_log (
1372: p_module_name => 'QA_SKIPLOT_RES_ENGINE.UPDATE_SKIPLOT_RESULT',
1373: p_error_message => 'QA_SKIPLOT_RES_UPDATE_RESULT_ERR',
1374: p_comments => SUBSTR (SQLERRM , 1 , 240));
1375: fnd_message.clear;

Line 1391: plan_state qa_skiplot_utility.plan_state_rec;

1387: p_txn IN NUMBER,
1388: p_prev_txn_type IN VARCHAR2 DEFAULT NULL,
1389: p_reinsp_flag IN VARCHAR2 DEFAULT NULL) IS
1390:
1391: plan_state qa_skiplot_utility.plan_state_rec;
1392: forward_lot number;
1393: pp_id number;
1394: next_rule number;
1395:

Line 1398: qa_skiplot_utility.fetch_plan_state(

1394: next_rule number;
1395:
1396: BEGIN
1397:
1398: qa_skiplot_utility.fetch_plan_state(
1399: p_plan_id => p_lot_plan.plan_id,
1400: p_criteria_id => p_criteria_id,
1401: p_process_id => p_process_id,
1402: p_txn => p_txn,

Line 1413: qa_skiplot_utility.init_plan_state(

1409: if p_prev_txn_type = 'ACCEPT' and p_insp_result = 'REJECT' then
1410: --
1411: -- reset plan states if re-inspection failed
1412: --
1413: qa_skiplot_utility.init_plan_state(
1414: p_plan_id => p_lot_plan.plan_id,
1415: p_criteria_id => p_criteria_id,
1416: p_process_id => plan_state.process_id,
1417: p_lot_id => p_lot_plan.insp_lot_id,

Line 1429: qa_skiplot_utility.init_plan_state(

1425: elsif p_insp_result = 'REJECT' then
1426: --
1427: -- if lot is rejected, reset every inspection plan state
1428: --
1429: qa_skiplot_utility.init_plan_state(
1430: p_plan_id => p_lot_plan.plan_id,
1431: p_criteria_id => p_criteria_id,
1432: p_process_id => plan_state.process_id,
1433: p_lot_id => p_lot_plan.insp_lot_id,

Line 1440: elsif qa_skiplot_utility.insp_round_finished(plan_state)

1436:
1437: --
1438: -- if round is not finished, update the round parameters
1439: --
1440: elsif qa_skiplot_utility.insp_round_finished(plan_state)
1441: = fnd_api.g_false then
1442:
1443: if qa_skiplot_utility.enough_lot_accepted (plan_state)
1444: = fnd_api.g_false then

Line 1443: if qa_skiplot_utility.enough_lot_accepted (plan_state)

1439: --
1440: elsif qa_skiplot_utility.insp_round_finished(plan_state)
1441: = fnd_api.g_false then
1442:
1443: if qa_skiplot_utility.enough_lot_accepted (plan_state)
1444: = fnd_api.g_false then
1445: forward_lot := 1;
1446: --
1447: -- if this is over inspection, do not forward the

Line 1454: qa_skiplot_utility.update_plan_state(

1450: else
1451: forward_lot := 0;
1452: end if;
1453:
1454: qa_skiplot_utility.update_plan_state(
1455: p_process_plan_id => plan_state.process_plan_id,
1456: p_criteria_id => plan_state.criteria_id,
1457: p_next_lot => plan_state.current_lot + forward_lot,
1458: p_lot_accepted => plan_state.lot_accepted + 1,

Line 1468: elsif qa_skiplot_utility.more_rounds(plan_state)

1464: -- if this rule is done and there are no more rules or
1465: -- if date span exceeded then
1466: -- start a new round for this rule
1467: --
1468: elsif qa_skiplot_utility.more_rounds(plan_state)
1469: = fnd_api.g_true OR
1470: qa_skiplot_utility.get_next_insp_rule(plan_state) = -1 OR
1471: qa_skiplot_utility.date_reasonable (
1472: p_check_mode => qa_skiplot_utility.DATE_SPAN_CHECK,

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

1466: -- start a new round for this rule
1467: --
1468: elsif qa_skiplot_utility.more_rounds(plan_state)
1469: = fnd_api.g_true OR
1470: qa_skiplot_utility.get_next_insp_rule(plan_state) = -1 OR
1471: qa_skiplot_utility.date_reasonable (
1472: p_check_mode => qa_skiplot_utility.DATE_SPAN_CHECK,
1473: p_plan_state => plan_state) = fnd_api.g_false then
1474:

Line 1471: qa_skiplot_utility.date_reasonable (

1467: --
1468: elsif qa_skiplot_utility.more_rounds(plan_state)
1469: = fnd_api.g_true OR
1470: qa_skiplot_utility.get_next_insp_rule(plan_state) = -1 OR
1471: qa_skiplot_utility.date_reasonable (
1472: p_check_mode => qa_skiplot_utility.DATE_SPAN_CHECK,
1473: p_plan_state => plan_state) = fnd_api.g_false then
1474:
1475: qa_skiplot_utility.update_plan_state(

Line 1472: p_check_mode => qa_skiplot_utility.DATE_SPAN_CHECK,

1468: elsif qa_skiplot_utility.more_rounds(plan_state)
1469: = fnd_api.g_true OR
1470: qa_skiplot_utility.get_next_insp_rule(plan_state) = -1 OR
1471: qa_skiplot_utility.date_reasonable (
1472: p_check_mode => qa_skiplot_utility.DATE_SPAN_CHECK,
1473: p_plan_state => plan_state) = fnd_api.g_false then
1474:
1475: qa_skiplot_utility.update_plan_state(
1476: p_process_plan_id => plan_state.process_plan_id,

Line 1475: qa_skiplot_utility.update_plan_state(

1471: qa_skiplot_utility.date_reasonable (
1472: p_check_mode => qa_skiplot_utility.DATE_SPAN_CHECK,
1473: p_plan_state => plan_state) = fnd_api.g_false then
1474:
1475: qa_skiplot_utility.update_plan_state(
1476: p_process_plan_id => plan_state.process_plan_id,
1477: p_criteria_id => plan_state.criteria_id,
1478: p_next_round => plan_state.current_round + 1,
1479: p_next_lot => 1,

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

1486: -- date span is reasonable
1487: -- then go to next rule
1488: --
1489: else
1490: next_rule := qa_skiplot_utility.get_next_insp_rule(plan_state);
1491:
1492: qa_skiplot_utility.update_plan_state(
1493: p_process_plan_id => plan_state.process_plan_id,
1494: p_criteria_id => plan_state.criteria_id,

Line 1492: qa_skiplot_utility.update_plan_state(

1488: --
1489: else
1490: next_rule := qa_skiplot_utility.get_next_insp_rule(plan_state);
1491:
1492: qa_skiplot_utility.update_plan_state(
1493: p_process_plan_id => plan_state.process_plan_id,
1494: p_criteria_id => plan_state.criteria_id,
1495: p_next_rule => next_rule,
1496: p_next_round => 1,

Line 1504: qa_skiplot_utility.insert_error_log (

1500:
1501: end if;
1502: EXCEPTION
1503: WHEN OTHERS THEN
1504: qa_skiplot_utility.insert_error_log (
1505: p_module_name => 'QA_SKIPLOT_RES_ENGINE.UPDATE_PLAN_STATE',
1506: p_error_message => 'QA_SKIPLOT_RES_UPDATE_STATE_ERR',
1507: p_comments => SUBSTR (SQLERRM , 1 , 240));
1508: fnd_message.clear;

Line 1695: qa_skiplot_utility.insert_error_log (

1691: p_msg_data => x_msg_data);
1692: end if;
1693:
1694: if x_return_status <> 'S' then
1695: qa_skiplot_utility.insert_error_log (
1696: p_module_name => 'QA_SKIPLOT_RES_ENGINE.LAUNCH_SHIPMENT_ACTION',
1697: p_error_message => 'QA_SKIPLOT_REJECTION_ACTION_ERROR',
1698: p_comments => x_msg_data);
1699: fnd_message.clear;

Line 1736: qa_skiplot_utility.insert_error_log (

1732: p_msg_count => x_msg_count,
1733: p_msg_data => x_msg_data);
1734: end if;
1735: if x_return_status <> 'S' then
1736: qa_skiplot_utility.insert_error_log (
1737: p_module_name => 'QA_SKIPLOT_RES_ENGINE.LAUNCH_SHIPMENT_ACTION',
1738: p_error_message => 'QA_SKIPLOT_ACCEPTANCE_ACTION_ERROR',
1739: p_comments => x_msg_data);
1740: fnd_message.clear;