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.MSD_SPF_COLLECT_HISTORY_DATA dependencies on FND_REQUEST

Line 617: var_request_id := fnd_request.submit_request ('MSD', 'MSDDEMPSP', NULL, NULL, FALSE,

613:
614: /* Launch Push Setup Parameters */
615: BEGIN
616: var_request_id := null;
617: var_request_id := fnd_request.submit_request ('MSD', 'MSDDEMPSP', NULL, NULL, FALSE,
618: p_sr_instance_id, p_collection_group, G_YES);
619: EXCEPTION
620: WHEN OTHERS THEN
621: retcode := -1;

Line 653: var_request_id := fnd_request.submit_request ('MSD', 'MSDSRPLD', NULL, NULL, FALSE,

649:
650: /* Usage */
651: BEGIN
652: var_request_id := null;
653: var_request_id := fnd_request.submit_request ('MSD', 'MSDSRPLD', NULL, NULL, FALSE,
654: p_sr_instance_id, 1440, p_file_separator, p_control_file_path, p_data_file_path, 3,
655: null, null, null, null, null, null, null, null, null, null, null, null,
656: null, null, null, null, null, null, null, null, null, null, null, null,
657: null, null, null, null, null, 1, null, null, null, null, null, null,

Line 687: var_request_id := fnd_request.submit_request ('MSD', 'MSDDEMLD', NULL, NULL, FALSE,

683: /* Launch Shipment Flat File Load */ -- Bug#12675064
684: IF (p_shipment_data = G_YES AND p_usage_flat_file = G_YES) THEN
685: BEGIN
686: var_request_id := null;
687: var_request_id := fnd_request.submit_request ('MSD', 'MSDDEMLD', NULL, NULL, FALSE,
688: p_sr_instance_id, 1440, p_file_separator, p_control_file_path, p_data_file_path, 3, null,
689: null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null,
690: null, null, null, null, null, null, null, null, null, null, p_data_file_name, p_auto_run_download);
691: EXCEPTION

Line 755: var_request_id := fnd_request.submit_request ('MSD', 'MSDSPFLCF', NULL, NULL, FALSE, G_YES);

751: THEN
752:
753: BEGIN
754: var_request_id := null;
755: var_request_id := fnd_request.submit_request ('MSD', 'MSDSPFLCF', NULL, NULL, FALSE, G_YES);
756: EXCEPTION
757: WHEN OTHERS THEN
758: retcode := -1;
759: errbuf := substr(SQLERRM,1,150);

Line 787: /*var_request_id := fnd_request.submit_request ('MSD', 'MSDDEMCHD', NULL, NULL, FALSE,

783:
784: BEGIN
785: var_request_id := null;
786: -- Bug#12675064
787: /*var_request_id := fnd_request.submit_request ('MSD', 'MSDDEMCHD', NULL, NULL, FALSE,
788: p_sr_instance_id, p_collection_group, p_collection_method, null, p_date_range_type, p_collection_window, p_char_from_date, p_char_to_date,
789: G_NO, G_NO, G_NO, G_NO, G_YES, G_NO, G_NO, G_NO, G_NO, G_YES, null, null, p_auto_run_download, G_YES);*/
790: var_request_id := fnd_request.submit_request('MSD', 'MSDSPFCSSH', NULL, NULL, FALSE,
791: p_sr_instance_id, p_collection_method, fnd_date.date_to_canonical(p_from_date), fnd_date.date_to_canonical(p_to_date));

Line 790: var_request_id := fnd_request.submit_request('MSD', 'MSDSPFCSSH', NULL, NULL, FALSE,

786: -- Bug#12675064
787: /*var_request_id := fnd_request.submit_request ('MSD', 'MSDDEMCHD', NULL, NULL, FALSE,
788: p_sr_instance_id, p_collection_group, p_collection_method, null, p_date_range_type, p_collection_window, p_char_from_date, p_char_to_date,
789: G_NO, G_NO, G_NO, G_NO, G_YES, G_NO, G_NO, G_NO, G_NO, G_YES, null, null, p_auto_run_download, G_YES);*/
790: var_request_id := fnd_request.submit_request('MSD', 'MSDSPFCSSH', NULL, NULL, FALSE,
791: p_sr_instance_id, p_collection_method, fnd_date.date_to_canonical(p_from_date), fnd_date.date_to_canonical(p_to_date));
792: EXCEPTION
793: WHEN OTHERS THEN
794: retcode := -1;

Line 823: var_request_id := fnd_request.submit_request ('MSD', 'MSDSPFCSUH', NULL, NULL, FALSE,

819:
820: /* Usage */
821: BEGIN
822: var_request_id := null;
823: var_request_id := fnd_request.submit_request ('MSD', 'MSDSPFCSUH', NULL, NULL, FALSE,
824: p_sr_instance_id, p_collection_method, fnd_date.date_to_canonical(p_from_date), fnd_date.date_to_canonical(p_to_date), G_YES);
825: EXCEPTION
826: WHEN OTHERS THEN
827: retcode := -1;

Line 881: var_request_id := fnd_request.submit_request ('MSD', 'MSDSPFUPP', NULL, NULL, FALSE, p_sr_instance_id);

877:
878: /* Pre-Process data in msd_spf_st_spare_usage */
879: BEGIN
880: var_request_id := null;
881: var_request_id := fnd_request.submit_request ('MSD', 'MSDSPFUPP', NULL, NULL, FALSE, p_sr_instance_id);
882: EXCEPTION
883: WHEN OTHERS THEN
884: retcode := -1;
885: errbuf := substr(SQLERRM,1,150);

Line 913: var_request_id := fnd_request.submit_request ('MSD', 'MSDSPFDSC', NULL, NULL, FALSE, p_sr_instance_id);

909:
910: /* Supersession Chain */
911: BEGIN
912: var_request_id := null;
913: var_request_id := fnd_request.submit_request ('MSD', 'MSDSPFDSC', NULL, NULL, FALSE, p_sr_instance_id);
914: EXCEPTION
915: WHEN OTHERS THEN
916: retcode := -1;
917: errbuf := substr(SQLERRM,1,150);

Line 1000: var_request_id := fnd_request.submit_request ('MSD', 'MSDSPFCID', NULL, NULL, FALSE,

996: IF (p_install_base = G_YES)
997: THEN
998: BEGIN
999: var_request_id := null;
1000: var_request_id := fnd_request.submit_request ('MSD', 'MSDSPFCID', NULL, NULL, FALSE,
1001: p_sr_instance_id, p_collection_method, fnd_date.date_to_canonical(p_from_date), fnd_date.date_to_canonical(p_to_date), p_custom_ibuc_hist_view);
1002: EXCEPTION
1003: WHEN OTHERS THEN
1004: retcode := -1;

Line 1031: var_request_id := fnd_request.submit_request ('MSD', 'MSDSPFDSB', NULL, NULL, FALSE, p_sr_instance_id, p_install_base, fnd_date.date_to_canonical(p_from_date), fnd_date.date_to_canonical(p_to_date), p_custom_ibuc_hist_view);

1027: IF (p_usage_data = G_YES OR p_install_base = G_YES OR p_shipment_data = G_YES) -- Bug#12675064
1028: THEN
1029: BEGIN
1030: var_request_id := null;
1031: var_request_id := fnd_request.submit_request ('MSD', 'MSDSPFDSB', NULL, NULL, FALSE, p_sr_instance_id, p_install_base, fnd_date.date_to_canonical(p_from_date), fnd_date.date_to_canonical(p_to_date), p_custom_ibuc_hist_view);
1032: EXCEPTION
1033: WHEN OTHERS THEN
1034: retcode := -1;
1035: errbuf := substr(SQLERRM,1,150);

Line 1102: var_request_id := fnd_request.submit_request ('MSD', 'MSDSPFPST', NULL, NULL, FALSE, 'EQ_SPF_BASE_MODEL', p_sr_instance_id);

1098:
1099: /* BIIO_SPF_BASE_MODEL */
1100: BEGIN
1101: var_request_id := null;
1102: var_request_id := fnd_request.submit_request ('MSD', 'MSDSPFPST', NULL, NULL, FALSE, 'EQ_SPF_BASE_MODEL', p_sr_instance_id);
1103: EXCEPTION
1104: WHEN OTHERS THEN
1105: retcode := -1;
1106: errbuf := substr(SQLERRM,1,150);

Line 1129: var_request_id := fnd_request.submit_request ('MSD', 'MSDSPFPST', NULL, NULL, FALSE, 'EQ_SPF_CHILD', p_sr_instance_id);

1125:
1126: /* BIIO_SPF_CHILD */
1127: BEGIN
1128: var_request_id := null;
1129: var_request_id := fnd_request.submit_request ('MSD', 'MSDSPFPST', NULL, NULL, FALSE, 'EQ_SPF_CHILD', p_sr_instance_id);
1130: EXCEPTION
1131: WHEN OTHERS THEN
1132: retcode := -1;
1133: errbuf := substr(SQLERRM,1,150);

Line 1156: var_request_id := fnd_request.submit_request ('MSD', 'MSDSPFPST', NULL, NULL, FALSE, 'EQ_SPF_LATEST_REVISION', p_sr_instance_id);

1152:
1153: /* BIIO_SPF_LATEST_REVISION */
1154: BEGIN
1155: var_request_id := null;
1156: var_request_id := fnd_request.submit_request ('MSD', 'MSDSPFPST', NULL, NULL, FALSE, 'EQ_SPF_LATEST_REVISION', p_sr_instance_id);
1157: EXCEPTION
1158: WHEN OTHERS THEN
1159: retcode := -1;
1160: errbuf := substr(SQLERRM,1,150);

Line 1189: var_request_id := fnd_request.submit_request ('MSD', 'MSDSPFPST', NULL, NULL, FALSE, 'EQ_SPF_LEVEL', p_sr_instance_id);

1185: x_sql := 'select to_number(replace(version,''.'','''')) from ' || x_dem_schema || '.version_details' ;
1186: EXECUTE IMMEDIATE x_sql INTO x_version;
1187:
1188: IF (x_version = 731) THEN
1189: var_request_id := fnd_request.submit_request ('MSD', 'MSDSPFPST', NULL, NULL, FALSE, 'EQ_SPF_LEVEL', p_sr_instance_id);
1190: ELSE
1191: var_request_id := fnd_request.submit_request ('MSD', 'MSDSPFPST', NULL, NULL, FALSE, 'EQ_SPF_LEVEL_732', p_sr_instance_id);
1192: END IF;
1193:

Line 1191: var_request_id := fnd_request.submit_request ('MSD', 'MSDSPFPST', NULL, NULL, FALSE, 'EQ_SPF_LEVEL_732', p_sr_instance_id);

1187:
1188: IF (x_version = 731) THEN
1189: var_request_id := fnd_request.submit_request ('MSD', 'MSDSPFPST', NULL, NULL, FALSE, 'EQ_SPF_LEVEL', p_sr_instance_id);
1190: ELSE
1191: var_request_id := fnd_request.submit_request ('MSD', 'MSDSPFPST', NULL, NULL, FALSE, 'EQ_SPF_LEVEL_732', p_sr_instance_id);
1192: END IF;
1193:
1194: EXCEPTION
1195: WHEN OTHERS THEN

Line 1220: var_request_id := fnd_request.submit_request ('MSD', 'MSDSPFPST', NULL, NULL, FALSE, 'EQ_SPF_SALES_TMPL', p_sr_instance_id);

1216:
1217: /* T_SRC_SALES_TMPL */
1218: BEGIN
1219: var_request_id := null;
1220: var_request_id := fnd_request.submit_request ('MSD', 'MSDSPFPST', NULL, NULL, FALSE, 'EQ_SPF_SALES_TMPL', p_sr_instance_id);
1221: EXCEPTION
1222: WHEN OTHERS THEN
1223: retcode := -1;
1224: errbuf := substr(SQLERRM,1,150);

Line 1247: var_request_id := fnd_request.submit_request ('MSD', 'MSDSPFPST', NULL, NULL, FALSE, 'EQ_SPF_DATA', p_sr_instance_id);

1243:
1244: /* BIIO_SPF_DATA */
1245: BEGIN
1246: var_request_id := null;
1247: var_request_id := fnd_request.submit_request ('MSD', 'MSDSPFPST', NULL, NULL, FALSE, 'EQ_SPF_DATA', p_sr_instance_id);
1248: EXCEPTION
1249: WHEN OTHERS THEN
1250: retcode := -1;
1251: errbuf := substr(SQLERRM,1,150);

Line 1319: var_request_id := fnd_request.submit_request ('MSD', 'MSDSPFPST', NULL, NULL, FALSE, 'EQ_SPF_POPULATION', p_sr_instance_id);

1315:
1316: /* BIIO_SPF_POPULATION */
1317: BEGIN
1318: var_request_id := null;
1319: var_request_id := fnd_request.submit_request ('MSD', 'MSDSPFPST', NULL, NULL, FALSE, 'EQ_SPF_POPULATION', p_sr_instance_id);
1320: EXCEPTION
1321: WHEN OTHERS THEN
1322: retcode := -1;
1323: errbuf := substr(SQLERRM,1,150);

Line 1346: var_request_id := fnd_request.submit_request ('MSD', 'MSDDEMCLT', NULL, NULL, FALSE, p_sr_instance_id, 2);

1342:
1343: /* T_SRC_ITEM_TMPL */
1344: BEGIN
1345: var_request_id := null;
1346: var_request_id := fnd_request.submit_request ('MSD', 'MSDDEMCLT', NULL, NULL, FALSE, p_sr_instance_id, 2);
1347: EXCEPTION
1348: WHEN OTHERS THEN
1349: retcode := -1;
1350: errbuf := substr(SQLERRM,1,150);

Line 1373: var_request_id := fnd_request.submit_request ('MSD', 'MSDDEMCLT', NULL, NULL, FALSE, p_sr_instance_id, 1, -1, G_YES);

1369:
1370: /* T_SRC_LOC_TMPL */
1371: BEGIN
1372: var_request_id := null;
1373: var_request_id := fnd_request.submit_request ('MSD', 'MSDDEMCLT', NULL, NULL, FALSE, p_sr_instance_id, 1, -1, G_YES);
1374: EXCEPTION
1375: WHEN OTHERS THEN
1376: retcode := -1;
1377: errbuf := substr(SQLERRM,1,150);

Line 1532: var_request_id := fnd_request.submit_request ('MSD', 'MSDSPFLSD', NULL, NULL, FALSE, 'WF_SPF_FULL_DOWNLOAD', p_check_interval, p_time_out);

1528:
1529: var_request_id := null;
1530: IF (p_usage_data = G_YES OR p_install_base = G_YES OR p_shipment_data = G_YES) -- Bug#12675064
1531: THEN
1532: var_request_id := fnd_request.submit_request ('MSD', 'MSDSPFLSD', NULL, NULL, FALSE, 'WF_SPF_FULL_DOWNLOAD', p_check_interval, p_time_out);
1533: ELSE
1534: var_request_id := fnd_request.submit_request ('MSD', 'MSDSPFLSD', NULL, NULL, FALSE, 'WF_SPF_GL_DATA_DOWNLOAD', p_check_interval, p_time_out);
1535: END IF;
1536:

Line 1534: var_request_id := fnd_request.submit_request ('MSD', 'MSDSPFLSD', NULL, NULL, FALSE, 'WF_SPF_GL_DATA_DOWNLOAD', p_check_interval, p_time_out);

1530: IF (p_usage_data = G_YES OR p_install_base = G_YES OR p_shipment_data = G_YES) -- Bug#12675064
1531: THEN
1532: var_request_id := fnd_request.submit_request ('MSD', 'MSDSPFLSD', NULL, NULL, FALSE, 'WF_SPF_FULL_DOWNLOAD', p_check_interval, p_time_out);
1533: ELSE
1534: var_request_id := fnd_request.submit_request ('MSD', 'MSDSPFLSD', NULL, NULL, FALSE, 'WF_SPF_GL_DATA_DOWNLOAD', p_check_interval, p_time_out);
1535: END IF;
1536:
1537:
1538: EXCEPTION

Line 1643: var_request_id := fnd_request.submit_request ('MSD', 'MSDDEMLD', NULL, NULL, FALSE,

1639:
1640: /* Launch Flat File Loads */
1641: BEGIN
1642: var_request_id := null;
1643: var_request_id := fnd_request.submit_request ('MSD', 'MSDDEMLD', NULL, NULL, FALSE,
1644: p_sr_instance_id, 1440, p_file_separator, p_control_file_path, p_data_file_path, 3, null,
1645: null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null,
1646: null, null, null, null, null, null, null, null, null, null, p_data_file_name, p_auto_run_download);
1647: EXCEPTION

Line 1678: var_request_id := fnd_request.submit_request ('MSD', 'MSDDEMPSP', NULL, NULL, FALSE,

1674:
1675: /* Launch Push Setup Parameters */
1676: BEGIN
1677: var_request_id := null;
1678: var_request_id := fnd_request.submit_request ('MSD', 'MSDDEMPSP', NULL, NULL, FALSE,
1679: p_sr_instance_id, '-999', G_YES);
1680: EXCEPTION
1681: WHEN OTHERS THEN
1682: retcode := -1;

Line 1788: var_request_id := fnd_request.submit_request ('MSD', 'MSDSPFLSD', NULL, NULL, FALSE, 'WF_SPF_GL_DATA_DOWNLOAD', p_check_interval, p_time_out);

1784: THEN
1785:
1786: BEGIN
1787:
1788: var_request_id := fnd_request.submit_request ('MSD', 'MSDSPFLSD', NULL, NULL, FALSE, 'WF_SPF_GL_DATA_DOWNLOAD', p_check_interval, p_time_out);
1789:
1790: EXCEPTION
1791: WHEN OTHERS THEN
1792: retcode := -1;

Line 3484: var_request_id := fnd_request.submit_request ('MSD', 'MSDSPFPST', NULL, NULL, FALSE, 'EQ_SPF_MODEL_BOM_COMPONENTS', p_sr_instance_id);

3480:
3481: -- parallel step#1
3482: BEGIN
3483: var_request_id := null;
3484: var_request_id := fnd_request.submit_request ('MSD', 'MSDSPFPST', NULL, NULL, FALSE, 'EQ_SPF_MODEL_BOM_COMPONENTS', p_sr_instance_id);
3485: EXCEPTION
3486: WHEN OTHERS THEN
3487: retcode := -1;
3488: errbuf := substr(SQLERRM,1,150);

Line 3520: var_request_id := fnd_request.submit_request ('MSD', 'MSDSPFPST', NULL, NULL, FALSE, 'EQ_SPF_MODEL_ORGS', p_sr_instance_id, x_key_values);

3516: x_key_values := x_key_values || '$';
3517:
3518: BEGIN
3519: var_request_id := null;
3520: var_request_id := fnd_request.submit_request ('MSD', 'MSDSPFPST', NULL, NULL, FALSE, 'EQ_SPF_MODEL_ORGS', p_sr_instance_id, x_key_values);
3521: EXCEPTION
3522: WHEN OTHERS THEN
3523: retcode := -1;
3524: errbuf := substr(SQLERRM,1,150);

Line 4939: var_request_id := fnd_request.submit_request ('MSD', 'MSDSPFPST', NULL, NULL, FALSE,

4935: msd_dem_common_utilities.log_message ('');
4936: msd_dem_common_utilities.log_message ('Launching request for populating EQ_SPF_CMRO_BOM');
4937: BEGIN
4938: var_request_id := null;
4939: var_request_id := fnd_request.submit_request ('MSD', 'MSDSPFPST', NULL, NULL, FALSE,
4940: 'EQ_SPF_CMRO_BOM',
4941: p_sr_instance_id);
4942: EXCEPTION
4943: WHEN OTHERS THEN

Line 4967: var_request_id := fnd_request.submit_request ('MSD', 'MSDSPFPST', NULL, NULL, FALSE,

4963: msd_dem_common_utilities.log_message ('');
4964: msd_dem_common_utilities.log_message ('Launching request for populating EQ_SPF_CMRO_SALES_TMPL');
4965: BEGIN
4966: var_request_id := null;
4967: var_request_id := fnd_request.submit_request ('MSD', 'MSDSPFPST', NULL, NULL, FALSE,
4968: 'EQ_SPF_CMRO_SALES_TMPL',
4969: p_sr_instance_id);
4970: EXCEPTION
4971: WHEN OTHERS THEN

Line 4995: var_request_id := fnd_request.submit_request ('MSD', 'MSDSPFPST', NULL, NULL, FALSE,

4991: msd_dem_common_utilities.log_message ('');
4992: msd_dem_common_utilities.log_message ('Launching request for populating EQ_SPF_CMRO_DATA');
4993: BEGIN
4994: var_request_id := null;
4995: var_request_id := fnd_request.submit_request ('MSD', 'MSDSPFPST', NULL, NULL, FALSE,
4996: 'EQ_SPF_CMRO_DATA',
4997: p_sr_instance_id);
4998: EXCEPTION
4999: WHEN OTHERS THEN

Line 5035: var_request_id := fnd_request.submit_request ('MSD', 'MSDSPFPST', NULL, NULL, FALSE,

5031: var_key_value_pairs := var_key_value_pairs || '$C_MATERIAL#' || CS_DEM_MATERIAL;
5032: var_key_value_pairs := var_key_value_pairs || '$C_RESOURCE#' || CS_DEM_RESOURCE || '$';
5033:
5034: var_request_id := null;
5035: var_request_id := fnd_request.submit_request ('MSD', 'MSDSPFPST', NULL, NULL, FALSE,
5036: 'EQ_SPF_CMRO_ITEM_TMPL',
5037: p_sr_instance_id,
5038: var_key_value_pairs);
5039: EXCEPTION

Line 5097: var_request_id := fnd_request.submit_request ('MSD', 'MSDSPFPST', NULL, NULL, FALSE,

5093: msd_dem_common_utilities.log_message ('');
5094: msd_dem_common_utilities.log_message ('Launching request for populating EQ_SPF_CMRO_BASE_MODEL');
5095: BEGIN
5096: var_request_id := null;
5097: var_request_id := fnd_request.submit_request ('MSD', 'MSDSPFPST', NULL, NULL, FALSE,
5098: 'EQ_SPF_CMRO_BASE_MODEL',
5099: p_sr_instance_id);
5100: EXCEPTION
5101: WHEN OTHERS THEN

Line 5125: var_request_id := fnd_request.submit_request ('MSD', 'MSDSPFPST', NULL, NULL, FALSE,

5121: msd_dem_common_utilities.log_message ('');
5122: msd_dem_common_utilities.log_message ('Launching request for populating EQ_SPF_CMRO_CHILD');
5123: BEGIN
5124: var_request_id := null;
5125: var_request_id := fnd_request.submit_request ('MSD', 'MSDSPFPST', NULL, NULL, FALSE,
5126: 'EQ_SPF_CMRO_CHILD',
5127: p_sr_instance_id);
5128: EXCEPTION
5129: WHEN OTHERS THEN

Line 5153: var_request_id := fnd_request.submit_request ('MSD', 'MSDSPFPST', NULL, NULL, FALSE,

5149: msd_dem_common_utilities.log_message ('');
5150: msd_dem_common_utilities.log_message ('Launching request for populating EQ_SPF_CMRO_VISIT_TYPE');
5151: BEGIN
5152: var_request_id := null;
5153: var_request_id := fnd_request.submit_request ('MSD', 'MSDSPFPST', NULL, NULL, FALSE,
5154: 'EQ_SPF_CMRO_VISIT_TYPE',
5155: p_sr_instance_id);
5156: EXCEPTION
5157: WHEN OTHERS THEN

Line 5181: var_request_id := fnd_request.submit_request ('MSD', 'MSDSPFPST', NULL, NULL, FALSE,

5177: msd_dem_common_utilities.log_message ('');
5178: msd_dem_common_utilities.log_message ('Launching request for populating EQ_SPF_CMRO_VISIT_STAGE_TYPE');
5179: BEGIN
5180: var_request_id := null;
5181: var_request_id := fnd_request.submit_request ('MSD', 'MSDSPFPST', NULL, NULL, FALSE,
5182: 'EQ_SPF_CMRO_VISIT_STAGE_TYPE',
5183: p_sr_instance_id);
5184: EXCEPTION
5185: WHEN OTHERS THEN

Line 5209: var_request_id := fnd_request.submit_request ('MSD', 'MSDSPFPST', NULL, NULL, FALSE,

5205: /*msd_dem_common_utilities.log_message ('');
5206: msd_dem_common_utilities.log_message ('Launching request for populating EQ_SPF_CMRO_MAINTENANCE_TYPE');
5207: BEGIN
5208: var_request_id := null;
5209: var_request_id := fnd_request.submit_request ('MSD', 'MSDSPFPST', NULL, NULL, FALSE,
5210: 'EQ_SPF_CMRO_MAINTENANCE_TYPE',
5211: p_sr_instance_id);
5212: EXCEPTION
5213: WHEN OTHERS THEN

Line 5237: var_request_id := fnd_request.submit_request ('MSD', 'MSDSPFPST', NULL, NULL, FALSE,

5233: msd_dem_common_utilities.log_message ('');
5234: msd_dem_common_utilities.log_message ('Launching request for populating EQ_SPF_CMRO_LEVEL');
5235: BEGIN
5236: var_request_id := null;
5237: var_request_id := fnd_request.submit_request ('MSD', 'MSDSPFPST', NULL, NULL, FALSE,
5238: 'EQ_SPF_CMRO_LEVEL',
5239: p_sr_instance_id);
5240: EXCEPTION
5241: WHEN OTHERS THEN

Line 5265: var_request_id := fnd_request.submit_request ('MSD', 'MSDDEMCLT', NULL, NULL, FALSE,

5261: msd_dem_common_utilities.log_message ('');
5262: msd_dem_common_utilities.log_message ('Launching request for Collect Level Types - Location');
5263: BEGIN
5264: var_request_id := null;
5265: var_request_id := fnd_request.submit_request ('MSD', 'MSDDEMCLT', NULL, NULL, FALSE,
5266: p_sr_instance_id, 1);
5267: EXCEPTION
5268: WHEN OTHERS THEN
5269: retcode := -1;

Line 5364: var_request_id := fnd_request.submit_request ('MSD', 'MSDSPFPST', NULL, NULL, FALSE,

5360: msd_dem_common_utilities.log_message ('Launching request for populating EQ_SPF_CMRO_POPULATION');
5361: BEGIN
5362: var_key_value_pairs := '$C_POP_UNTIL_DATE#to_date(''' || to_char(x_forecast_cap, 'DD-MON-RRRR') || ''', ''DD-MON-RRRR'')$';
5363: var_request_id := null;
5364: var_request_id := fnd_request.submit_request ('MSD', 'MSDSPFPST', NULL, NULL, FALSE,
5365: 'EQ_SPF_CMRO_POPULATION',
5366: p_sr_instance_id,
5367: var_key_value_pairs);
5368: EXCEPTION

Line 5460: var_request_id := fnd_request.submit_request ('MSD', 'MSDDEMLDW', NULL, NULL, FALSE,

5456: IF (p_auto_run_download = G_YES) then
5457: BEGIN
5458:
5459: var_request_id := null;
5460: var_request_id := fnd_request.submit_request ('MSD', 'MSDDEMLDW', NULL, NULL, FALSE,
5461: 'WF_SPF_IMPORT_CMRO_DATA',
5462: p_synchronous, p_check_interval, p_time_out);
5463:
5464: EXCEPTION

Line 5764: var_request_id := fnd_request.submit_request ('MSD', 'MSDDEMLDW', NULL, NULL, FALSE,

5760: IF (p_auto_run_download = G_YES) then
5761: BEGIN
5762:
5763: var_request_id := null;
5764: var_request_id := fnd_request.submit_request ('MSD', 'MSDDEMLDW', NULL, NULL, FALSE,
5765: 'WF_SPF_IMPORT_CMRO_FLEET_DATA',
5766: p_synchronous, p_check_interval, p_time_out);
5767:
5768: EXCEPTION

Line 6100: var_request_id := fnd_request.submit_request ('MSD', 'MSDSPFPST', NULL, NULL, FALSE,'EQ_SPF_EAM_ITEM_TMPL', p_sr_instance_id, x_key_values);

6096:
6097:
6098: BEGIN
6099: var_request_id := null;
6100: var_request_id := fnd_request.submit_request ('MSD', 'MSDSPFPST', NULL, NULL, FALSE,'EQ_SPF_EAM_ITEM_TMPL', p_sr_instance_id, x_key_values);
6101: EXCEPTION
6102: WHEN OTHERS THEN
6103: retcode := -1;
6104: errbuf := substr(SQLERRM,1,150);

Line 6129: var_request_id := fnd_request.submit_request ('MSD', 'MSDDEMCLT', NULL, NULL, FALSE, p_sr_instance_id, 1, -1, G_YES);

6125: /*------- START - Submit "Collect Level Types" conc program to load T_SRC_LOC_TMPL -------*/
6126: msd_dem_common_utilities.log_message ('Submitting "MSDDEMCLT" request for populating T_SRC_LOC_TMPL');
6127: BEGIN
6128: var_request_id := null;
6129: var_request_id := fnd_request.submit_request ('MSD', 'MSDDEMCLT', NULL, NULL, FALSE, p_sr_instance_id, 1, -1, G_YES);
6130: EXCEPTION
6131: WHEN OTHERS THEN
6132: retcode := -1;
6133: errbuf := substr(SQLERRM,1,150);

Line 6186: var_request_id := fnd_request.submit_request ('MSD', 'MSDDEMLDW', NULL, NULL, FALSE,

6182: THEN
6183:
6184: BEGIN
6185: var_request_id := null;
6186: var_request_id := fnd_request.submit_request ('MSD', 'MSDDEMLDW', NULL, NULL, FALSE,
6187: 'WF_EBS_FULL_DOWNLOAD',
6188: p_synchronous, p_check_interval, p_time_out);
6189:
6190: msd_dem_common_utilities.log_message ('Request Id for "Launch Demantra Workflow" concurrent program - ' || var_request_id);

Line 6355: var_request_id := fnd_request.submit_request ('MSD', 'MSDDEMPSP', NULL, NULL, FALSE,

6351: msd_dem_common_utilities.log_debug (' ');
6352:
6353: BEGIN
6354: var_request_id := null;
6355: var_request_id := fnd_request.submit_request ('MSD', 'MSDDEMPSP', NULL, NULL, FALSE,
6356: p_sr_instance_id, p_collection_group, G_NO );
6357: EXCEPTION
6358: WHEN OTHERS THEN
6359: retcode := -1;

Line 6472: var_request_id := fnd_request.submit_request ('MSD', 'MSDDEMCLT', NULL, NULL, FALSE, p_sr_instance_id, 2);

6468: msd_dem_common_utilities.log_debug ('Submiting Collect Level Types conc progam for items.');
6469: msd_dem_common_utilities.log_debug (' ');
6470: BEGIN
6471: var_request_id := null;
6472: var_request_id := fnd_request.submit_request ('MSD', 'MSDDEMCLT', NULL, NULL, FALSE, p_sr_instance_id, 2);
6473: EXCEPTION
6474: WHEN OTHERS THEN
6475: retcode := -1;
6476: errbuf := substr(SQLERRM,1,150);

Line 6506: var_request_id := fnd_request.submit_request ('MSD', 'MSDDEMCLT', NULL, NULL, FALSE, p_sr_instance_id, 1, -1, G_YES);

6502: msd_dem_common_utilities.log_debug ('Submiting Collect Level Types conc progam for locations.');
6503: msd_dem_common_utilities.log_debug (' ');
6504: BEGIN
6505: var_request_id := null;
6506: var_request_id := fnd_request.submit_request ('MSD', 'MSDDEMCLT', NULL, NULL, FALSE, p_sr_instance_id, 1, -1, G_YES);
6507: EXCEPTION
6508: WHEN OTHERS THEN
6509: retcode := -1;
6510: errbuf := substr(SQLERRM,1,150);

Line 6569: var_request_id := fnd_request.submit_request ('MSD', 'MSDDEMLDW', NULL, NULL, FALSE,

6565: THEN
6566:
6567: BEGIN
6568: var_request_id := null;
6569: var_request_id := fnd_request.submit_request ('MSD', 'MSDDEMLDW', NULL, NULL, FALSE,
6570: 'WF_EBS_FULL_DOWNLOAD',
6571: p_synchronous, p_check_interval, p_time_out);
6572:
6573: msd_dem_common_utilities.log_message ('Request Id for "Launch Demantra Workflow" concurrent program - ' || var_request_id);