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_MESSAGE

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

475: x_lov_sql OUT NOCOPY VARCHAR2) IS
476: BEGIN
477:
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;

Line 480: fnd_message.set_token('DEPELEM',

476: BEGIN
477:
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:

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

520:
521: BEGIN
522:
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;

Line 525: fnd_message.set_token('DEPELEM',

521: BEGIN
522:
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:

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

544: value IN VARCHAR2, x_lov_sql OUT NOCOPY VARCHAR2) IS
545:
546: BEGIN
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;

Line 549: fnd_message.set_token('DEPELEM',

545:
546: BEGIN
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:

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

657: BEGIN
658:
659: l_project_id := qa_plan_element_api.get_project_number_id(p_project_number);
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;

Line 662: fnd_message.set_token('DEPELEM',

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

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

734: value IN VARCHAR2,
735: x_lov_sql OUT NOCOPY VARCHAR2) IS
736: BEGIN
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;

Line 739: fnd_message.set_token('DEPELEM',

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

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

782: -- x_item_id NUMBER DEFAULT NULL;
783:
784: BEGIN
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;

Line 787: fnd_message.set_token('DEPELEM',

783:
784: BEGIN
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:

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

841: -- x_item_id NUMBER DEFAULT NULL;
842:
843: BEGIN
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;

Line 846: fnd_message.set_token('DEPELEM',

842:
843: BEGIN
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:

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

930: x_lov_sql OUT NOCOPY VARCHAR2) IS
931: BEGIN
932:
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;

Line 935: fnd_message.set_token('DEPELEM',

931: BEGIN
932:
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:

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

974: x_lov_sql OUT NOCOPY VARCHAR2) IS
975: -- l_lov_sql VARCHAR2(300);
976: BEGIN
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;

Line 979: fnd_message.set_token('DEPELEM',

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

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

1043: j NUMBER;
1044: BEGIN
1045:
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;

Line 1048: fnd_message.set_token('DEPELEM',

1044: BEGIN
1045:
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:

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

1132: j NUMBER;
1133: BEGIN
1134:
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;

Line 1137: fnd_message.set_token('DEPELEM',

1133: BEGIN
1134:
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:

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

1217:
1218: BEGIN
1219: /*
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;

Line 1222: fnd_message.set_token('DEPELEM',

1218: BEGIN
1219: /*
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:

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

1313: value IN VARCHAR2, x_lov_sql OUT NOCOPY VARCHAR2) IS
1314:
1315: BEGIN
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;

Line 1318: fnd_message.set_token('DEPELEM',

1314:
1315: BEGIN
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:

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

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

Line 1403: fnd_message.set_token('DEPELEM',

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

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

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

Line 1513: fnd_message.set_token('DEPELEM',

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

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

1561: -- po_number_id NUMBER;
1562:
1563: BEGIN
1564: IF ((plan_id is not null) AND ((po_header_id is null) OR (po_line_num is null))) THEN
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();

Line 1566: fnd_message.set_token('DEPELEM',

1562:
1563: BEGIN
1564: IF ((plan_id is not null) AND ((po_header_id is null) OR (po_line_num is null))) THEN
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;

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

1638: po_release_num IN NUMBER, value IN VARCHAR2, x_lov_sql OUT NOCOPY VARCHAR2) IS
1639:
1640: BEGIN
1641: IF ((plan_id is not null) AND ((po_header_id is null) OR (po_line_num is null))) THEN
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();

Line 1643: fnd_message.set_token('DEPELEM',

1639:
1640: BEGIN
1641: IF ((plan_id is not null) AND ((po_header_id is null) OR (po_line_num is null))) THEN
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;

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

1765: -- l_item_id NUMBER DEFAULT NULL;
1766: BEGIN
1767:
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;

Line 1770: fnd_message.set_token('DEPELEM',

1766: BEGIN
1767:
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:

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

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

Line 1861: fnd_message.set_token('DEPELEM',

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

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

2017: x_lov_sql OUT NOCOPY VARCHAR2) IS
2018:
2019: BEGIN
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;

Line 2022: fnd_message.set_token('DEPELEM',

2018:
2019: BEGIN
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:

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

2095: value IN VARCHAR2, x_lov_sql OUT NOCOPY VARCHAR2) IS
2096:
2097: BEGIN
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;

Line 2100: fnd_message.set_token('DEPELEM',

2096:
2097: BEGIN
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:

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

2146: value IN VARCHAR2, x_lov_sql OUT NOCOPY VARCHAR2) IS
2147:
2148: BEGIN
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;

Line 2151: fnd_message.set_token('DEPELEM',

2147:
2148: BEGIN
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:

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

2341: BEGIN
2342: l_process_batch_id := qa_plan_element_api.get_process_batch_id (process_batch_num, org_id);
2343:
2344: IF (l_process_batch_id is null) THEN
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();

Line 2346: fnd_message.set_token('DEPELEM',

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

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

2386: BEGIN
2387: L_PROCESS_BATCH_ID := QA_PLAN_ELEMENT_API.GET_PROCESS_BATCH_ID(PROCESS_BATCH_NUM,ORG_ID);
2388:
2389: IF (l_process_batch_id is null) THEN
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();

Line 2391: fnd_message.set_token('DEPELEM',

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

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

2397: L_PROCESS_BATCHSTEP_ID := QA_PLAN_ELEMENT_API.GET_PROCESS_BATCHSTEP_ID
2398: (process_batchstep_num,L_PROCESS_BATCH_ID);
2399:
2400: IF (l_process_batchstep_id is null) THEN
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();

Line 2402: fnd_message.set_token('DEPELEM',

2398: (process_batchstep_num,L_PROCESS_BATCH_ID);
2399:
2400: IF (l_process_batchstep_id is null) THEN
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;

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

2451: BEGIN
2452: L_PROCESS_BATCH_ID := QA_PLAN_ELEMENT_API.GET_PROCESS_BATCH_ID(PROCESS_BATCH_NUM,ORG_ID);
2453:
2454: IF (l_process_batch_id is null) THEN
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();

Line 2456: fnd_message.set_token('DEPELEM',

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

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

2462: L_PROCESS_BATCHSTEP_ID := QA_PLAN_ELEMENT_API.GET_PROCESS_BATCHSTEP_ID
2463: (PROCESS_BATCHSTEP_NUM,L_PROCESS_BATCH_ID);
2464:
2465: IF (l_process_batchstep_id is null) THEN
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();

Line 2467: fnd_message.set_token('DEPELEM',

2463: (PROCESS_BATCHSTEP_NUM,L_PROCESS_BATCH_ID);
2464:
2465: IF (l_process_batchstep_id is null) THEN
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;

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

2519: BEGIN
2520: L_PROCESS_BATCH_ID := QA_PLAN_ELEMENT_API.GET_PROCESS_BATCH_ID(PROCESS_BATCH_NUM,ORG_ID);
2521:
2522: IF (l_process_batch_id is null) THEN
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();

Line 2524: fnd_message.set_token('DEPELEM',

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

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

2530: L_PROCESS_BATCHSTEP_ID := QA_PLAN_ELEMENT_API.GET_PROCESS_BATCHSTEP_ID
2531: (PROCESS_BATCHSTEP_NUM,L_PROCESS_BATCH_ID);
2532:
2533: IF (l_process_batchstep_id is null) THEN
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();

Line 2535: fnd_message.set_token('DEPELEM',

2531: (PROCESS_BATCHSTEP_NUM,L_PROCESS_BATCH_ID);
2532:
2533: IF (l_process_batchstep_id is null) THEN
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;

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

2541: L_PROCESS_ACTIVITY_ID := QA_PLAN_ELEMENT_API.GET_PROCESS_ACTIVITY_ID
2542: (PROCESS_ACTIVITY,L_PROCESS_BATCH_ID,L_PROCESS_BATCHSTEP_ID);
2543:
2544: IF (l_process_activity_id is null) THEN
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();

Line 2546: fnd_message.set_token('DEPELEM',

2542: (PROCESS_ACTIVITY,L_PROCESS_BATCH_ID,L_PROCESS_BATCHSTEP_ID);
2543:
2544: IF (l_process_activity_id is null) THEN
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;

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

2645: x_wip_entity_id NUMBER DEFAULT NULL;
2646:
2647: BEGIN
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;

Line 2650: fnd_message.set_token('DEPELEM',

2646:
2647: BEGIN
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.

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

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

Line 2779: fnd_message.set_token('DEPELEM',

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