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_SS_LOV_API dependencies on FND_MSG_PUB

Line 482: fnd_msg_pub.add();

478: IF (p_so_number is null) THEN
479: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
480: fnd_message.set_token('DEPELEM',
481: qa_plan_element_api.get_prompt(p_plan_id, qa_ss_const.sales_order));
482: fnd_msg_pub.add();
483: END IF;
484:
485: x_lov_sql := 'select distinct to_char(oel.line_number) ,''Sales Order: '' ||
486: oeha.order_number || '';'' || ''Item: '' || oel.ordered_item description

Line 527: fnd_msg_pub.add();

523: IF ((p_plan_id is not null) AND (po_header_id is null)) THEN
524: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
525: fnd_message.set_token('DEPELEM',
526: qa_plan_element_api.get_prompt(p_plan_id, qa_ss_const.po_number));
527: fnd_msg_pub.add();
528: END IF;
529:
530: x_lov_sql := 'SELECT to_char(release_num), QLTDATE.date_to_user(release_date) ' ||
531: 'FROM po_releases pr ' ||

Line 551: fnd_msg_pub.add();

547: IF ((plan_id is not null) AND (po_number is null)) THEN
548: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
549: fnd_message.set_token('DEPELEM',
550: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.po_number));
551: fnd_msg_pub.add();
552: END IF;
553:
554: x_lov_sql := 'SELECT DISTINCT to_char(pr.release_num) release_number,
555: QLTDATE.date_to_user(pr.release_date)

Line 664: fnd_msg_pub.add();

660: IF (l_project_id is null) THEN
661: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
662: fnd_message.set_token('DEPELEM',
663: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.project_number));
664: fnd_msg_pub.add();
665: END IF;
666:
667: x_lov_sql := 'select task_number, task_name
668: from mtl_task_v

Line 741: fnd_msg_pub.add();

737: IF (p_rma_number is null) THEN
738: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
739: fnd_message.set_token('DEPELEM',
740: qa_plan_element_api.get_prompt(p_plan_id, qa_ss_const.rma_number));
741: fnd_msg_pub.add();
742: END IF;
743:
744: x_lov_sql := 'select distinct to_char(oel.line_number),''RMA Number: '' ||
745: sh.order_number || '';'' || ''Item: '' || oel.ordered_item description

Line 789: fnd_msg_pub.add();

785: IF ((plan_id is not null) and (x_item_name is null)) THEN
786: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
787: fnd_message.set_token('DEPELEM',
788: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.item));
789: fnd_msg_pub.add();
790: END IF;
791:
792: -- This procedure is used for both uom and component uom
793:

Line 848: fnd_msg_pub.add();

844: IF ((plan_id is not null) AND (x_item_name is null)) THEN
845: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
846: fnd_message.set_token('DEPELEM',
847: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.item));
848: fnd_msg_pub.add();
849: END IF;
850:
851: -- This procedure is used for both revision and component revision
852:

Line 937: fnd_msg_pub.add();

933: IF (p_item is null) THEN
934: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
935: fnd_message.set_token('DEPELEM',
936: qa_plan_element_api.get_prompt(p_plan_id, qa_ss_const.item));
937: fnd_msg_pub.add();
938: END IF;
939:
940: x_lov_sql := 'select lot_number, description
941: from mtl_lot_numbers

Line 981: fnd_msg_pub.add();

977: IF (p_comp_item is null) THEN
978: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
979: fnd_message.set_token('DEPELEM',
980: qa_plan_element_api.get_prompt(p_plan_id, qa_ss_const.comp_item));
981: fnd_msg_pub.add();
982: END IF;
983:
984: x_lov_sql := 'select lot_number, description
985: from mtl_lot_numbers

Line 1050: fnd_msg_pub.add();

1046: IF (p_item is null) THEN
1047: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
1048: fnd_message.set_token('DEPELEM',
1049: qa_plan_element_api.get_prompt(p_plan_id, qa_ss_const.item));
1050: fnd_msg_pub.add();
1051: END IF;
1052:
1053: l_item_id := qa_flex_util.get_item_id(p_org_id, p_item);
1054:

Line 1139: fnd_msg_pub.add();

1135: IF (p_comp_item is null) THEN
1136: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
1137: fnd_message.set_token('DEPELEM',
1138: qa_plan_element_api.get_prompt(p_plan_id, qa_ss_const.comp_item));
1139: fnd_msg_pub.add();
1140: END IF;
1141:
1142: l_item_id := qa_flex_util.get_item_id(p_org_id, p_comp_item);
1143:

Line 1224: fnd_msg_pub.add();

1220: IF (x_lot_number is null) THEN
1221: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
1222: fnd_message.set_token('DEPELEM',
1223: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.lot_number));
1224: fnd_msg_pub.add();
1225: END IF;
1226:
1227: x_lov_sql := 'SELECT msn.serial_number, msn.current_status
1228: FROM mtl_serial_numbers msn,

Line 1320: fnd_msg_pub.add();

