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.0.12010000.1 2008/11/05 14:22:23 sathapli noship $ */
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.0.12010000.1 2008/11/05 14:22:23 sathapli noship $ */
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.0.12010000.1 2008/11/05 14:22:23 sathapli noship $ */
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 100: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Entered');

96: l_rel_id NUMBER;
97:
98: BEGIN
99: IF (l_log_statement >= l_log_current_level) THEN
100: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Entered');
101: END IF;
102:
103: -- log the input
104: IF (l_log_statement >= l_log_current_level) THEN

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

101: END IF;
102:
103: -- log the input
104: IF (l_log_statement >= l_log_current_level) THEN
105: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'p_primary_object_id:' || p_primary_object_id);
106: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'p_secondary_object_id:'||p_secondary_object_id);
107: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'p_object_type:'||p_object_type);
108: END IF;
109:

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

102:
103: -- log the input
104: IF (l_log_statement >= l_log_current_level) THEN
105: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'p_primary_object_id:' || p_primary_object_id);
106: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'p_secondary_object_id:'||p_secondary_object_id);
107: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'p_object_type:'||p_object_type);
108: END IF;
109:
110:

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

103: -- log the input
104: IF (l_log_statement >= l_log_current_level) THEN
105: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'p_primary_object_id:' || p_primary_object_id);
106: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'p_secondary_object_id:'||p_secondary_object_id);
107: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'p_object_type:'||p_object_type);
108: END IF;
109:
110:
111: -- Object Type is MC and the object id is relationship id

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

110:
111: -- Object Type is MC and the object id is relationship id
112: IF (p_object_type = 'MC') THEN
113: IF (l_log_statement >= l_log_current_level) THEN
114: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Object Type is MC');
115: END IF;
116:
117: OPEN get_model_and_ata_csr(p_primary_object_id);
118: FETCH get_model_and_ata_csr INTO x_model,x_ata_code;

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

120:
121: x_tail_number := '';
122: x_doc_id := replace(x_ata_code,'-');
123: IF (l_log_statement >= l_log_current_level) THEN
124: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Model->' || x_model);
125: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'ATA Code->' || x_ata_code);
126: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Tail Number->' || x_tail_number);
127: END IF;
128:

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

121: x_tail_number := '';
122: x_doc_id := replace(x_ata_code,'-');
123: IF (l_log_statement >= l_log_current_level) THEN
124: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Model->' || x_model);
125: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'ATA Code->' || x_ata_code);
126: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Tail Number->' || x_tail_number);
127: END IF;
128:
129: -- SATHAPLI::Enigma code changes, 19-Sep-2008 - UC handling is done in the class AhlEnigmaDocHelper itself.

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

122: x_doc_id := replace(x_ata_code,'-');
123: IF (l_log_statement >= l_log_current_level) THEN
124: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Model->' || x_model);
125: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'ATA Code->' || x_ata_code);
126: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Tail Number->' || x_tail_number);
127: END IF;
128:
129: -- SATHAPLI::Enigma code changes, 19-Sep-2008 - UC handling is done in the class AhlEnigmaDocHelper itself.
130: /*

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

131: -- object type is UC
132: ELSIF (p_object_type = 'UC') THEN
133: -- Use instance id to get the details
134: IF (l_log_statement >= l_log_current_level) THEN
135: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Object Type is UC');
136: END IF;
137: IF (p_primary_object_id IS NOT NULL AND p_primary_object_id <> 0) THEN
138: IF (l_log_statement >= l_log_current_level) THEN
139: 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 139: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Instance ID will be used to get the details');

135: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Object Type is UC');
136: END IF;
137: IF (p_primary_object_id IS NOT NULL AND p_primary_object_id <> 0) THEN
138: IF (l_log_statement >= l_log_current_level) THEN
139: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Instance ID will be used to get the details');
140: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'p_primary_object_id->' || p_primary_object_id);
141: END IF;
142: x_tail_number := AHL_UTIL_UC_PKG.get_unit_name(p_primary_object_id);
143: p_relationship_id := AHL_UTIL_UC_PKG.Map_Instance_to_RelID(p_primary_object_id);

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

136: END IF;
137: IF (p_primary_object_id IS NOT NULL AND p_primary_object_id <> 0) THEN
138: IF (l_log_statement >= l_log_current_level) THEN
139: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Instance ID will be used to get the details');
140: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'p_primary_object_id->' || p_primary_object_id);
141: END IF;
142: x_tail_number := AHL_UTIL_UC_PKG.get_unit_name(p_primary_object_id);
143: p_relationship_id := AHL_UTIL_UC_PKG.Map_Instance_to_RelID(p_primary_object_id);
144: OPEN get_model_and_ata_csr(p_relationship_id);

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

145: FETCH get_model_and_ata_csr INTO x_model,x_ata_code;
146: CLOSE get_model_and_ata_csr;
147: x_doc_id := replace(x_ata_code,'-');
148: IF (l_log_statement >= l_log_current_level) THEN
149: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Relationship Id->' || p_relationship_id);
150: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Model->' || x_model);
151: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'ATA Code->' || x_ata_code);
152: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Tail Number->' || x_tail_number);
153: END IF;

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

146: CLOSE get_model_and_ata_csr;
147: x_doc_id := replace(x_ata_code,'-');
148: IF (l_log_statement >= l_log_current_level) THEN
149: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Relationship Id->' || p_relationship_id);
150: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Model->' || x_model);
151: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'ATA Code->' || x_ata_code);
152: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Tail Number->' || x_tail_number);
153: END IF;
154: ELSE

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

147: x_doc_id := replace(x_ata_code,'-');
148: IF (l_log_statement >= l_log_current_level) THEN
149: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Relationship Id->' || p_relationship_id);
150: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Model->' || x_model);
151: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'ATA Code->' || x_ata_code);
152: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Tail Number->' || x_tail_number);
153: END IF;
154: ELSE
155: -- There is no instance at this node, which means we will have to show the details for the complete UC

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

148: IF (l_log_statement >= l_log_current_level) THEN
149: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Relationship Id->' || p_relationship_id);
150: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Model->' || x_model);
151: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'ATA Code->' || x_ata_code);
152: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Tail Number->' || x_tail_number);
153: END IF;
154: ELSE
155: -- There is no instance at this node, which means we will have to show the details for the complete UC
156: IF (l_log_statement >= l_log_current_level) THEN

Line 157: 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');

153: END IF;
154: ELSE
155: -- There is no instance at this node, which means we will have to show the details for the complete UC
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,'Node has no instance,UC header id will be used');
158: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'p_secondary_object_id->' || p_secondary_object_id);
159: END IF;
160: --x_doc_id := replace(x_ata_code,'-');
161: --*******************************

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

154: ELSE
155: -- There is no instance at this node, which means we will have to show the details for the complete UC
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,'Node has no instance,UC header id will be used');
158: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'p_secondary_object_id->' || p_secondary_object_id);
159: END IF;
160: --x_doc_id := replace(x_ata_code,'-');
161: --*******************************
162: --mpothuku changed on 29-Dec-06

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

166: OPEN get_model_and_tail_csr(p_secondary_object_id);
167: FETCH get_model_and_tail_csr INTO x_tail_number,x_model;
168: CLOSE get_model_and_tail_csr;
169: IF (l_log_statement >= l_log_current_level) THEN
170: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Model->' || x_model);
171: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'ATA Code->' || x_ata_code);
172: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Tail Number->' || x_tail_number);
173: END IF;
174: END IF;

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

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

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

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

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

175: */
176:
177: ELSIF (p_object_type = 'WO') THEN
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,'Object Type is WO');
180: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Workorder Id is ->' || p_primary_object_id);
181: END IF;
182:
183: -- get the doc id

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

176:
177: ELSIF (p_object_type = 'WO') THEN
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,'Object Type is WO');
180: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Workorder Id is ->' || p_primary_object_id);
181: END IF;
182:
183: -- get the doc id
184: OPEN get_doc_id(p_primary_object_id);

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

186: IF get_doc_id%NOTFOUND THEN
187: x_doc_id := NULL;
188: END IF;
189: IF (l_log_statement >= l_log_current_level) THEN
190: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Document Id is->' || x_doc_id);
191: END IF;
192:
193: -- get the model
194: OPEN get_wo_model_tail_csr(p_primary_object_id);

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

204: FETCH get_model_and_ata_csr INTO x_model,x_ata_code;
205: CLOSE get_model_and_ata_csr;
206: END IF;
207: IF (l_log_statement >= l_log_current_level) THEN
208: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'x_model ->' || x_doc_id);
209: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'x_tail_number ->' || x_tail_number);
210: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'l_instance_id ->' || l_instance_id);
211: END IF;
212:

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

205: CLOSE get_model_and_ata_csr;
206: END IF;
207: IF (l_log_statement >= l_log_current_level) THEN
208: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'x_model ->' || x_doc_id);
209: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'x_tail_number ->' || x_tail_number);
210: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'l_instance_id ->' || l_instance_id);
211: END IF;
212:
213: ELSIF (p_object_type = 'WO_MC_DOC') THEN

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

