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_MC_MASTERCONFIG_PVT dependencies on FND_LOG

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

110: -- Initialize API return status to success
111: x_return_status := FND_API.G_RET_STS_SUCCESS;
112:
113: -- API body starts here
114: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
115: THEN
116: fnd_log.string
117: (
118: fnd_log.level_procedure,

Line 116: fnd_log.string

112:
113: -- API body starts here
114: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
115: THEN
116: fnd_log.string
117: (
118: fnd_log.level_procedure,
119: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.begin',
120: 'At the start of PLSQL procedure'

Line 118: fnd_log.level_procedure,

114: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
115: THEN
116: fnd_log.string
117: (
118: fnd_log.level_procedure,
119: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.begin',
120: 'At the start of PLSQL procedure'
121: );
122: END IF;

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

138: IF (RTRIM(p_x_mc_header_rec.name) IS NULL)
139: THEN
140: FND_MESSAGE.Set_Name('AHL','AHL_MC_NAME_INVALID');
141: FND_MSG_PUB.ADD;
142: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
143: THEN
144: fnd_log.message
145: (
146: fnd_log.level_exception,

Line 144: fnd_log.message

140: FND_MESSAGE.Set_Name('AHL','AHL_MC_NAME_INVALID');
141: FND_MSG_PUB.ADD;
142: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
143: THEN
144: fnd_log.message
145: (
146: fnd_log.level_exception,
147: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
148: false

Line 146: fnd_log.level_exception,

142: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
143: THEN
144: fnd_log.message
145: (
146: fnd_log.level_exception,
147: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
148: false
149: );
150: END IF;

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

154: IF (check_other_mc_name_unique%FOUND)
155: THEN
156: FND_MESSAGE.Set_Name('AHL','AHL_MC_RNAME_EXISTS');
157: FND_MSG_PUB.ADD;
158: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
159: THEN
160: fnd_log.message
161: (
162: fnd_log.level_exception,

Line 160: fnd_log.message

156: FND_MESSAGE.Set_Name('AHL','AHL_MC_RNAME_EXISTS');
157: FND_MSG_PUB.ADD;
158: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
159: THEN
160: fnd_log.message
161: (
162: fnd_log.level_exception,
163: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
164: false

Line 162: fnd_log.level_exception,

158: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
159: THEN
160: fnd_log.message
161: (
162: fnd_log.level_exception,
163: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
164: false
165: );
166: END IF;

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

177: THEN
178: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_STATUS_INVALID');
179: FND_MESSAGE.Set_Token('STATUS', p_x_mc_header_rec.config_status_meaning);
180: FND_MSG_PUB.ADD;
181: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
182: THEN
183: fnd_log.message
184: (
185: fnd_log.level_exception,

Line 183: fnd_log.message

179: FND_MESSAGE.Set_Token('STATUS', p_x_mc_header_rec.config_status_meaning);
180: FND_MSG_PUB.ADD;
181: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
182: THEN
183: fnd_log.message
184: (
185: fnd_log.level_exception,
186: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
187: false

Line 185: fnd_log.level_exception,

181: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
182: THEN
183: fnd_log.message
184: (
185: fnd_log.level_exception,
186: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
187: false
188: );
189: END IF;

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

195: THEN
196: RAISE FND_API.G_EXC_ERROR;
197: END IF;
198:
199: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
200: THEN
201: fnd_log.string
202: (
203: fnd_log.level_statement,

Line 201: fnd_log.string

197: END IF;
198:
199: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
200: THEN
201: fnd_log.string
202: (
203: fnd_log.level_statement,
204: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
205: 'Header validation successful'

Line 203: fnd_log.level_statement,

199: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
200: THEN
201: fnd_log.string
202: (
203: fnd_log.level_statement,
204: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
205: 'Header validation successful'
206: );
207: END IF;

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

265: X_LAST_UPDATED_BY => G_USER_ID,
266: X_LAST_UPDATE_LOGIN => G_LOGIN_ID
267: );
268:
269: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
270: THEN
271: fnd_log.string
272: (
273: fnd_log.level_statement,

Line 271: fnd_log.string

267: );
268:
269: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
270: THEN
271: fnd_log.string
272: (
273: fnd_log.level_statement,
274: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
275: 'Header ['||p_x_mc_header_rec.mc_header_id||'] created'

Line 273: fnd_log.level_statement,

269: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
270: THEN
271: fnd_log.string
272: (
273: fnd_log.level_statement,
274: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
275: 'Header ['||p_x_mc_header_rec.mc_header_id||'] created'
276: );
277: END IF;

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

297: IF (p_x_node_rec.position_necessity_code <> 'MANDATORY')
298: THEN
299: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_TOPNODE_NEC_INV');
300: FND_MSG_PUB.ADD;
301: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
302: THEN
303: fnd_log.message
304: (
305: fnd_log.level_exception,

Line 303: fnd_log.message

299: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_TOPNODE_NEC_INV');
300: FND_MSG_PUB.ADD;
301: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
302: THEN
303: fnd_log.message
304: (
305: fnd_log.level_exception,
306: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
307: false

Line 305: fnd_log.level_exception,

301: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
302: THEN
303: fnd_log.message
304: (
305: fnd_log.level_exception,
306: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
307: false
308: );
309: END IF;

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

313: IF (p_x_node_rec.uom_code <> 'Ea')
314: THEN
315: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_TOPNODE_UOM_INV');
316: FND_MSG_PUB.ADD;
317: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
318: THEN
319: fnd_log.message
320: (
321: fnd_log.level_exception,

Line 319: fnd_log.message

315: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_TOPNODE_UOM_INV');
316: FND_MSG_PUB.ADD;
317: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
318: THEN
319: fnd_log.message
320: (
321: fnd_log.level_exception,
322: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
323: false

Line 321: fnd_log.level_exception,

317: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
318: THEN
319: fnd_log.message
320: (
321: fnd_log.level_exception,
322: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
323: false
324: );
325: END IF;

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

328: IF (p_x_node_rec.quantity <> 1)
329: THEN
330: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_TOPNODE_QTY_INV');
331: FND_MSG_PUB.ADD;
332: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
333: THEN
334: fnd_log.message
335: (
336: fnd_log.level_exception,

Line 334: fnd_log.message

330: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_TOPNODE_QTY_INV');
331: FND_MSG_PUB.ADD;
332: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
333: THEN
334: fnd_log.message
335: (
336: fnd_log.level_exception,
337: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
338: false

Line 336: fnd_log.level_exception,

332: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
333: THEN
334: fnd_log.message
335: (
336: fnd_log.level_exception,
337: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
338: false
339: );
340: END IF;

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

343: IF (p_x_node_rec.display_order <> 1)
344: THEN
345: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_TOPNODE_DSP_INV');
346: FND_MSG_PUB.ADD;
347: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
348: THEN
349: fnd_log.message
350: (
351: fnd_log.level_exception,

Line 349: fnd_log.message

345: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_TOPNODE_DSP_INV');
346: FND_MSG_PUB.ADD;
347: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
348: THEN
349: fnd_log.message
350: (
351: fnd_log.level_exception,
352: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
353: false

Line 351: fnd_log.level_exception,

347: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
348: THEN
349: fnd_log.message
350: (
351: fnd_log.level_exception,
352: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
353: false
354: );
355: END IF;

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

361: THEN
362: RAISE FND_API.G_EXC_ERROR;
363: END IF;
364:
365: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
366: THEN
367: fnd_log.string
368: (
369: fnd_log.level_statement,

Line 367: fnd_log.string

363: END IF;
364:
365: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
366: THEN
367: fnd_log.string
368: (
369: fnd_log.level_statement,
370: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
371: 'Node validation successful... Calling AHL_MC_Node_PVT.Create_Node'

Line 369: fnd_log.level_statement,

365: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
366: THEN
367: fnd_log.string
368: (
369: fnd_log.level_statement,
370: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
371: 'Node validation successful... Calling AHL_MC_Node_PVT.Create_Node'
372: );
373: END IF;

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

386: p_x_counter_rules_tbl => l_counter_rules_tbl, -- passed as dummy, cannot pass null
387: p_x_subconfig_tbl => l_subconfig_tbl -- passed as dummy, cannot pass null
388: );
389:
390: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
391: THEN
392: fnd_log.string
393: (
394: fnd_log.level_procedure,

Line 392: fnd_log.string

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

Line 394: fnd_log.level_procedure,

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

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

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

Line 511: fnd_log.string

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

Line 513: fnd_log.level_procedure,

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

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

540: ELSIF (l_header_status <> 'DRAFT')
541: THEN
542: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_EDIT_STS_INV');
543: FND_MSG_PUB.ADD;
544: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
545: THEN
546: fnd_log.message
547: (
548: fnd_log.level_exception,

Line 546: fnd_log.message

542: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_EDIT_STS_INV');
543: FND_MSG_PUB.ADD;
544: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
545: THEN
546: fnd_log.message
547: (
548: fnd_log.level_exception,
549: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
550: false

Line 548: fnd_log.level_exception,

544: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
545: THEN
546: fnd_log.message
547: (
548: fnd_log.level_exception,
549: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
550: false
551: );
552: END IF;

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

571: THEN
572: RAISE FND_API.G_EXC_ERROR;
573: END IF;
574:
575: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
576: THEN
577: fnd_log.string
578: (
579: fnd_log.level_statement,

Line 577: fnd_log.string

573: END IF;
574:
575: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
576: THEN
577: fnd_log.string
578: (
579: fnd_log.level_statement,
580: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
581: 'Header validation successful'

Line 579: fnd_log.level_statement,

575: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
576: THEN
577: fnd_log.string
578: (
579: fnd_log.level_statement,
580: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
581: 'Header validation successful'
582: );
583: END IF;

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

623: X_LAST_UPDATED_BY => G_USER_ID,
624: X_LAST_UPDATE_LOGIN => G_LOGIN_ID
625: );
626:
627: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
628: THEN
629: fnd_log.string
630: (
631: fnd_log.level_statement,

Line 629: fnd_log.string

625: );
626:
627: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
628: THEN
629: fnd_log.string
630: (
631: fnd_log.level_statement,
632: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
633: 'Header ['||p_x_mc_header_rec.mc_header_id||'] updated'

Line 631: fnd_log.level_statement,

627: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
628: THEN
629: fnd_log.string
630: (
631: fnd_log.level_statement,
632: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
633: 'Header ['||p_x_mc_header_rec.mc_header_id||'] updated'
634: );
635: END IF;

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

638: IF (p_x_node_rec.mc_header_id <> p_x_mc_header_rec.mc_header_id)
639: THEN
640: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_TOPNODE_NOTFOUND');
641: FND_MSG_PUB.ADD;
642: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
643: THEN
644: fnd_log.message
645: (
646: fnd_log.level_exception,

Line 644: fnd_log.message

640: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_TOPNODE_NOTFOUND');
641: FND_MSG_PUB.ADD;
642: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
643: THEN
644: fnd_log.message
645: (
646: fnd_log.level_exception,
647: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
648: false

Line 646: fnd_log.level_exception,

642: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
643: THEN
644: fnd_log.message
645: (
646: fnd_log.level_exception,
647: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
648: false
649: );
650: END IF;

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

654: IF (p_x_node_rec.position_necessity_code <> 'MANDATORY')
655: THEN
656: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_TOPNODE_NEC_INV');
657: FND_MSG_PUB.ADD;
658: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
659: THEN
660: fnd_log.message
661: (
662: fnd_log.level_exception,

Line 660: fnd_log.message

656: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_TOPNODE_NEC_INV');
657: FND_MSG_PUB.ADD;
658: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
659: THEN
660: fnd_log.message
661: (
662: fnd_log.level_exception,
663: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
664: false

Line 662: fnd_log.level_exception,

658: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
659: THEN
660: fnd_log.message
661: (
662: fnd_log.level_exception,
663: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
664: false
665: );
666: END IF;

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

671: IF (p_x_node_rec.uom_code <> 'Ea')
672: THEN
673: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_TOPNODE_UOM_INV');
674: FND_MSG_PUB.ADD;
675: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
676: THEN
677: fnd_log.message
678: (
679: fnd_log.level_exception,

Line 677: fnd_log.message

673: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_TOPNODE_UOM_INV');
674: FND_MSG_PUB.ADD;
675: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
676: THEN
677: fnd_log.message
678: (
679: fnd_log.level_exception,
680: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
681: false

Line 679: fnd_log.level_exception,

675: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
676: THEN
677: fnd_log.message
678: (
679: fnd_log.level_exception,
680: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
681: false
682: );
683: END IF;

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

686: IF (p_x_node_rec.quantity <> 1)
687: THEN
688: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_TOPNODE_QTY_INV');
689: FND_MSG_PUB.ADD;
690: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
691: THEN
692: fnd_log.message
693: (
694: fnd_log.level_exception,

Line 692: fnd_log.message

688: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_TOPNODE_QTY_INV');
689: FND_MSG_PUB.ADD;
690: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
691: THEN
692: fnd_log.message
693: (
694: fnd_log.level_exception,
695: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
696: false

Line 694: fnd_log.level_exception,

690: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
691: THEN
692: fnd_log.message
693: (
694: fnd_log.level_exception,
695: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
696: false
697: );
698: END IF;

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

701: IF (p_x_node_rec.display_order <> 1)
702: THEN
703: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_TOPNODE_DSP_INV');
704: FND_MSG_PUB.ADD;
705: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
706: THEN
707: fnd_log.message
708: (
709: fnd_log.level_exception,

Line 707: fnd_log.message

703: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_TOPNODE_DSP_INV');
704: FND_MSG_PUB.ADD;
705: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
706: THEN
707: fnd_log.message
708: (
709: fnd_log.level_exception,
710: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
711: false

Line 709: fnd_log.level_exception,

705: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
706: THEN
707: fnd_log.message
708: (
709: fnd_log.level_exception,
710: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
711: false
712: );
713: END IF;

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

719: THEN
720: RAISE FND_API.G_EXC_ERROR;
721: END IF;
722:
723: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
724: THEN
725: fnd_log.string
726: (
727: fnd_log.level_statement,

Line 725: fnd_log.string

721: END IF;
722:
723: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
724: THEN
725: fnd_log.string
726: (
727: fnd_log.level_statement,
728: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
729: 'Node validation successful... Calling AHL_MC_Node_PVT.Modify_Node'

Line 727: fnd_log.level_statement,

723: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
724: THEN
725: fnd_log.string
726: (
727: fnd_log.level_statement,
728: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
729: 'Node validation successful... Calling AHL_MC_Node_PVT.Modify_Node'
730: );
731: END IF;

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

748: p_x_counter_rules_tbl => l_counter_rules_tbl, -- passed as dummy, cannot pass null
749: p_x_subconfig_tbl => l_subconfig_tbl -- passed as dummy, cannot pass null
750: );
751:
752: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
753: THEN
754: fnd_log.string
755: (
756: fnd_log.level_procedure,

Line 754: fnd_log.string

750: );
751:
752: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
753: THEN
754: fnd_log.string
755: (
756: fnd_log.level_procedure,
757: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.end',
758: 'At the end of PLSQL procedure'

Line 756: fnd_log.level_procedure,

752: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
753: THEN
754: fnd_log.string
755: (
756: fnd_log.level_procedure,
757: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.end',
758: 'At the end of PLSQL procedure'
759: );
760: END IF;

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

917: -- Initialize API return status to success
918: x_return_status := FND_API.G_RET_STS_SUCCESS;
919:
920: -- API body starts here
921: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
922: THEN
923: fnd_log.string
924: (
925: fnd_log.level_procedure,

Line 923: fnd_log.string

919:
920: -- API body starts here
921: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
922: THEN
923: fnd_log.string
924: (
925: fnd_log.level_procedure,
926: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.begin',
927: 'At the start of PLSQL procedure'

Line 925: fnd_log.level_procedure,

921: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
922: THEN
923: fnd_log.string
924: (
925: fnd_log.level_procedure,
926: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.begin',
927: 'At the start of PLSQL procedure'
928: );
929: END IF;

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

937: IF (check_mc_not_subconfig%FOUND)
938: THEN
939: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_IS_SUBCONFIG');
940: FND_MSG_PUB.ADD;
941: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
942: THEN
943: fnd_log.message
944: (
945: fnd_log.level_exception,

Line 943: fnd_log.message

939: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_IS_SUBCONFIG');
940: FND_MSG_PUB.ADD;
941: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
942: THEN
943: fnd_log.message
944: (
945: fnd_log.level_exception,
946: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
947: false

Line 945: fnd_log.level_exception,

941: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
942: THEN
943: fnd_log.message
944: (
945: fnd_log.level_exception,
946: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
947: false
948: );
949: END IF;

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

951: RAISE FND_API.G_EXC_ERROR;
952: END IF;
953: CLOSE check_mc_not_subconfig;
954:
955: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
956: THEN
957: fnd_log.string
958: (
959: fnd_log.level_statement,

Line 957: fnd_log.string

953: CLOSE check_mc_not_subconfig;
954:
955: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
956: THEN
957: fnd_log.string
958: (
959: fnd_log.level_statement,
960: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
961: 'Header validation successful'

Line 959: fnd_log.level_statement,

955: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
956: THEN
957: fnd_log.string
958: (
959: fnd_log.level_statement,
960: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
961: 'Header validation successful'
962: );
963: END IF;

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

967: IF (l_config_status_code IN ('CLOSED', 'EXPIRED'))
968: THEN
969: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_DEL_STS_INV');
970: FND_MSG_PUB.ADD;
971: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
972: THEN
973: fnd_log.message
974: (
975: fnd_log.level_exception,

Line 973: fnd_log.message

969: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_DEL_STS_INV');
970: FND_MSG_PUB.ADD;
971: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
972: THEN
973: fnd_log.message
974: (
975: fnd_log.level_exception,
976: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
977: false

Line 975: fnd_log.level_exception,

971: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
972: THEN
973: fnd_log.message
974: (
975: fnd_log.level_exception,
976: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
977: false
978: );
979: END IF;

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

999: IF x_msg_count > 0 THEN
1000: RAISE FND_API.G_EXC_ERROR;
1001: END IF;
1002:
1003: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1004: THEN
1005: fnd_log.string
1006: (
1007: fnd_log.level_statement,

Line 1005: fnd_log.string

1001: END IF;
1002:
1003: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1004: THEN
1005: fnd_log.string
1006: (
1007: fnd_log.level_statement,
1008: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1009: 'Deleted rules for MC'

Line 1007: fnd_log.level_statement,

1003: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1004: THEN
1005: fnd_log.string
1006: (
1007: fnd_log.level_statement,
1008: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1009: 'Deleted rules for MC'
1010: );
1011: END IF;

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

1028: IF x_msg_count > 0 THEN
1029: RAISE FND_API.G_EXC_ERROR;
1030: END IF;
1031:
1032: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1033: THEN
1034: fnd_log.string
1035: (
1036: fnd_log.level_statement,

Line 1034: fnd_log.string

1030: END IF;
1031:
1032: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1033: THEN
1034: fnd_log.string
1035: (
1036: fnd_log.level_statement,
1037: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1038: 'Deleted position paths for MC'

Line 1036: fnd_log.level_statement,

1032: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1033: THEN
1034: fnd_log.string
1035: (
1036: fnd_log.level_statement,
1037: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1038: 'Deleted position paths for MC'
1039: );
1040: END IF;

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

1063: IF x_msg_count > 0 THEN
1064: RAISE FND_API.G_EXC_ERROR;
1065: END IF;
1066:
1067: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1068: THEN
1069: fnd_log.string
1070: (
1071: fnd_log.level_statement,

Line 1069: fnd_log.string

1065: END IF;
1066:
1067: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1068: THEN
1069: fnd_log.string
1070: (
1071: fnd_log.level_statement,
1072: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1073: 'Deleted nodes for MC'

Line 1071: fnd_log.level_statement,

1067: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1068: THEN
1069: fnd_log.string
1070: (
1071: fnd_log.level_statement,
1072: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1073: 'Deleted nodes for MC'
1074: );
1075: END IF;

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

1076:
1077: -- 6d. Call AHL_MC_HEADERS_PKG.DELETE_ROW to delete the MC
1078: AHL_MC_HEADERS_PKG.DELETE_ROW (p_mc_header_id);
1079:
1080: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1081: THEN
1082: fnd_log.string
1083: (
1084: fnd_log.level_statement,

Line 1082: fnd_log.string

1078: AHL_MC_HEADERS_PKG.DELETE_ROW (p_mc_header_id);
1079:
1080: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1081: THEN
1082: fnd_log.string
1083: (
1084: fnd_log.level_statement,
1085: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1086: 'Deleted Header'

Line 1084: fnd_log.level_statement,

1080: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1081: THEN
1082: fnd_log.string
1083: (
1084: fnd_log.level_statement,
1085: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1086: 'Deleted Header'
1087: );
1088: END IF;

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

1097: IF (check_unit_assigned%FOUND)
1098: THEN
1099: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_CLOSE_INVALID');
1100: FND_MSG_PUB.ADD;
1101: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1102: THEN
1103: fnd_log.message
1104: (
1105: fnd_log.level_exception,

Line 1103: fnd_log.message

1099: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_CLOSE_INVALID');
1100: FND_MSG_PUB.ADD;
1101: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1102: THEN
1103: fnd_log.message
1104: (
1105: fnd_log.level_exception,
1106: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1107: false

Line 1105: fnd_log.level_exception,

1101: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1102: THEN
1103: fnd_log.message
1104: (
1105: fnd_log.level_exception,
1106: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1107: false
1108: );
1109: END IF;

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

1111: RAISE FND_API.G_EXC_ERROR;
1112: END IF;
1113: CLOSE check_unit_assigned;
1114:
1115: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1116: THEN
1117: fnd_log.string
1118: (
1119: fnd_log.level_statement,

Line 1117: fnd_log.string

1113: CLOSE check_unit_assigned;
1114:
1115: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1116: THEN
1117: fnd_log.string
1118: (
1119: fnd_log.level_statement,
1120: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1121: 'Unit assignment for Header ['||p_mc_header_id||'] validated'

Line 1119: fnd_log.level_statement,

1115: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1116: THEN
1117: fnd_log.string
1118: (
1119: fnd_log.level_statement,
1120: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1121: 'Unit assignment for Header ['||p_mc_header_id||'] validated'
1122: );
1123: END IF;

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

1149: -- Consider the case that a particular draft MC automatically expires based on end-date, there is another draft
1150: -- MC associated with one of the nodes, the latter cannot be deleted ever since it is associated as a
1151: -- subconfig, since potentially the earlier MC can be reopened
1152:
1153: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1154: THEN
1155: fnd_log.string
1156: (
1157: fnd_log.level_statement,

Line 1155: fnd_log.string

1151: -- subconfig, since potentially the earlier MC can be reopened
1152:
1153: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1154: THEN
1155: fnd_log.string
1156: (
1157: fnd_log.level_statement,
1158: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1159: 'Header ['||p_mc_header_id||'] and topnode ['||l_topnode_rel_id||'] closed'

Line 1157: fnd_log.level_statement,

1153: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1154: THEN
1155: fnd_log.string
1156: (
1157: fnd_log.level_statement,
1158: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1159: 'Header ['||p_mc_header_id||'] and topnode ['||l_topnode_rel_id||'] closed'
1160: );
1161: END IF;

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

1162:
1163: ELSE
1164: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_DELETE_STS_INV');
1165: FND_MSG_PUB.ADD;
1166: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1167: THEN
1168: fnd_log.message
1169: (
1170: fnd_log.level_exception,

Line 1168: fnd_log.message

1164: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_DELETE_STS_INV');
1165: FND_MSG_PUB.ADD;
1166: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1167: THEN
1168: fnd_log.message
1169: (
1170: fnd_log.level_exception,
1171: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1172: false

Line 1170: fnd_log.level_exception,

1166: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1167: THEN
1168: fnd_log.message
1169: (
1170: fnd_log.level_exception,
1171: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1172: false
1173: );
1174: END IF;

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

1173: );
1174: END IF;
1175: END IF;
1176:
1177: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1178: THEN
1179: fnd_log.string
1180: (
1181: fnd_log.level_procedure,

Line 1179: fnd_log.string

1175: END IF;
1176:
1177: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1178: THEN
1179: fnd_log.string
1180: (
1181: fnd_log.level_procedure,
1182: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.end',
1183: 'At the end of PLSQL procedure'

Line 1181: fnd_log.level_procedure,

1177: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1178: THEN
1179: fnd_log.string
1180: (
1181: fnd_log.level_procedure,
1182: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.end',
1183: 'At the end of PLSQL procedure'
1184: );
1185: END IF;

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

1291: -- Initialize API return status to success
1292: x_return_status := FND_API.G_RET_STS_SUCCESS;
1293:
1294: -- API body starts here
1295: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1296: THEN
1297: fnd_log.string
1298: (
1299: fnd_log.level_procedure,

Line 1297: fnd_log.string

1293:
1294: -- API body starts here
1295: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1296: THEN
1297: fnd_log.string
1298: (
1299: fnd_log.level_procedure,
1300: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.begin',
1301: 'At the start of PLSQL procedure'

Line 1299: fnd_log.level_procedure,

1295: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1296: THEN
1297: fnd_log.string
1298: (
1299: fnd_log.level_procedure,
1300: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.begin',
1301: 'At the start of PLSQL procedure'
1302: );
1303: END IF;

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

1303: END IF;
1304:
1305: Validate_MC_Exists (p_x_mc_header_rec.mc_header_id, nvl(p_x_mc_header_rec.object_version_number, 0));
1306:
1307: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1308: THEN
1309: fnd_log.string
1310: (
1311: fnd_log.level_statement,

Line 1309: fnd_log.string

1305: Validate_MC_Exists (p_x_mc_header_rec.mc_header_id, nvl(p_x_mc_header_rec.object_version_number, 0));
1306:
1307: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1308: THEN
1309: fnd_log.string
1310: (
1311: fnd_log.level_statement,
1312: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1313: 'Header validation successful'

Line 1311: fnd_log.level_statement,

1307: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1308: THEN
1309: fnd_log.string
1310: (
1311: fnd_log.level_statement,
1312: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1313: 'Header validation successful'
1314: );
1315: END IF;

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

1348: IF x_msg_count > 0 THEN
1349: RAISE FND_API.G_EXC_ERROR;
1350: END IF;
1351:
1352: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1353: THEN
1354: fnd_log.string
1355: (
1356: fnd_log.level_statement,

Line 1354: fnd_log.string

1350: END IF;
1351:
1352: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1353: THEN
1354: fnd_log.string
1355: (
1356: fnd_log.level_statement,
1357: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1358: 'Header ['||p_x_mc_header_rec.mc_header_id||'] and topnode ['||p_x_node_rec.relationship_id||'] copied'

Line 1356: fnd_log.level_statement,

1352: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1353: THEN
1354: fnd_log.string
1355: (
1356: fnd_log.level_statement,
1357: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1358: 'Header ['||p_x_mc_header_rec.mc_header_id||'] and topnode ['||p_x_node_rec.relationship_id||'] copied'
1359: );
1360:

Line 1361: fnd_log.string

1357: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1358: 'Header ['||p_x_mc_header_rec.mc_header_id||'] and topnode ['||p_x_node_rec.relationship_id||'] copied'
1359: );
1360:
1361: fnd_log.string
1362: (
1363: fnd_log.level_statement,
1364: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1365: 'Copying documents from topnode ['||l_old_node_id||'] to topnode ['||p_x_node_rec.relationship_id||']'

Line 1363: fnd_log.level_statement,

1359: );
1360:
1361: fnd_log.string
1362: (
1363: fnd_log.level_statement,
1364: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1365: 'Copying documents from topnode ['||l_old_node_id||'] to topnode ['||p_x_node_rec.relationship_id||']'
1366: );
1367: END IF;

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

1386: IF x_msg_count > 0 THEN
1387: RAISE FND_API.G_EXC_ERROR;
1388: END IF;
1389:
1390: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1391: THEN
1392: fnd_log.string
1393: (
1394: fnd_log.level_statement,

Line 1392: fnd_log.string

1388: END IF;
1389:
1390: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1391: THEN
1392: fnd_log.string
1393: (
1394: fnd_log.level_statement,
1395: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1396: 'Copying nodes'

Line 1394: fnd_log.level_statement,

1390: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1391: THEN
1392: fnd_log.string
1393: (
1394: fnd_log.level_statement,
1395: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1396: 'Copying nodes'
1397: );
1398: END IF;

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

1418: IF x_msg_count > 0 THEN
1419: RAISE FND_API.G_EXC_ERROR;
1420: END IF;
1421:
1422: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1423: THEN
1424: fnd_log.string
1425: (
1426: fnd_log.level_statement,

Line 1424: fnd_log.string

1420: END IF;
1421:
1422: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1423: THEN
1424: fnd_log.string
1425: (
1426: fnd_log.level_statement,
1427: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1428: 'Copying position paths'

Line 1426: fnd_log.level_statement,

1422: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1423: THEN
1424: fnd_log.string
1425: (
1426: fnd_log.level_statement,
1427: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1428: 'Copying position paths'
1429: );
1430: END IF;

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

1448: IF x_msg_count > 0 THEN
1449: RAISE FND_API.G_EXC_ERROR;
1450: END IF;
1451:
1452: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1453: THEN
1454: fnd_log.string
1455: (
1456: fnd_log.level_statement,

Line 1454: fnd_log.string

1450: END IF;
1451:
1452: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1453: THEN
1454: fnd_log.string
1455: (
1456: fnd_log.level_statement,
1457: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1458: 'Copying rules'

Line 1456: fnd_log.level_statement,

1452: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1453: THEN
1454: fnd_log.string
1455: (
1456: fnd_log.level_statement,
1457: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1458: 'Copying rules'
1459: );
1460: END IF;

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

1478: IF x_msg_count > 0 THEN
1479: RAISE FND_API.G_EXC_ERROR;
1480: END IF;
1481:
1482: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1483: THEN
1484: fnd_log.string
1485: (
1486: fnd_log.level_procedure,

Line 1484: fnd_log.string

1480: END IF;
1481:
1482: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1483: THEN
1484: fnd_log.string
1485: (
1486: fnd_log.level_procedure,
1487: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.end',
1488: 'At the end of PLSQL procedure'

Line 1486: fnd_log.level_procedure,

1482: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1483: THEN
1484: fnd_log.string
1485: (
1486: fnd_log.level_procedure,
1487: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.end',
1488: 'At the end of PLSQL procedure'
1489: );
1490: END IF;

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

1689: -- Initialize API return status to success
1690: x_return_status := FND_API.G_RET_STS_SUCCESS;
1691:
1692: -- API body starts here
1693: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1694: THEN
1695: fnd_log.string
1696: (
1697: fnd_log.level_procedure,

Line 1695: fnd_log.string

1691:
1692: -- API body starts here
1693: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1694: THEN
1695: fnd_log.string
1696: (
1697: fnd_log.level_procedure,
1698: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.begin',
1699: 'At the start of PLSQL procedure'

Line 1697: fnd_log.level_procedure,

1693: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1694: THEN
1695: fnd_log.string
1696: (
1697: fnd_log.level_procedure,
1698: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.begin',
1699: 'At the start of PLSQL procedure'
1700: );
1701: END IF;

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

1712: IF (l_header_rec.config_status_code <> 'COMPLETE')
1713: THEN
1714: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_REV_STS_INV');
1715: FND_MSG_PUB.ADD;
1716: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1717: THEN
1718: fnd_log.message
1719: (
1720: fnd_log.level_exception,

Line 1718: fnd_log.message

1714: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_REV_STS_INV');
1715: FND_MSG_PUB.ADD;
1716: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1717: THEN
1718: fnd_log.message
1719: (
1720: fnd_log.level_exception,
1721: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1722: false

Line 1720: fnd_log.level_exception,

1716: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1717: THEN
1718: fnd_log.message
1719: (
1720: fnd_log.level_exception,
1721: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1722: false
1723: );
1724: END IF;

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

1730: IF (check_latest_rev%FOUND)
1731: THEN
1732: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_NOT_LATEST_REV');
1733: FND_MSG_PUB.ADD;
1734: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1735: THEN
1736: fnd_log.message
1737: (
1738: fnd_log.level_exception,

Line 1736: fnd_log.message

1732: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_NOT_LATEST_REV');
1733: FND_MSG_PUB.ADD;
1734: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1735: THEN
1736: fnd_log.message
1737: (
1738: fnd_log.level_exception,
1739: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1740: false

Line 1738: fnd_log.level_exception,

1734: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1735: THEN
1736: fnd_log.message
1737: (
1738: fnd_log.level_exception,
1739: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1740: false
1741: );
1742: END IF;

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

1747: IF x_msg_count > 0 THEN
1748: RAISE FND_API.G_EXC_ERROR;
1749: END IF;
1750:
1751: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1752: THEN
1753: fnd_log.string
1754: (
1755: fnd_log.level_statement,

Line 1753: fnd_log.string

1749: END IF;
1750:
1751: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1752: THEN
1753: fnd_log.string
1754: (
1755: fnd_log.level_statement,
1756: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1757: 'Header validation successful'

Line 1755: fnd_log.level_statement,

1751: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1752: THEN
1753: fnd_log.string
1754: (
1755: fnd_log.level_statement,
1756: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1757: 'Header validation successful'
1758: );
1759: END IF;

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

1852: IF x_msg_count > 0 THEN
1853: RAISE FND_API.G_EXC_ERROR;
1854: END IF;
1855:
1856: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1857: THEN
1858: fnd_log.string
1859: (
1860: fnd_log.level_statement,

Line 1858: fnd_log.string

1854: END IF;
1855:
1856: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1857: THEN
1858: fnd_log.string
1859: (
1860: fnd_log.level_statement,
1861: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1862: 'Header ['||l_mc_header_rec.mc_header_id||'] and topnode ['||l_node_rec.relationship_id||'] created'

Line 1860: fnd_log.level_statement,

1856: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1857: THEN
1858: fnd_log.string
1859: (
1860: fnd_log.level_statement,
1861: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1862: 'Header ['||l_mc_header_rec.mc_header_id||'] and topnode ['||l_node_rec.relationship_id||'] created'
1863: );
1864: END IF;

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

1865:
1866: -- 15. Set p_x_mc_header_id := l_header_rec.mc_header_id, to return the header-id of the created MC
1867: p_x_mc_header_id := l_mc_header_rec.mc_header_id;
1868:
1869: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1870: THEN
1871: fnd_log.string
1872: (
1873: fnd_log.level_statement,

Line 1871: fnd_log.string

1867: p_x_mc_header_id := l_mc_header_rec.mc_header_id;
1868:
1869: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1870: THEN
1871: fnd_log.string
1872: (
1873: fnd_log.level_statement,
1874: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1875: 'Copying documents from topnode ['||l_old_node_id||'] to topnode ['||l_node_rec.relationship_id||']'

Line 1873: fnd_log.level_statement,

1869: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1870: THEN
1871: fnd_log.string
1872: (
1873: fnd_log.level_statement,
1874: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1875: 'Copying documents from topnode ['||l_old_node_id||'] to topnode ['||l_node_rec.relationship_id||']'
1876: );
1877: END IF;

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

1896: IF x_msg_count > 0 THEN
1897: RAISE FND_API.G_EXC_ERROR;
1898: END IF;
1899:
1900: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1901: THEN
1902: fnd_log.string
1903: (
1904: fnd_log.level_statement,

Line 1902: fnd_log.string

1898: END IF;
1899:
1900: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1901: THEN
1902: fnd_log.string
1903: (
1904: fnd_log.level_statement,
1905: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1906: 'Copying nodes'

Line 1904: fnd_log.level_statement,

1900: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1901: THEN
1902: fnd_log.string
1903: (
1904: fnd_log.level_statement,
1905: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1906: 'Copying nodes'
1907: );
1908: END IF;

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

1928: IF x_msg_count > 0 THEN
1929: RAISE FND_API.G_EXC_ERROR;
1930: END IF;
1931:
1932: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1933: THEN
1934: fnd_log.string
1935: (
1936: fnd_log.level_statement,

Line 1934: fnd_log.string

1930: END IF;
1931:
1932: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1933: THEN
1934: fnd_log.string
1935: (
1936: fnd_log.level_statement,
1937: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1938: 'Copying position paths'

Line 1936: fnd_log.level_statement,

1932: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1933: THEN
1934: fnd_log.string
1935: (
1936: fnd_log.level_statement,
1937: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1938: 'Copying position paths'
1939: );
1940: END IF;

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

1958: IF x_msg_count > 0 THEN
1959: RAISE FND_API.G_EXC_ERROR;
1960: END IF;
1961:
1962: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1963: THEN
1964: fnd_log.string
1965: (
1966: fnd_log.level_statement,

Line 1964: fnd_log.string

1960: END IF;
1961:
1962: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1963: THEN
1964: fnd_log.string
1965: (
1966: fnd_log.level_statement,
1967: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1968: 'Copying rules'

Line 1966: fnd_log.level_statement,

1962: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1963: THEN
1964: fnd_log.string
1965: (
1966: fnd_log.level_statement,
1967: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1968: 'Copying rules'
1969: );
1970: END IF;

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

1988: IF x_msg_count > 0 THEN
1989: RAISE FND_API.G_EXC_ERROR;
1990: END IF;
1991:
1992: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1993: THEN
1994: fnd_log.string
1995: (
1996: fnd_log.level_procedure,

Line 1994: fnd_log.string

1990: END IF;
1991:
1992: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1993: THEN
1994: fnd_log.string
1995: (
1996: fnd_log.level_procedure,
1997: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.end',
1998: 'At the end of PLSQL procedure'

Line 1996: fnd_log.level_procedure,

1992: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1993: THEN
1994: fnd_log.string
1995: (
1996: fnd_log.level_procedure,
1997: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.end',
1998: 'At the end of PLSQL procedure'
1999: );
2000: END IF;

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

2158: -- Initialize API return status to success
2159: x_return_status := FND_API.G_RET_STS_SUCCESS;
2160:
2161: -- API body starts here
2162: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2163: THEN
2164: fnd_log.string
2165: (
2166: fnd_log.level_procedure,

Line 2164: fnd_log.string

2160:
2161: -- API body starts here
2162: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2163: THEN
2164: fnd_log.string
2165: (
2166: fnd_log.level_procedure,
2167: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.begin',
2168: 'At the start of PLSQL procedure'

Line 2166: fnd_log.level_procedure,

2162: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2163: THEN
2164: fnd_log.string
2165: (
2166: fnd_log.level_procedure,
2167: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.begin',
2168: 'At the start of PLSQL procedure'
2169: );
2170: END IF;

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

2181: IF NOT (l_config_status_code IN ('CLOSED', 'EXPIRED'))
2182: THEN
2183: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_REOPEN_INV_MC');
2184: FND_MSG_PUB.ADD;
2185: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2186: THEN
2187: fnd_log.message
2188: (
2189: fnd_log.level_exception,

Line 2187: fnd_log.message

2183: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_REOPEN_INV_MC');
2184: FND_MSG_PUB.ADD;
2185: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2186: THEN
2187: fnd_log.message
2188: (
2189: fnd_log.level_exception,
2190: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
2191: false

Line 2189: fnd_log.level_exception,

2185: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2186: THEN
2187: fnd_log.message
2188: (
2189: fnd_log.level_exception,
2190: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
2191: false
2192: );
2193: END IF;

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

2200: FETCH get_mc_status INTO l_config_status_code;
2201: CLOSE get_mc_status;
2202: END IF;
2203:
2204: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2205: THEN
2206: fnd_log.string
2207: (
2208: fnd_log.level_statement,

Line 2206: fnd_log.string

2202: END IF;
2203:
2204: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2205: THEN
2206: fnd_log.string
2207: (
2208: fnd_log.level_statement,
2209: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
2210: 'Header validation successful'

Line 2208: fnd_log.level_statement,

2204: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2205: THEN
2206: fnd_log.string
2207: (
2208: fnd_log.level_statement,
2209: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
2210: 'Header validation successful'
2211: );
2212: END IF;

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

2219: IF (get_topnode_itemgroup%NOTFOUND) THEN
2220: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_ITEMGROUP_INVALID');
2221: --FND_MESSAGE.Set_Token('ITEM_GRP', l_item_group_name);
2222: FND_MSG_PUB.ADD;
2223: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2224: THEN
2225: fnd_log.message
2226: (
2227: fnd_log.level_exception,

Line 2225: fnd_log.message

2221: --FND_MESSAGE.Set_Token('ITEM_GRP', l_item_group_name);
2222: FND_MSG_PUB.ADD;
2223: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2224: THEN
2225: fnd_log.message
2226: (
2227: fnd_log.level_exception,
2228: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
2229: false

Line 2227: fnd_log.level_exception,

2223: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2224: THEN
2225: fnd_log.message
2226: (
2227: fnd_log.level_exception,
2228: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
2229: false
2230: );
2231: END IF;

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

2258: last_updated_by = G_USER_ID,
2259: last_update_login = G_LOGIN_ID
2260: WHERE relationship_id = l_topnode_rel_id;
2261:
2262: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2263: THEN
2264: fnd_log.string
2265: (
2266: fnd_log.level_statement,

Line 2264: fnd_log.string

2260: WHERE relationship_id = l_topnode_rel_id;
2261:
2262: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2263: THEN
2264: fnd_log.string
2265: (
2266: fnd_log.level_statement,
2267: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
2268: 'Header ['||p_mc_header_id||'] and topnode ['||l_topnode_rel_id||'] reopened'

Line 2266: fnd_log.level_statement,

2262: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2263: THEN
2264: fnd_log.string
2265: (
2266: fnd_log.level_statement,
2267: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
2268: 'Header ['||p_mc_header_id||'] and topnode ['||l_topnode_rel_id||'] reopened'
2269: );
2270: END IF;

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

2268: 'Header ['||p_mc_header_id||'] and topnode ['||l_topnode_rel_id||'] reopened'
2269: );
2270: END IF;
2271:
2272: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2273: THEN
2274: fnd_log.string
2275: (
2276: fnd_log.level_procedure,

Line 2274: fnd_log.string

2270: END IF;
2271:
2272: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2273: THEN
2274: fnd_log.string
2275: (
2276: fnd_log.level_procedure,
2277: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.end',
2278: 'At the end of PLSQL procedure'

Line 2276: fnd_log.level_procedure,

2272: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2273: THEN
2274: fnd_log.string
2275: (
2276: fnd_log.level_procedure,
2277: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.end',
2278: 'At the end of PLSQL procedure'
2279: );
2280: END IF;

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

2389: -- Initialize API return status to success
2390: x_return_status := FND_API.G_RET_STS_SUCCESS;
2391:
2392: -- API body starts here
2393: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2394: THEN
2395: fnd_log.string
2396: (
2397: fnd_log.level_procedure,

Line 2395: fnd_log.string

2391:
2392: -- API body starts here
2393: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2394: THEN
2395: fnd_log.string
2396: (
2397: fnd_log.level_procedure,
2398: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.begin',
2399: 'At the start of PLSQL procedure'

Line 2397: fnd_log.level_procedure,

2393: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2394: THEN
2395: fnd_log.string
2396: (
2397: fnd_log.level_procedure,
2398: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.begin',
2399: 'At the start of PLSQL procedure'
2400: );
2401: END IF;

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

2407: IF NOT (l_config_status_code IN ('DRAFT', 'APPROVAL_REJECTED'))
2408: THEN
2409: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_WF_STS_INVALID');
2410: FND_MSG_PUB.ADD;
2411: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2412: THEN
2413: fnd_log.message
2414: (
2415: fnd_log.level_exception,

Line 2413: fnd_log.message

2409: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_WF_STS_INVALID');
2410: FND_MSG_PUB.ADD;
2411: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2412: THEN
2413: fnd_log.message
2414: (
2415: fnd_log.level_exception,
2416: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
2417: false

Line 2415: fnd_log.level_exception,

2411: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2412: THEN
2413: fnd_log.message
2414: (
2415: fnd_log.level_exception,
2416: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
2417: false
2418: );
2419: END IF;

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

2419: END IF;
2420: RAISE FND_API.G_EXC_ERROR;
2421: END IF;
2422:
2423: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2424: THEN
2425: fnd_log.string
2426: (
2427: fnd_log.level_statement,

Line 2425: fnd_log.string

2421: END IF;
2422:
2423: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2424: THEN
2425: fnd_log.string
2426: (
2427: fnd_log.level_statement,
2428: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
2429: 'Header validation successful'

Line 2427: fnd_log.level_statement,

2423: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2424: THEN
2425: fnd_log.string
2426: (
2427: fnd_log.level_statement,
2428: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
2429: 'Header validation successful'
2430: );
2431: END IF;

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

2432:
2433: -- 4. Call Check_MC_Complete to validate all itemgroup and subconfiguration associations are complete
2434: Check_MC_Complete (p_mc_header_id);
2435:
2436: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2437: THEN
2438: fnd_log.string
2439: (
2440: fnd_log.level_statement,

Line 2438: fnd_log.string

2434: Check_MC_Complete (p_mc_header_id);
2435:
2436: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2437: THEN
2438: fnd_log.string
2439: (
2440: fnd_log.level_statement,
2441: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
2442: 'Check for MC completion is successful'

Line 2440: fnd_log.level_statement,

2436: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2437: THEN
2438: fnd_log.string
2439: (
2440: fnd_log.level_statement,
2441: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
2442: 'Check for MC completion is successful'
2443: );
2444: END IF;

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

2472:
2473: IF (l_active = 'Y')
2474: THEN
2475: -- 5b. If workflow is active
2476: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2477: THEN
2478: fnd_log.string
2479: (
2480: fnd_log.level_statement,

Line 2478: fnd_log.string

2474: THEN
2475: -- 5b. If workflow is active
2476: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2477: THEN
2478: fnd_log.string
2479: (
2480: fnd_log.level_statement,
2481: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
2482: 'MC Approval workflow process is active'

Line 2480: fnd_log.level_statement,

2476: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2477: THEN
2478: fnd_log.string
2479: (
2480: fnd_log.level_statement,
2481: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
2482: 'MC Approval workflow process is active'
2483: );
2484: END IF;

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

2508: P_WORKFLOWPROCESS => l_process_name,
2509: P_ITEM_TYPE => l_item_type
2510: );
2511:
2512: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2513: THEN
2514: fnd_log.string
2515: (
2516: fnd_log.level_statement,

Line 2514: fnd_log.string

2510: );
2511:
2512: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2513: THEN
2514: fnd_log.string
2515: (
2516: fnd_log.level_statement,
2517: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
2518: 'Approval process for MC ['||p_mc_header_id||', '||to_char(p_object_ver_num + 1)||'] has been started'

Line 2516: fnd_log.level_statement,

2512: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2513: THEN
2514: fnd_log.string
2515: (
2516: fnd_log.level_statement,
2517: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
2518: 'Approval process for MC ['||p_mc_header_id||', '||to_char(p_object_ver_num + 1)||'] has been started'
2519: );
2520: END IF;

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

2518: 'Approval process for MC ['||p_mc_header_id||', '||to_char(p_object_ver_num + 1)||'] has been started'
2519: );
2520: END IF;
2521: ELSE
2522: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2523: THEN
2524: fnd_log.string
2525: (
2526: fnd_log.level_statement,

Line 2524: fnd_log.string

2520: END IF;
2521: ELSE
2522: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2523: THEN
2524: fnd_log.string
2525: (
2526: fnd_log.level_statement,
2527: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
2528: 'MC Approval workflow process is inactive'

Line 2526: fnd_log.level_statement,

2522: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2523: THEN
2524: fnd_log.string
2525: (
2526: fnd_log.level_statement,
2527: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
2528: 'MC Approval workflow process is inactive'
2529: );
2530: END IF;

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

2539: WHERE mc_header_id = p_mc_header_id AND
2540: object_version_number = p_object_ver_num;
2541: END IF;
2542:
2543: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2544: THEN
2545: fnd_log.string
2546: (
2547: fnd_log.level_procedure,

Line 2545: fnd_log.string

2541: END IF;
2542:
2543: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2544: THEN
2545: fnd_log.string
2546: (
2547: fnd_log.level_procedure,
2548: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.end',
2549: 'At the end of PLSQL procedure'

Line 2547: fnd_log.level_procedure,

2543: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2544: THEN
2545: fnd_log.string
2546: (
2547: fnd_log.level_procedure,
2548: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.end',
2549: 'At the end of PLSQL procedure'
2550: );
2551: END IF;

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

2639: IF (check_mc_exists%NOTFOUND)
2640: THEN
2641: FND_MESSAGE.Set_Name('AHL','AHL_MC_NOT_FOUND');
2642: FND_MSG_PUB.ADD;
2643: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2644: THEN
2645: fnd_log.message
2646: (
2647: fnd_log.level_exception,

Line 2645: fnd_log.message

2641: FND_MESSAGE.Set_Name('AHL','AHL_MC_NOT_FOUND');
2642: FND_MSG_PUB.ADD;
2643: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2644: THEN
2645: fnd_log.message
2646: (
2647: fnd_log.level_exception,
2648: 'ahl.plsql.'||G_PKG_NAME||'.Validate_MC_Exists',
2649: false

Line 2647: fnd_log.level_exception,

2643: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2644: THEN
2645: fnd_log.message
2646: (
2647: fnd_log.level_exception,
2648: 'ahl.plsql.'||G_PKG_NAME||'.Validate_MC_Exists',
2649: false
2650: );
2651: END IF;

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

2654: ELSIF (NVL(p_object_ver_num, l_dummy_number) <> l_dummy_number)
2655: THEN
2656: FND_MESSAGE.Set_Name('AHL', 'AHL_COM_RECORD_CHANGED');
2657: FND_MSG_PUB.ADD;
2658: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2659: THEN
2660: fnd_log.message
2661: (
2662: fnd_log.level_exception,

Line 2660: fnd_log.message

2656: FND_MESSAGE.Set_Name('AHL', 'AHL_COM_RECORD_CHANGED');
2657: FND_MSG_PUB.ADD;
2658: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2659: THEN
2660: fnd_log.message
2661: (
2662: fnd_log.level_exception,
2663: 'ahl.plsql.'||G_PKG_NAME||'.Validate_MC_Exists',
2664: false

Line 2662: fnd_log.level_exception,

2658: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2659: THEN
2660: fnd_log.message
2661: (
2662: fnd_log.level_exception,
2663: 'ahl.plsql.'||G_PKG_NAME||'.Validate_MC_Exists',
2664: false
2665: );
2666: END IF;

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

2703: IF (RTRIM(p_x_mc_header_rec.name) IS NULL)
2704: THEN
2705: FND_MESSAGE.Set_Name('AHL','AHL_MC_NAME_INVALID');
2706: FND_MSG_PUB.ADD;
2707: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2708: THEN
2709: fnd_log.message
2710: (
2711: fnd_log.level_exception,

Line 2709: fnd_log.message

2705: FND_MESSAGE.Set_Name('AHL','AHL_MC_NAME_INVALID');
2706: FND_MSG_PUB.ADD;
2707: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2708: THEN
2709: fnd_log.message
2710: (
2711: fnd_log.level_exception,
2712: 'ahl.plsql.'||G_PKG_NAME||'.Validate_MC_Name',
2713: false

Line 2711: fnd_log.level_exception,

2707: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2708: THEN
2709: fnd_log.message
2710: (
2711: fnd_log.level_exception,
2712: 'ahl.plsql.'||G_PKG_NAME||'.Validate_MC_Name',
2713: false
2714: );
2715: END IF;

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

2722: IF (check_mc_name_unique%FOUND)
2723: THEN
2724: FND_MESSAGE.Set_Name('AHL','AHL_MC_RNAME_EXISTS');
2725: FND_MSG_PUB.ADD;
2726: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2727: THEN
2728: fnd_log.message
2729: (
2730: fnd_log.level_exception,

Line 2728: fnd_log.message

2724: FND_MESSAGE.Set_Name('AHL','AHL_MC_RNAME_EXISTS');
2725: FND_MSG_PUB.ADD;
2726: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2727: THEN
2728: fnd_log.message
2729: (
2730: fnd_log.level_exception,
2731: 'ahl.plsql.'||G_PKG_NAME||'.Validate_MC_Name',
2732: false

Line 2730: fnd_log.level_exception,

2726: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2727: THEN
2728: fnd_log.message
2729: (
2730: fnd_log.level_exception,
2731: 'ahl.plsql.'||G_PKG_NAME||'.Validate_MC_Name',
2732: false
2733: );
2734: END IF;

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

2741: IF (l_dummy_name <> p_x_mc_header_rec.name)
2742: THEN
2743: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_RNAME_NOUPDATE');
2744: FND_MSG_PUB.ADD;
2745: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2746: THEN
2747: fnd_log.message
2748: (
2749: fnd_log.level_exception,

Line 2747: fnd_log.message

2743: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_RNAME_NOUPDATE');
2744: FND_MSG_PUB.ADD;
2745: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2746: THEN
2747: fnd_log.message
2748: (
2749: fnd_log.level_exception,
2750: 'ahl.plsql.'||G_PKG_NAME||'.Validate_MC_Name',
2751: false

Line 2749: fnd_log.level_exception,

2745: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2746: THEN
2747: fnd_log.message
2748: (
2749: fnd_log.level_exception,
2750: 'ahl.plsql.'||G_PKG_NAME||'.Validate_MC_Name',
2751: false
2752: );
2753: END IF;

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

2805: IF (check_mc_revision_unique%FOUND)
2806: THEN
2807: FND_MESSAGE.Set_Name('AHL','AHL_MC_REV_EXISTS');
2808: FND_MSG_PUB.ADD;
2809: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2810: THEN
2811: fnd_log.message
2812: (
2813: fnd_log.level_exception,

Line 2811: fnd_log.message

2807: FND_MESSAGE.Set_Name('AHL','AHL_MC_REV_EXISTS');
2808: FND_MSG_PUB.ADD;
2809: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2810: THEN
2811: fnd_log.message
2812: (
2813: fnd_log.level_exception,
2814: 'ahl.plsql.'||G_PKG_NAME||'.Validate_MC_Revision',
2815: false

Line 2813: fnd_log.level_exception,

2809: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2810: THEN
2811: fnd_log.message
2812: (
2813: fnd_log.level_exception,
2814: 'ahl.plsql.'||G_PKG_NAME||'.Validate_MC_Revision',
2815: false
2816: );
2817: END IF;

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

2838: END LOOP;
2839:
2840: FND_MESSAGE.Set_Name('AHL','AHL_MC_NO_ALPHA_REV');
2841: FND_MSG_PUB.ADD;
2842: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2843: THEN
2844: fnd_log.message
2845: (
2846: fnd_log.level_exception,

Line 2844: fnd_log.message

2840: FND_MESSAGE.Set_Name('AHL','AHL_MC_NO_ALPHA_REV');
2841: FND_MSG_PUB.ADD;
2842: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2843: THEN
2844: fnd_log.message
2845: (
2846: fnd_log.level_exception,
2847: 'ahl.plsql.'||G_PKG_NAME||'.Validate_MC_Revision',
2848: false

Line 2846: fnd_log.level_exception,

2842: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2843: THEN
2844: fnd_log.message
2845: (
2846: fnd_log.level_exception,
2847: 'ahl.plsql.'||G_PKG_NAME||'.Validate_MC_Revision',
2848: false
2849: );
2850: END IF;

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

2884: IF (get_mc_status%NOTFOUND)
2885: THEN
2886: FND_MESSAGE.Set_Name('AHL','AHL_MC_NOT_FOUND');
2887: FND_MSG_PUB.ADD;
2888: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2889: THEN
2890: fnd_log.message
2891: (
2892: fnd_log.level_exception,

Line 2890: fnd_log.message

2886: FND_MESSAGE.Set_Name('AHL','AHL_MC_NOT_FOUND');
2887: FND_MSG_PUB.ADD;
2888: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2889: THEN
2890: fnd_log.message
2891: (
2892: fnd_log.level_exception,
2893: 'ahl.plsql.'||G_PKG_NAME||'.Get_MC_Status',
2894: false

Line 2892: fnd_log.level_exception,

2888: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2889: THEN
2890: fnd_log.message
2891: (
2892: fnd_log.level_exception,
2893: 'ahl.plsql.'||G_PKG_NAME||'.Get_MC_Status',
2894: false
2895: );
2896: END IF;

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

3000: l_msg_data VARCHAR2(2000);
3001:
3002: BEGIN
3003:
3004: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
3005: THEN
3006: fnd_log.string
3007: (
3008: fnd_log.level_procedure,

Line 3006: fnd_log.string

3002: BEGIN
3003:
3004: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
3005: THEN
3006: fnd_log.string
3007: (
3008: fnd_log.level_procedure,
3009: 'ahl.plsql.'||G_PKG_NAME||'.Check_MC_Complete.begin',
3010: 'At the start of PLSQL procedure '||G_PKG_NAME||'.Check_MC_Complete'

Line 3008: fnd_log.level_procedure,

3004: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
3005: THEN
3006: fnd_log.string
3007: (
3008: fnd_log.level_procedure,
3009: 'ahl.plsql.'||G_PKG_NAME||'.Check_MC_Complete.begin',
3010: 'At the start of PLSQL procedure '||G_PKG_NAME||'.Check_MC_Complete'
3011: );
3012: END IF;

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

3033: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_IG_NOT_COMP');
3034: FND_MESSAGE.Set_Token('IG_NAME', l_item_group_name);
3035: FND_MESSAGE.Set_Token('POS_REF', l_posref_meaning);
3036: FND_MSG_PUB.ADD;
3037: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3038: THEN
3039: fnd_log.message
3040: (
3041: fnd_log.level_exception,

Line 3039: fnd_log.message

3035: FND_MESSAGE.Set_Token('POS_REF', l_posref_meaning);
3036: FND_MSG_PUB.ADD;
3037: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3038: THEN
3039: fnd_log.message
3040: (
3041: fnd_log.level_exception,
3042: 'ahl.plsql.'||G_PKG_NAME||'.Check_MC_Complete',
3043: false

Line 3041: fnd_log.level_exception,

3037: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3038: THEN
3039: fnd_log.message
3040: (
3041: fnd_log.level_exception,
3042: 'ahl.plsql.'||G_PKG_NAME||'.Check_MC_Complete',
3043: false
3044: );
3045: END IF;

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

3046: END IF;
3047: END LOOP;
3048: CLOSE get_node_itemgroups_csr;
3049:
3050: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
3051: THEN
3052: fnd_log.string
3053: (
3054: fnd_log.level_statement,

Line 3052: fnd_log.string

3048: CLOSE get_node_itemgroups_csr;
3049:
3050: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
3051: THEN
3052: fnd_log.string
3053: (
3054: fnd_log.level_statement,
3055: 'ahl.plsql.'||G_PKG_NAME||'.Check_MC_Complete',
3056: 'Item group validation done for Node ['||l_relationship_id||']'

Line 3054: fnd_log.level_statement,

3050: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
3051: THEN
3052: fnd_log.string
3053: (
3054: fnd_log.level_statement,
3055: 'ahl.plsql.'||G_PKG_NAME||'.Check_MC_Complete',
3056: 'Item group validation done for Node ['||l_relationship_id||']'
3057: );
3058: END IF;

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

3074: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_SUBMC_NOT_COMP');
3075: FND_MESSAGE.Set_Token('MC_NAME', l_mc_name);
3076: FND_MESSAGE.Set_Token('POS_REF', l_posref_meaning);
3077: FND_MSG_PUB.ADD;
3078: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3079: THEN
3080: fnd_log.message
3081: (
3082: fnd_log.level_exception,

Line 3080: fnd_log.message

3076: FND_MESSAGE.Set_Token('POS_REF', l_posref_meaning);
3077: FND_MSG_PUB.ADD;
3078: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3079: THEN
3080: fnd_log.message
3081: (
3082: fnd_log.level_exception,
3083: 'ahl.plsql.'||G_PKG_NAME||'.Check_MC_Complete',
3084: false

Line 3082: fnd_log.level_exception,

3078: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3079: THEN
3080: fnd_log.message
3081: (
3082: fnd_log.level_exception,
3083: 'ahl.plsql.'||G_PKG_NAME||'.Check_MC_Complete',
3084: false
3085: );
3086: END IF;

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

3087: END IF;
3088: END LOOP;
3089: CLOSE get_node_subconfigs_csr;
3090:
3091: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
3092: THEN
3093: fnd_log.string
3094: (
3095: fnd_log.level_statement,

Line 3093: fnd_log.string

3089: CLOSE get_node_subconfigs_csr;
3090:
3091: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
3092: THEN
3093: fnd_log.string
3094: (
3095: fnd_log.level_statement,
3096: 'ahl.plsql.'||G_PKG_NAME||'.Check_MC_Complete',
3097: 'Subconfig validation done for Node ['||l_relationship_id||']'

Line 3095: fnd_log.level_statement,

3091: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
3092: THEN
3093: fnd_log.string
3094: (
3095: fnd_log.level_statement,
3096: 'ahl.plsql.'||G_PKG_NAME||'.Check_MC_Complete',
3097: 'Subconfig validation done for Node ['||l_relationship_id||']'
3098: );
3099: END IF;

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

3102: THEN
3103: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_NODE_NO_ASSOS');
3104: FND_MESSAGE.Set_Token('POS_REF', l_posref_meaning);
3105: FND_MSG_PUB.ADD;
3106: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3107: THEN
3108: fnd_log.message
3109: (
3110: fnd_log.level_exception,

Line 3108: fnd_log.message

3104: FND_MESSAGE.Set_Token('POS_REF', l_posref_meaning);
3105: FND_MSG_PUB.ADD;
3106: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3107: THEN
3108: fnd_log.message
3109: (
3110: fnd_log.level_exception,
3111: 'ahl.plsql.'||G_PKG_NAME||'.Check_MC_Complete',
3112: false

Line 3110: fnd_log.level_exception,

3106: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3107: THEN
3108: fnd_log.message
3109: (
3110: fnd_log.level_exception,
3111: 'ahl.plsql.'||G_PKG_NAME||'.Check_MC_Complete',
3112: false
3113: );
3114: END IF;

Line 3121: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

3117: CLOSE get_mc_nodes_csr;
3118:
3119: -- SATHAPLI::FP OGMA Issue# 105 - Non-Serialized Item Maintenance, 04-Dec-2007
3120: -- Call the API AHL_MC_RULE_STMT_PVT.validate_quantity_rules_for_mc for Quantity Rule Validation
3121: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3122: fnd_log.string
3123: (
3124: fnd_log.level_statement,
3125: 'ahl.plsql.'||G_PKG_NAME||'.Check_MC_Complete',

Line 3122: fnd_log.string

3118:
3119: -- SATHAPLI::FP OGMA Issue# 105 - Non-Serialized Item Maintenance, 04-Dec-2007
3120: -- Call the API AHL_MC_RULE_STMT_PVT.validate_quantity_rules_for_mc for Quantity Rule Validation
3121: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3122: fnd_log.string
3123: (
3124: fnd_log.level_statement,
3125: 'ahl.plsql.'||G_PKG_NAME||'.Check_MC_Complete',
3126: 'Calling API AHL_MC_RULE_STMT_PVT.validate_quantity_rules_for_mc for '||

Line 3124: fnd_log.level_statement,

3120: -- Call the API AHL_MC_RULE_STMT_PVT.validate_quantity_rules_for_mc for Quantity Rule Validation
3121: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3122: fnd_log.string
3123: (
3124: fnd_log.level_statement,
3125: 'ahl.plsql.'||G_PKG_NAME||'.Check_MC_Complete',
3126: 'Calling API AHL_MC_RULE_STMT_PVT.validate_quantity_rules_for_mc for '||
3127: 'Quantity Rule Validation for mc_header_id ['||p_mc_header_id||']'
3128: );

Line 3142: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

3138: x_msg_count => l_msg_count,
3139: x_msg_data => l_msg_data
3140: );
3141:
3142: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3143: fnd_log.string
3144: (
3145: fnd_log.level_statement,
3146: 'ahl.plsql.'||G_PKG_NAME||'.Check_MC_Complete',

Line 3143: fnd_log.string

3139: x_msg_data => l_msg_data
3140: );
3141:
3142: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3143: fnd_log.string
3144: (
3145: fnd_log.level_statement,
3146: 'ahl.plsql.'||G_PKG_NAME||'.Check_MC_Complete',
3147: 'Returned from calling API AHL_MC_RULE_STMT_PVT.validate_quantity_rules_for_mc for '||

Line 3145: fnd_log.level_statement,

3141:
3142: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3143: fnd_log.string
3144: (
3145: fnd_log.level_statement,
3146: 'ahl.plsql.'||G_PKG_NAME||'.Check_MC_Complete',
3147: 'Returned from calling API AHL_MC_RULE_STMT_PVT.validate_quantity_rules_for_mc for '||
3148: 'Quantity Rule Validation for mc_header_id ['||p_mc_header_id||']'
3149: );

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

3148: 'Quantity Rule Validation for mc_header_id ['||p_mc_header_id||']'
3149: );
3150: END IF;
3151:
3152: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
3153: THEN
3154: fnd_log.string
3155: (
3156: fnd_log.level_procedure,

Line 3154: fnd_log.string

3150: END IF;
3151:
3152: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
3153: THEN
3154: fnd_log.string
3155: (
3156: fnd_log.level_procedure,
3157: 'ahl.plsql.'||G_PKG_NAME||'.Check_MC_Complete.end',
3158: 'At the end of PLSQL procedure '||G_PKG_NAME||'.Check_MC_Complete'

Line 3156: fnd_log.level_procedure,

3152: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
3153: THEN
3154: fnd_log.string
3155: (
3156: fnd_log.level_procedure,
3157: 'ahl.plsql.'||G_PKG_NAME||'.Check_MC_Complete.end',
3158: 'At the end of PLSQL procedure '||G_PKG_NAME||'.Check_MC_Complete'
3159: );
3160: END IF;