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 488: fnd_msg_pub.add();

484: IF ((p_plan_id is not null) AND (po_header_id is null)) THEN
485: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
486: fnd_message.set_token('DEPELEM',
487: qa_plan_element_api.get_prompt(p_plan_id, qa_ss_const.po_number));
488: fnd_msg_pub.add();
489: END IF;
490:
491: x_lov_sql := 'SELECT to_char(release_num), QLTDATE.date_to_user(release_date) ' ||
492: 'FROM po_releases pr ' ||

Line 572: fnd_msg_pub.add();

568: IF (l_project_id is null) THEN
569: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
570: fnd_message.set_token('DEPELEM',
571: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.project_number));
572: fnd_msg_pub.add();
573: END IF;
574:
575: x_lov_sql := 'select task_number, task_name
576: from mtl_task_v

Line 649: fnd_msg_pub.add();

645: IF (p_rma_number is null) THEN
646: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
647: fnd_message.set_token('DEPELEM',
648: qa_plan_element_api.get_prompt(p_plan_id, qa_ss_const.rma_number));
649: fnd_msg_pub.add();
650: END IF;
651:
652: x_lov_sql := 'select distinct to_char(oel.line_number),''RMA Number: '' ||
653: sh.order_number || '';'' || ''Item: '' || oel.ordered_item description

Line 697: fnd_msg_pub.add();

693: IF ((plan_id is not null) and (x_item_name is null)) THEN
694: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
695: fnd_message.set_token('DEPELEM',
696: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.item));
697: fnd_msg_pub.add();
698: END IF;
699:
700: -- This procedure is used for both uom and component uom
701:

Line 756: fnd_msg_pub.add();

752: IF ((plan_id is not null) AND (x_item_name is null)) THEN
753: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
754: fnd_message.set_token('DEPELEM',
755: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.item));
756: fnd_msg_pub.add();
757: END IF;
758:
759: -- This procedure is used for both revision and component revision
760:

Line 845: fnd_msg_pub.add();

841: IF (p_item is null) THEN
842: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
843: fnd_message.set_token('DEPELEM',
844: qa_plan_element_api.get_prompt(p_plan_id, qa_ss_const.item));
845: fnd_msg_pub.add();
846: END IF;
847:
848: x_lov_sql := 'select lot_number, description
849: from mtl_lot_numbers

Line 889: fnd_msg_pub.add();

885: IF (p_comp_item is null) THEN
886: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
887: fnd_message.set_token('DEPELEM',
888: qa_plan_element_api.get_prompt(p_plan_id, qa_ss_const.comp_item));
889: fnd_msg_pub.add();
890: END IF;
891:
892: x_lov_sql := 'select lot_number, description
893: from mtl_lot_numbers

Line 958: fnd_msg_pub.add();

954: IF (p_item is null) THEN
955: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
956: fnd_message.set_token('DEPELEM',
957: qa_plan_element_api.get_prompt(p_plan_id, qa_ss_const.item));
958: fnd_msg_pub.add();
959: END IF;
960:
961: l_item_id := qa_flex_util.get_item_id(p_org_id, p_item);
962:

Line 1047: fnd_msg_pub.add();

1043: IF (p_comp_item is null) THEN
1044: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
1045: fnd_message.set_token('DEPELEM',
1046: qa_plan_element_api.get_prompt(p_plan_id, qa_ss_const.comp_item));
1047: fnd_msg_pub.add();
1048: END IF;
1049:
1050: l_item_id := qa_flex_util.get_item_id(p_org_id, p_comp_item);
1051:

Line 1132: fnd_msg_pub.add();

1128: IF (x_lot_number is null) THEN
1129: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
1130: fnd_message.set_token('DEPELEM',
1131: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.lot_number));
1132: fnd_msg_pub.add();
1133: END IF;
1134:
1135: x_lov_sql := 'SELECT msn.serial_number, msn.current_status
1136: FROM mtl_serial_numbers msn,

Line 1228: fnd_msg_pub.add();

1224: IF ((plan_id is not null) AND (x_asset_group is null)) THEN
1225: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
1226: fnd_message.set_token('DEPELEM',
1227: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.asset_group));
1228: fnd_msg_pub.add();
1229: END IF;
1230:
1231: --dgupta: Start R12 EAM Integration. Bug 4345492
1232: x_lov_sql := 'SELECT

Line 1313: fnd_msg_pub.add();

1309: IF (plan_id is not null) AND (job_name is null) THEN
1310: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
1311: fnd_message.set_token('DEPELEM',
1312: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.job_name));
1313: fnd_msg_pub.add();
1314: END IF;
1315:
1316: IF (production_line IS NOT NULL) THEN
1317: x_line_id := qa_plan_element_api.get_production_line_id(org_id,

Line 1423: fnd_msg_pub.add();

1419: IF ((plan_id is not null) AND (po_header_id is null)) THEN
1420: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
1421: fnd_message.set_token('DEPELEM',
1422: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.po_number));
1423: fnd_msg_pub.add();
1424: END IF;
1425:
1426: -- po_number_id := qa_plan_element_api.get_po_number_id(po_number);
1427:

Line 1473: fnd_msg_pub.add();

1469: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
1470: fnd_message.set_token('DEPELEM',
1471: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.po_number) ||
1472: ', ' || qa_plan_element_api.get_prompt(plan_id, qa_ss_const.po_line_num));
1473: fnd_msg_pub.add();
1474: END IF;
1475:
1476: -- po_number_id := qa_plan_element_api.get_po_number_id(po_number);
1477:

Line 1578: fnd_msg_pub.add();

1574: IF (p_item is null) THEN
1575: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
1576: fnd_message.set_token('DEPELEM',
1577: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.item));
1578: fnd_msg_pub.add();
1579: END IF;
1580:
1581: IF (p_item is not null) THEN
1582:

Line 1669: fnd_msg_pub.add();

1665: AND (p_asset_instance_number is null)) THEN
1666: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
1667: fnd_message.set_token('DEPELEM',
1668: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.asset_group));
1669: fnd_msg_pub.add();
1670: END IF;
1671:
1672: if (p_asset_number is null and p_asset_instance_number is null) then
1673: -- show all activities asssociated to the asset group

Line 1830: fnd_msg_pub.add();

1826: IF ((plan_id is not null) AND (x_subinventory is null)) THEN
1827: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
1828: fnd_message.set_token('DEPELEM',
1829: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.subinventory));
1830: fnd_msg_pub.add();
1831: END IF;
1832:
1833: -- anagarwa Thu May 13 14:56:49 PDT 2004
1834: -- Bug 3625998: Added subinventory and disable_date to restrict the lov

Line 2052: fnd_msg_pub.add();

2048: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
2049: fnd_message.set_token('DEPELEM',
2050: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.process_batch_num)
2051: );
2052: fnd_msg_pub.add();
2053: END IF;
2054:
2055: x_lov_sql := 'SELECT to_char(STEPS.BATCHSTEP_NO) ,OPS.OPRN_DESC BATCHSTEP_DESC '||
2056: 'FROM GME_BATCH_STEPS STEPS, GMD_OPERATIONS OPS '||

Line 2097: fnd_msg_pub.add();

2093: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
2094: fnd_message.set_token('DEPELEM',
2095: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.process_batch_num)
2096: );
2097: fnd_msg_pub.add();
2098: END IF;
2099:
2100: L_PROCESS_BATCHSTEP_ID := QA_PLAN_ELEMENT_API.GET_PROCESS_BATCHSTEP_ID
2101: (process_batchstep_num,L_PROCESS_BATCH_ID);

Line 2108: fnd_msg_pub.add();

2104: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
2105: fnd_message.set_token('DEPELEM',
2106: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.process_batchstep_num)
2107: );
2108: fnd_msg_pub.add();
2109: END IF;
2110:
2111: x_lov_sql := 'SELECT OPERATION PROCESS_OPERATION, OPRN_DESC '||
2112: 'FROM GMO_BATCH_STEPS_V '||

Line 2162: fnd_msg_pub.add();

2158: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
2159: fnd_message.set_token('DEPELEM',
2160: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.process_batch_num)
2161: );
2162: fnd_msg_pub.add();
2163: END IF;
2164:
2165: L_PROCESS_BATCHSTEP_ID := QA_PLAN_ELEMENT_API.GET_PROCESS_BATCHSTEP_ID
2166: (PROCESS_BATCHSTEP_NUM,L_PROCESS_BATCH_ID);

Line 2173: fnd_msg_pub.add();

