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

Line 11: l_log_current_level NUMBER := FND_LOG.g_current_runtime_level;

7:
8: ------------------------------------------------------------------------------------
9: -- Common variables
10: ------------------------------------------------------------------------------------
11: l_log_current_level NUMBER := FND_LOG.g_current_runtime_level;
12: l_log_statement NUMBER := FND_LOG.level_statement;
13: l_log_procedure NUMBER := FND_LOG.level_procedure;
14: l_log_error NUMBER := FND_LOG.level_error;
15: l_log_exception NUMBER := FND_LOG.level_exception;

Line 12: l_log_statement NUMBER := FND_LOG.level_statement;

8: ------------------------------------------------------------------------------------
9: -- Common variables
10: ------------------------------------------------------------------------------------
11: l_log_current_level NUMBER := FND_LOG.g_current_runtime_level;
12: l_log_statement NUMBER := FND_LOG.level_statement;
13: l_log_procedure NUMBER := FND_LOG.level_procedure;
14: l_log_error NUMBER := FND_LOG.level_error;
15: l_log_exception NUMBER := FND_LOG.level_exception;
16: l_log_unexpected NUMBER := FND_LOG.level_unexpected;

Line 13: l_log_procedure NUMBER := FND_LOG.level_procedure;

9: -- Common variables
10: ------------------------------------------------------------------------------------
11: l_log_current_level NUMBER := FND_LOG.g_current_runtime_level;
12: l_log_statement NUMBER := FND_LOG.level_statement;
13: l_log_procedure NUMBER := FND_LOG.level_procedure;
14: l_log_error NUMBER := FND_LOG.level_error;
15: l_log_exception NUMBER := FND_LOG.level_exception;
16: l_log_unexpected NUMBER := FND_LOG.level_unexpected;
17: ------------------------------------------------------------------------------------

Line 14: l_log_error NUMBER := FND_LOG.level_error;

10: ------------------------------------------------------------------------------------
11: l_log_current_level NUMBER := FND_LOG.g_current_runtime_level;
12: l_log_statement NUMBER := FND_LOG.level_statement;
13: l_log_procedure NUMBER := FND_LOG.level_procedure;
14: l_log_error NUMBER := FND_LOG.level_error;
15: l_log_exception NUMBER := FND_LOG.level_exception;
16: l_log_unexpected NUMBER := FND_LOG.level_unexpected;
17: ------------------------------------------------------------------------------------
18:

Line 15: l_log_exception NUMBER := FND_LOG.level_exception;

11: l_log_current_level NUMBER := FND_LOG.g_current_runtime_level;
12: l_log_statement NUMBER := FND_LOG.level_statement;
13: l_log_procedure NUMBER := FND_LOG.level_procedure;
14: l_log_error NUMBER := FND_LOG.level_error;
15: l_log_exception NUMBER := FND_LOG.level_exception;
16: l_log_unexpected NUMBER := FND_LOG.level_unexpected;
17: ------------------------------------------------------------------------------------
18:
19: ------------------------------------------------------------------------------------

Line 16: l_log_unexpected NUMBER := FND_LOG.level_unexpected;

12: l_log_statement NUMBER := FND_LOG.level_statement;
13: l_log_procedure NUMBER := FND_LOG.level_procedure;
14: l_log_error NUMBER := FND_LOG.level_error;
15: l_log_exception NUMBER := FND_LOG.level_exception;
16: l_log_unexpected NUMBER := FND_LOG.level_unexpected;
17: ------------------------------------------------------------------------------------
18:
19: ------------------------------------------------------------------------------------
20: -- Start of Comments

Line 179: FND_LOG.string(l_log_procedure, l_full_name || '.begin', 'At the start of the API');

175: --
176:
177: BEGIN
178: IF (l_log_procedure >= l_log_current_level) THEN
179: FND_LOG.string(l_log_procedure, l_full_name || '.begin', 'At the start of the API');
180: END IF;
181:
182: -- Standard start of API savepoint
183: SAVEPOINT Check_Unit_Completeness_Pvt;

Line 200: FND_LOG.string(l_log_statement, l_full_name,

196: -- Initialize Procedure return status to success
197: x_return_status := FND_API.G_RET_STS_SUCCESS;
198:
199: IF (l_log_statement >= l_log_current_level) THEN
200: FND_LOG.string(l_log_statement, l_full_name,
201: ' p_uc_header_id = '||p_uc_header_id||
202: ', p_visit_id = '||p_visit_id||
203: ', p_x_erring_rules_tbl.COUNT = '||p_x_erring_rules_tbl.COUNT);
204: END IF;

Line 213: FND_LOG.string(l_log_statement, l_full_name, 'invalid unit header id');

209: IF (chk_unit_header_id_csr%NOTFOUND) THEN
210: -- invalid unit header id
211: CLOSE chk_unit_header_id_csr;
212: IF (l_log_statement >= l_log_current_level) THEN
213: FND_LOG.string(l_log_statement, l_full_name, 'invalid unit header id');
214: END IF;
215: -- The Unit Configuration header identifier UC_HEADER_ID is invalid.
216: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_UC_HEADER_ID_INVALID');
217: FND_MESSAGE.Set_Token('UC_HEADER_ID', p_uc_header_id);

Line 233: FND_LOG.string(l_log_statement, l_full_name, 'invalid visit id');

229: IF (chk_visit_id_csr%NOTFOUND) THEN
230: -- invalid visit id
231: CLOSE chk_visit_id_csr;
232: IF (l_log_statement >= l_log_current_level) THEN
233: FND_LOG.string(l_log_statement, l_full_name, 'invalid visit id');
234: END IF;
235: -- Visit id VISIT_ID is invalid.
236: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_VWP_INVALID_VST');
237: FND_MESSAGE.Set_Token('VISIT_ID', p_visit_id);

Line 260: FND_LOG.string(l_log_statement, l_full_name,

256: CLOSE get_appl_sb_rules_csr2;
257: END IF;
258:
259: IF (l_log_statement >= l_log_current_level) THEN
260: FND_LOG.string(l_log_statement, l_full_name,
261: ' l_rule_id_tbl.COUNT = '||l_rule_id_tbl.COUNT||
262: ', l_rule_name_tbl.COUNT = '||l_rule_name_tbl.COUNT||
263: ', l_rel_id_tbl.COUNT = '||l_rel_id_tbl.COUNT);
264: END IF;

Line 283: FND_LOG.string(l_log_statement, l_full_name, 'rule violated = '||l_rule_name_tbl(i));

279: ELSE
280: p_x_erring_rules_tbl(0) := FND_MESSAGE.Get;
281: END IF;
282: IF (l_log_statement >= l_log_current_level) THEN
283: FND_LOG.string(l_log_statement, l_full_name, 'rule violated = '||l_rule_name_tbl(i));
284: END IF;
285: END IF;
286: CLOSE validate_sb_rule_csr;
287: END LOOP;

Line 291: FND_LOG.string(l_log_statement, l_full_name,

287: END LOOP;
288: END IF;
289:
290: IF (l_log_statement >= l_log_current_level) THEN
291: FND_LOG.string(l_log_statement, l_full_name,
292: ' p_x_erring_rules_tbl.COUNT = '||p_x_erring_rules_tbl.COUNT);
293: END IF;
294:
295: IF (l_log_procedure >= l_log_current_level) THEN

Line 296: FND_LOG.string(l_log_procedure, l_full_name || '.end', 'At the end of the API');

292: ' p_x_erring_rules_tbl.COUNT = '||p_x_erring_rules_tbl.COUNT);
293: END IF;
294:
295: IF (l_log_procedure >= l_log_current_level) THEN
296: FND_LOG.string(l_log_procedure, l_full_name || '.end', 'At the end of the API');
297: END IF;
298:
299: EXCEPTION
300: WHEN FND_API.G_EXC_ERROR THEN

Line 307: FND_LOG.string(l_log_exception, l_full_name, 'Execution Error: ' || x_msg_data);

303: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
304: p_data => x_msg_data,
305: p_encoded => FND_API.G_FALSE);
306: IF (l_log_exception >= l_log_current_level) THEN
307: FND_LOG.string(l_log_exception, l_full_name, 'Execution Error: ' || x_msg_data);
308: END IF;
309:
310: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
311: ROLLBACK TO Check_Unit_Completeness_Pvt;

Line 317: FND_LOG.string(l_log_unexpected, l_full_name, 'Unexpected Exception: ' || x_msg_data);

313: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
314: p_data => x_msg_data,
315: p_encoded => FND_API.G_FALSE);
316: IF (l_log_unexpected >= l_log_current_level) THEN
317: FND_LOG.string(l_log_unexpected, l_full_name, 'Unexpected Exception: ' || x_msg_data);
318: END IF;
319:
320: WHEN OTHERS THEN
321: ROLLBACK TO Check_Unit_Completeness_Pvt;