1316: IF ((plan_id is not null) AND (x_asset_group is null)) THEN
1317: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
1318: fnd_message.set_token('DEPELEM',
1319: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.asset_group));
1320: fnd_msg_pub.add();
1321: END IF;
1322:
1323: --dgupta: Start R12 EAM Integration. Bug 4345492
1324: x_lov_sql := 'SELECT

Line 1405: fnd_msg_pub.add();

1401: IF (plan_id is not null) AND (job_name is null) THEN
1402: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
1403: fnd_message.set_token('DEPELEM',
1404: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.job_name));
1405: fnd_msg_pub.add();
1406: END IF;
1407:
1408: IF (production_line IS NOT NULL) THEN
1409: x_line_id := qa_plan_element_api.get_production_line_id(org_id,

Line 1515: fnd_msg_pub.add();

1511: IF ((plan_id is not null) AND (po_header_id is null)) THEN
1512: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
1513: fnd_message.set_token('DEPELEM',
1514: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.po_number));
1515: fnd_msg_pub.add();
1516: END IF;
1517:
1518: -- po_number_id := qa_plan_element_api.get_po_number_id(po_number);
1519:

Line 1569: fnd_msg_pub.add();

1565: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
1566: fnd_message.set_token('DEPELEM',
1567: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.po_number) ||
1568: ', ' || qa_plan_element_api.get_prompt(plan_id, qa_ss_const.po_line_num));
1569: fnd_msg_pub.add();
1570: END IF;
1571:
1572: -- po_number_id := qa_plan_element_api.get_po_number_id(po_number);
1573:

Line 1646: fnd_msg_pub.add();

1642: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
1643: fnd_message.set_token('DEPELEM',
1644: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.po_number) ||
1645: ', ' || qa_plan_element_api.get_prompt(plan_id, qa_ss_const.po_line_num));
1646: fnd_msg_pub.add();
1647: END IF;
1648:
1649: x_lov_sql := 'select to_char(shipment_num) shipment_number,shipment_type
1650: from po_shipments_all_v

Line 1772: fnd_msg_pub.add();

1768: IF (p_item is null) THEN
1769: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
1770: fnd_message.set_token('DEPELEM',
1771: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.item));
1772: fnd_msg_pub.add();
1773: END IF;
1774:
1775: IF (p_item is not null) THEN
1776:

Line 1863: fnd_msg_pub.add();

1859: AND (p_asset_instance_number is null)) THEN
1860: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
1861: fnd_message.set_token('DEPELEM',
1862: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.asset_group));
1863: fnd_msg_pub.add();
1864: END IF;
1865:
1866: if (p_asset_number is null and p_asset_instance_number is null) then
1867: -- show all activities asssociated to the asset group

Line 2024: fnd_msg_pub.add();

2020: IF ((plan_id is not null) AND (x_subinventory is null)) THEN
2021: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
2022: fnd_message.set_token('DEPELEM',
2023: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.subinventory));
2024: fnd_msg_pub.add();
2025: END IF;
2026:
2027: -- anagarwa Thu May 13 14:56:49 PDT 2004
2028: -- Bug 3625998: Added subinventory and disable_date to restrict the lov

Line 2102: fnd_msg_pub.add();

2098: IF (p_item is null) THEN
2099: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
2100: fnd_message.set_token('DEPELEM',
2101: qa_plan_element_api.get_prompt(p_plan_id, qa_ss_const.item));
2102: fnd_msg_pub.add();
2103: END IF;
2104:
2105: x_lov_sql := 'SELECT cii.instance_number, cii.serial_number
2106: FROM qa_csi_item_instances cii, mtl_system_items_kfv msik

Line 2153: fnd_msg_pub.add();

2149: IF (p_item is null) THEN
2150: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
2151: fnd_message.set_token('DEPELEM',
2152: qa_plan_element_api.get_prompt(p_plan_id, qa_ss_const.item));
2153: fnd_msg_pub.add();
2154: END IF;
2155:
2156: x_lov_sql := 'SELECT cii.serial_number, msik.concatenated_segments
2157: FROM qa_csi_item_instances cii, mtl_system_items_kfv msik

Line 2349: fnd_msg_pub.add();

2345: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
2346: fnd_message.set_token('DEPELEM',
2347: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.process_batch_num)
2348: );
2349: fnd_msg_pub.add();
2350: END IF;
2351:
2352: x_lov_sql := 'SELECT to_char(STEPS.BATCHSTEP_NO) ,OPS.OPRN_DESC BATCHSTEP_DESC '||
2353: 'FROM GME_BATCH_STEPS STEPS, GMD_OPERATIONS OPS '||

Line 2394: fnd_msg_pub.add();

2390: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
2391: fnd_message.set_token('DEPELEM',
2392: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.process_batch_num)
2393: );
2394: fnd_msg_pub.add();
2395: END IF;
2396:
2397: L_PROCESS_BATCHSTEP_ID := QA_PLAN_ELEMENT_API.GET_PROCESS_BATCHSTEP_ID
2398: (process_batchstep_num,L_PROCESS_BATCH_ID);

Line 2405: fnd_msg_pub.add();

2401: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
2402: fnd_message.set_token('DEPELEM',
2403: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.process_batchstep_num)
2404: );
2405: fnd_msg_pub.add();
2406: END IF;
2407:
2408: x_lov_sql := 'SELECT OPERATION PROCESS_OPERATION, OPRN_DESC '||
2409: 'FROM GMO_BATCH_STEPS_V '||

Line 2459: fnd_msg_pub.add();

2455: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
2456: fnd_message.set_token('DEPELEM',
2457: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.process_batch_num)
2458: );
2459: fnd_msg_pub.add();
2460: END IF;
2461:
2462: L_PROCESS_BATCHSTEP_ID := QA_PLAN_ELEMENT_API.GET_PROCESS_BATCHSTEP_ID
2463: (PROCESS_BATCHSTEP_NUM,L_PROCESS_BATCH_ID);

Line 2470: fnd_msg_pub.add();

2466: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
2467: fnd_message.set_token('DEPELEM',
2468: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.process_batchstep_num)
2469: );
2470: fnd_msg_pub.add();
2471: END IF;
2472:
2473: x_lov_sql := 'SELECT STEPS.ACTIVITY, ACTIVITIES.ACTIVITY_DESC '||
2474: 'FROM GME_BATCH_STEP_ACTIVITIES STEPS, GMD_ACTIVITIES ACTIVITIES '||

Line 2527: fnd_msg_pub.add();

2523: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
2524: fnd_message.set_token('DEPELEM',
2525: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.process_batch_num)
2526: );
2527: fnd_msg_pub.add();
2528: END IF;
2529:
2530: L_PROCESS_BATCHSTEP_ID := QA_PLAN_ELEMENT_API.GET_PROCESS_BATCHSTEP_ID
2531: (PROCESS_BATCHSTEP_NUM,L_PROCESS_BATCH_ID);

Line 2538: fnd_msg_pub.add();

2534: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
2535: fnd_message.set_token('DEPELEM',
2536: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.process_batchstep_num)
2537: );
2538: fnd_msg_pub.add();
2539: END IF;
2540:
2541: L_PROCESS_ACTIVITY_ID := QA_PLAN_ELEMENT_API.GET_PROCESS_ACTIVITY_ID
2542: (PROCESS_ACTIVITY,L_PROCESS_BATCH_ID,L_PROCESS_BATCHSTEP_ID);

Line 2549: fnd_msg_pub.add();

2545: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
2546: fnd_message.set_token('DEPELEM',
2547: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.process_activity)
2548: );
2549: fnd_msg_pub.add();
2550: END IF;
2551:
2552: x_lov_sql := 'SELECT GBSR.RESOURCES, CRMV.RESOURCE_DESC '||
2553: 'FROM GME_BATCH_STEP_RESOURCES GBSR, CR_RSRC_MST_VL CRMV '||

Line 2652: fnd_msg_pub.add();

2648: IF ((plan_id is not null) AND (maintenance_work_order is null)) THEN
2649: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
2650: fnd_message.set_token('DEPELEM',
2651: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.work_order));
2652: fnd_msg_pub.add();
2653: END IF;
2654: -- rkaza. 10/22/2003. 3209804.
2655: -- operation_seq_num should be made a varchar2 to be compatible with
2656: -- code and description in a dynamic lov.

Line 2781: fnd_msg_pub.add();

2777: IF ((plan_id is not null) AND (x_item_name is null)) THEN
2778: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
2779: fnd_message.set_token('DEPELEM',
2780: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.item));
2781: fnd_msg_pub.add();
2782: END IF;
2783:
2784: x_lov_sql := 'SELECT concatenated_segments, description
2785: FROM mtl_item_locations_kfv

Line 3060: -- Now that we utilize fnd_msg_pub to show error messages

3056: l_lov_sql VARCHAR2(1500);
3057:
3058: BEGIN
3059: -- Bug 3228490 ksoh Fri Oct 31 11:38:21 PST 2003
3060: -- Now that we utilize fnd_msg_pub to show error messages
3061: -- we should clear stack so that errors are not shown over and over again.
3062: fnd_msg_pub.Initialize();
3063: fnd_msg_pub.reset();
3064:

Line 3062: fnd_msg_pub.Initialize();

3058: BEGIN
3059: -- Bug 3228490 ksoh Fri Oct 31 11:38:21 PST 2003
3060: -- Now that we utilize fnd_msg_pub to show error messages
3061: -- we should clear stack so that errors are not shown over and over again.
3062: fnd_msg_pub.Initialize();
3063: fnd_msg_pub.reset();
3064:
3065: IF (char_id = qa_ss_const.department) THEN
3066: get_department_lov(org_id, value, l_lov_sql);

Line 3063: fnd_msg_pub.reset();

3059: -- Bug 3228490 ksoh Fri Oct 31 11:38:21 PST 2003
3060: -- Now that we utilize fnd_msg_pub to show error messages
3061: -- we should clear stack so that errors are not shown over and over again.
3062: fnd_msg_pub.Initialize();
3063: fnd_msg_pub.reset();
3064:
3065: IF (char_id = qa_ss_const.department) THEN
3066: get_department_lov(org_id, value, l_lov_sql);
3067: