238: MTL_INV_UTIL_GRP.Get_LPN_Item_SysQty
239: (
240: --p_api_version => 1.0 -- commented for bug 14082014
241: p_api_version => 0.9 -- added for bug 14082014
242: , p_init_msg_lst => fnd_api.g_true
243: , p_commit => fnd_api.g_true
244: , x_return_status => L_return_status
245: , x_msg_count => L_msg_count
246: , x_msg_data => L_msg_data
239: (
240: --p_api_version => 1.0 -- commented for bug 14082014
241: p_api_version => 0.9 -- added for bug 14082014
242: , p_init_msg_lst => fnd_api.g_true
243: , p_commit => fnd_api.g_true
244: , x_return_status => L_return_status
245: , x_msg_count => L_msg_count
246: , x_msg_data => L_msg_data
247: , p_organization_id => c_rec.Organization_id
349:
350: --
351: -- Error Validation/Replace all NULL statements
352: --
353: IF(L_return_status = FND_API.G_RET_STS_SUCCESS) THEN
354: -- no errors
355: --
356: IF (l_debug = 1) THEN
357: mdebug('success '||L_return_status||'='||FND_API.G_RET_STS_SUCCESS);
353: IF(L_return_status = FND_API.G_RET_STS_SUCCESS) THEN
354: -- no errors
355: --
356: IF (l_debug = 1) THEN
357: mdebug('success '||L_return_status||'='||FND_API.G_RET_STS_SUCCESS);
358: END IF;
359: L_rec_counter_pos := L_rec_counter_pos + 1;
360: --
361: ELSE
802: p_cycle_count_entry_id =>
803: c_rec.cycle_count_entry_id,
804: p_export_flag=> 2);
805: --
806: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
807: ERRBUF := L_msg_data;
808: RETCODE:= 'ERROR';
809: ELSE
810: RETCODE := 'SUCCESS';
1149: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Worker: Action-'||to_char(c_rec.action_code));
1150:
1151: MTL_CCEOI_ACTION_PUB.Import_CountRequest(
1152: p_api_version => 0.9,
1153: p_init_msg_list => FND_API.G_TRUE,
1154: x_return_status => L_return_status,
1155: x_msg_count => L_msg_count,
1156: x_msg_data => L_msg_data,
1157: x_errorcode => l_errorcode,
1169: c_rec.action_code = MTL_CCEOI_VAR_PVT.G_VALIDATE THEN
1170: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Worker: Action-is Vaildate ');
1171: MTL_CCEOI_ACTION_PVT.Validate_CountRequest(
1172: p_api_version => 0.9,
1173: p_init_msg_list => FND_API.G_TRUE,
1174: x_return_status => L_return_status,
1175: x_msg_count => L_msg_count,
1176: x_msg_data => L_msg_data,
1177: P_interface_rec => L_iface_rec);
1178: ELSIF
1179: c_rec.action_code = MTL_CCEOI_VAR_PVT.G_CREATE THEN
1180: MTL_CCEOI_ACTION_PVT.Create_CountRequest(
1181: p_api_version => 0.9,
1182: p_init_msg_list => FND_API.G_TRUE,
1183: x_return_status => L_return_status,
1184: x_msg_count => L_msg_count,
1185: x_msg_data => L_msg_data,
1186: P_interface_rec => L_iface_rec);
1187: ELSIF
1188: c_rec.action_code = MTL_CCEOI_VAR_PVT.G_VALSIM THEN
1189: MTL_CCEOI_ACTION_PVT.ValSim_CountRequest(
1190: p_api_version => 0.9,
1191: p_init_msg_list => FND_API.G_TRUE,
1192: x_return_status => L_return_status,
1193: x_msg_count => L_msg_count,
1194: x_msg_data => L_msg_data,
1195: P_interface_rec => L_iface_rec);
1197: c_rec.action_code = MTL_CCEOI_VAR_PVT.G_PROCESS THEN
1198: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Worker: Action-is process ');
1199: MTL_CCEOI_ACTION_PVT.Process_CountRequest(
1200: p_api_version => 0.9,
1201: p_init_msg_list => FND_API.G_TRUE,
1202: x_return_status => L_return_status,
1203: x_msg_count => L_msg_count,
1204: x_msg_data => L_msg_data,
1205: P_interface_rec => L_iface_rec);
1232: END IF;
1233: END IF;
1234: */
1235: --
1236: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1237: ERRBUF := L_msg_data;
1238: FND_FILE.PUT_LINE(FND_FILE.LOG, ERRBUF);
1239: --
1240: IF P_ErrorReportLev = 1 THEN