Line 332: FND_LOG.string(l_log_unexpected, l_full_name, 'Other Exception: ' || x_msg_data);

328: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
329: p_data => x_msg_data,
330: p_encoded => fnd_api.G_FALSE);
331: IF (l_log_unexpected >= l_log_current_level) THEN
332: FND_LOG.string(l_log_unexpected, l_full_name, 'Other Exception: ' || x_msg_data);
333: END IF;
334:
335: END Check_Unit_Completeness;
336: ------------------------------------------------------------------------------------

Line 447: FND_LOG.string(l_log_procedure, l_full_name || '.begin', 'At the start of the API');

443: --
444:
445: BEGIN
446: IF (l_log_procedure >= l_log_current_level) THEN
447: FND_LOG.string(l_log_procedure, l_full_name || '.begin', 'At the start of the API');
448: END IF;
449:
450: -- Standard start of API savepoint
451: SAVEPOINT Check_Inst_Completeness_Pvt;

Line 468: FND_LOG.string(l_log_statement, l_full_name,

464: -- Initialize Procedure return status to success
465: x_return_status := FND_API.G_RET_STS_SUCCESS;
466:
467: IF (l_log_statement >= l_log_current_level) THEN
468: FND_LOG.string(l_log_statement, l_full_name,
469: ' p_csi_instance_id = '||p_csi_instance_id);
470: END IF;
471:
472: -- Get the error message count till this point

Line 481: FND_LOG.string(l_log_statement, l_full_name, 'invalid instance id');

477: FETCH chk_instance_id_csr INTO l_dummy;
478: IF (chk_instance_id_csr%NOTFOUND) THEN
479: -- invalid instance id
480: IF (l_log_statement >= l_log_current_level) THEN
481: FND_LOG.string(l_log_statement, l_full_name, 'invalid instance id');
482: END IF;
483: -- The item instance INSTANCE is invalid.
484: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_FMP_INVALID_ITEM_INSTANCE');
485: FND_MESSAGE.Set_Token('INSTANCE', p_csi_instance_id);

Line 497: FND_LOG.string(l_log_statement, l_full_name, 'invalid unit header id l_uc_header_id = '||l_uc_header_id);

493: FETCH get_unit_name_csr INTO l_unit_name;
494: IF (get_unit_name_csr%NOTFOUND) THEN
495: -- invalid unit header id
496: IF (l_log_statement >= l_log_current_level) THEN
497: FND_LOG.string(l_log_statement, l_full_name, 'invalid unit header id l_uc_header_id = '||l_uc_header_id);
498: END IF;
499: -- The Unit Configuration header identifier UC_HEADER_ID is invalid.
500: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_UC_HEADER_ID_INVALID');
501: FND_MESSAGE.Set_Token('UC_HEADER_ID', l_uc_header_id);

Line 509: FND_LOG.string(l_log_statement, l_full_name, 'given instance and / or its unit are invalid');

505:
506: -- If any errors occured, then raise them
507: IF (l_msg_count < FND_MSG_PUB.count_msg) THEN
508: IF (l_log_statement >= l_log_current_level) THEN
509: FND_LOG.string(l_log_statement, l_full_name, 'given instance and / or its unit are invalid');
510: END IF;
511: RAISE FND_API.G_EXC_ERROR;
512: END IF;
513:

Line 515: FND_LOG.string(l_log_statement, l_full_name,

511: RAISE FND_API.G_EXC_ERROR;
512: END IF;
513:
514: IF (l_log_statement >= l_log_current_level) THEN
515: FND_LOG.string(l_log_statement, l_full_name,
516: ' l_uc_header_id = '||l_uc_header_id||', l_unit_name = '||l_unit_name);
517: END IF;
518:
519: -- Get the applicable SB rules for the unit and the given instance

Line 527: FND_LOG.string(l_log_statement, l_full_name,

523: FETCH get_appl_sb_rules_csr BULK COLLECT INTO l_rule_id_tbl, l_rule_name_tbl, l_rel_id_tbl;
524: CLOSE get_appl_sb_rules_csr;
525:
526: IF (l_log_statement >= l_log_current_level) THEN
527: FND_LOG.string(l_log_statement, l_full_name,
528: ' l_rule_id_tbl.COUNT = '||l_rule_id_tbl.COUNT||
529: ', l_rule_name_tbl.COUNT = '||l_rule_name_tbl.COUNT||
530: ', l_rel_id_tbl.COUNT = '||l_rel_id_tbl.COUNT);
531: END IF;

Line 550: FND_LOG.string(l_log_statement, l_full_name, 'rule violated = '||l_rule_name_tbl(i));

546: ELSE
547: p_x_erring_rules_tbl(0) := FND_MESSAGE.Get;
548: END IF;
549: IF (l_log_statement >= l_log_current_level) THEN
550: FND_LOG.string(l_log_statement, l_full_name, 'rule violated = '||l_rule_name_tbl(i));
551: END IF;
552: END IF;
553: CLOSE validate_sb_rule_csr;
554: END LOOP;

Line 558: FND_LOG.string(l_log_statement, l_full_name,

554: END LOOP;
555: END IF;
556:
557: IF (l_log_statement >= l_log_current_level) THEN
558: FND_LOG.string(l_log_statement, l_full_name,
559: ' p_x_erring_rules_tbl.COUNT = '||p_x_erring_rules_tbl.COUNT);
560: END IF;
561:
562: IF (l_log_procedure >= l_log_current_level) THEN

Line 563: FND_LOG.string(l_log_procedure, l_full_name || '.end', 'At the end of the API');

559: ' p_x_erring_rules_tbl.COUNT = '||p_x_erring_rules_tbl.COUNT);
560: END IF;
561:
562: IF (l_log_procedure >= l_log_current_level) THEN
563: FND_LOG.string(l_log_procedure, l_full_name || '.end', 'At the end of the API');
564: END IF;
565:
566: EXCEPTION
567: WHEN FND_API.G_EXC_ERROR THEN

Line 574: FND_LOG.string(l_log_exception, l_full_name, 'Execution Error: ' || x_msg_data);

570: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
571: p_data => x_msg_data,
572: p_encoded => FND_API.G_FALSE);
573: IF (l_log_exception >= l_log_current_level) THEN
574: FND_LOG.string(l_log_exception, l_full_name, 'Execution Error: ' || x_msg_data);
575: END IF;
576:
577: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
578: ROLLBACK TO Check_Inst_Completeness_Pvt;

Line 584: FND_LOG.string(l_log_unexpected, l_full_name, 'Unexpected Exception: ' || x_msg_data);

580: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
581: p_data => x_msg_data,
582: p_encoded => FND_API.G_FALSE);
583: IF (l_log_unexpected >= l_log_current_level) THEN
584: FND_LOG.string(l_log_unexpected, l_full_name, 'Unexpected Exception: ' || x_msg_data);
585: END IF;
586:
587: WHEN OTHERS THEN
588: ROLLBACK TO Check_Inst_Completeness_Pvt;

Line 599: FND_LOG.string(l_log_unexpected, l_full_name, 'Other Exception: ' || x_msg_data);

595: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
596: p_data => x_msg_data,
597: p_encoded => fnd_api.G_FALSE);
598: IF (l_log_unexpected >= l_log_current_level) THEN
599: FND_LOG.string(l_log_unexpected, l_full_name, 'Other Exception: ' || x_msg_data);
600: END IF;
601:
602: END Check_Inst_Completeness;
603: ------------------------------------------------------------------------------------

Line 715: FND_LOG.string(l_log_procedure, l_full_name || '.begin', 'At the start of the API');

711: --
712:
713: BEGIN
714: IF (l_log_procedure >= l_log_current_level) THEN
715: FND_LOG.string(l_log_procedure, l_full_name || '.begin', 'At the start of the API');
716: END IF;
717:
718: -- Initialize message list if p_init_msg_list is set to TRUE
719: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 724: FND_LOG.string(l_log_statement, l_full_name,

720: FND_MSG_PUB.Initialize;
721: END IF;
722:
723: IF (l_log_statement >= l_log_current_level) THEN
724: FND_LOG.string(l_log_statement, l_full_name,
725: ' p_mc_header_id = '||p_mc_header_id||
726: ', p_mc_pos_key = '||p_mc_pos_key||
727: ', p_inv_item_id = '||p_inv_item_id||
728: ', p_inv_org_id = '||p_inv_org_id||

Line 738: FND_LOG.string(l_log_statement, l_full_name, 'invalid MC and position');

734: FETCH get_mc_rel_id_csr INTO l_mc_rel_id;
735: IF (get_mc_rel_id_csr%NOTFOUND) THEN
736: -- invalid MC and position
737: IF (l_log_statement >= l_log_current_level) THEN
738: FND_LOG.string(l_log_statement, l_full_name, 'invalid MC and position');
739: END IF;
740: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_MC_NODE_NOT_FOUND'); -- Master Configuration node not found.
741: FND_MSG_PUB.ADD;
742: END IF;

Line 767: FND_LOG.string(l_log_statement, l_full_name, 'rule violated = '||l_rule_name_tbl(i));

763: FND_MESSAGE.Set_Token('RULE_NAME',l_rule_name_tbl(i));
764: FND_MESSAGE.Set_Token('UNIT_NAME',l_get_unit_det_csr_rec.name);
765: FND_MSG_PUB.ADD;
766: IF (l_log_statement >= l_log_current_level) THEN
767: FND_LOG.string(l_log_statement, l_full_name, 'rule violated = '||l_rule_name_tbl(i));
768: END IF;
769: END IF;
770: CLOSE validate_sb_rule_csr;
771: END LOOP;

Line 779: FND_LOG.string(l_log_statement, l_full_name, 'no matching unit found');

775: END LOOP;
776: IF (l_count = 0) THEN
777: -- no matching unit found
778: IF (l_log_statement >= l_log_current_level) THEN
779: FND_LOG.string(l_log_statement, l_full_name, 'no matching unit found');
780: END IF;
781: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_PC_UNIT_NOT_FOUND'); -- No such unit found in Unit Configuration.
782: FND_MSG_PUB.ADD;
783: END IF;

Line 786: FND_LOG.string(l_log_procedure, l_full_name || '.end', 'At the end of the API');

782: FND_MSG_PUB.ADD;
783: END IF;
784:
785: IF (l_log_procedure >= l_log_current_level) THEN
786: FND_LOG.string(l_log_procedure, l_full_name || '.end', 'At the end of the API');
787: END IF;
788:
789: END Evaluate_Rules_For_Pos;
790: ------------------------------------------------------------------------------------

Line 851: FND_LOG.string(l_log_procedure, l_full_name || '.begin', 'At the start of the API');

847: --
848:
849: BEGIN
850: IF (l_log_procedure >= l_log_current_level) THEN
851: FND_LOG.string(l_log_procedure, l_full_name || '.begin', 'At the start of the API');
852: END IF;
853:
854: -- Standard start of API savepoint
855: SAVEPOINT Copy_Rules_For_MR_Pvt;

Line 867: FND_LOG.string(l_log_statement, l_full_name,

863: -- Initialize Procedure return status to success
864: x_return_status := FND_API.G_RET_STS_SUCCESS;
865:
866: IF (l_log_statement >= l_log_current_level) THEN
867: FND_LOG.string(l_log_statement, l_full_name,
868: ' p_src_mr_header_id = '||p_src_mr_header_id||
869: ', p_dst_mr_header_id = '||p_dst_mr_header_id);
870: END IF;
871:

Line 881: FND_LOG.string(l_log_statement, l_full_name, 'invalid source MR header id');

877: FETCH chk_mr_header_id_csr INTO l_dummy;
878: IF (chk_mr_header_id_csr%NOTFOUND) THEN
879: -- invalid source MR header id
880: IF (l_log_statement >= l_log_current_level) THEN
881: FND_LOG.string(l_log_statement, l_full_name, 'invalid source MR header id');
882: END IF;
883: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_UMP_PUE_MR_NOTFOUND'); -- Maintenance requirement ID (MR_ID) not found.
884: FND_MESSAGE.Set_Token('MR_ID', p_src_mr_header_id);
885: FND_MSG_PUB.ADD;

Line 893: FND_LOG.string(l_log_statement, l_full_name, 'invalid destination MR header id');

889: FETCH chk_mr_header_id_csr INTO l_dummy;
890: IF (chk_mr_header_id_csr%NOTFOUND) THEN
891: -- invalid destination MR header id
892: IF (l_log_statement >= l_log_current_level) THEN
893: FND_LOG.string(l_log_statement, l_full_name, 'invalid destination MR header id');
894: END IF;
895: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_UMP_PUE_MR_NOTFOUND'); -- Maintenance requirement ID (MR_ID) not found.
896: FND_MESSAGE.Set_Token('MR_ID', p_dst_mr_header_id);
897: FND_MSG_PUB.ADD;

Line 911: FND_LOG.string(l_log_statement, l_full_name, 'l_copy = '||l_copy);

907: -- 1) get the translated message AHL_COM_COPY
908: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_COM_COPY'); -- Copy
909: l_copy := FND_MESSAGE.Get;
910: IF (l_log_statement >= l_log_current_level) THEN
911: FND_LOG.string(l_log_statement, l_full_name, 'l_copy = '||l_copy);
912: END IF;
913:
914: -- 2) copy the SB rules and their items
915: FOR l_get_rule_det_csr_rec IN get_rule_det_csr(p_src_mr_header_id) LOOP

Line 952: FND_LOG.string(l_log_statement, l_full_name, 'copied rule = '||l_get_rule_det_csr_rec.rule_name);

948: l_get_rule_items_det_csr_rec.item_association_id, l_get_rule_items_det_csr_rec.sub_config_item);
949: END LOOP;
950:
951: IF (l_log_statement >= l_log_current_level) THEN
952: FND_LOG.string(l_log_statement, l_full_name, 'copied rule = '||l_get_rule_det_csr_rec.rule_name);
953: END IF;
954: END LOOP;
955:
956: -- Standard check of p_commit

Line 962: FND_LOG.string(l_log_procedure, l_full_name || '.end', 'At the end of the API');

958: COMMIT WORK;
959: END IF;
960:
961: IF (l_log_procedure >= l_log_current_level) THEN
962: FND_LOG.string(l_log_procedure, l_full_name || '.end', 'At the end of the API');
963: END IF;
964:
965: EXCEPTION
966: WHEN FND_API.G_EXC_ERROR THEN

Line 973: FND_LOG.string(l_log_exception, l_full_name, 'Execution Error: ' || x_msg_data);

969: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
970: p_data => x_msg_data,
971: p_encoded => FND_API.G_FALSE);
972: IF (l_log_exception >= l_log_current_level) THEN
973: FND_LOG.string(l_log_exception, l_full_name, 'Execution Error: ' || x_msg_data);
974: END IF;
975:
976: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
977: ROLLBACK TO Copy_Rules_For_MR_Pvt;

Line 983: FND_LOG.string(l_log_unexpected, l_full_name, 'Unexpected Exception: ' || x_msg_data);

979: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
980: p_data => x_msg_data,
981: p_encoded => FND_API.G_FALSE);
982: IF (l_log_unexpected >= l_log_current_level) THEN
983: FND_LOG.string(l_log_unexpected, l_full_name, 'Unexpected Exception: ' || x_msg_data);
984: END IF;
985:
986: WHEN OTHERS THEN
987: ROLLBACK TO Copy_Rules_For_MR_Pvt;

Line 998: FND_LOG.string(l_log_unexpected, l_full_name, 'Other Exception: ' || x_msg_data);

994: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
995: p_data => x_msg_data,
996: p_encoded => fnd_api.G_FALSE);
997: IF (l_log_unexpected >= l_log_current_level) THEN
998: FND_LOG.string(l_log_unexpected, l_full_name, 'Other Exception: ' || x_msg_data);
999: END IF;
1000:
1001: END Copy_Rules_For_MR;
1002: ------------------------------------------------------------------------------------

Line 1072: FND_LOG.string(l_log_procedure, l_full_name || '.begin', 'At the start of the API');

1068: --
1069:
1070: BEGIN
1071: IF (l_log_procedure >= l_log_current_level) THEN
1072: FND_LOG.string(l_log_procedure, l_full_name || '.begin', 'At the start of the API');
1073: END IF;
1074:
1075: -- Standard start of API savepoint
1076: SAVEPOINT Update_Rules_For_MR_Pvt;

Line 1088: FND_LOG.string(l_log_statement, l_full_name,

1084: -- Initialize Procedure return status to success
1085: x_return_status := FND_API.G_RET_STS_SUCCESS;
1086:
1087: IF (l_log_statement >= l_log_current_level) THEN
1088: FND_LOG.string(l_log_statement, l_full_name,
1089: ' p_mr_header_id = '||p_mr_header_id);
1090: END IF;
1091:
1092: -- Check for the given MR id

Line 1099: FND_LOG.string(l_log_statement, l_full_name, 'invalid MR header id');

1095: IF (chk_mr_header_id_csr%NOTFOUND) THEN
1096: -- invalid MR header id
1097: CLOSE chk_mr_header_id_csr;
1098: IF (l_log_statement >= l_log_current_level) THEN
1099: FND_LOG.string(l_log_statement, l_full_name, 'invalid MR header id');
1100: END IF;
1101: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_UMP_PUE_MR_NOTFOUND'); -- Maintenance requirement ID (MR_ID) not found.
1102: FND_MESSAGE.Set_Token('MR_ID', p_mr_header_id);
1103: FND_MSG_PUB.ADD;

Line 1113: FND_LOG.string(l_log_statement, l_full_name, 'l_sb_mc_hdr_id_tbl.COUNT = '||l_sb_mc_hdr_id_tbl.COUNT);

1109: OPEN get_sb_mc_header_id_csr(p_mr_header_id);
1110: FETCH get_sb_mc_header_id_csr BULK COLLECT INTO l_sb_mc_hdr_id_tbl;
1111: CLOSE get_sb_mc_header_id_csr;
1112: IF (l_log_statement >= l_log_current_level) THEN
1113: FND_LOG.string(l_log_statement, l_full_name, 'l_sb_mc_hdr_id_tbl.COUNT = '||l_sb_mc_hdr_id_tbl.COUNT);
1114: END IF;
1115:
1116: IF (l_sb_mc_hdr_id_tbl.COUNT > 0) THEN
1117: -- 1) Get the MR affected items

Line 1135: FND_LOG.string(l_log_statement, l_full_name, 'AHL_FMP_PVT.Get_MR_Affected_Items call errored out');

1131: );
1132:
1133: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1134: IF (l_log_statement >= l_log_current_level) THEN
1135: FND_LOG.string(l_log_statement, l_full_name, 'AHL_FMP_PVT.Get_MR_Affected_Items call errored out');
1136: END IF;
1137: RAISE FND_API.G_EXC_ERROR;
1138: END IF;
1139:

Line 1141: FND_LOG.string(l_log_statement, l_full_name, 'l_mr_item_inst_tbl.COUNT = '||l_mr_item_inst_tbl.COUNT);

1137: RAISE FND_API.G_EXC_ERROR;
1138: END IF;
1139:
1140: IF (l_log_statement >= l_log_current_level) THEN
1141: FND_LOG.string(l_log_statement, l_full_name, 'l_mr_item_inst_tbl.COUNT = '||l_mr_item_inst_tbl.COUNT);
1142: END IF;
1143:
1144: IF (l_mr_item_inst_tbl.COUNT > 0) THEN
1145: -- 2) Get all the effective MCs

Line 1153: FND_LOG.string(l_log_statement, l_full_name, 'effective MC header id put = '||l_mc_hdr_id);

1149: IF (get_mc_header_id_csr%FOUND) THEN
1150: -- put this MC header id in the associative array for effective MCs
1151: l_eff_mc_hdr_id_tbl(l_mc_hdr_id) := l_mc_hdr_id;
1152: IF (l_log_statement >= l_log_current_level) THEN
1153: FND_LOG.string(l_log_statement, l_full_name, 'effective MC header id put = '||l_mc_hdr_id);
1154: END IF;
1155: END IF;
1156: CLOSE get_mc_header_id_csr;
1157: END LOOP; -- LOOP for l_mr_item_inst_tbl

Line 1165: FND_LOG.string(l_log_statement, l_full_name, 'erring SB MC found = '||l_sb_mc_hdr_id_tbl(i));

1161: FOR i IN l_sb_mc_hdr_id_tbl.FIRST..l_sb_mc_hdr_id_tbl.LAST LOOP
1162: IF (NOT l_eff_mc_hdr_id_tbl.EXISTS(l_sb_mc_hdr_id_tbl(i))) THEN
1163: -- get the SB rule ids defined for this MC and given MR
1164: IF (l_log_statement >= l_log_current_level) THEN
1165: FND_LOG.string(l_log_statement, l_full_name, 'erring SB MC found = '||l_sb_mc_hdr_id_tbl(i));
1166: END IF;
1167: FOR l_get_rule_id_csr_rec IN get_rule_id_csr(l_sb_mc_hdr_id_tbl(i), p_mr_header_id) LOOP
1168: -- delete the SB rule items
1169: DELETE FROM AHL_SB_RULE_ITEMS WHERE rule_id = l_get_rule_id_csr_rec.rule_id;

Line 1175: FND_LOG.string(l_log_statement, l_full_name, 'rule deleted = '||l_get_rule_id_csr_rec.rule_id);

1171: -- delete the SB rule itself
1172: DELETE FROM AHL_SB_POSITION_RULES WHERE rule_id = l_get_rule_id_csr_rec.rule_id;
1173:
1174: IF (l_log_statement >= l_log_current_level) THEN
1175: FND_LOG.string(l_log_statement, l_full_name, 'rule deleted = '||l_get_rule_id_csr_rec.rule_id);
1176: END IF;
1177: END LOOP;
1178: END IF;
1179: END LOOP; -- LOOP for l_sb_mc_hdr_id_tbl

Line 1189: FND_LOG.string(l_log_procedure, l_full_name || '.end', 'At the end of the API');

1185: COMMIT WORK;
1186: END IF;
1187:
1188: IF (l_log_procedure >= l_log_current_level) THEN
1189: FND_LOG.string(l_log_procedure, l_full_name || '.end', 'At the end of the API');
1190: END IF;
1191:
1192: EXCEPTION
1193: WHEN FND_API.G_EXC_ERROR THEN

Line 1200: FND_LOG.string(l_log_exception, l_full_name, 'Execution Error: ' || x_msg_data);

1196: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1197: p_data => x_msg_data,
1198: p_encoded => FND_API.G_FALSE);
1199: IF (l_log_exception >= l_log_current_level) THEN
1200: FND_LOG.string(l_log_exception, l_full_name, 'Execution Error: ' || x_msg_data);
1201: END IF;
1202:
1203: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1204: ROLLBACK TO Update_Rules_For_MR_Pvt;

Line 1210: FND_LOG.string(l_log_unexpected, l_full_name, 'Unexpected Exception: ' || x_msg_data);

1206: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1207: p_data => x_msg_data,
1208: p_encoded => FND_API.G_FALSE);
1209: IF (l_log_unexpected >= l_log_current_level) THEN
1210: FND_LOG.string(l_log_unexpected, l_full_name, 'Unexpected Exception: ' || x_msg_data);
1211: END IF;
1212:
1213: WHEN OTHERS THEN
1214: ROLLBACK TO Update_Rules_For_MR_Pvt;

Line 1225: FND_LOG.string(l_log_unexpected, l_full_name, 'Other Exception: ' || x_msg_data);

1221: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
1222: p_data => x_msg_data,
1223: p_encoded => fnd_api.G_FALSE);
1224: IF (l_log_unexpected >= l_log_current_level) THEN
1225: FND_LOG.string(l_log_unexpected, l_full_name, 'Other Exception: ' || x_msg_data);
1226: END IF;
1227:
1228: END Update_Rules_For_MR;
1229: ------------------------------------------------------------------------------------

Line 1281: FND_LOG.string(l_log_procedure, l_full_name || '.begin', 'At the start of the API');

1277: --
1278:
1279: BEGIN
1280: IF (l_log_procedure >= l_log_current_level) THEN
1281: FND_LOG.string(l_log_procedure, l_full_name || '.begin', 'At the start of the API');
1282: END IF;
1283:
1284: -- Standard start of API savepoint
1285: SAVEPOINT Delete_Rules_For_MR_Pvt;

Line 1297: FND_LOG.string(l_log_statement, l_full_name,

1293: -- Initialize Procedure return status to success
1294: x_return_status := FND_API.G_RET_STS_SUCCESS;
1295:
1296: IF (l_log_statement >= l_log_current_level) THEN
1297: FND_LOG.string(l_log_statement, l_full_name,
1298: ' p_mr_header_id = '||p_mr_header_id);
1299: END IF;
1300:
1301: -- Check for the given MR id

Line 1308: FND_LOG.string(l_log_statement, l_full_name, 'invalid MR header id');

1304: IF (chk_mr_header_id_csr%NOTFOUND) THEN
1305: -- invalid MR header id
1306: CLOSE chk_mr_header_id_csr;
1307: IF (l_log_statement >= l_log_current_level) THEN
1308: FND_LOG.string(l_log_statement, l_full_name, 'invalid MR header id');
1309: END IF;
1310: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_UMP_PUE_MR_NOTFOUND'); -- Maintenance requirement ID (MR_ID) not found.
1311: FND_MESSAGE.Set_Token('MR_ID', p_mr_header_id);
1312: FND_MSG_PUB.ADD;

Line 1322: FND_LOG.string(l_log_statement, l_full_name, 'l_rule_id_tbl.COUNT = '||l_rule_id_tbl.COUNT);

1318: OPEN get_rule_id_csr(p_mr_header_id);
1319: FETCH get_rule_id_csr BULK COLLECT INTO l_rule_id_tbl;
1320: CLOSE get_rule_id_csr;
1321: IF (l_log_statement >= l_log_current_level) THEN
1322: FND_LOG.string(l_log_statement, l_full_name, 'l_rule_id_tbl.COUNT = '||l_rule_id_tbl.COUNT);
1323: END IF;
1324:
1325: IF (l_rule_id_tbl.COUNT > 0) THEN
1326: FOR i IN l_rule_id_tbl.FIRST..l_rule_id_tbl.LAST LOOP

Line 1341: FND_LOG.string(l_log_procedure, l_full_name || '.end', 'At the end of the API');

1337: COMMIT WORK;
1338: END IF;
1339:
1340: IF (l_log_procedure >= l_log_current_level) THEN
1341: FND_LOG.string(l_log_procedure, l_full_name || '.end', 'At the end of the API');
1342: END IF;
1343:
1344: EXCEPTION
1345: WHEN FND_API.G_EXC_ERROR THEN

Line 1352: FND_LOG.string(l_log_exception, l_full_name, 'Execution Error: ' || x_msg_data);

1348: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1349: p_data => x_msg_data,
1350: p_encoded => FND_API.G_FALSE);
1351: IF (l_log_exception >= l_log_current_level) THEN
1352: FND_LOG.string(l_log_exception, l_full_name, 'Execution Error: ' || x_msg_data);
1353: END IF;
1354:
1355: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1356: ROLLBACK TO Delete_Rules_For_MR_Pvt;

Line 1362: FND_LOG.string(l_log_unexpected, l_full_name, 'Unexpected Exception: ' || x_msg_data);

1358: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1359: p_data => x_msg_data,
1360: p_encoded => FND_API.G_FALSE);
1361: IF (l_log_unexpected >= l_log_current_level) THEN
1362: FND_LOG.string(l_log_unexpected, l_full_name, 'Unexpected Exception: ' || x_msg_data);
1363: END IF;
1364:
1365: WHEN OTHERS THEN
1366: ROLLBACK TO Delete_Rules_For_MR_Pvt;

Line 1377: FND_LOG.string(l_log_unexpected, l_full_name, 'Other Exception: ' || x_msg_data);

1373: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
1374: p_data => x_msg_data,
1375: p_encoded => fnd_api.G_FALSE);
1376: IF (l_log_unexpected >= l_log_current_level) THEN
1377: FND_LOG.string(l_log_unexpected, l_full_name, 'Other Exception: ' || x_msg_data);
1378: END IF;
1379:
1380: END Delete_Rules_For_MR;
1381: ------------------------------------------------------------------------------------

Line 1482: FND_LOG.string(l_log_procedure, l_full_name || '.begin', 'At the start of the API');

1478: --
1479:
1480: BEGIN
1481: IF (l_log_procedure >= l_log_current_level) THEN
1482: FND_LOG.string(l_log_procedure, l_full_name || '.begin', 'At the start of the API');
1483: END IF;
1484:
1485: IF (l_log_statement >= l_log_current_level) THEN
1486: FND_LOG.string(l_log_statement, l_full_name,

Line 1486: FND_LOG.string(l_log_statement, l_full_name,

1482: FND_LOG.string(l_log_procedure, l_full_name || '.begin', 'At the start of the API');
1483: END IF;
1484:
1485: IF (l_log_statement >= l_log_current_level) THEN
1486: FND_LOG.string(l_log_statement, l_full_name,
1487: ' p_frk_or_mrg_flg = '||p_frk_or_mrg_flg||
1488: ', p_item_group_id = '||p_item_group_id||
1489: ', p_src_item_group_id = '||p_src_item_group_id);
1490: END IF;

Line 1499: FND_LOG.string(l_log_statement, l_full_name, 'no SB rules exist for the source item group - return');

1495: IF (chk_rule_upd_required%NOTFOUND) THEN
1496: -- no SB rules exist for the source item group - return
1497: CLOSE chk_rule_upd_required;
1498: IF (l_log_statement >= l_log_current_level) THEN
1499: FND_LOG.string(l_log_statement, l_full_name, 'no SB rules exist for the source item group - return');
1500: END IF;
1501: RETURN;
1502: END IF;
1503: CLOSE chk_rule_upd_required;

Line 1511: FND_LOG.string(l_log_statement, l_full_name, 'invalid item group id');

1507: FETCH chk_item_group_id_csr INTO l_dummy;
1508: IF (chk_item_group_id_csr%NOTFOUND) THEN
1509: -- invalid item group id
1510: IF (l_log_statement >= l_log_current_level) THEN
1511: FND_LOG.string(l_log_statement, l_full_name, 'invalid item group id');
1512: END IF;
1513: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_MC_ITEMGRP_INVALID'); -- Item Group ITEM_GRP is invalid.
1514: FND_MESSAGE.Set_Token('ITEM_GRP', p_item_group_id);
1515: FND_MSG_PUB.ADD;

Line 1523: FND_LOG.string(l_log_statement, l_full_name, 'invalid source item group id');

1519: FETCH chk_item_group_id_csr INTO l_dummy;
1520: IF (chk_item_group_id_csr%NOTFOUND) THEN
1521: -- invalid source item group id
1522: IF (l_log_statement >= l_log_current_level) THEN
1523: FND_LOG.string(l_log_statement, l_full_name, 'invalid source item group id');
1524: END IF;
1525: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_MC_ITEMGRP_INVALID'); -- Item Group ITEM_GRP is invalid.
1526: FND_MESSAGE.Set_Token('ITEM_GRP', p_src_item_group_id);
1527: FND_MSG_PUB.ADD;

Line 1539: FND_LOG.string(l_log_statement, l_full_name, 'l_rule_id_for_fork_tbl.COUNT = '||l_rule_id_for_fork_tbl.COUNT);

1535: OPEN get_rule_id_for_fork_csr(p_src_item_group_id);
1536: FETCH get_rule_id_for_fork_csr BULK COLLECT INTO l_rule_id_for_fork_tbl;
1537: CLOSE get_rule_id_for_fork_csr;
1538: IF (l_log_statement >= l_log_current_level) THEN
1539: FND_LOG.string(l_log_statement, l_full_name, 'l_rule_id_for_fork_tbl.COUNT = '||l_rule_id_for_fork_tbl.COUNT);
1540: END IF;
1541:
1542: IF (l_rule_id_for_fork_tbl.COUNT > 0) THEN
1543: FOR i IN l_rule_id_for_fork_tbl.FIRST..l_rule_id_for_fork_tbl.LAST LOOP

Line 1550: FND_LOG.string(l_log_statement, l_full_name, 'applicable rule items deleted');

1546: WHERE rule_id = l_rule_id_for_fork_tbl(i)
1547: AND item_group_id = p_src_item_group_id;
1548:
1549: IF (l_log_statement >= l_log_current_level) THEN
1550: FND_LOG.string(l_log_statement, l_full_name, 'applicable rule items deleted');
1551: END IF;
1552:
1553: -- 3) If the rule has no items left, then delete it too
1554: l_dummy := NULL;

Line 1563: FND_LOG.string(l_log_statement, l_full_name, 'rule deleted = '||l_rule_id_for_fork_tbl(i));

1559: -- delete the SB rule itself
1560: DELETE FROM AHL_SB_POSITION_RULES WHERE rule_id = l_rule_id_for_fork_tbl(i);
1561:
1562: IF (l_log_statement >= l_log_current_level) THEN
1563: FND_LOG.string(l_log_statement, l_full_name, 'rule deleted = '||l_rule_id_for_fork_tbl(i));
1564: END IF;
1565: END IF;
1566: END LOOP;
1567: END IF;

Line 1575: FND_LOG.string(l_log_statement, l_full_name, 'l_src_item_asso_id_tbl.COUNT = '||l_src_item_asso_id_tbl.COUNT);

1571: OPEN get_item_asso_det_csr(p_src_item_group_id);
1572: FETCH get_item_asso_det_csr BULK COLLECT INTO l_src_item_asso_id_tbl, l_src_item_pattern_tbl;
1573: CLOSE get_item_asso_det_csr;
1574: IF (l_log_statement >= l_log_current_level) THEN
1575: FND_LOG.string(l_log_statement, l_full_name, 'l_src_item_asso_id_tbl.COUNT = '||l_src_item_asso_id_tbl.COUNT);
1576: END IF;
1577:
1578: IF (l_src_item_asso_id_tbl.COUNT > 0) THEN
1579: -- 2) Get the item associations' details for the given item group, in associative arrays

Line 1608: FND_LOG.string(l_log_statement, l_full_name, 'rule item '||l_action||' = '||l_src_item_asso_id_tbl(i));

1604: l_action := 'updated';
1605: END IF; -- item pattern check
1606:
1607: IF (l_log_statement >= l_log_current_level) THEN
1608: FND_LOG.string(l_log_statement, l_full_name, 'rule item '||l_action||' = '||l_src_item_asso_id_tbl(i));
1609: END IF;
1610: END IF; -- l_dummy check
1611: END LOOP; -- LOOP for l_src_item_asso_id_tbl
1612: END IF; -- l_src_item_asso_id_tbl COUNT check

Line 1619: FND_LOG.string(l_log_statement, l_full_name, 'l_rule_id_for_merge_tbl.COUNT = '||l_rule_id_for_merge_tbl.COUNT);

1615: OPEN get_rule_id_for_merge_csr;
1616: FETCH get_rule_id_for_merge_csr BULK COLLECT INTO l_rule_id_for_merge_tbl;
1617: CLOSE get_rule_id_for_merge_csr;
1618: IF (l_log_statement >= l_log_current_level) THEN
1619: FND_LOG.string(l_log_statement, l_full_name, 'l_rule_id_for_merge_tbl.COUNT = '||l_rule_id_for_merge_tbl.COUNT);
1620: END IF;
1621: IF (l_rule_id_for_merge_tbl.COUNT > 0) THEN
1622: FOR i IN l_rule_id_for_merge_tbl.FIRST..l_rule_id_for_merge_tbl.LAST LOOP
1623: l_dummy := NULL;

Line 1632: FND_LOG.string(l_log_statement, l_full_name, 'rule deleted = '||l_rule_id_for_merge_tbl(i));

1628: -- delete the SB rule itself
1629: DELETE FROM AHL_SB_POSITION_RULES WHERE rule_id = l_rule_id_for_merge_tbl(i);
1630:
1631: IF (l_log_statement >= l_log_current_level) THEN
1632: FND_LOG.string(l_log_statement, l_full_name, 'rule deleted = '||l_rule_id_for_merge_tbl(i));
1633: END IF;
1634: END IF;
1635: END LOOP;
1636: END IF; -- l_rule_id_for_merge_tbl COUNT check

Line 1640: FND_LOG.string(l_log_procedure, l_full_name || '.end', 'At the end of the API');

1636: END IF; -- l_rule_id_for_merge_tbl COUNT check
1637: END IF; -- fork or merge indicator check
1638:
1639: IF (l_log_procedure >= l_log_current_level) THEN
1640: FND_LOG.string(l_log_procedure, l_full_name || '.end', 'At the end of the API');
1641: END IF;
1642:
1643: END Update_Rules_For_IG;
1644: ------------------------------------------------------------------------------------

Line 1750: FND_LOG.string(l_log_procedure, l_full_name || '.begin', 'At the start of the API');

1746: --
1747:
1748: BEGIN
1749: IF (l_log_procedure >= l_log_current_level) THEN
1750: FND_LOG.string(l_log_procedure, l_full_name || '.begin', 'At the start of the API');
1751: END IF;
1752:
1753: -- Standard start of API savepoint
1754: SAVEPOINT Get_Violated_Instances_Pvt;

Line 1771: FND_LOG.string(l_log_statement, l_full_name,

1767: -- Initialize Procedure return status to success
1768: x_return_status := FND_API.G_RET_STS_SUCCESS;
1769:
1770: IF (l_log_statement >= l_log_current_level) THEN
1771: FND_LOG.string(l_log_statement, l_full_name,
1772: ' p_uc_header_id = '||p_uc_header_id);
1773: END IF;
1774:
1775: -- Check for the unit header id

Line 1782: FND_LOG.string(l_log_statement, l_full_name, 'invalid unit header id');

1778: IF (chk_unit_header_id_csr%NOTFOUND) THEN
1779: -- invalid unit header id
1780: CLOSE chk_unit_header_id_csr;
1781: IF (l_log_statement >= l_log_current_level) THEN
1782: FND_LOG.string(l_log_statement, l_full_name, 'invalid unit header id');
1783: END IF;
1784: -- The Unit Configuration header identifier UC_HEADER_ID is invalid.
1785: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_UC_HEADER_ID_INVALID');
1786: FND_MESSAGE.Set_Token('UC_HEADER_ID', p_uc_header_id);

Line 1798: FND_LOG.string(l_log_statement, l_full_name,

1794: FETCH get_appl_sb_rules_csr BULK COLLECT INTO l_rule_id_tbl, l_rel_id_tbl;
1795: CLOSE get_appl_sb_rules_csr;
1796:
1797: IF (l_log_statement >= l_log_current_level) THEN
1798: FND_LOG.string(l_log_statement, l_full_name,
1799: ' l_rule_id_tbl.COUNT = '||l_rule_id_tbl.COUNT||
1800: ' ,l_rel_id_tbl.COUNT = '||l_rel_id_tbl.COUNT);
1801: END IF;
1802:

Line 1818: FND_LOG.string(l_log_statement, l_full_name,

1814: IF (l_instance_id IS NOT NULL) THEN
1815: x_violated_inst_tbl(l_instance_id) := l_instance_id;
1816: END IF;
1817: IF (l_log_statement >= l_log_current_level) THEN
1818: FND_LOG.string(l_log_statement, l_full_name,
1819: ' rule violated = '||l_rule_id_tbl(i)||
1820: ', l_instance_id = '||l_instance_id);
1821: END IF;
1822: END IF;

Line 1828: FND_LOG.string(l_log_procedure, l_full_name || '.end', 'At the end of the API');

1824: END LOOP;
1825: END IF;
1826:
1827: IF (l_log_procedure >= l_log_current_level) THEN
1828: FND_LOG.string(l_log_procedure, l_full_name || '.end', 'At the end of the API');
1829: END IF;
1830:
1831: EXCEPTION
1832: WHEN FND_API.G_EXC_ERROR THEN

Line 1839: FND_LOG.string(l_log_exception, l_full_name, 'Execution Error: ' || x_msg_data);

1835: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1836: p_data => x_msg_data,
1837: p_encoded => FND_API.G_FALSE);
1838: IF (l_log_exception >= l_log_current_level) THEN
1839: FND_LOG.string(l_log_exception, l_full_name, 'Execution Error: ' || x_msg_data);
1840: END IF;
1841:
1842: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1843: ROLLBACK TO Get_Violated_Instances_Pvt;

Line 1849: FND_LOG.string(l_log_unexpected, l_full_name, 'Unexpected Exception: ' || x_msg_data);

1845: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1846: p_data => x_msg_data,
1847: p_encoded => FND_API.G_FALSE);
1848: IF (l_log_unexpected >= l_log_current_level) THEN
1849: FND_LOG.string(l_log_unexpected, l_full_name, 'Unexpected Exception: ' || x_msg_data);
1850: END IF;
1851:
1852: WHEN OTHERS THEN
1853: ROLLBACK TO Get_Violated_Instances_Pvt;

Line 1864: FND_LOG.string(l_log_unexpected, l_full_name, 'Other Exception: ' || x_msg_data);

1860: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
1861: p_data => x_msg_data,
1862: p_encoded => fnd_api.G_FALSE);
1863: IF (l_log_unexpected >= l_log_current_level) THEN
1864: FND_LOG.string(l_log_unexpected, l_full_name, 'Other Exception: ' || x_msg_data);
1865: END IF;
1866:
1867: END Get_Violated_Instances;
1868: ------------------------------------------------------------------------------------

Line 1920: FND_LOG.string(l_log_procedure, l_full_name || '.begin', 'At the start of the API');

1916: --
1917:
1918: BEGIN
1919: IF (l_log_procedure >= l_log_current_level) THEN
1920: FND_LOG.string(l_log_procedure, l_full_name || '.begin', 'At the start of the API');
1921: END IF;
1922:
1923: -- Standard start of API savepoint
1924: SAVEPOINT Get_Affected_MC_Pvt;

Line 1941: FND_LOG.string(l_log_statement, l_full_name,

1937: -- Initialize Procedure return status to success
1938: x_return_status := FND_API.G_RET_STS_SUCCESS;
1939:
1940: IF (l_log_statement >= l_log_current_level) THEN
1941: FND_LOG.string(l_log_statement, l_full_name,
1942: ' p_mr_header_id = '||p_mr_header_id);
1943: END IF;
1944:
1945: -- Check for the given MR id

Line 1952: FND_LOG.string(l_log_statement, l_full_name, 'invalid MR header id');

1948: IF (chk_mr_header_id_csr%NOTFOUND) THEN
1949: -- invalid MR header id
1950: CLOSE chk_mr_header_id_csr;
1951: IF (l_log_statement >= l_log_current_level) THEN
1952: FND_LOG.string(l_log_statement, l_full_name, 'invalid MR header id');
1953: END IF;
1954: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_UMP_PUE_MR_NOTFOUND'); -- Maintenance requirement ID (MR_ID) not found.
1955: FND_MESSAGE.Set_Token('MR_ID', p_mr_header_id);
1956: FND_MSG_PUB.ADD;

Line 1980: FND_LOG.string(l_log_statement, l_full_name, 'AHL_FMP_PVT.Get_MR_Affected_Items call errored out');

1976: );
1977:
1978: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1979: IF (l_log_statement >= l_log_current_level) THEN
1980: FND_LOG.string(l_log_statement, l_full_name, 'AHL_FMP_PVT.Get_MR_Affected_Items call errored out');
1981: END IF;
1982: RAISE FND_API.G_EXC_ERROR;
1983: END IF;
1984:

Line 1986: FND_LOG.string(l_log_statement, l_full_name, 'l_mr_item_inst_tbl.COUNT = '||l_mr_item_inst_tbl.COUNT);

1982: RAISE FND_API.G_EXC_ERROR;
1983: END IF;
1984:
1985: IF (l_log_statement >= l_log_current_level) THEN
1986: FND_LOG.string(l_log_statement, l_full_name, 'l_mr_item_inst_tbl.COUNT = '||l_mr_item_inst_tbl.COUNT);
1987: END IF;
1988:
1989: IF (l_mr_item_inst_tbl.COUNT > 0) THEN
1990: -- 2) Get all the effective MCs

Line 2002: FND_LOG.string(l_log_statement, l_full_name, 'effective MC header id put = '||l_mc_hdr_id);

1998: ELSE
1999: x_affected_mc_tbl(0) := l_mc_hdr_id;
2000: END IF;
2001: IF (l_log_statement >= l_log_current_level) THEN
2002: FND_LOG.string(l_log_statement, l_full_name, 'effective MC header id put = '||l_mc_hdr_id);
2003: END IF;
2004: END IF;
2005: CLOSE get_mc_header_id_csr;
2006: END LOOP; -- LOOP for l_mr_item_inst_tbl

Line 2010: FND_LOG.string(l_log_statement, l_full_name,

2006: END LOOP; -- LOOP for l_mr_item_inst_tbl
2007: END IF; -- l_mr_item_inst_tbl COUNT check
2008:
2009: IF (l_log_statement >= l_log_current_level) THEN
2010: FND_LOG.string(l_log_statement, l_full_name,
2011: ' x_affected_mc_tbl.COUNT = '||x_affected_mc_tbl.COUNT);
2012: END IF;
2013:
2014: IF (l_log_procedure >= l_log_current_level) THEN

Line 2015: FND_LOG.string(l_log_procedure, l_full_name || '.end', 'At the end of the API');

2011: ' x_affected_mc_tbl.COUNT = '||x_affected_mc_tbl.COUNT);
2012: END IF;
2013:
2014: IF (l_log_procedure >= l_log_current_level) THEN
2015: FND_LOG.string(l_log_procedure, l_full_name || '.end', 'At the end of the API');
2016: END IF;
2017:
2018: EXCEPTION
2019: WHEN FND_API.G_EXC_ERROR THEN

Line 2026: FND_LOG.string(l_log_exception, l_full_name, 'Execution Error: ' || x_msg_data);

2022: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2023: p_data => x_msg_data,
2024: p_encoded => FND_API.G_FALSE);
2025: IF (l_log_exception >= l_log_current_level) THEN
2026: FND_LOG.string(l_log_exception, l_full_name, 'Execution Error: ' || x_msg_data);
2027: END IF;
2028:
2029: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2030: ROLLBACK TO Get_Affected_MC_Pvt;

Line 2036: FND_LOG.string(l_log_unexpected, l_full_name, 'Unexpected Exception: ' || x_msg_data);

2032: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2033: p_data => x_msg_data,
2034: p_encoded => FND_API.G_FALSE);
2035: IF (l_log_unexpected >= l_log_current_level) THEN
2036: FND_LOG.string(l_log_unexpected, l_full_name, 'Unexpected Exception: ' || x_msg_data);
2037: END IF;
2038:
2039: WHEN OTHERS THEN
2040: ROLLBACK TO Get_Affected_MC_Pvt;

Line 2051: FND_LOG.string(l_log_unexpected, l_full_name, 'Other Exception: ' || x_msg_data);

2047: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
2048: p_data => x_msg_data,
2049: p_encoded => fnd_api.G_FALSE);
2050: IF (l_log_unexpected >= l_log_current_level) THEN
2051: FND_LOG.string(l_log_unexpected, l_full_name, 'Other Exception: ' || x_msg_data);
2052: END IF;
2053:
2054: END Get_Affected_MC;
2055: ------------------------------------------------------------------------------------