2169: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
2170: fnd_message.set_token('DEPELEM',
2171: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.process_batchstep_num)
2172: );
2173: fnd_msg_pub.add();
2174: END IF;
2175:
2176: x_lov_sql := 'SELECT STEPS.ACTIVITY, ACTIVITIES.ACTIVITY_DESC '||
2177: 'FROM GME_BATCH_STEP_ACTIVITIES STEPS, GMD_ACTIVITIES ACTIVITIES '||

Line 2230: fnd_msg_pub.add();

2226: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
2227: fnd_message.set_token('DEPELEM',
2228: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.process_batch_num)
2229: );
2230: fnd_msg_pub.add();
2231: END IF;
2232:
2233: L_PROCESS_BATCHSTEP_ID := QA_PLAN_ELEMENT_API.GET_PROCESS_BATCHSTEP_ID
2234: (PROCESS_BATCHSTEP_NUM,L_PROCESS_BATCH_ID);

Line 2241: fnd_msg_pub.add();

2237: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
2238: fnd_message.set_token('DEPELEM',
2239: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.process_batchstep_num)
2240: );
2241: fnd_msg_pub.add();
2242: END IF;
2243:
2244: L_PROCESS_ACTIVITY_ID := QA_PLAN_ELEMENT_API.GET_PROCESS_ACTIVITY_ID
2245: (PROCESS_ACTIVITY,L_PROCESS_BATCH_ID,L_PROCESS_BATCHSTEP_ID);

Line 2252: fnd_msg_pub.add();

2248: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
2249: fnd_message.set_token('DEPELEM',
2250: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.process_activity)
2251: );
2252: fnd_msg_pub.add();
2253: END IF;
2254:
2255: x_lov_sql := 'SELECT GBSR.RESOURCES, CRMV.RESOURCE_DESC '||
2256: 'FROM GME_BATCH_STEP_RESOURCES GBSR, CR_RSRC_MST_VL CRMV '||

Line 2355: fnd_msg_pub.add();

2351: IF ((plan_id is not null) AND (maintenance_work_order is null)) THEN
2352: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
2353: fnd_message.set_token('DEPELEM',
2354: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.work_order));
2355: fnd_msg_pub.add();
2356: END IF;
2357: -- rkaza. 10/22/2003. 3209804.
2358: -- operation_seq_num should be made a varchar2 to be compatible with
2359: -- code and description in a dynamic lov.

Line 2484: fnd_msg_pub.add();

2480: IF ((plan_id is not null) AND (x_item_name is null)) THEN
2481: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');
2482: fnd_message.set_token('DEPELEM',
2483: qa_plan_element_api.get_prompt(plan_id, qa_ss_const.item));
2484: fnd_msg_pub.add();
2485: END IF;
2486:
2487: x_lov_sql := 'SELECT concatenated_segments, description
2488: FROM mtl_item_locations_kfv

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

2728: l_lov_sql VARCHAR2(1500);
2729:
2730: BEGIN
2731: -- Bug 3228490 ksoh Fri Oct 31 11:38:21 PST 2003
2732: -- Now that we utilize fnd_msg_pub to show error messages
2733: -- we should clear stack so that errors are not shown over and over again.
2734: fnd_msg_pub.Initialize();
2735: fnd_msg_pub.reset();
2736:

Line 2734: fnd_msg_pub.Initialize();

2730: BEGIN
2731: -- Bug 3228490 ksoh Fri Oct 31 11:38:21 PST 2003
2732: -- Now that we utilize fnd_msg_pub to show error messages
2733: -- we should clear stack so that errors are not shown over and over again.
2734: fnd_msg_pub.Initialize();
2735: fnd_msg_pub.reset();
2736:
2737: IF (char_id = qa_ss_const.department) THEN
2738: get_department_lov(org_id, value, l_lov_sql);

Line 2735: fnd_msg_pub.reset();

2731: -- Bug 3228490 ksoh Fri Oct 31 11:38:21 PST 2003
2732: -- Now that we utilize fnd_msg_pub to show error messages
2733: -- we should clear stack so that errors are not shown over and over again.
2734: fnd_msg_pub.Initialize();
2735: fnd_msg_pub.reset();
2736:
2737: IF (char_id = qa_ss_const.department) THEN
2738: get_department_lov(org_id, value, l_lov_sql);
2739: