DBA Data[Home] [Help]

APPS.MSC_CL_PULL dependencies on MSC_CL_OTHER_PULL

Line 4599: -- FOR MSC_CL_OTHER_PULL.LOAD_SOURCING

4595: return false; -- NCP: do not call TASK_SOURCING in net change
4596: else
4597: RETURN TRUE;
4598: end if;
4599: -- FOR MSC_CL_OTHER_PULL.LOAD_SOURCING
4600: END IF;
4601: END IF;
4602:
4603: -- NOTE : There is no procedure that deals

Line 5273: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_PULL.LOAD_SCHEDULE');

5269: -- only call if doing discrete mfg, for process this is done in
5270: -- MDS demands
5271:
5272: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
5273: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_PULL.LOAD_SCHEDULE');
5274: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
5275: IF ( v_discrete_flag = MSC_UTIL.SYS_YES ) THEN
5276: IF prec.mds_flag = MSC_UTIL.SYS_YES AND prec.mps_flag = MSC_UTIL.SYS_NO THEN
5277: v_schedule_flag := MSC_UTIL.G_MDS;

Line 5284: MSC_CL_OTHER_PULL.LOAD_SCHEDULE;

5280: ELSE
5281: v_schedule_flag := MSC_UTIL.G_BOTH;
5282: END IF;
5283:
5284: MSC_CL_OTHER_PULL.LOAD_SCHEDULE;
5285: END IF;
5286:
5287: ELSIF prec.item_flag = MSC_UTIL.SYS_YES AND pTASKNUM= TASK_ITEM1 THEN
5288:

Line 5644: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_PULL.LOAD_SUB_INVENTORY');

5640:
5641: -- call the appropriate routine for sub inventory
5642:
5643: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
5644: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_PULL.LOAD_SUB_INVENTORY');
5645: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
5646:
5647: /* OPM Team - OPM Inventory Convergence Project
5648: Commented this has to be called for both discrete/process

Line 5650: MSC_CL_OTHER_PULL.LOAD_SUB_INVENTORY;

5646:
5647: /* OPM Team - OPM Inventory Convergence Project
5648: Commented this has to be called for both discrete/process
5649: IF v_discrete_flag = MSC_UTIL.SYS_YES THEN */
5650: MSC_CL_OTHER_PULL.LOAD_SUB_INVENTORY;
5651: -- END IF;
5652: IF v_process_flag = MSC_UTIL.SYS_YES and WIP_ENABLED= MSC_UTIL.SYS_YES THEN
5653: IF v_cp_enabled = MSC_UTIL.SYS_YES THEN
5654: lv_return_status := TRUE;

Line 5708: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_PULL.LOAD_SOURCING');

5704:
5705: ELSIF prec.sourcing_rule_flag = MSC_UTIL.SYS_YES AND pTASKNUM= TASK_SOURCING THEN
5706:
5707: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
5708: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_PULL.LOAD_SOURCING');
5709: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
5710:
5711: MSC_CL_OTHER_PULL.LOAD_SOURCING;
5712:

Line 5711: MSC_CL_OTHER_PULL.LOAD_SOURCING;

5707: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
5708: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_PULL.LOAD_SOURCING');
5709: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
5710:
5711: MSC_CL_OTHER_PULL.LOAD_SOURCING;
5712:
5713: ELSIF (prec.app_supp_cap_flag = MSC_UTIL.ASL_YES or prec.app_supp_cap_flag = MSC_UTIL.ASL_YES_RETAIN_CP ) AND pTASKNUM= TASK_SUPPLIER_CAPACITY THEN
5714:
5715: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');

Line 5876: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_PULL.LOAD_UNIT_NUMBER');

5872:
5873: ELSIF prec.unit_number_flag = MSC_UTIL.SYS_YES AND pTASKNUM= TASK_UNIT_NUMBER THEN
5874:
5875: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
5876: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_PULL.LOAD_UNIT_NUMBER');
5877: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
5878:
5879: MSC_CL_OTHER_PULL.LOAD_UNIT_NUMBER;
5880:

