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.AHL_ENIGMA_UTIL_PKG dependencies on FND_LOG

Line 4: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;

1: PACKAGE BODY AHL_ENIGMA_UTIL_PKG AS
2: /* $Header: AHLUENGB.pls 120.2.12020000.2 2012/12/10 16:47:07 prakkum ship $ */
3:
4: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;
5: l_log_statement NUMBER := fnd_log.level_statement;
6: l_log_procedure NUMBER := fnd_log.level_procedure;
7: l_log_error NUMBER := fnd_log.level_error;
8: l_log_unexpected NUMBER := fnd_log.level_unexpected;

Line 5: l_log_statement NUMBER := fnd_log.level_statement;

1: PACKAGE BODY AHL_ENIGMA_UTIL_PKG AS
2: /* $Header: AHLUENGB.pls 120.2.12020000.2 2012/12/10 16:47:07 prakkum ship $ */
3:
4: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;
5: l_log_statement NUMBER := fnd_log.level_statement;
6: l_log_procedure NUMBER := fnd_log.level_procedure;
7: l_log_error NUMBER := fnd_log.level_error;
8: l_log_unexpected NUMBER := fnd_log.level_unexpected;
9:

Line 6: l_log_procedure NUMBER := fnd_log.level_procedure;

2: /* $Header: AHLUENGB.pls 120.2.12020000.2 2012/12/10 16:47:07 prakkum ship $ */
3:
4: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;
5: l_log_statement NUMBER := fnd_log.level_statement;
6: l_log_procedure NUMBER := fnd_log.level_procedure;
7: l_log_error NUMBER := fnd_log.level_error;
8: l_log_unexpected NUMBER := fnd_log.level_unexpected;
9:
10: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_ENIGMA_UTIL_PKG';

Line 7: l_log_error NUMBER := fnd_log.level_error;

3:
4: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;
5: l_log_statement NUMBER := fnd_log.level_statement;
6: l_log_procedure NUMBER := fnd_log.level_procedure;
7: l_log_error NUMBER := fnd_log.level_error;
8: l_log_unexpected NUMBER := fnd_log.level_unexpected;
9:
10: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_ENIGMA_UTIL_PKG';
11:

Line 8: l_log_unexpected NUMBER := fnd_log.level_unexpected;

4: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;
5: l_log_statement NUMBER := fnd_log.level_statement;
6: l_log_procedure NUMBER := fnd_log.level_procedure;
7: l_log_error NUMBER := fnd_log.level_error;
8: l_log_unexpected NUMBER := fnd_log.level_unexpected;
9:
10: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_ENIGMA_UTIL_PKG';
11:
12: ----------------------------------------------------------------------------------------------------------

Line 122: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Entered');

118: l_dummy VARCHAR2(40);
119:
120: BEGIN
121: IF (l_log_statement >= l_log_current_level) THEN
122: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Entered');
123: END IF;
124:
125: -- log the input
126: IF (l_log_statement >= l_log_current_level) THEN

Line 127: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'p_primary_object_id:' || p_primary_object_id);

123: END IF;
124:
125: -- log the input
126: IF (l_log_statement >= l_log_current_level) THEN
127: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'p_primary_object_id:' || p_primary_object_id);
128: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'p_secondary_object_id:'||p_secondary_object_id);
129: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'p_object_type:'||p_object_type);
130: END IF;
131:

Line 128: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'p_secondary_object_id:'||p_secondary_object_id);

124:
125: -- log the input
126: IF (l_log_statement >= l_log_current_level) THEN
127: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'p_primary_object_id:' || p_primary_object_id);
128: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'p_secondary_object_id:'||p_secondary_object_id);
129: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'p_object_type:'||p_object_type);
130: END IF;
131:
132:

Line 129: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'p_object_type:'||p_object_type);

125: -- log the input
126: IF (l_log_statement >= l_log_current_level) THEN
127: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'p_primary_object_id:' || p_primary_object_id);
128: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'p_secondary_object_id:'||p_secondary_object_id);
129: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'p_object_type:'||p_object_type);
130: END IF;
131:
132:
133: -- Object Type is MC and the object id is relationship id

Line 136: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Object Type is MC');

132:
133: -- Object Type is MC and the object id is relationship id
134: IF (p_object_type = 'MC') THEN
135: IF (l_log_statement >= l_log_current_level) THEN
136: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Object Type is MC');
137: END IF;
138:
139: OPEN get_model_and_ata_csr(p_primary_object_id);
140: FETCH get_model_and_ata_csr INTO x_model,x_ata_code;

Line 146: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Model->' || x_model);

142:
143: x_tail_number := '';
144: x_doc_id := replace(x_ata_code,'-');
145: IF (l_log_statement >= l_log_current_level) THEN
146: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Model->' || x_model);
147: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'ATA Code->' || x_ata_code);
148: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Tail Number->' || x_tail_number);
149: END IF;
150:

Line 147: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'ATA Code->' || x_ata_code);

143: x_tail_number := '';
144: x_doc_id := replace(x_ata_code,'-');
145: IF (l_log_statement >= l_log_current_level) THEN
146: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Model->' || x_model);
147: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'ATA Code->' || x_ata_code);
148: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Tail Number->' || x_tail_number);
149: END IF;
150:
151: -- SATHAPLI::Enigma code changes, 19-Sep-2008 - UC handling is done in the class AhlEnigmaDocHelper itself.

Line 148: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Tail Number->' || x_tail_number);

144: x_doc_id := replace(x_ata_code,'-');
145: IF (l_log_statement >= l_log_current_level) THEN
146: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Model->' || x_model);
147: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'ATA Code->' || x_ata_code);
148: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Tail Number->' || x_tail_number);
149: END IF;
150:
151: -- SATHAPLI::Enigma code changes, 19-Sep-2008 - UC handling is done in the class AhlEnigmaDocHelper itself.
152: /*

Line 157: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Object Type is UC');

153: -- object type is UC
154: ELSIF (p_object_type = 'UC') THEN
155: -- Use instance id to get the details
156: IF (l_log_statement >= l_log_current_level) THEN
157: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Object Type is UC');
158: END IF;
159: IF (p_primary_object_id IS NOT NULL AND p_primary_object_id <> 0) THEN
160: IF (l_log_statement >= l_log_current_level) THEN
161: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Instance ID will be used to get the details');

Line 161: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Instance ID will be used to get the details');

157: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Object Type is UC');
158: END IF;
159: IF (p_primary_object_id IS NOT NULL AND p_primary_object_id <> 0) THEN
160: IF (l_log_statement >= l_log_current_level) THEN
161: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Instance ID will be used to get the details');
162: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'p_primary_object_id->' || p_primary_object_id);
163: END IF;
164: x_tail_number := AHL_UTIL_UC_PKG.get_unit_name(p_primary_object_id);
165: p_relationship_id := AHL_UTIL_UC_PKG.Map_Instance_to_RelID(p_primary_object_id);

Line 162: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'p_primary_object_id->' || p_primary_object_id);

158: END IF;
159: IF (p_primary_object_id IS NOT NULL AND p_primary_object_id <> 0) THEN
160: IF (l_log_statement >= l_log_current_level) THEN
161: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Instance ID will be used to get the details');
162: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'p_primary_object_id->' || p_primary_object_id);
163: END IF;
164: x_tail_number := AHL_UTIL_UC_PKG.get_unit_name(p_primary_object_id);
165: p_relationship_id := AHL_UTIL_UC_PKG.Map_Instance_to_RelID(p_primary_object_id);
166: OPEN get_model_and_ata_csr(p_relationship_id);

Line 171: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Relationship Id->' || p_relationship_id);

167: FETCH get_model_and_ata_csr INTO x_model,x_ata_code;
168: CLOSE get_model_and_ata_csr;
169: x_doc_id := replace(x_ata_code,'-');
170: IF (l_log_statement >= l_log_current_level) THEN
171: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Relationship Id->' || p_relationship_id);
172: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Model->' || x_model);
173: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'ATA Code->' || x_ata_code);
174: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Tail Number->' || x_tail_number);
175: END IF;

Line 172: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Model->' || x_model);

168: CLOSE get_model_and_ata_csr;
169: x_doc_id := replace(x_ata_code,'-');
170: IF (l_log_statement >= l_log_current_level) THEN
171: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Relationship Id->' || p_relationship_id);
172: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Model->' || x_model);
173: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'ATA Code->' || x_ata_code);
174: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Tail Number->' || x_tail_number);
175: END IF;
176: ELSE

Line 173: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'ATA Code->' || x_ata_code);

169: x_doc_id := replace(x_ata_code,'-');
170: IF (l_log_statement >= l_log_current_level) THEN
171: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Relationship Id->' || p_relationship_id);
172: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Model->' || x_model);
173: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'ATA Code->' || x_ata_code);
174: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Tail Number->' || x_tail_number);
175: END IF;
176: ELSE
177: -- There is no instance at this node, which means we will have to show the details for the complete UC

Line 174: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Tail Number->' || x_tail_number);

170: IF (l_log_statement >= l_log_current_level) THEN
171: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Relationship Id->' || p_relationship_id);
172: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Model->' || x_model);
173: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'ATA Code->' || x_ata_code);
174: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Tail Number->' || x_tail_number);
175: END IF;
176: ELSE
177: -- There is no instance at this node, which means we will have to show the details for the complete UC
178: IF (l_log_statement >= l_log_current_level) THEN

Line 179: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Node has no instance,UC header id will be used');

175: END IF;
176: ELSE
177: -- There is no instance at this node, which means we will have to show the details for the complete UC
178: IF (l_log_statement >= l_log_current_level) THEN
179: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Node has no instance,UC header id will be used');
180: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'p_secondary_object_id->' || p_secondary_object_id);
181: END IF;
182: --x_doc_id := replace(x_ata_code,'-');
183: --*******************************

Line 180: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'p_secondary_object_id->' || p_secondary_object_id);

176: ELSE
177: -- There is no instance at this node, which means we will have to show the details for the complete UC
178: IF (l_log_statement >= l_log_current_level) THEN
179: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Node has no instance,UC header id will be used');
180: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'p_secondary_object_id->' || p_secondary_object_id);
181: END IF;
182: --x_doc_id := replace(x_ata_code,'-');
183: --*******************************
184: --mpothuku changed on 29-Dec-06

Line 192: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Model->' || x_model);

188: OPEN get_model_and_tail_csr(p_secondary_object_id);
189: FETCH get_model_and_tail_csr INTO x_tail_number,x_model;
190: CLOSE get_model_and_tail_csr;
191: IF (l_log_statement >= l_log_current_level) THEN
192: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Model->' || x_model);
193: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'ATA Code->' || x_ata_code);
194: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Tail Number->' || x_tail_number);
195: END IF;
196: END IF;

Line 193: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'ATA Code->' || x_ata_code);

189: FETCH get_model_and_tail_csr INTO x_tail_number,x_model;
190: CLOSE get_model_and_tail_csr;
191: IF (l_log_statement >= l_log_current_level) THEN
192: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Model->' || x_model);
193: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'ATA Code->' || x_ata_code);
194: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Tail Number->' || x_tail_number);
195: END IF;
196: END IF;
197: */

Line 194: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Tail Number->' || x_tail_number);

190: CLOSE get_model_and_tail_csr;
191: IF (l_log_statement >= l_log_current_level) THEN
192: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Model->' || x_model);
193: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'ATA Code->' || x_ata_code);
194: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Tail Number->' || x_tail_number);
195: END IF;
196: END IF;
197: */
198:

Line 201: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Object Type is WO');

197: */
198:
199: ELSIF (p_object_type = 'WO' OR p_object_type = 'WO_AMM') THEN
200: IF (l_log_statement >= l_log_current_level) THEN
201: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Object Type is WO');
202: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Workorder Id is ->' || p_primary_object_id);
203: END IF;
204:
205: -- get the doc id

Line 202: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Workorder Id is ->' || p_primary_object_id);

198:
199: ELSIF (p_object_type = 'WO' OR p_object_type = 'WO_AMM') THEN
200: IF (l_log_statement >= l_log_current_level) THEN
201: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Object Type is WO');
202: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Workorder Id is ->' || p_primary_object_id);
203: END IF;
204:
205: -- get the doc id
206: OPEN get_doc_id(p_primary_object_id);

Line 212: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Document Id is->' || x_doc_id);

208: IF get_doc_id%NOTFOUND THEN
209: x_doc_id := NULL;
210: END IF;
211: IF (l_log_statement >= l_log_current_level) THEN
212: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Document Id is->' || x_doc_id);
213: END IF;
214:
215: -- get the model
216: OPEN get_wo_model_tail_csr(p_primary_object_id);

Line 241: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'x_model ->' || x_model);

237: CLOSE get_wo_model_tail_csr;
238: END IF;
239:
240: IF (l_log_statement >= l_log_current_level) THEN
241: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'x_model ->' || x_model);
242: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'x_tail_number ->' || x_tail_number);
243: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'l_instance_id ->' || l_instance_id);
244: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'x_ata_code ->' || x_ata_code);
245: END IF;

Line 242: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'x_tail_number ->' || x_tail_number);

238: END IF;
239:
240: IF (l_log_statement >= l_log_current_level) THEN
241: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'x_model ->' || x_model);
242: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'x_tail_number ->' || x_tail_number);
243: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'l_instance_id ->' || l_instance_id);
244: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'x_ata_code ->' || x_ata_code);
245: END IF;
246:

Line 243: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'l_instance_id ->' || l_instance_id);

239:
240: IF (l_log_statement >= l_log_current_level) THEN
241: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'x_model ->' || x_model);
242: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'x_tail_number ->' || x_tail_number);
243: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'l_instance_id ->' || l_instance_id);
244: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'x_ata_code ->' || x_ata_code);
245: END IF;
246:
247: ELSIF (p_object_type = 'WO_MC_DOC') THEN

Line 244: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'x_ata_code ->' || x_ata_code);

240: IF (l_log_statement >= l_log_current_level) THEN
241: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'x_model ->' || x_model);
242: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'x_tail_number ->' || x_tail_number);
243: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'l_instance_id ->' || l_instance_id);
244: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'x_ata_code ->' || x_ata_code);
245: END IF;
246:
247: ELSIF (p_object_type = 'WO_MC_DOC') THEN
248: IF (l_log_statement >= l_log_current_level) THEN

Line 249: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Object Type is WO');

245: END IF;
246:
247: ELSIF (p_object_type = 'WO_MC_DOC') THEN
248: IF (l_log_statement >= l_log_current_level) THEN
249: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Object Type is WO');
250: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Workorder Id is ->' || p_primary_object_id);
251: END IF;
252:
253: -- get the model

Line 250: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Workorder Id is ->' || p_primary_object_id);

246:
247: ELSIF (p_object_type = 'WO_MC_DOC') THEN
248: IF (l_log_statement >= l_log_current_level) THEN
249: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Object Type is WO');
250: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Workorder Id is ->' || p_primary_object_id);
251: END IF;
252:
253: -- get the model
254: OPEN get_wo_model_tail_csr(p_primary_object_id);

Line 271: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'x_model ->' || x_model);

267:
268: x_doc_id := replace(x_ata_code,'-');
269:
270: IF (l_log_statement >= l_log_current_level) THEN
271: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'x_model ->' || x_model);
272: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'x_doc_id ->' || x_doc_id);
273: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'l_rel_id ->' || l_rel_id);
274: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'x_tail_number ->' || x_tail_number);
275: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'l_instance_id ->' || l_instance_id);

Line 272: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'x_doc_id ->' || x_doc_id);

268: x_doc_id := replace(x_ata_code,'-');
269:
270: IF (l_log_statement >= l_log_current_level) THEN
271: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'x_model ->' || x_model);
272: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'x_doc_id ->' || x_doc_id);
273: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'l_rel_id ->' || l_rel_id);
274: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'x_tail_number ->' || x_tail_number);
275: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'l_instance_id ->' || l_instance_id);
276: END IF;

Line 273: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'l_rel_id ->' || l_rel_id);

269:
270: IF (l_log_statement >= l_log_current_level) THEN
271: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'x_model ->' || x_model);
272: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'x_doc_id ->' || x_doc_id);
273: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'l_rel_id ->' || l_rel_id);
274: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'x_tail_number ->' || x_tail_number);
275: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'l_instance_id ->' || l_instance_id);
276: END IF;
277:

Line 274: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'x_tail_number ->' || x_tail_number);

270: IF (l_log_statement >= l_log_current_level) THEN
271: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'x_model ->' || x_model);
272: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'x_doc_id ->' || x_doc_id);
273: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'l_rel_id ->' || l_rel_id);
274: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'x_tail_number ->' || x_tail_number);
275: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'l_instance_id ->' || l_instance_id);
276: END IF;
277:
278: ELSIF (p_object_type = 'RT') THEN

Line 275: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'l_instance_id ->' || l_instance_id);

271: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'x_model ->' || x_model);
272: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'x_doc_id ->' || x_doc_id);
273: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'l_rel_id ->' || l_rel_id);
274: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'x_tail_number ->' || x_tail_number);
275: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'l_instance_id ->' || l_instance_id);
276: END IF;
277:
278: ELSIF (p_object_type = 'RT') THEN
279: IF (l_log_statement >= l_log_current_level) THEN

Line 280: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Object Type is RT');

276: END IF;
277:
278: ELSIF (p_object_type = 'RT') THEN
279: IF (l_log_statement >= l_log_current_level) THEN
280: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Object Type is RT');
281: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Route Id is ->' || p_primary_object_id);
282: END IF;
283: OPEN c_get_route_details(p_primary_object_id);
284: FETCH c_get_route_details INTO x_doc_id,x_model;

Line 281: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Route Id is ->' || p_primary_object_id);

277:
278: ELSIF (p_object_type = 'RT') THEN
279: IF (l_log_statement >= l_log_current_level) THEN
280: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Object Type is RT');
281: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Route Id is ->' || p_primary_object_id);
282: END IF;
283: OPEN c_get_route_details(p_primary_object_id);
284: FETCH c_get_route_details INTO x_doc_id,x_model;
285: CLOSE c_get_route_details;

Line 287: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Doc Id is:' || x_doc_id);

283: OPEN c_get_route_details(p_primary_object_id);
284: FETCH c_get_route_details INTO x_doc_id,x_model;
285: CLOSE c_get_route_details;
286: IF (l_log_statement >= l_log_current_level) THEN
287: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Doc Id is:' || x_doc_id);
288: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Model is :' || x_model);
289: END IF;
290:
291: --pekambar Enigma Phase II changes -- start

Line 288: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Model is :' || x_model);

284: FETCH c_get_route_details INTO x_doc_id,x_model;
285: CLOSE c_get_route_details;
286: IF (l_log_statement >= l_log_current_level) THEN
287: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Doc Id is:' || x_doc_id);
288: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Model is :' || x_model);
289: END IF;
290:
291: --pekambar Enigma Phase II changes -- start
292: ELSIF (p_object_type = 'OP') THEN

Line 294: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Object Type is OP');

290:
291: --pekambar Enigma Phase II changes -- start
292: ELSIF (p_object_type = 'OP') THEN
293: IF (l_log_statement >= l_log_current_level) THEN
294: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Object Type is OP');
295: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Operation id is ->' || p_primary_object_id);
296: END IF;
297: OPEN c_get_operation_details(p_primary_object_id);
298: FETCH c_get_operation_details INTO x_doc_id,x_model;

Line 295: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Operation id is ->' || p_primary_object_id);

291: --pekambar Enigma Phase II changes -- start
292: ELSIF (p_object_type = 'OP') THEN
293: IF (l_log_statement >= l_log_current_level) THEN
294: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Object Type is OP');
295: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Operation id is ->' || p_primary_object_id);
296: END IF;
297: OPEN c_get_operation_details(p_primary_object_id);
298: FETCH c_get_operation_details INTO x_doc_id,x_model;
299: CLOSE c_get_operation_details;

Line 301: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Doc Id is:' || x_doc_id);

297: OPEN c_get_operation_details(p_primary_object_id);
298: FETCH c_get_operation_details INTO x_doc_id,x_model;
299: CLOSE c_get_operation_details;
300: IF (l_log_statement >= l_log_current_level) THEN
301: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Doc Id is:' || x_doc_id);
302: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Model is :' || x_model);
303: END IF;
304: ELSIF (p_object_type = 'DI') THEN
305: IF (l_log_statement >= l_log_current_level) THEN

Line 302: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Model is :' || x_model);

298: FETCH c_get_operation_details INTO x_doc_id,x_model;
299: CLOSE c_get_operation_details;
300: IF (l_log_statement >= l_log_current_level) THEN
301: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Doc Id is:' || x_doc_id);
302: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Model is :' || x_model);
303: END IF;
304: ELSIF (p_object_type = 'DI') THEN
305: IF (l_log_statement >= l_log_current_level) THEN
306: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Object Type is DI');

Line 306: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Object Type is DI');

302: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Model is :' || x_model);
303: END IF;
304: ELSIF (p_object_type = 'DI') THEN
305: IF (l_log_statement >= l_log_current_level) THEN
306: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Object Type is DI');
307: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Document Revision id is ->' || p_primary_object_id);
308: END IF;
309: OPEN c_get_document_details(p_primary_object_id);
310: FETCH c_get_document_details INTO x_doc_id,x_model;

Line 307: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Document Revision id is ->' || p_primary_object_id);

303: END IF;
304: ELSIF (p_object_type = 'DI') THEN
305: IF (l_log_statement >= l_log_current_level) THEN
306: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Object Type is DI');
307: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Document Revision id is ->' || p_primary_object_id);
308: END IF;
309: OPEN c_get_document_details(p_primary_object_id);
310: FETCH c_get_document_details INTO x_doc_id,x_model;
311: CLOSE c_get_document_details;

Line 313: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Doc Id is:' || x_doc_id);

309: OPEN c_get_document_details(p_primary_object_id);
310: FETCH c_get_document_details INTO x_doc_id,x_model;
311: CLOSE c_get_document_details;
312: IF (l_log_statement >= l_log_current_level) THEN
313: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Doc Id is:' || x_doc_id);
314: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Model is :' || x_model);
315: END IF;
316: END IF;
317: --pekambar Enigma Phase II changes -- end

Line 314: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Model is :' || x_model);

310: FETCH c_get_document_details INTO x_doc_id,x_model;
311: CLOSE c_get_document_details;
312: IF (l_log_statement >= l_log_current_level) THEN
313: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Doc Id is:' || x_doc_id);
314: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Model is :' || x_model);
315: END IF;
316: END IF;
317: --pekambar Enigma Phase II changes -- end
318:

Line 323: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'user name->' || x_user_name);

319: OPEN get_user_and_lang;
320: FETCH get_user_and_lang INTO x_user_name,x_user_lang;
321: CLOSE get_user_and_lang;
322: IF (l_log_statement >= l_log_current_level) THEN
323: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'user name->' || x_user_name);
324: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'user lang->' || x_user_lang);
325: END IF;
326: END get_enigma_url_params;
327:

Line 324: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'user lang->' || x_user_lang);

320: FETCH get_user_and_lang INTO x_user_name,x_user_lang;
321: CLOSE get_user_and_lang;
322: IF (l_log_statement >= l_log_current_level) THEN
323: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'user name->' || x_user_name);
324: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'user lang->' || x_user_lang);
325: END IF;
326: END get_enigma_url_params;
327:
328: