DBA Data[Home] [Help]

APPS.AHL_CMP_PVT dependencies on AHL_DEBUG_PUB

Line 7: G_DEBUG CONSTANT VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;

3:
4: -- Package constants
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_CMP_PVT';
6: G_APP_NAME CONSTANT VARCHAR2(3) := 'AHL';
7: G_DEBUG CONSTANT VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
8:
9: --ITEM Params
10: C_NO_SERIAL_CONTROL CONSTANT NUMBER := 1;
11: C_NO_LOT_CONTROL CONSTANT NUMBER := 1;

Line 227: AHL_DEBUG_PUB.enable_debug;

223: x_return_status := FND_API.G_RET_STS_SUCCESS;
224:
225:
226: IF G_DEBUG='Y' THEN
227: AHL_DEBUG_PUB.enable_debug;
228: AHL_DEBUG_PUB.debug('Entered Mtl Transfer API');
229: END IF;
230:
231: IF (p_x_ahl_mtlxfr_tbl.COUNT > 0) THEN

Line 228: AHL_DEBUG_PUB.debug('Entered Mtl Transfer API');

224:
225:
226: IF G_DEBUG='Y' THEN
227: AHL_DEBUG_PUB.enable_debug;
228: AHL_DEBUG_PUB.debug('Entered Mtl Transfer API');
229: END IF;
230:
231: IF (p_x_ahl_mtlxfr_tbl.COUNT > 0) THEN
232:

Line 236: AHL_DEBUG_PUB.debug('calling Validate_Rec for i=['||i||']');

232:
233: FOR i IN p_x_ahl_mtlxfr_tbl.FIRST..p_x_ahl_mtlxfr_tbl.LAST LOOP
234:
235: IF G_DEBUG='Y' THEN
236: AHL_DEBUG_PUB.debug('calling Validate_Rec for i=['||i||']');
237: END IF;
238:
239: --Call Validate_rec to validate the material transfer record.
240: VALIDATE_REC

Line 249: AHL_DEBUG_PUB.debug('After calling Validate_rec');

245: x_msg_data => x_msg_data
246: );
247:
248: IF G_DEBUG='Y' THEN
249: AHL_DEBUG_PUB.debug('After calling Validate_rec');
250: END IF;
251:
252: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
253: l_error := true;

Line 256: AHL_DEBUG_PUB.debug('Error in Validate_rec');

252: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
253: l_error := true;
254:
255: IF G_DEBUG='Y' THEN
256: AHL_DEBUG_PUB.debug('Error in Validate_rec');
257: END IF;
258: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
259: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
260:

Line 262: AHL_DEBUG_PUB.debug('Unexpected error in Validate_rec');

258: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
259: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
260:
261: IF G_DEBUG='Y' THEN
262: AHL_DEBUG_PUB.debug('Unexpected error in Validate_rec');
263: END IF;
264: END IF;
265:
266: END LOOP;

Line 278: AHL_DEBUG_PUB.debug('Calling Insert_Txn_Intf...');

274: l_Error := false;
275: FOR i IN p_x_ahl_mtlxfr_tbl.FIRST..p_x_ahl_mtlxfr_tbl.LAST LOOP
276:
277: IF G_DEBUG='Y' THEN
278: AHL_DEBUG_PUB.debug('Calling Insert_Txn_Intf...');
279: END IF;
280:
281: INSERT_MTL_TXN_INTF
282: (

Line 291: AHL_DEBUG_PUB.debug('After Calling Insert_Txn_Intf...ret_status['||x_return_status||']');

287: );
288:
289: l_txn_Id_Tbl(i) := l_Txn_tmp_Id;
290: IF G_DEBUG='Y' THEN
291: AHL_DEBUG_PUB.debug('After Calling Insert_Txn_Intf...ret_status['||x_return_status||']');
292: END IF;
293:
294:
295: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 309: AHL_DEBUG_PUB.debug('Before calling INV_TXN_MANAGER_PUB.process_Transactions....');

305: END IF;
306:
307: -- Now process the interface records
308: IF G_DEBUG='Y' THEN
309: AHL_DEBUG_PUB.debug('Before calling INV_TXN_MANAGER_PUB.process_Transactions....');
310: END IF;
311:
312: l_result := INV_TXN_MANAGER_PUB.process_Transactions(
313: p_api_version => null ,

Line 328: AHL_DEBUG_PUB.debug('INV_TXN_MANAGER_PUB.process_Transactions....errored');

324: mo_global.init('AHL');
325:
326: IF( l_result = -1 OR x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
327: IF G_DEBUG='Y' THEN
328: AHL_DEBUG_PUB.debug('INV_TXN_MANAGER_PUB.process_Transactions....errored');
329: AHL_DEBUG_PUB.debug('count of error msgs: ' || FND_MSG_PUB.COUNT_MSG);
330: END IF;
331:
332: END IF;

Line 329: AHL_DEBUG_PUB.debug('count of error msgs: ' || FND_MSG_PUB.COUNT_MSG);

325:
326: IF( l_result = -1 OR x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
327: IF G_DEBUG='Y' THEN
328: AHL_DEBUG_PUB.debug('INV_TXN_MANAGER_PUB.process_Transactions....errored');
329: AHL_DEBUG_PUB.debug('count of error msgs: ' || FND_MSG_PUB.COUNT_MSG);
330: END IF;
331:
332: END IF;
333: END IF;

Line 351: AHL_DEBUG_PUB.debug('Error in transaction['||l_error_msg||']');

347: IF(Txn_Error_cur%FOUND AND (l_error_code IS NOT NULL
348: OR trim(l_error_code) = '')) THEN
349:
350: IF G_DEBUG='Y' THEN
351: AHL_DEBUG_PUB.debug('Error in transaction['||l_error_msg||']');
352: END IF;
353:
354: FND_MESSAGE.Set_Name('AHL','AHL_CMP_MTLXFR_ERROR');
355: FND_MESSAGE.Set_Token('MSG',l_error_msg);

Line 501: AHL_DEBUG_PUB.enable_debug;

497:
498: x_return_status := FND_API.G_RET_STS_SUCCESS;
499:
500: IF G_DEBUG='Y' THEN
501: AHL_DEBUG_PUB.enable_debug;
502: AHL_DEBUG_PUB.debug('Ahl Validating TxnType...['||to_Char(p_x_ahl_mtlxfr_rec.Transaction_Type_Id)||']');
503: END IF;
504:
505: -- Validate transaction type

Line 502: AHL_DEBUG_PUB.debug('Ahl Validating TxnType...['||to_Char(p_x_ahl_mtlxfr_rec.Transaction_Type_Id)||']');

498: x_return_status := FND_API.G_RET_STS_SUCCESS;
499:
500: IF G_DEBUG='Y' THEN
501: AHL_DEBUG_PUB.enable_debug;
502: AHL_DEBUG_PUB.debug('Ahl Validating TxnType...['||to_Char(p_x_ahl_mtlxfr_rec.Transaction_Type_Id)||']');
503: END IF;
504:
505: -- Validate transaction type
506: IF p_x_ahl_mtlxfr_rec.Transaction_Type_Id IS NULL THEN

Line 523: AHL_DEBUG_PUB.debug('Validating quantity...['||to_Char(p_x_ahl_mtlxfr_rec.Quantity)||']');

519: END IF;
520:
521: -- transaction quantity should be +ve always.
522: IF G_DEBUG='Y' THEN
523: AHL_DEBUG_PUB.debug('Validating quantity...['||to_Char(p_x_ahl_mtlxfr_rec.Quantity)||']');
524: END IF;
525:
526: IF(nvl(p_x_ahl_mtlxfr_rec.Quantity,0) <= 0) THEN
527: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_QTY');

Line 534: AHL_DEBUG_PUB.debug('Validating item_id['||to_Char(p_x_ahl_mtlxfr_rec.Organization_ID)||','||to_Char(p_x_ahl_mtlxfr_rec.Inventory_Item_Id)||']');

530: x_return_status := FND_API.G_RET_STS_ERROR;
531: END IF;
532:
533: IF G_DEBUG='Y' THEN
534: AHL_DEBUG_PUB.debug('Validating item_id['||to_Char(p_x_ahl_mtlxfr_rec.Organization_ID)||','||to_Char(p_x_ahl_mtlxfr_rec.Inventory_Item_Id)||']');
535: END IF;
536:
537:
538: -- Validate Item id

Line 567: AHL_DEBUG_PUB.debug('Validating serial num(control, srl_num)['||to_Char(l_serial_Control)||','||p_x_ahl_mtlxfr_rec.Serial_Number||']');

563: END IF;
564:
565:
566: IF G_DEBUG='Y' THEN
567: AHL_DEBUG_PUB.debug('Validating serial num(control, srl_num)['||to_Char(l_serial_Control)||','||p_x_ahl_mtlxfr_rec.Serial_Number||']');
568: END IF;
569:
570: -- If the item is of serial controlled check if the serial numebr is null
571: IF(p_x_ahl_mtlxfr_rec.Serial_Number IS NULL

Line 591: AHL_DEBUG_PUB.debug('Validating lot num(control, lot_num)['||to_Char(l_lot_Control)||','||p_x_ahl_mtlxfr_rec.Lot_Number||']');

587: END IF;
588:
589:
590: IF G_DEBUG='Y' THEN
591: AHL_DEBUG_PUB.debug('Validating lot num(control, lot_num)['||to_Char(l_lot_Control)||','||p_x_ahl_mtlxfr_rec.Lot_Number||']');
592: END IF;
593:
594: -- If the item is of lot controlled check if the lot number is null
595: IF((p_x_ahl_mtlxfr_rec.Lot_Number IS NULL

Line 682: AHL_DEBUG_PUB.debug('Validating revision['||p_x_ahl_mtlxfr_rec.Revision||']');

678: END IF;
679:
680:
681: IF G_DEBUG='Y' THEN
682: AHL_DEBUG_PUB.debug('Validating revision['||p_x_ahl_mtlxfr_rec.Revision||']');
683: END IF;
684:
685:
686: -- If item is revision-controlled, then verify revision is NOT NULL and is valid

Line 732: AHL_DEBUG_PUB.debug('Validating serial num/qty['||p_x_ahl_mtlxfr_rec.quantity||']');

728: --If the serial number is not null and the quantity is <>1 return the
729: --Error AHL_INVALID_SRL_QTY
730:
731: IF G_DEBUG='Y' THEN
732: AHL_DEBUG_PUB.debug('Validating serial num/qty['||p_x_ahl_mtlxfr_rec.quantity||']');
733: END IF;
734:
735: IF ((p_x_ahl_mtlxfr_rec.Serial_Number IS NOT NULL) AND nvl(l_serial_Control,1) <> 1) THEN
736: IF (p_x_ahl_mtlxfr_rec.Quantity <> 1) THEN

Line 746: AHL_DEBUG_PUB.debug('Validating serial subinv, loc['||p_x_ahl_mtlxfr_rec.Serial_Number||']');

742: END IF;
743: END IF;
744:
745: IF G_DEBUG='Y' THEN
746: AHL_DEBUG_PUB.debug('Validating serial subinv, loc['||p_x_ahl_mtlxfr_rec.Serial_Number||']');
747: END IF;
748:
749: -- For issue txn with serial number, validate if subinventory and locator match
750: -- that from mtl_serial_numbers.

Line 759: AHL_DEBUG_PUB.debug('Validating serial subinv['||p_x_ahl_mtlxfr_rec.Src_Subinv_Name||']');

755: FETCH mtl_srl_num_csr INTO l_curr_subinventory_code, l_curr_locator_id;
756: IF (mtl_srl_num_csr%FOUND) THEN
757:
758: IF G_DEBUG='Y' THEN
759: AHL_DEBUG_PUB.debug('Validating serial subinv['||p_x_ahl_mtlxfr_rec.Src_Subinv_Name||']');
760: END IF;
761:
762: IF (p_x_ahl_mtlxfr_rec.Src_Subinv_Name IS NOT NULL AND
763: p_x_ahl_mtlxfr_rec.Src_Subinv_Name <> l_curr_subinventory_code) THEN

Line 773: AHL_DEBUG_PUB.debug('Validating serial subinv['||p_x_ahl_mtlxfr_rec.Src_Subinv_Name||']');

769: x_return_status := FND_API.G_RET_STS_ERROR;
770: END IF;
771:
772: IF G_DEBUG='Y' THEN
773: AHL_DEBUG_PUB.debug('Validating serial subinv['||p_x_ahl_mtlxfr_rec.Src_Subinv_Name||']');
774: END IF;
775:
776: IF (p_x_ahl_mtlxfr_rec.Src_Locator_Id IS NOT NULL AND l_curr_locator_id IS NOT NULL AND
777: p_x_ahl_mtlxfr_rec.Src_Locator_Id <> l_curr_locator_id) THEN

Line 884: AHL_DEBUG_PUB.debug('Did not find the Txn Type');

880: OPEN TRX_ACTION_CUR(p_x_ahl_mtlxfr_rec.Transaction_Type_Id);
881: FETCH TRX_ACTION_CUR INTO l_txn_action, l_txn_source_type;
882: IF(TRX_ACTION_CUR%NOTFOUND) THEN
883: IF G_DEBUG='Y' THEN
884: AHL_DEBUG_PUB.debug('Did not find the Txn Type');
885: END IF;
886: CLOSE TRX_ACTION_CUR;
887: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
888: END IF;

Line 897: AHL_DEBUG_PUB.debug('Header id created..['||p_x_txn_hdr_id||']');

893: SELECT Mtl_Material_Transactions_S.nextval
894: INTO p_x_txn_hdr_id
895: FROM DUAL;
896: IF G_DEBUG='Y' THEN
897: AHL_DEBUG_PUB.debug('Header id created..['||p_x_txn_hdr_id||']');
898: END IF;
899: END IF;
900:
901: --l_loop_count := 0;

Line 910: AHL_DEBUG_PUB.debug('Interface id created..['||p_x_txn_intf_id||']');

906: INTO p_x_txn_intf_id
907: FROM DUAL;
908:
909: IF G_DEBUG='Y' THEN
910: AHL_DEBUG_PUB.debug('Interface id created..['||p_x_txn_intf_id||']');
911: END IF;
912:
913: --l_qty := 1;
914: --l_loop_count := l_loop_count + 1;

Line 917: AHL_DEBUG_PUB.debug('Before dynamic chk:loc segs:ID' || p_x_ahl_mtlxfr_rec.Dst_Locator_Segments || ':' || p_x_ahl_mtlxfr_rec.Dst_Locator_Id);

913: --l_qty := 1;
914: --l_loop_count := l_loop_count + 1;
915:
916: IF G_DEBUG='Y' THEN
917: AHL_DEBUG_PUB.debug('Before dynamic chk:loc segs:ID' || p_x_ahl_mtlxfr_rec.Dst_Locator_Segments || ':' || p_x_ahl_mtlxfr_rec.Dst_Locator_Id);
918: END IF;
919:
920:
921: -- support dynamic locator creation if allowed.

Line 961: AHL_DEBUG_PUB.debug('insertng the lot record,interface id,tempid['

957: l_txn_tmp_id := p_x_txn_intf_id;
958: END IF;
959:
960: IF G_DEBUG='Y' THEN
961: AHL_DEBUG_PUB.debug('insertng the lot record,interface id,tempid['
962: ||to_char(p_x_txn_intf_id)||','
963: ||to_char(l_txn_tmp_id)||']');
964: END IF;
965:

Line 1043: AHL_DEBUG_PUB.debug('insertng the serial record,interface id['

1039: l_txn_tmp_id := p_x_txn_intf_id;
1040: END IF;
1041:
1042: IF G_DEBUG='Y' THEN
1043: AHL_DEBUG_PUB.debug('insertng the serial record,interface id['
1044: ||to_char(l_txn_tmp_id)||']');
1045: END IF;
1046:
1047:

Line 1110: AHL_DEBUG_PUB.debug('insertng the txn record,header id,interface id['

1106:
1107: END IF;
1108:
1109: IF G_DEBUG='Y' THEN
1110: AHL_DEBUG_PUB.debug('insertng the txn record,header id,interface id['
1111: ||to_char(p_x_txn_hdr_id)||','
1112: ||to_char(p_x_txn_intf_id)||']');
1113: END IF;
1114:

Line 1171: AHL_DEBUG_PUB.debug('Exception inserting into mtl_txn interface' || SQLCODE);

1167: EXCEPTION
1168: WHEN OTHERS THEN
1169: x_return_status := FND_API.G_RET_STS_ERROR;
1170: IF G_DEBUG='Y' THEN
1171: AHL_DEBUG_PUB.debug('Exception inserting into mtl_txn interface' || SQLCODE);
1172: AHL_DEBUG_PUB.debug('SQLERRM:' || SQLERRM);
1173: END IF;
1174: FND_MESSAGE.Set_Name('AHL','AHL_CMP_MTLXFR_ERROR');
1175: FND_MESSAGE.Set_Token('MSG',SQLERRM);

Line 1172: AHL_DEBUG_PUB.debug('SQLERRM:' || SQLERRM);

1168: WHEN OTHERS THEN
1169: x_return_status := FND_API.G_RET_STS_ERROR;
1170: IF G_DEBUG='Y' THEN
1171: AHL_DEBUG_PUB.debug('Exception inserting into mtl_txn interface' || SQLCODE);
1172: AHL_DEBUG_PUB.debug('SQLERRM:' || SQLERRM);
1173: END IF;
1174: FND_MESSAGE.Set_Name('AHL','AHL_CMP_MTLXFR_ERROR');
1175: FND_MESSAGE.Set_Token('MSG',SQLERRM);
1176: FND_MESSAGE.Set_Token('ITEM',p_x_ahl_mtlxfr_rec.Inventory_Item_Id);

Line 2050: AHL_DEBUG_PUB.enable_debug;

2046: -- Initialize API return status to success
2047: x_return_status := FND_API.G_RET_STS_SUCCESS;
2048:
2049: IF G_DEBUG='Y' THEN
2050: AHL_DEBUG_PUB.enable_debug;
2051: AHL_DEBUG_PUB.debug('Entered Close Repair Batch API');
2052: END IF;
2053:
2054: OPEN get_batch_details (p_repair_batch_id);

Line 2051: AHL_DEBUG_PUB.debug('Entered Close Repair Batch API');

2047: x_return_status := FND_API.G_RET_STS_SUCCESS;
2048:
2049: IF G_DEBUG='Y' THEN
2050: AHL_DEBUG_PUB.enable_debug;
2051: AHL_DEBUG_PUB.debug('Entered Close Repair Batch API');
2052: END IF;
2053:
2054: OPEN get_batch_details (p_repair_batch_id);
2055: FETCH get_batch_details INTO l_batch_dtl_rec;

Line 2200: AHL_DEBUG_PUB.enable_debug;

2196: RAISE FND_API.G_EXC_ERROR;
2197: END IF;
2198:
2199: IF G_DEBUG='Y' THEN
2200: AHL_DEBUG_PUB.enable_debug;
2201: AHL_DEBUG_PUB.debug('End of Close Repair Batch API');
2202: END IF;
2203:
2204: -- Standard check of p_commit

Line 2201: AHL_DEBUG_PUB.debug('End of Close Repair Batch API');

2197: END IF;
2198:
2199: IF G_DEBUG='Y' THEN
2200: AHL_DEBUG_PUB.enable_debug;
2201: AHL_DEBUG_PUB.debug('End of Close Repair Batch API');
2202: END IF;
2203:
2204: -- Standard check of p_commit
2205: IF FND_API.To_Boolean(p_commit) THEN

Line 2462: AHL_DEBUG_PUB.enable_debug;

2458: -- Initialize API return status to success
2459: x_return_status := FND_API.G_RET_STS_SUCCESS;
2460:
2461: IF G_DEBUG='Y' THEN
2462: AHL_DEBUG_PUB.enable_debug;
2463: AHL_DEBUG_PUB.debug('Entering Move_To_InRepair_Locator API with WIP Entity ID: '
2464: || p_wip_entity_id ||
2465: ' RepairBatch Name: ' || p_repair_batch_name);
2466: END IF;

Line 2463: AHL_DEBUG_PUB.debug('Entering Move_To_InRepair_Locator API with WIP Entity ID: '

2459: x_return_status := FND_API.G_RET_STS_SUCCESS;
2460:
2461: IF G_DEBUG='Y' THEN
2462: AHL_DEBUG_PUB.enable_debug;
2463: AHL_DEBUG_PUB.debug('Entering Move_To_InRepair_Locator API with WIP Entity ID: '
2464: || p_wip_entity_id ||
2465: ' RepairBatch Name: ' || p_repair_batch_name);
2466: END IF;
2467:

Line 2930: AHL_DEBUG_PUB.enable_debug;

2926: -- Initialize API return status to success
2927: x_return_status := FND_API.G_RET_STS_SUCCESS;
2928:
2929: IF G_DEBUG='Y' THEN
2930: AHL_DEBUG_PUB.enable_debug;
2931: AHL_DEBUG_PUB.debug('Entering Create_Instance_in_WIP API with WIP Entity ID: '|| p_wip_entity_id ||
2932: ' Instance ID: ' || p_instance_id);
2933: END IF;
2934:

Line 2931: AHL_DEBUG_PUB.debug('Entering Create_Instance_in_WIP API with WIP Entity ID: '|| p_wip_entity_id ||

2927: x_return_status := FND_API.G_RET_STS_SUCCESS;
2928:
2929: IF G_DEBUG='Y' THEN
2930: AHL_DEBUG_PUB.enable_debug;
2931: AHL_DEBUG_PUB.debug('Entering Create_Instance_in_WIP API with WIP Entity ID: '|| p_wip_entity_id ||
2932: ' Instance ID: ' || p_instance_id);
2933: END IF;
2934:
2935: -- Get the details of the existing instance

Line 3167: AHL_DEBUG_PUB.enable_debug;

3163: -- Initialize API return status to success
3164: x_return_status := FND_API.G_RET_STS_SUCCESS;
3165:
3166: IF G_DEBUG='Y' THEN
3167: AHL_DEBUG_PUB.enable_debug;
3168: AHL_DEBUG_PUB.debug('Entering Update_EAM_Workorders API with WIP Entity ID: '|| p_wip_entity_id ||
3169: ' Instance ID: ' || p_instance_id);
3170: END IF;
3171:

Line 3168: AHL_DEBUG_PUB.debug('Entering Update_EAM_Workorders API with WIP Entity ID: '|| p_wip_entity_id ||

3164: x_return_status := FND_API.G_RET_STS_SUCCESS;
3165:
3166: IF G_DEBUG='Y' THEN
3167: AHL_DEBUG_PUB.enable_debug;
3168: AHL_DEBUG_PUB.debug('Entering Update_EAM_Workorders API with WIP Entity ID: '|| p_wip_entity_id ||
3169: ' Instance ID: ' || p_instance_id);
3170: END IF;
3171:
3172: OPEN get_workorder_dtls_csr(p_wip_entity_id);

Line 3179: AHL_DEBUG_PUB.enable_debug;

3175: l_organization_id,
3176: l_wo_status_code ;
3177: CLOSE get_workorder_dtls_csr;
3178: IF G_DEBUG='Y' THEN
3179: AHL_DEBUG_PUB.enable_debug;
3180: AHL_DEBUG_PUB.debug('l_organization_id ::' || l_organization_id ||
3181: 'l_item_id :: ' || l_item_id || 'l_wo_status_code :: ' || l_wo_status_code);
3182: END IF;
3183:

Line 3180: AHL_DEBUG_PUB.debug('l_organization_id ::' || l_organization_id ||

3176: l_wo_status_code ;
3177: CLOSE get_workorder_dtls_csr;
3178: IF G_DEBUG='Y' THEN
3179: AHL_DEBUG_PUB.enable_debug;
3180: AHL_DEBUG_PUB.debug('l_organization_id ::' || l_organization_id ||
3181: 'l_item_id :: ' || l_item_id || 'l_wo_status_code :: ' || l_wo_status_code);
3182: END IF;
3183:
3184: l_eam_wo_rec.wip_entity_id := p_wip_entity_id;

Line 3311: AHL_DEBUG_PUB.enable_debug;

3307:
3308: x_return_status := FND_API.G_RET_STS_SUCCESS;
3309:
3310: IF G_DEBUG='Y' THEN
3311: AHL_DEBUG_PUB.enable_debug;
3312: AHL_DEBUG_PUB.debug('Entering Validate_Rtn_Rec Procedure');
3313: END IF;
3314:
3315: -- Return Quantity should be +ve always.

Line 3312: AHL_DEBUG_PUB.debug('Entering Validate_Rtn_Rec Procedure');

3308: x_return_status := FND_API.G_RET_STS_SUCCESS;
3309:
3310: IF G_DEBUG='Y' THEN
3311: AHL_DEBUG_PUB.enable_debug;
3312: AHL_DEBUG_PUB.debug('Entering Validate_Rtn_Rec Procedure');
3313: END IF;
3314:
3315: -- Return Quantity should be +ve always.
3316: IF G_DEBUG='Y' THEN

Line 3317: AHL_DEBUG_PUB.debug('Validating quantity...['||to_Char(p_x_ahl_mtlrtn_rec.Return_Qty)||']');

3313: END IF;
3314:
3315: -- Return Quantity should be +ve always.
3316: IF G_DEBUG='Y' THEN
3317: AHL_DEBUG_PUB.debug('Validating quantity...['||to_Char(p_x_ahl_mtlrtn_rec.Return_Qty)||']');
3318: END IF;
3319:
3320: IF p_x_ahl_mtlrtn_rec.Return_Qty IS NULL THEN
3321: FND_MESSAGE.Set_Name('AHL','AHL_CMP_RTN_QTY_NULL'); -- Return quantity cannot be null.

Line 3380: AHL_DEBUG_PUB.debug('after all the validations, ret_status['|| x_return_status || ']');

3376: END IF;
3377: END IF;
3378:
3379: IF G_DEBUG='Y' THEN
3380: AHL_DEBUG_PUB.debug('after all the validations, ret_status['|| x_return_status || ']');
3381: END IF;
3382:
3383:
3384: END Validate_Rtn_Rec;