Line 5879: MSC_CL_OTHER_PULL.LOAD_UNIT_NUMBER;

5875: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
5876: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_PULL.LOAD_UNIT_NUMBER');
5877: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
5878:
5879: MSC_CL_OTHER_PULL.LOAD_UNIT_NUMBER;
5880:
5881: ELSIF prec.saf_stock_flag = MSC_UTIL.SYS_YES AND pTASKNUM= TASK_SAFETY_STOCK THEN
5882:
5883: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');

Line 5884: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_PULL.LOAD_SAFETY_STOCK');

5880:
5881: ELSIF prec.saf_stock_flag = MSC_UTIL.SYS_YES AND pTASKNUM= TASK_SAFETY_STOCK THEN
5882:
5883: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
5884: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_PULL.LOAD_SAFETY_STOCK');
5885: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
5886:
5887: MSC_CL_OTHER_PULL.LOAD_SAFETY_STOCK;
5888:

Line 5887: MSC_CL_OTHER_PULL.LOAD_SAFETY_STOCK;

5883: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
5884: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_PULL.LOAD_SAFETY_STOCK');
5885: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
5886:
5887: MSC_CL_OTHER_PULL.LOAD_SAFETY_STOCK;
5888:
5889: ELSIF prec.project_flag = MSC_UTIL.SYS_YES AND pTASKNUM= TASK_PROJECT THEN
5890:
5891: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');

Line 5892: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_PULL.LOAD_PROJECT');

5888:
5889: ELSIF prec.project_flag = MSC_UTIL.SYS_YES AND pTASKNUM= TASK_PROJECT THEN
5890:
5891: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
5892: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_PULL.LOAD_PROJECT');
5893: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
5894:
5895: MSC_CL_OTHER_PULL.LOAD_PROJECT;
5896:

Line 5895: MSC_CL_OTHER_PULL.LOAD_PROJECT;

5891: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
5892: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_PULL.LOAD_PROJECT');
5893: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
5894:
5895: MSC_CL_OTHER_PULL.LOAD_PROJECT;
5896:
5897: ELSIF prec.parameter_flag = MSC_UTIL.SYS_YES AND pTASKNUM= TASK_PARAMETER THEN
5898:
5899: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');

Line 5922: MSC_CL_OTHER_PULL.LOAD_BIS110;

5918:
5919:
5920: IF v_apps_ver= MSC_UTIL.G_APPS110 THEN
5921:
5922: MSC_CL_OTHER_PULL.LOAD_BIS110;
5923:
5924: ELSIF v_apps_ver>= MSC_UTIL.G_APPS115 THEN
5925:
5926: MSC_CL_OTHER_PULL.LOAD_BIS115;

Line 5926: MSC_CL_OTHER_PULL.LOAD_BIS115;

5922: MSC_CL_OTHER_PULL.LOAD_BIS110;
5923:
5924: ELSIF v_apps_ver>= MSC_UTIL.G_APPS115 THEN
5925:
5926: MSC_CL_OTHER_PULL.LOAD_BIS115;
5927:
5928: ELSIF v_apps_ver= MSC_UTIL.G_APPS107 THEN
5929:
5930: MSC_CL_OTHER_PULL.LOAD_BIS107;

Line 5930: MSC_CL_OTHER_PULL.LOAD_BIS107;

5926: MSC_CL_OTHER_PULL.LOAD_BIS115;
5927:
5928: ELSIF v_apps_ver= MSC_UTIL.G_APPS107 THEN
5929:
5930: MSC_CL_OTHER_PULL.LOAD_BIS107;
5931:
5932: END IF;
5933:
5934: ELSIF prec.atp_rules_flag = MSC_UTIL.SYS_YES AND pTASKNUM= TASK_ATP_RULES THEN

Line 5937: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_PULL.LOAD_ATP_RULES');

5933:
5934: ELSIF prec.atp_rules_flag = MSC_UTIL.SYS_YES AND pTASKNUM= TASK_ATP_RULES THEN
5935:
5936: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
5937: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_PULL.LOAD_ATP_RULES');
5938: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
5939:
5940: MSC_CL_OTHER_PULL.LOAD_ATP_RULES;
5941:

Line 5940: MSC_CL_OTHER_PULL.LOAD_ATP_RULES;

5936: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
5937: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_PULL.LOAD_ATP_RULES');
5938: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
5939:
5940: MSC_CL_OTHER_PULL.LOAD_ATP_RULES;
5941:
5942: ELSIF prec.user_supply_demand_flag = MSC_UTIL.SYS_YES AND pTASKNUM= TASK_USER_SUPPLY THEN
5943:
5944: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');

Line 5961: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_PULL.LOAD_PLANNERS');

5957:
5958: ELSIF prec.planner_flag = MSC_UTIL.SYS_YES AND pTASKNUM= TASK_PLANNERS THEN
5959:
5960: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
5961: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_PULL.LOAD_PLANNERS');
5962: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
5963:
5964: MSC_CL_OTHER_PULL.LOAD_PLANNERS;
5965:

Line 5964: MSC_CL_OTHER_PULL.LOAD_PLANNERS;

5960: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
5961: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_PULL.LOAD_PLANNERS');
5962: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
5963:
5964: MSC_CL_OTHER_PULL.LOAD_PLANNERS;
5965:
5966: -- Added this new task for Prod. Subst ---
5967: ELSIF prec.item_subst_flag = MSC_UTIL.SYS_YES AND pTASKNUM= TASK_ITEM_SUBSTITUTES THEN
5968:

Line 5980: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_PULL.LOAD_DEMAND_CLASS');

5976:
5977: ELSIF prec.demand_class_flag = MSC_UTIL.SYS_YES AND pTASKNUM= TASK_DEMAND_CLASS THEN
5978:
5979: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
5980: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_PULL.LOAD_DEMAND_CLASS');
5981: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
5982:
5983: MSC_CL_OTHER_PULL.LOAD_DEMAND_CLASS;
5984:

Line 5983: MSC_CL_OTHER_PULL.LOAD_DEMAND_CLASS;

5979: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
5980: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_PULL.LOAD_DEMAND_CLASS');
5981: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
5982:
5983: MSC_CL_OTHER_PULL.LOAD_DEMAND_CLASS;
5984:
5985: ELSIF (prec.tp_customer_flag = MSC_UTIL.SYS_YES OR prec.tp_vendor_flag = MSC_UTIL.SYS_YES) AND pTASKNUM= TASK_BUYER_CONTACT THEN
5986:
5987: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');

Line 6072: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_PULL.LOAD_TRIP');

6068:
6069: ELSIF prec.trip_flag = MSC_UTIL.SYS_YES AND pTASKNUM= TASK_TRIP THEN
6070:
6071: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
6072: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_PULL.LOAD_TRIP');
6073: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
6074:
6075: MSC_CL_OTHER_PULL.LOAD_TRIP;
6076:

Line 6075: MSC_CL_OTHER_PULL.LOAD_TRIP;

6071: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
6072: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_PULL.LOAD_TRIP');
6073: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
6074:
6075: MSC_CL_OTHER_PULL.LOAD_TRIP;
6076:
6077:
6078: ELSIF prec.sales_channel_flag = MSC_UTIL.SYS_YES AND pTASKNUM= TASK_SALES_CHANNEL THEN
6079:

Line 6081: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_PULL.LOAD_SALES_CHANNEL');

6077:
6078: ELSIF prec.sales_channel_flag = MSC_UTIL.SYS_YES AND pTASKNUM= TASK_SALES_CHANNEL THEN
6079:
6080: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
6081: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_PULL.LOAD_SALES_CHANNEL');
6082: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,FND_MESSAGE.GET);
6083:
6084: MSC_CL_OTHER_PULL.LOAD_SALES_CHANNEL;
6085:

Line 6084: MSC_CL_OTHER_PULL.LOAD_SALES_CHANNEL;

6080: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
6081: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_PULL.LOAD_SALES_CHANNEL');
6082: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,FND_MESSAGE.GET);
6083:
6084: MSC_CL_OTHER_PULL.LOAD_SALES_CHANNEL;
6085:
6086: ELSIF prec.fiscal_calendar_flag = MSC_UTIL.SYS_YES AND pTASKNUM= TASK_FISCAL_CALENDAR THEN
6087:
6088: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');

Line 6089: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_PULL.LOAD_FISCAL_CALENDAR');

6085:
6086: ELSIF prec.fiscal_calendar_flag = MSC_UTIL.SYS_YES AND pTASKNUM= TASK_FISCAL_CALENDAR THEN
6087:
6088: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
6089: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_PULL.LOAD_FISCAL_CALENDAR');
6090: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,FND_MESSAGE.GET);
6091:
6092: MSC_CL_OTHER_PULL.LOAD_FISCAL_CALENDAR;
6093:

Line 6092: MSC_CL_OTHER_PULL.LOAD_FISCAL_CALENDAR;

6088: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
6089: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_PULL.LOAD_FISCAL_CALENDAR');
6090: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,FND_MESSAGE.GET);
6091:
6092: MSC_CL_OTHER_PULL.LOAD_FISCAL_CALENDAR;
6093:
6094: ELSIF (prec.internal_repair_flag = MSC_UTIL.SYS_YES) AND (MSC_UTIL.G_COLLECT_SRP_DATA='Y') AND (pTASKNUM= TASK_IRO) THEN
6095:
6096: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');

Line 6137: IF (MSC_CL_OTHER_PULL.G_MSC_HUB_CURR_CODE IS NOT NULL) THEN

6133: MSC_CL_DEMAND_PULL.LOAD_OPEN_PAYBACKS;
6134:
6135: /* changes for currency conversion bug # 6469722 */
6136: ELSIF prec.currency_conversion_flag = MSC_UTIL.SYS_YES AND pTASKNUM= TASK_CURRENCY_CONVERSION THEN -- bug # 6469722
6137: IF (MSC_CL_OTHER_PULL.G_MSC_HUB_CURR_CODE IS NOT NULL) THEN
6138: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
6139: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_PULL.LOAD_CURRENCY_CONVERSION');
6140: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,FND_MESSAGE.GET);
6141:

Line 6139: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_PULL.LOAD_CURRENCY_CONVERSION');

6135: /* changes for currency conversion bug # 6469722 */
6136: ELSIF prec.currency_conversion_flag = MSC_UTIL.SYS_YES AND pTASKNUM= TASK_CURRENCY_CONVERSION THEN -- bug # 6469722
6137: IF (MSC_CL_OTHER_PULL.G_MSC_HUB_CURR_CODE IS NOT NULL) THEN
6138: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
6139: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_PULL.LOAD_CURRENCY_CONVERSION');
6140: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,FND_MESSAGE.GET);
6141:
6142: MSC_CL_OTHER_PULL.LOAD_CURRENCY_CONVERSION;
6143: ELSE

Line 6142: MSC_CL_OTHER_PULL.LOAD_CURRENCY_CONVERSION;

6138: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
6139: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_PULL.LOAD_CURRENCY_CONVERSION');
6140: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,FND_MESSAGE.GET);
6141:
6142: MSC_CL_OTHER_PULL.LOAD_CURRENCY_CONVERSION;
6143: ELSE
6144: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Currency Data is not collected as MSC:Planning Hub Currency Code Profile is NULL.');
6145: END IF;
6146: ELSIF prec.delivery_details_flag = MSC_UTIL.SYS_YES AND pTASKNUM= TASK_DELIVERY_DETAILS THEN

Line 6152: MSC_CL_OTHER_PULL.LOAD_DELIVERY_DETAILS;

6148: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
6149: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_DELIVERY_DETAILS');
6150: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,FND_MESSAGE.GET);
6151:
6152: MSC_CL_OTHER_PULL.LOAD_DELIVERY_DETAILS;
6153: END IF;
6154:
6155: -- ======== If no exception occurs, then returns with status = OK ========
6156: pSTATUS := OK;