APPS.AHL_ENIGMA_ROUTE_OP_PUB dependencies on AHL_ENIGMA_ROUTE_OP_PUB

Line 1: PACKAGE BODY AHL_ENIGMA_ROUTE_OP_PUB AS

1: PACKAGE BODY AHL_ENIGMA_ROUTE_OP_PUB AS
2: /* $Header: AHLPEROB.pls 120.4.12020000.4 2013/01/03 09:30:43 arunjk ship $ */
3: ------------------------------------
4: -- Common constants and variables --
5: ------------------------------------

Line 11: G_PKG_NAME VARCHAR2(30) := 'AHL_ENIGMA_ROUTE_OP_PUB';

7: l_log_statement NUMBER := fnd_log.level_statement;
8: l_log_procedure NUMBER := fnd_log.level_procedure;
9: l_log_error NUMBER := fnd_log.level_error;
10: l_log_unexpected NUMBER := fnd_log.level_unexpected;
11: G_PKG_NAME VARCHAR2(30) := 'AHL_ENIGMA_ROUTE_OP_PUB';
12:
13: -----------------------------------
14: -- Process Routes Details --
15: ------------------------------------

Line 169: l_debug_module CONSTANT VARCHAR2(100) := 'ahl.plsql.'||'AHL_ENIGMA_ROUTE_OP_PUB'||'.'||l_api_name;

165:
166: -- Declare local variables
167: l_api_name CONSTANT VARCHAR2(30) := 'Process_Route_Operations';
168: l_api_version CONSTANT NUMBER := 1.0;
169: l_debug_module CONSTANT VARCHAR2(100) := 'ahl.plsql.'||'AHL_ENIGMA_ROUTE_OP_PUB'||'.'||l_api_name;
170:
171: l_dummy VARCHAR2(1);
172: l_route_exists VARCHAR2(1) := FND_API.G_FALSE;
173: l_enigma_route_id VARCHAR2(80);

Line 579: l_debug_module CONSTANT VARCHAR2(100) := 'AHL.PLSQL.'||'AHL_ENIGMA_ROUTE_OP_PUB'||'.'||'MAP_ENIGMA_TO_CMRO_ROUTE_REC';

575: )
576: IS
577: X_file_id NUMBER;
578: x_return_status VARCHAR2(1);
579: l_debug_module CONSTANT VARCHAR2(100) := 'AHL.PLSQL.'||'AHL_ENIGMA_ROUTE_OP_PUB'||'.'||'MAP_ENIGMA_TO_CMRO_ROUTE_REC';
580:
581: BEGIN
582: IF (l_log_statement >= l_log_current_level) THEN
583: fnd_log.string(fnd_log.level_statement,l_debug_module,'In Map_Enigma_To_CMRO_Route_Rec');

Line 653: l_debug_module CONSTANT VARCHAR2(100) := 'AHL.PLSQL.'||'AHL_ENIGMA_ROUTE_OP_PUB'||'.'||'Update_Route_Interface_table';

649: p_isrecoverable IN VARCHAR2,
650: p_reason IN VARCHAR2
651: )
652: IS
653: l_debug_module CONSTANT VARCHAR2(100) := 'AHL.PLSQL.'||'AHL_ENIGMA_ROUTE_OP_PUB'||'.'||'Update_Route_Interface_table';
654:
655: BEGIN
656: IF (l_log_statement >= l_log_current_level) THEN
657: fnd_log.string(fnd_log.level_statement,l_debug_module,'Before Inserting into interface table');

Line 736: l_debug_module CONSTANT VARCHAR2(100) := 'AHL.PLSQL.'||'AHL_ENIGMA_ROUTE_OP_PUB'||'.'||'PROCESS_RT_OP_ASSOC';

732: l_ctr NUMBER;
733: l_last_ctr NUMBER;
734: l_step NUMBER;
735: l_route_op_asso_table AHL_RM_OP_ROUTE_AS_PVT.route_operation_tbl_type;
736: l_debug_module CONSTANT VARCHAR2(100) := 'AHL.PLSQL.'||'AHL_ENIGMA_ROUTE_OP_PUB'||'.'||'PROCESS_RT_OP_ASSOC';
737: l_flag BOOLEAN;
738: l_upper_bound NUMBER;
739:
740: TYPE ASSO_RECORD IS RECORD (

Line 944: l_debug_module CONSTANT VARCHAR2(100) := 'AHL.PLSQL.'||'AHL_ENIGMA_ROUTE_OP_PUB'||'.'||'PROCESS_ROUTE_DETAILS';

940:
941: -- Declare local variables
942: l_api_name CONSTANT VARCHAR2(30) := 'PROCESS_ROUTE_DETAILS';
943: l_api_version CONSTANT NUMBER := 1.0;
944: l_debug_module CONSTANT VARCHAR2(100) := 'AHL.PLSQL.'||'AHL_ENIGMA_ROUTE_OP_PUB'||'.'||'PROCESS_ROUTE_DETAILS';
945:
946: x_route_id NUMBER;
947: l_ovn NUMBER;
948: x_file_id NUMBER;

Line 1635: l_debug_module CONSTANT VARCHAR2(100) := 'AHL.PLSQL.'||'AHL_ENIGMA_ROUTE_OP_PUB'||'.'||'Update_Op_Interface_table';

1631: p_isrecoverable IN VARCHAR2,
1632: p_reason IN VARCHAR2
1633: )
1634: IS
1635: l_debug_module CONSTANT VARCHAR2(100) := 'AHL.PLSQL.'||'AHL_ENIGMA_ROUTE_OP_PUB'||'.'||'Update_Op_Interface_table';
1636:
1637: BEGIN
1638: --IF (l_log_statement >= l_log_current_level) THEN
1639: -- fnd_log.string(fnd_log.level_statement,l_debug_module,'Before Inserting into op interface table');

Line 1724: l_debug_module CONSTANT VARCHAR2(100) := 'ahl.plsql.'||'AHL_ENIGMA_ROUTE_OP_PUB'||'.'||l_api_name;

1720:
1721: -- Declare local variables
1722: l_api_name CONSTANT VARCHAR2(30) := 'Process_OP_Details';
1723: l_api_version CONSTANT NUMBER := 1.0;
1724: l_debug_module CONSTANT VARCHAR2(100) := 'ahl.plsql.'||'AHL_ENIGMA_ROUTE_OP_PUB'||'.'||l_api_name;
1725:
1726: -- Bug # 8285733
1727: l_rev_op_rec c_get_op_rec%ROWTYPE;
1728: l_get_latest_oper_rev get_latest_oper_rev%ROWTYPE;

Line 2439: l_debug_module CONSTANT VARCHAR2(100) := 'ahl.plsql.'||'AHL_ENIGMA_ROUTE_OP_PUB'||'.'||l_api_name;

2435: l_contentBlob BLOB;
2436: l_inputFilePtr BFILE;
2437: seqNo NUMBER;
2438: l_api_name CONSTANT VARCHAR2(30) := 'UPLOAD_REVISION_REPORT';
2439: l_debug_module CONSTANT VARCHAR2(100) := 'ahl.plsql.'||'AHL_ENIGMA_ROUTE_OP_PUB'||'.'||l_api_name;
2440:
2441: BEGIN
2442:
2443: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2520: END AHL_ENIGMA_ROUTE_OP_PUB;

2516: END IF;
2517:
2518: END UPLOAD_REVISION_REPORT;
2519:
2520: END AHL_ENIGMA_ROUTE_OP_PUB;