DBA Data[Home] [Help]

APPS.QA_SS_LOV_API dependencies on FND_MESSAGE

Line 485: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');

481:
482: BEGIN
483:
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;

Line 486: fnd_message.set_token('DEPELEM',

482: BEGIN
483:
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:

Line 569: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');

565: BEGIN
566:
567: l_project_id := qa_plan_element_api.get_project_number_id(p_project_number);
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;

Line 570: fnd_message.set_token('DEPELEM',

566:
567: l_project_id := qa_plan_element_api.get_project_number_id(p_project_number);
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:

Line 646: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');

642: value IN VARCHAR2,
643: x_lov_sql OUT NOCOPY VARCHAR2) IS
644: BEGIN
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;

Line 647: fnd_message.set_token('DEPELEM',

643: x_lov_sql OUT NOCOPY VARCHAR2) IS
644: BEGIN
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:

Line 694: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');

690: -- x_item_id NUMBER DEFAULT NULL;
691:
692: BEGIN
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;

Line 695: fnd_message.set_token('DEPELEM',

691:
692: BEGIN
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:

Line 753: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');

749: -- x_item_id NUMBER DEFAULT NULL;
750:
751: BEGIN
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;

Line 754: fnd_message.set_token('DEPELEM',

750:
751: BEGIN
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:

Line 842: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');

838: x_lov_sql OUT NOCOPY VARCHAR2) IS
839: BEGIN
840:
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;

Line 843: fnd_message.set_token('DEPELEM',

839: BEGIN
840:
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:

Line 886: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');

882: x_lov_sql OUT NOCOPY VARCHAR2) IS
883: -- l_lov_sql VARCHAR2(300);
884: BEGIN
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;

Line 887: fnd_message.set_token('DEPELEM',

883: -- l_lov_sql VARCHAR2(300);
884: BEGIN
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:

Line 955: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');

951: j NUMBER;
952: BEGIN
953:
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;

Line 956: fnd_message.set_token('DEPELEM',

952: BEGIN
953:
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:

Line 1044: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');

1040: j NUMBER;
1041: BEGIN
1042:
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;

Line 1045: fnd_message.set_token('DEPELEM',

1041: BEGIN
1042:
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:

Line 1129: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');

1125:
1126: BEGIN
1127: /*
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;

Line 1130: fnd_message.set_token('DEPELEM',

1126: BEGIN
1127: /*
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:

Line 1225: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');

1221: value IN VARCHAR2, x_lov_sql OUT NOCOPY VARCHAR2) IS
1222:
1223: BEGIN
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;

Line 1226: fnd_message.set_token('DEPELEM',

1222:
1223: BEGIN
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:

Line 1310: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');

1306: -- to/from op seq number only job is the required field. Production line is
1307: -- used only if present. Hence changing the following if condition to look
1308: -- for job only.
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;

Line 1311: fnd_message.set_token('DEPELEM',

1307: -- used only if present. Hence changing the following if condition to look
1308: -- for job only.
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:

Line 1420: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');

1416: BEGIN
1417: -- MOAC. Just changed the name becuase we are not using po_header_id
1418: -- in this method except for this dependency check.
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;

Line 1421: fnd_message.set_token('DEPELEM',

1417: -- MOAC. Just changed the name becuase we are not using po_header_id
1418: -- in this method except for this dependency check.
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:

Line 1469: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');

1465: -- po_number_id NUMBER;
1466:
1467: BEGIN
1468: IF ((plan_id is not null) AND ((po_header_id is null) OR (po_line_num is null))) THEN
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();

Line 1470: fnd_message.set_token('DEPELEM',

1466:
1467: BEGIN
1468: IF ((plan_id is not null) AND ((po_header_id is null) OR (po_line_num is null))) THEN
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;

Line 1575: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');

1571: -- l_item_id NUMBER DEFAULT NULL;
1572: BEGIN
1573:
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;

Line 1576: fnd_message.set_token('DEPELEM',

1572: BEGIN
1573:
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:

Line 1666: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');

1662: -- Dependency on Asset Number is not a must. So removed it from the check.
1663: -- dgupta: Added that either asset group or asset instance number be present
1664: IF ((plan_id is not null) AND (p_asset_group is null)
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;

Line 1667: fnd_message.set_token('DEPELEM',

1663: -- dgupta: Added that either asset group or asset instance number be present
1664: IF ((plan_id is not null) AND (p_asset_group is null)
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:

Line 1827: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');

1823: x_lov_sql OUT NOCOPY VARCHAR2) IS
1824:
1825: BEGIN
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;

Line 1828: fnd_message.set_token('DEPELEM',

1824:
1825: BEGIN
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:

Line 2048: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');

2044: BEGIN
2045: l_process_batch_id := qa_plan_element_api.get_process_batch_id (process_batch_num, org_id);
2046:
2047: IF (l_process_batch_id is null) THEN
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();

Line 2049: fnd_message.set_token('DEPELEM',

2045: l_process_batch_id := qa_plan_element_api.get_process_batch_id (process_batch_num, org_id);
2046:
2047: IF (l_process_batch_id is null) THEN
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;

Line 2093: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');

2089: BEGIN
2090: L_PROCESS_BATCH_ID := QA_PLAN_ELEMENT_API.GET_PROCESS_BATCH_ID(PROCESS_BATCH_NUM,ORG_ID);
2091:
2092: IF (l_process_batch_id is null) THEN
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();

Line 2094: fnd_message.set_token('DEPELEM',

2090: L_PROCESS_BATCH_ID := QA_PLAN_ELEMENT_API.GET_PROCESS_BATCH_ID(PROCESS_BATCH_NUM,ORG_ID);
2091:
2092: IF (l_process_batch_id is null) THEN
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;

Line 2104: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');

2100: L_PROCESS_BATCHSTEP_ID := QA_PLAN_ELEMENT_API.GET_PROCESS_BATCHSTEP_ID
2101: (process_batchstep_num,L_PROCESS_BATCH_ID);
2102:
2103: IF (l_process_batchstep_id is null) THEN
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();

Line 2105: fnd_message.set_token('DEPELEM',

2101: (process_batchstep_num,L_PROCESS_BATCH_ID);
2102:
2103: IF (l_process_batchstep_id is null) THEN
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;

Line 2158: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');

2154: BEGIN
2155: L_PROCESS_BATCH_ID := QA_PLAN_ELEMENT_API.GET_PROCESS_BATCH_ID(PROCESS_BATCH_NUM,ORG_ID);
2156:
2157: IF (l_process_batch_id is null) THEN
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();

Line 2159: fnd_message.set_token('DEPELEM',

2155: L_PROCESS_BATCH_ID := QA_PLAN_ELEMENT_API.GET_PROCESS_BATCH_ID(PROCESS_BATCH_NUM,ORG_ID);
2156:
2157: IF (l_process_batch_id is null) THEN
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;

Line 2169: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');

2165: L_PROCESS_BATCHSTEP_ID := QA_PLAN_ELEMENT_API.GET_PROCESS_BATCHSTEP_ID
2166: (PROCESS_BATCHSTEP_NUM,L_PROCESS_BATCH_ID);
2167:
2168: IF (l_process_batchstep_id is null) THEN
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();

Line 2170: fnd_message.set_token('DEPELEM',

2166: (PROCESS_BATCHSTEP_NUM,L_PROCESS_BATCH_ID);
2167:
2168: IF (l_process_batchstep_id is null) THEN
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;

Line 2226: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');

2222: BEGIN
2223: L_PROCESS_BATCH_ID := QA_PLAN_ELEMENT_API.GET_PROCESS_BATCH_ID(PROCESS_BATCH_NUM,ORG_ID);
2224:
2225: IF (l_process_batch_id is null) THEN
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();

Line 2227: fnd_message.set_token('DEPELEM',

2223: L_PROCESS_BATCH_ID := QA_PLAN_ELEMENT_API.GET_PROCESS_BATCH_ID(PROCESS_BATCH_NUM,ORG_ID);
2224:
2225: IF (l_process_batch_id is null) THEN
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;

Line 2237: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');

2233: L_PROCESS_BATCHSTEP_ID := QA_PLAN_ELEMENT_API.GET_PROCESS_BATCHSTEP_ID
2234: (PROCESS_BATCHSTEP_NUM,L_PROCESS_BATCH_ID);
2235:
2236: IF (l_process_batchstep_id is null) THEN
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();

Line 2238: fnd_message.set_token('DEPELEM',

2234: (PROCESS_BATCHSTEP_NUM,L_PROCESS_BATCH_ID);
2235:
2236: IF (l_process_batchstep_id is null) THEN
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;

Line 2248: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');

2244: L_PROCESS_ACTIVITY_ID := QA_PLAN_ELEMENT_API.GET_PROCESS_ACTIVITY_ID
2245: (PROCESS_ACTIVITY,L_PROCESS_BATCH_ID,L_PROCESS_BATCHSTEP_ID);
2246:
2247: IF (l_process_activity_id is null) THEN
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();

Line 2249: fnd_message.set_token('DEPELEM',

2245: (PROCESS_ACTIVITY,L_PROCESS_BATCH_ID,L_PROCESS_BATCHSTEP_ID);
2246:
2247: IF (l_process_activity_id is null) THEN
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;

Line 2352: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');

2348: x_wip_entity_id NUMBER DEFAULT NULL;
2349:
2350: BEGIN
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;

Line 2353: fnd_message.set_token('DEPELEM',

2349:
2350: BEGIN
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.

Line 2481: fnd_message.set_name('QA', 'QA_SSQR_DEPENDENT_LOV');

2477: -- comment out my changes and write new logic here.
2478: get_locator_lov(plan_id, org_id, x_subinventory, value, x_lov_sql);
2479: /*
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;

Line 2482: fnd_message.set_token('DEPELEM',

2478: get_locator_lov(plan_id, org_id, x_subinventory, value, x_lov_sql);
2479: /*
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: