DBA Data[Home] [Help]

APPS.AHL_MC_NODE_PUB dependencies on FND_LOG

Line 76: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

72: -- Initialize API return status to success
73: x_return_status := FND_API.G_RET_STS_SUCCESS;
74:
75: -- API body starts here
76: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
77: THEN
78: fnd_log.string
79: (
80: fnd_log.level_procedure,

Line 78: fnd_log.string

74:
75: -- API body starts here
76: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
77: THEN
78: fnd_log.string
79: (
80: fnd_log.level_procedure,
81: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.begin',
82: 'At the start of PLSQL procedure'

Line 80: fnd_log.level_procedure,

76: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
77: THEN
78: fnd_log.string
79: (
80: fnd_log.level_procedure,
81: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.begin',
82: 'At the start of PLSQL procedure'
83: );
84: END IF;

Line 97: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

93: THEN
94: -- This is a mandatory field, hence throw error
95: FND_MESSAGE.Set_Name('AHL','AHL_MC_POSREF_NULL');
96: FND_MSG_PUB.ADD;
97: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
98: THEN
99: fnd_log.message
100: (
101: fnd_log.level_exception,

Line 99: fnd_log.message

95: FND_MESSAGE.Set_Name('AHL','AHL_MC_POSREF_NULL');
96: FND_MSG_PUB.ADD;
97: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
98: THEN
99: fnd_log.message
100: (
101: fnd_log.level_exception,
102: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
103: false

Line 101: fnd_log.level_exception,

97: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
98: THEN
99: fnd_log.message
100: (
101: fnd_log.level_exception,
102: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
103: false
104: );
105: END IF;

Line 120: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

116: THEN
117: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_POSREF_INVALID');
118: FND_MESSAGE.Set_Token('POSREF', p_x_node_rec.position_ref_meaning);
119: FND_MSG_PUB.ADD;
120: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
121: THEN
122: fnd_log.message
123: (
124: fnd_log.level_exception,

Line 122: fnd_log.message

118: FND_MESSAGE.Set_Token('POSREF', p_x_node_rec.position_ref_meaning);
119: FND_MSG_PUB.ADD;
120: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
121: THEN
122: fnd_log.message
123: (
124: fnd_log.level_exception,
125: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
126: false

Line 124: fnd_log.level_exception,

120: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
121: THEN
122: fnd_log.message
123: (
124: fnd_log.level_exception,
125: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
126: false
127: );
128: END IF;

Line 152: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

148: THEN
149: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_ATASEQ_INVALID');
150: FND_MESSAGE.Set_Token('ATAMEANING', p_x_node_rec.ata_meaning);
151: FND_MSG_PUB.ADD;
152: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
153: THEN
154: fnd_log.message
155: (
156: fnd_log.level_exception,

Line 154: fnd_log.message

150: FND_MESSAGE.Set_Token('ATAMEANING', p_x_node_rec.ata_meaning);
151: FND_MSG_PUB.ADD;
152: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
153: THEN
154: fnd_log.message
155: (
156: fnd_log.level_exception,
157: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
158: false

Line 156: fnd_log.level_exception,

152: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
153: THEN
154: fnd_log.message
155: (
156: fnd_log.level_exception,
157: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
158: false
159: );
160: END IF;

Line 173: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

169: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_ATASEQ_INVALID');
170: FND_MESSAGE.Set_Token('ATA', p_x_node_rec.ata_meaning);
171: FND_MESSAGE.Set_Token('CODE', p_x_node_rec.ata_code);
172: FND_MSG_PUB.ADD;
173: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
174: THEN
175: fnd_log.message
176: (
177: fnd_log.level_exception,

Line 175: fnd_log.message

171: FND_MESSAGE.Set_Token('CODE', p_x_node_rec.ata_code);
172: FND_MSG_PUB.ADD;
173: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
174: THEN
175: fnd_log.message
176: (
177: fnd_log.level_exception,
178: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
179: false

Line 177: fnd_log.level_exception,

173: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
174: THEN
175: fnd_log.message
176: (
177: fnd_log.level_exception,
178: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
179: false
180: );
181: END IF; */

Line 192: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

188: THEN
189: -- This is a mandatory field, hence throw error
190: FND_MESSAGE.Set_Name('AHL','AHL_MC_NECESSITY_NULL');
191: FND_MSG_PUB.ADD;
192: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
193: THEN
194: fnd_log.message
195: (
196: fnd_log.level_exception,

Line 194: fnd_log.message

190: FND_MESSAGE.Set_Name('AHL','AHL_MC_NECESSITY_NULL');
191: FND_MSG_PUB.ADD;
192: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
193: THEN
194: fnd_log.message
195: (
196: fnd_log.level_exception,
197: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
198: false

Line 196: fnd_log.level_exception,

192: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
193: THEN
194: fnd_log.message
195: (
196: fnd_log.level_exception,
197: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
198: false
199: );
200: END IF;

Line 207: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

203: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_NECESSITY_INVALID');
204: FND_MESSAGE.Set_Token('POSREF', p_x_node_rec.position_ref_meaning);
205: FND_MESSAGE.Set_Token('CODE', p_x_node_rec.position_necessity_code);
206: FND_MSG_PUB.ADD;
207: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
208: THEN
209: fnd_log.message
210: (
211: fnd_log.level_exception,

Line 209: fnd_log.message

205: FND_MESSAGE.Set_Token('CODE', p_x_node_rec.position_necessity_code);
206: FND_MSG_PUB.ADD;
207: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
208: THEN
209: fnd_log.message
210: (
211: fnd_log.level_exception,
212: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
213: false

Line 211: fnd_log.level_exception,

207: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
208: THEN
209: fnd_log.message
210: (
211: fnd_log.level_exception,
212: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
213: false
214: );
215: END IF;

Line 232: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

228: THEN
229: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_ITEMGRP_INVALID');
230: FND_MESSAGE.Set_Token('ITEM_GRP', p_x_node_rec.item_group_name);
231: FND_MSG_PUB.ADD;
232: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
233: THEN
234: fnd_log.message
235: (
236: fnd_log.level_exception,

Line 234: fnd_log.message

230: FND_MESSAGE.Set_Token('ITEM_GRP', p_x_node_rec.item_group_name);
231: FND_MSG_PUB.ADD;
232: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
233: THEN
234: fnd_log.message
235: (
236: fnd_log.level_exception,
237: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
238: false

Line 236: fnd_log.level_exception,

232: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
233: THEN
234: fnd_log.message
235: (
236: fnd_log.level_exception,
237: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
238: false
239: );
240: END IF;

Line 268: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

264: THEN
265: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_MC_INVALID');
266: FND_MESSAGE.Set_Token('MC_NAME', p_x_subconfig_tbl(i).name);
267: FND_MSG_PUB.ADD;
268: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
269: THEN
270: fnd_log.message
271: (
272: fnd_log.level_exception,

Line 270: fnd_log.message

266: FND_MESSAGE.Set_Token('MC_NAME', p_x_subconfig_tbl(i).name);
267: FND_MSG_PUB.ADD;
268: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
269: THEN
270: fnd_log.message
271: (
272: fnd_log.level_exception,
273: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
274: false

Line 272: fnd_log.level_exception,

268: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
269: THEN
270: fnd_log.message
271: (
272: fnd_log.level_exception,
273: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
274: false
275: );
276: END IF;

Line 284: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

280: CLOSE get_subconfig_id;
281: ELSE
282: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_SUBMC_NULL');
283: FND_MSG_PUB.ADD;
284: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
285: THEN
286: fnd_log.message
287: (
288: fnd_log.level_exception,

Line 286: fnd_log.message

282: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_SUBMC_NULL');
283: FND_MSG_PUB.ADD;
284: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
285: THEN
286: fnd_log.message
287: (
288: fnd_log.level_exception,
289: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
290: false

Line 288: fnd_log.level_exception,

284: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
285: THEN
286: fnd_log.message
287: (
288: fnd_log.level_exception,
289: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
290: false
291: );
292: END IF;

Line 311: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

307: THEN
308: -- This is a mandatory field, hence throw error
309: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_RULE_NULL');
310: FND_MSG_PUB.ADD;
311: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
312: THEN
313: fnd_log.message
314: (
315: fnd_log.level_exception,

Line 313: fnd_log.message

309: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_RULE_NULL');
310: FND_MSG_PUB.ADD;
311: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
312: THEN
313: fnd_log.message
314: (
315: fnd_log.level_exception,
316: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
317: false

Line 315: fnd_log.level_exception,

311: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
312: THEN
313: fnd_log.message
314: (
315: fnd_log.level_exception,
316: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
317: false
318: );
319: END IF;

Line 325: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

321: THEN
322: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_RULE_INVALID');
323: FND_MESSAGE.Set_Token('RULE', p_x_counter_rules_tbl(i).rule_meaning);
324: FND_MSG_PUB.ADD;
325: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
326: THEN
327: fnd_log.message
328: (
329: fnd_log.level_exception,

Line 327: fnd_log.message

323: FND_MESSAGE.Set_Token('RULE', p_x_counter_rules_tbl(i).rule_meaning);
324: FND_MSG_PUB.ADD;
325: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
326: THEN
327: fnd_log.message
328: (
329: fnd_log.level_exception,
330: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
331: false

Line 329: fnd_log.level_exception,

325: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
326: THEN
327: fnd_log.message
328: (
329: fnd_log.level_exception,
330: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
331: false
332: );
333: END IF;

Line 392: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

388: p_x_subconfig_tbl => p_x_subconfig_tbl
389: );
390: END IF;
391:
392: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
393: THEN
394: fnd_log.string
395: (
396: fnd_log.level_procedure,

Line 394: fnd_log.string

390: END IF;
391:
392: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
393: THEN
394: fnd_log.string
395: (
396: fnd_log.level_procedure,
397: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.end',
398: 'At the end of PLSQL procedure'

Line 396: fnd_log.level_procedure,

392: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
393: THEN
394: fnd_log.string
395: (
396: fnd_log.level_procedure,
397: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.end',
398: 'At the end of PLSQL procedure'
399: );
400: END IF;

Line 510: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

506: -- Initialize API return status to success
507: x_return_status := FND_API.G_RET_STS_SUCCESS;
508:
509: -- API body starts here
510: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
511: THEN
512: fnd_log.string
513: (
514: fnd_log.level_procedure,

Line 512: fnd_log.string

508:
509: -- API body starts here
510: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
511: THEN
512: fnd_log.string
513: (
514: fnd_log.level_procedure,
515: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.begin',
516: 'At the start of PLSQL procedure'

Line 514: fnd_log.level_procedure,

510: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
511: THEN
512: fnd_log.string
513: (
514: fnd_log.level_procedure,
515: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.begin',
516: 'At the start of PLSQL procedure'
517: );
518: END IF;

Line 537: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

533: p_node_id => p_nodes_tbl(i).relationship_id,
534: p_object_ver_num => p_nodes_tbl(i).object_version_number
535: );
536:
537: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
538: THEN
539: fnd_log.string
540: (
541: fnd_log.level_statement,

Line 539: fnd_log.string

535: );
536:
537: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
538: THEN
539: fnd_log.string
540: (
541: fnd_log.level_statement,
542: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
543: 'Deleted Node ['||p_nodes_tbl(i).relationship_id||']'

Line 541: fnd_log.level_statement,

537: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
538: THEN
539: fnd_log.string
540: (
541: fnd_log.level_statement,
542: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
543: 'Deleted Node ['||p_nodes_tbl(i).relationship_id||']'
544: );
545: END IF;

Line 555: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

551: END IF;
552: END LOOP;
553: END IF;
554:
555: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
556: THEN
557: fnd_log.string
558: (
559: fnd_log.level_procedure,

Line 557: fnd_log.string

553: END IF;
554:
555: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
556: THEN
557: fnd_log.string
558: (
559: fnd_log.level_procedure,
560: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.end',
561: 'At the end of PLSQL procedure'

Line 559: fnd_log.level_procedure,

555: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
556: THEN
557: fnd_log.string
558: (
559: fnd_log.level_procedure,
560: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.end',
561: 'At the end of PLSQL procedure'
562: );
563: END IF;