206: END IF;
207: IF (l_log_statement >= l_log_current_level) THEN
208: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'x_model ->' || x_doc_id);
209: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'x_tail_number ->' || x_tail_number);
210: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'l_instance_id ->' || l_instance_id);
211: END IF;
212:
213: ELSIF (p_object_type = 'WO_MC_DOC') THEN
214: IF (l_log_statement >= l_log_current_level) THEN

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

211: END IF;
212:
213: ELSIF (p_object_type = 'WO_MC_DOC') THEN
214: IF (l_log_statement >= l_log_current_level) THEN
215: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Object Type is WO');
216: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Workorder Id is ->' || p_primary_object_id);
217: END IF;
218:
219: -- get the model

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

212:
213: ELSIF (p_object_type = 'WO_MC_DOC') THEN
214: IF (l_log_statement >= l_log_current_level) THEN
215: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Object Type is WO');
216: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Workorder Id is ->' || p_primary_object_id);
217: END IF;
218:
219: -- get the model
220: OPEN get_wo_model_tail_csr(p_primary_object_id);

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

233:
234: x_doc_id := replace(x_ata_code,'-');
235:
236: IF (l_log_statement >= l_log_current_level) THEN
237: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'x_model ->' || x_model);
238: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'x_doc_id ->' || x_doc_id);
239: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'l_rel_id ->' || l_rel_id);
240: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'x_tail_number ->' || x_tail_number);
241: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'l_instance_id ->' || l_instance_id);

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

234: x_doc_id := replace(x_ata_code,'-');
235:
236: IF (l_log_statement >= l_log_current_level) THEN
237: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'x_model ->' || x_model);
238: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'x_doc_id ->' || x_doc_id);
239: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'l_rel_id ->' || l_rel_id);
240: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'x_tail_number ->' || x_tail_number);
241: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'l_instance_id ->' || l_instance_id);
242: END IF;

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

235:
236: IF (l_log_statement >= l_log_current_level) THEN
237: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'x_model ->' || x_model);
238: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'x_doc_id ->' || x_doc_id);
239: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'l_rel_id ->' || l_rel_id);
240: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'x_tail_number ->' || x_tail_number);
241: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'l_instance_id ->' || l_instance_id);
242: END IF;
243:

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

236: IF (l_log_statement >= l_log_current_level) THEN
237: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'x_model ->' || x_model);
238: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'x_doc_id ->' || x_doc_id);
239: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'l_rel_id ->' || l_rel_id);
240: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'x_tail_number ->' || x_tail_number);
241: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'l_instance_id ->' || l_instance_id);
242: END IF;
243:
244: ELSIF (p_object_type = 'RT') THEN

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

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

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

242: END IF;
243:
244: ELSIF (p_object_type = 'RT') THEN
245: IF (l_log_statement >= l_log_current_level) THEN
246: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Object Type is RT');
247: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Route Id is ->' || p_primary_object_id);
248: END IF;
249: OPEN c_get_route_details(p_primary_object_id);
250: FETCH c_get_route_details INTO x_doc_id,x_model;

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

243:
244: ELSIF (p_object_type = 'RT') THEN
245: IF (l_log_statement >= l_log_current_level) THEN
246: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Object Type is RT');
247: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Route Id is ->' || p_primary_object_id);
248: END IF;
249: OPEN c_get_route_details(p_primary_object_id);
250: FETCH c_get_route_details INTO x_doc_id,x_model;
251: CLOSE c_get_route_details;

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

249: OPEN c_get_route_details(p_primary_object_id);
250: FETCH c_get_route_details INTO x_doc_id,x_model;
251: CLOSE c_get_route_details;
252: IF (l_log_statement >= l_log_current_level) THEN
253: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Doc Id is:' || x_doc_id);
254: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Model is :' || x_model);
255: END IF;
256: END IF;
257:

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

250: FETCH c_get_route_details INTO x_doc_id,x_model;
251: CLOSE c_get_route_details;
252: IF (l_log_statement >= l_log_current_level) THEN
253: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Doc Id is:' || x_doc_id);
254: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Model is :' || x_model);
255: END IF;
256: END IF;
257:
258: OPEN get_user_and_lang;

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

258: OPEN get_user_and_lang;
259: FETCH get_user_and_lang INTO x_user_name,x_user_lang;
260: CLOSE get_user_and_lang;
261: IF (l_log_statement >= l_log_current_level) THEN
262: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'user name->' || x_user_name);
263: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'user lang->' || x_user_lang);
264: END IF;
265: END get_enigma_url_params;
266:

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

259: FETCH get_user_and_lang INTO x_user_name,x_user_lang;
260: CLOSE get_user_and_lang;
261: IF (l_log_statement >= l_log_current_level) THEN
262: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'user name->' || x_user_name);
263: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'user lang->' || x_user_lang);
264: END IF;
265: END get_enigma_url_params;
266:
267: