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_MR_LOOP_CHAIN_RELNS_PVT dependencies on AHL_DEBUG_PUB

Line 66: l_debug VARCHAR2(1) :=AHL_DEBUG_PUB.is_log_enabled;

62: AND MR.MR_STATUS_CODE IN ('DRAFT','COMPLETE','APPROVAL_PENDING');
63: -- AND rel.relationship_code <> 'PARENT';
64:
65: l_mr_relns_rec mr_relns_csr%ROWTYPE;
66: l_debug VARCHAR2(1) :=AHL_DEBUG_PUB.is_log_enabled;
67: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_LOOP_CHAIN';
68: l_api_version CONSTANT NUMBER := 1.0;
69: l_msg_count NUMBER;
70: l_return_status VARCHAR2(1);

Line 88: AHL_DEBUG_PUB.enable_debug;

84:
85: BEGIN
86:
87: IF l_debug = 'Y' THEN
88: AHL_DEBUG_PUB.enable_debug;
89: AHL_DEBUG_PUB.debug('Begin private API: AHL_MR_LOOP_CHAIN_RELNS_PVT.VALIDATE_LOOP_CHAIN');
90: END IF;
91:
92: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 89: AHL_DEBUG_PUB.debug('Begin private API: AHL_MR_LOOP_CHAIN_RELNS_PVT.VALIDATE_LOOP_CHAIN');

85: BEGIN
86:
87: IF l_debug = 'Y' THEN
88: AHL_DEBUG_PUB.enable_debug;
89: AHL_DEBUG_PUB.debug('Begin private API: AHL_MR_LOOP_CHAIN_RELNS_PVT.VALIDATE_LOOP_CHAIN');
90: END IF;
91:
92: IF FND_API.to_boolean(p_init_msg_list) THEN
93: FND_MSG_PUB.initialize;

Line 200: AHL_DEBUG_PUB.enable_debug;

196: FOR l_mr_index IN p_mr_relns.FIRST..p_mr_relns.LAST
197: LOOP
198: --Validating whether the MR is part of another loop/chain relationship.
199: IF l_debug = 'Y' THEN
200: AHL_DEBUG_PUB.enable_debug;
201: AHL_DEBUG_PUB.debug('p_page_mode::' || p_page_mode);
202: END IF;
203:
204: OPEN mr_dtls_csr(p_mr_relns(l_mr_index).mr_header_id);

Line 201: AHL_DEBUG_PUB.debug('p_page_mode::' || p_page_mode);

197: LOOP
198: --Validating whether the MR is part of another loop/chain relationship.
199: IF l_debug = 'Y' THEN
200: AHL_DEBUG_PUB.enable_debug;
201: AHL_DEBUG_PUB.debug('p_page_mode::' || p_page_mode);
202: END IF;
203:
204: OPEN mr_dtls_csr(p_mr_relns(l_mr_index).mr_header_id);
205: FETCH mr_dtls_csr INTO l_mr_rec_type;

Line 271: AHL_DEBUG_PUB.enable_debug;

267: CLOSE mr_dtls_csr;
268: END IF;
269:
270: IF l_debug = 'Y' THEN
271: AHL_DEBUG_PUB.enable_debug;
272: AHL_DEBUG_PUB.debug('End private API: AHL_MR_LOOP_CHAIN_RELNS_PVT.VALIDATE_LOOP_CHAIN');
273: END IF;
274:
275: EXCEPTION

Line 272: AHL_DEBUG_PUB.debug('End private API: AHL_MR_LOOP_CHAIN_RELNS_PVT.VALIDATE_LOOP_CHAIN');

268: END IF;
269:
270: IF l_debug = 'Y' THEN
271: AHL_DEBUG_PUB.enable_debug;
272: AHL_DEBUG_PUB.debug('End private API: AHL_MR_LOOP_CHAIN_RELNS_PVT.VALIDATE_LOOP_CHAIN');
273: END IF;
274:
275: EXCEPTION
276: WHEN FND_API.G_EXC_ERROR THEN

Line 278: AHL_DEBUG_PUB.enable_debug;

274:
275: EXCEPTION
276: WHEN FND_API.G_EXC_ERROR THEN
277: IF l_debug = 'Y' THEN
278: AHL_DEBUG_PUB.enable_debug;
279: AHL_DEBUG_PUB.debug('ERROR IN AHL_FMP_PVT.VALIDATE_LOOP_CHAIN');
280: END IF;
281:
282: WHEN OTHERS THEN

Line 279: AHL_DEBUG_PUB.debug('ERROR IN AHL_FMP_PVT.VALIDATE_LOOP_CHAIN');

275: EXCEPTION
276: WHEN FND_API.G_EXC_ERROR THEN
277: IF l_debug = 'Y' THEN
278: AHL_DEBUG_PUB.enable_debug;
279: AHL_DEBUG_PUB.debug('ERROR IN AHL_FMP_PVT.VALIDATE_LOOP_CHAIN');
280: END IF;
281:
282: WHEN OTHERS THEN
283: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

Line 287: AHL_DEBUG_PUB.enable_debug;

283: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
284: p_data => l_msg_data,
285: p_encoded => fnd_api.g_false);
286: IF l_debug = 'Y' THEN
287: AHL_DEBUG_PUB.enable_debug;
288: AHL_DEBUG_PUB.debug('Unexpected ERROR IN AHL_FMP_PVT.VALIDATE_LOOP_CHAIN');
289: END IF;
290:
291: END VALIDATE_LOOP_CHAIN;

Line 288: AHL_DEBUG_PUB.debug('Unexpected ERROR IN AHL_FMP_PVT.VALIDATE_LOOP_CHAIN');

284: p_data => l_msg_data,
285: p_encoded => fnd_api.g_false);
286: IF l_debug = 'Y' THEN
287: AHL_DEBUG_PUB.enable_debug;
288: AHL_DEBUG_PUB.debug('Unexpected ERROR IN AHL_FMP_PVT.VALIDATE_LOOP_CHAIN');
289: END IF;
290:
291: END VALIDATE_LOOP_CHAIN;
292:

Line 360: l_debug VARCHAR2(1) :=AHL_DEBUG_PUB.is_log_enabled;

356: l_valid NUMBER := 1;
357: l_loop_index NUMBER := 0;
358: l_start_mr_rel_id NUMBER;
359: l_skip_mr_rel_id NUMBER;
360: l_debug VARCHAR2(1) :=AHL_DEBUG_PUB.is_log_enabled;
361: l_mr_rel_count NUMBER := 0;
362: l_max_sequence NUMBER := 0;
363:
364: BEGIN

Line 366: AHL_DEBUG_PUB.enable_debug;

362: l_max_sequence NUMBER := 0;
363:
364: BEGIN
365: IF l_debug = 'Y' THEN
366: AHL_DEBUG_PUB.enable_debug;
367: AHL_DEBUG_PUB.debug('Begin private API: AHL_MR_LOOP_CHAIN_RELNS_PVT.get_valid_start_mr_rel');
368: END IF;
369:
370: FOR l_loop_chain_rec IN get_loop_chain_relns(p_mr_header_id, p_start_mr_header_id, p_start_mr_rel_id, p_start_mr_title, p_effective_from, p_effective_to, p_rel_code)

Line 367: AHL_DEBUG_PUB.debug('Begin private API: AHL_MR_LOOP_CHAIN_RELNS_PVT.get_valid_start_mr_rel');

363:
364: BEGIN
365: IF l_debug = 'Y' THEN
366: AHL_DEBUG_PUB.enable_debug;
367: AHL_DEBUG_PUB.debug('Begin private API: AHL_MR_LOOP_CHAIN_RELNS_PVT.get_valid_start_mr_rel');
368: END IF;
369:
370: FOR l_loop_chain_rec IN get_loop_chain_relns(p_mr_header_id, p_start_mr_header_id, p_start_mr_rel_id, p_start_mr_title, p_effective_from, p_effective_to, p_rel_code)
371: LOOP

Line 426: AHL_DEBUG_PUB.enable_debug;

422: IF l_valid = 1 AND l_mr_rel_count > l_max_sequence THEN
423: l_start_mr_rel_id := NULL;
424: END IF;
425: IF l_debug = 'Y' THEN
426: AHL_DEBUG_PUB.enable_debug;
427: AHL_DEBUG_PUB.debug('End private API: AHL_MR_LOOP_CHAIN_RELNS_PVT.get_valid_start_mr_rel');
428: END IF;
429:
430: RETURN l_start_mr_rel_id;

Line 427: AHL_DEBUG_PUB.debug('End private API: AHL_MR_LOOP_CHAIN_RELNS_PVT.get_valid_start_mr_rel');

423: l_start_mr_rel_id := NULL;
424: END IF;
425: IF l_debug = 'Y' THEN
426: AHL_DEBUG_PUB.enable_debug;
427: AHL_DEBUG_PUB.debug('End private API: AHL_MR_LOOP_CHAIN_RELNS_PVT.get_valid_start_mr_rel');
428: END IF;
429:
430: RETURN l_start_mr_rel_id;
431:

Line 505: l_debug VARCHAR2(1) :=AHL_DEBUG_PUB.is_log_enabled;

501: l_start_mr_index NUMBER := 0;
502: l_start_mr_header_id NUMBER;
503: l_skip_mr_rel_id NUMBER;
504: l_mr_rel_id NUMBER;
505: l_debug VARCHAR2(1) :=AHL_DEBUG_PUB.is_log_enabled;
506: l_max_rel_seq NUMBER; -- Holds the max seq number from the DB
507: l_current_max_seq NUMBER; -- Holds the current relation's max seq number
508:
509: BEGIN

Line 511: AHL_DEBUG_PUB.enable_debug;

507: l_current_max_seq NUMBER; -- Holds the current relation's max seq number
508:
509: BEGIN
510: IF l_debug = 'Y' THEN
511: AHL_DEBUG_PUB.enable_debug;
512: AHL_DEBUG_PUB.debug('Begin private API: AHL_MR_LOOP_CHAIN_RELNS_PVT.get_start_mr_relns');
513: END IF;
514:
515: FOR l_loop_chain_rec IN get_loop_chain_relns(p_mr_header_id, p_rel_code)

Line 512: AHL_DEBUG_PUB.debug('Begin private API: AHL_MR_LOOP_CHAIN_RELNS_PVT.get_start_mr_relns');

508:
509: BEGIN
510: IF l_debug = 'Y' THEN
511: AHL_DEBUG_PUB.enable_debug;
512: AHL_DEBUG_PUB.debug('Begin private API: AHL_MR_LOOP_CHAIN_RELNS_PVT.get_start_mr_relns');
513: END IF;
514:
515: FOR l_loop_chain_rec IN get_loop_chain_relns(p_mr_header_id, p_rel_code)
516: LOOP

Line 584: AHL_DEBUG_PUB.enable_debug;

580: CLOSE get_mr_dtls;
581: END LOOP;
582: END IF;
583: IF l_debug = 'Y' THEN
584: AHL_DEBUG_PUB.enable_debug;
585: AHL_DEBUG_PUB.debug('End private API: AHL_MR_LOOP_CHAIN_RELNS_PVT.get_start_mr_relns');
586: END IF;
587: END get_start_mr_relns;
588:

Line 585: AHL_DEBUG_PUB.debug('End private API: AHL_MR_LOOP_CHAIN_RELNS_PVT.get_start_mr_relns');

581: END LOOP;
582: END IF;
583: IF l_debug = 'Y' THEN
584: AHL_DEBUG_PUB.enable_debug;
585: AHL_DEBUG_PUB.debug('End private API: AHL_MR_LOOP_CHAIN_RELNS_PVT.get_start_mr_relns');
586: END IF;
587: END get_start_mr_relns;
588:
589: /**

Line 608: l_debug VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;

604: itemInstanceIndex NUMBER := 1;
605: presentFlag CHAR(1) := 'N';
606: l_mr_item_inst_tbl AHL_FMP_PVT.MR_ITEM_INSTANCE_TBL_TYPE;
607: l_applicable_mr_tbl AHL_FMP_PVT.APPLICABLE_MR_TBL_TYPE;
608: l_debug VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
609: l_api_name CONSTANT VARCHAR2(30) := 'GET_CM_AFFECTED_ITEMS';
610: l_api_version CONSTANT NUMBER := 1.0;
611: l_tempIndex NUMBER := 0;
612: l_return_status VARCHAR2(1);

Line 619: AHL_DEBUG_PUB.enable_debug;

615:
616: BEGIN
617: SAVEPOINT GET_CM_AFFECTED_ITEMS_PVT;
618: IF l_debug = 'Y' THEN
619: AHL_DEBUG_PUB.enable_debug;
620: AHL_DEBUG_PUB.debug('Begin private API: AHL_MR_LOOP_CHAIN_RELNS_PVT.GET_CM_AFFECTED_ITEMS');
621: END IF;
622:
623: -- Loop thru each MR in the chain/loop

Line 620: AHL_DEBUG_PUB.debug('Begin private API: AHL_MR_LOOP_CHAIN_RELNS_PVT.GET_CM_AFFECTED_ITEMS');

616: BEGIN
617: SAVEPOINT GET_CM_AFFECTED_ITEMS_PVT;
618: IF l_debug = 'Y' THEN
619: AHL_DEBUG_PUB.enable_debug;
620: AHL_DEBUG_PUB.debug('Begin private API: AHL_MR_LOOP_CHAIN_RELNS_PVT.GET_CM_AFFECTED_ITEMS');
621: END IF;
622:
623: -- Loop thru each MR in the chain/loop
624: FOR loopchainIndex IN p_cm_mr_chain_loop.FIRST..p_cm_mr_chain_loop.LAST

Line 689: AHL_DEBUG_PUB.enable_debug;

685: -- x_cm_mr_chain_loop.DELETE;
686: --END IF;
687:
688: IF l_debug = 'Y' THEN
689: AHL_DEBUG_PUB.enable_debug;
690: IF x_mr_item_instances.COUNT = 0 THEN
691: AHL_DEBUG_PUB.debug('AHL_MR_LOOP_CHAIN_RELNS_PVT.GET_CM_AFFECTED_ITEMS : No Common affected items');
692: END IF;
693: AHL_DEBUG_PUB.debug('END private API: AHL_MR_LOOP_CHAIN_RELNS_PVT.GET_CM_AFFECTED_ITEMS');

Line 691: AHL_DEBUG_PUB.debug('AHL_MR_LOOP_CHAIN_RELNS_PVT.GET_CM_AFFECTED_ITEMS : No Common affected items');

687:
688: IF l_debug = 'Y' THEN
689: AHL_DEBUG_PUB.enable_debug;
690: IF x_mr_item_instances.COUNT = 0 THEN
691: AHL_DEBUG_PUB.debug('AHL_MR_LOOP_CHAIN_RELNS_PVT.GET_CM_AFFECTED_ITEMS : No Common affected items');
692: END IF;
693: AHL_DEBUG_PUB.debug('END private API: AHL_MR_LOOP_CHAIN_RELNS_PVT.GET_CM_AFFECTED_ITEMS');
694: END IF;
695: EXCEPTION

Line 693: AHL_DEBUG_PUB.debug('END private API: AHL_MR_LOOP_CHAIN_RELNS_PVT.GET_CM_AFFECTED_ITEMS');

689: AHL_DEBUG_PUB.enable_debug;
690: IF x_mr_item_instances.COUNT = 0 THEN
691: AHL_DEBUG_PUB.debug('AHL_MR_LOOP_CHAIN_RELNS_PVT.GET_CM_AFFECTED_ITEMS : No Common affected items');
692: END IF;
693: AHL_DEBUG_PUB.debug('END private API: AHL_MR_LOOP_CHAIN_RELNS_PVT.GET_CM_AFFECTED_ITEMS');
694: END IF;
695: EXCEPTION
696: WHEN OTHERS THEN
697: ROLLBACK TO GET_CM_AFFECTED_ITEMS_PVT;

Line 708: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data,

704: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
705: p_count => x_msg_count,
706: p_data => x_msg_data);
707: IF l_debug = 'Y' THEN
708: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data,
709: 'OTHER ERROR IN PRIVATE:' );
710: AHL_DEBUG_PUB.debug('AHL_MR_LOOP_CHAIN_RELNS_PVT.GET_CM_AFFECTED_ITEMS', 'AHL_MR_LOOP_CHAIN_RELNS_PVT.GET_CM_AFFECTED_ITEMS');
711: AHL_DEBUG_PUB.disable_debug;
712: END IF;

Line 710: AHL_DEBUG_PUB.debug('AHL_MR_LOOP_CHAIN_RELNS_PVT.GET_CM_AFFECTED_ITEMS', 'AHL_MR_LOOP_CHAIN_RELNS_PVT.GET_CM_AFFECTED_ITEMS');

706: p_data => x_msg_data);
707: IF l_debug = 'Y' THEN
708: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data,
709: 'OTHER ERROR IN PRIVATE:' );
710: AHL_DEBUG_PUB.debug('AHL_MR_LOOP_CHAIN_RELNS_PVT.GET_CM_AFFECTED_ITEMS', 'AHL_MR_LOOP_CHAIN_RELNS_PVT.GET_CM_AFFECTED_ITEMS');
711: AHL_DEBUG_PUB.disable_debug;
712: END IF;
713: END GET_CM_AFFECTED_ITEMS;
714:

Line 711: AHL_DEBUG_PUB.disable_debug;

707: IF l_debug = 'Y' THEN
708: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data,
709: 'OTHER ERROR IN PRIVATE:' );
710: AHL_DEBUG_PUB.debug('AHL_MR_LOOP_CHAIN_RELNS_PVT.GET_CM_AFFECTED_ITEMS', 'AHL_MR_LOOP_CHAIN_RELNS_PVT.GET_CM_AFFECTED_ITEMS');
711: AHL_DEBUG_PUB.disable_debug;
712: END IF;
713: END GET_CM_AFFECTED_ITEMS;
714:
715: /**

Line 766: l_debug VARCHAR2(1) :=AHL_DEBUG_PUB.is_log_enabled;

762: ) LoopChain
763: WHERE LoopChain.orderSeq = 1;
764:
765:
766: l_debug VARCHAR2(1) :=AHL_DEBUG_PUB.is_log_enabled;
767: l_api_name CONSTANT VARCHAR2(30) := 'GET_MR_LOOP_CHAIN_DTLS';
768: l_api_version CONSTANT NUMBER := 1.0;
769: l_chainindex NUMBER := 0;
770: l_debug_prefix VARCHAR2(50) := 'AHL_MR_LOOP_CHAIN_RELNS_PVT.GET_MR_LOOP_CHAIN_DTLS';

Line 776: AHL_DEBUG_PUB.enable_debug;

772: l_max_seq NUMBER;
773:
774: BEGIN
775: IF l_debug = 'Y' THEN
776: AHL_DEBUG_PUB.enable_debug;
777: AHL_DEBUG_PUB.debug('Begin private API: AHL_MR_LOOP_CHAIN_RELNS_PVT.GET_MR_LOOP_CHAIN_DTLS');
778: END IF;
779:
780: l_start_mr_reln_id := p_start_mr_reln_id;

Line 777: AHL_DEBUG_PUB.debug('Begin private API: AHL_MR_LOOP_CHAIN_RELNS_PVT.GET_MR_LOOP_CHAIN_DTLS');

773:
774: BEGIN
775: IF l_debug = 'Y' THEN
776: AHL_DEBUG_PUB.enable_debug;
777: AHL_DEBUG_PUB.debug('Begin private API: AHL_MR_LOOP_CHAIN_RELNS_PVT.GET_MR_LOOP_CHAIN_DTLS');
778: END IF;
779:
780: l_start_mr_reln_id := p_start_mr_reln_id;
781:

Line 813: AHL_DEBUG_PUB.enable_debug;

809: IF l_chainindex <> l_max_seq THEN
810: x_cm_mr_chain_loop.DELETE;
811: END IF;
812: IF l_debug = 'Y' THEN
813: AHL_DEBUG_PUB.enable_debug;
814: AHL_DEBUG_PUB.debug('GET_MR_LOOP_CHAIN_DTLS:: ' || x_cm_mr_chain_loop.COUNT);
815: END IF;
816: IF l_debug = 'Y' THEN
817: AHL_DEBUG_PUB.enable_debug;

Line 814: AHL_DEBUG_PUB.debug('GET_MR_LOOP_CHAIN_DTLS:: ' || x_cm_mr_chain_loop.COUNT);

810: x_cm_mr_chain_loop.DELETE;
811: END IF;
812: IF l_debug = 'Y' THEN
813: AHL_DEBUG_PUB.enable_debug;
814: AHL_DEBUG_PUB.debug('GET_MR_LOOP_CHAIN_DTLS:: ' || x_cm_mr_chain_loop.COUNT);
815: END IF;
816: IF l_debug = 'Y' THEN
817: AHL_DEBUG_PUB.enable_debug;
818: AHL_DEBUG_PUB.debug('End private API: AHL_MR_LOOP_CHAIN_RELNS_PVT.GET_MR_LOOP_CHAIN_DTLS');

Line 817: AHL_DEBUG_PUB.enable_debug;

813: AHL_DEBUG_PUB.enable_debug;
814: AHL_DEBUG_PUB.debug('GET_MR_LOOP_CHAIN_DTLS:: ' || x_cm_mr_chain_loop.COUNT);
815: END IF;
816: IF l_debug = 'Y' THEN
817: AHL_DEBUG_PUB.enable_debug;
818: AHL_DEBUG_PUB.debug('End private API: AHL_MR_LOOP_CHAIN_RELNS_PVT.GET_MR_LOOP_CHAIN_DTLS');
819: END IF;
820:
821: END GET_MR_LOOP_CHAIN_DTLS;

Line 818: AHL_DEBUG_PUB.debug('End private API: AHL_MR_LOOP_CHAIN_RELNS_PVT.GET_MR_LOOP_CHAIN_DTLS');

814: AHL_DEBUG_PUB.debug('GET_MR_LOOP_CHAIN_DTLS:: ' || x_cm_mr_chain_loop.COUNT);
815: END IF;
816: IF l_debug = 'Y' THEN
817: AHL_DEBUG_PUB.enable_debug;
818: AHL_DEBUG_PUB.debug('End private API: AHL_MR_LOOP_CHAIN_RELNS_PVT.GET_MR_LOOP_CHAIN_DTLS');
819: END IF;
820:
821: END GET_MR_LOOP_CHAIN_DTLS;
822:

Line 857: l_debug VARCHAR2(1) :=AHL_DEBUG_PUB.is_log_enabled;

853: AND trunc(nvl(active_end_date, SYSDATE+1));
854:
855: l_get_unit_name_com get_unit_name_com%ROWTYPE;
856: l_get_unit_name_top get_unit_name_top%ROWTYPE;
857: l_debug VARCHAR2(1) :=AHL_DEBUG_PUB.is_log_enabled;
858: BEGIN
859: --Check for top node.
860: OPEN get_unit_name_top(p_item_instance_id);
861: FETCH get_unit_name_top INTO l_get_unit_name_top;

Line 955: l_debug VARCHAR2(1) :=AHL_DEBUG_PUB.is_log_enabled;

951: FROM csi_item_instances ii
952: WHERE ii.instance_id = c_item_instance_id;
953:
954: l_sequence NUMBER := 0;
955: l_debug VARCHAR2(1) :=AHL_DEBUG_PUB.is_log_enabled;
956: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_LOOP_CHAIN';
957: l_api_version CONSTANT NUMBER := 1.0;
958: l_debug_prefix VARCHAR2(50) := 'AHL_MR_LOOP_CHAIN_RELNS_PVT.VIEW_MR_LOOP_CHAIN';
959: l_start_ue_id NUMBER;

Line 963: AHL_DEBUG_PUB.enable_debug;

959: l_start_ue_id NUMBER;
960:
961: BEGIN
962: IF l_debug = 'Y' THEN
963: AHL_DEBUG_PUB.enable_debug;
964: AHL_DEBUG_PUB.debug('Begin private API: AHL_MR_LOOP_CHAIN_RELNS_PVT.VIEW_MR_LOOP_CHAIN');
965: END IF;
966: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version,
967: l_api_name, G_PKG_NAME)

Line 964: AHL_DEBUG_PUB.debug('Begin private API: AHL_MR_LOOP_CHAIN_RELNS_PVT.VIEW_MR_LOOP_CHAIN');

960:
961: BEGIN
962: IF l_debug = 'Y' THEN
963: AHL_DEBUG_PUB.enable_debug;
964: AHL_DEBUG_PUB.debug('Begin private API: AHL_MR_LOOP_CHAIN_RELNS_PVT.VIEW_MR_LOOP_CHAIN');
965: END IF;
966: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version,
967: l_api_name, G_PKG_NAME)
968: THEN

Line 1076: AHL_DEBUG_PUB.enable_debug;

1072: END IF;
1073: END LOOP;
1074: END IF;
1075: IF l_debug = 'Y' THEN
1076: AHL_DEBUG_PUB.enable_debug;
1077: AHL_DEBUG_PUB.debug('End private API: AHL_MR_LOOP_CHAIN_RELNS_PVT.VIEW_MR_LOOP_CHAIN');
1078: END IF;
1079:
1080: EXCEPTION

Line 1077: AHL_DEBUG_PUB.debug('End private API: AHL_MR_LOOP_CHAIN_RELNS_PVT.VIEW_MR_LOOP_CHAIN');

1073: END LOOP;
1074: END IF;
1075: IF l_debug = 'Y' THEN
1076: AHL_DEBUG_PUB.enable_debug;
1077: AHL_DEBUG_PUB.debug('End private API: AHL_MR_LOOP_CHAIN_RELNS_PVT.VIEW_MR_LOOP_CHAIN');
1078: END IF;
1079:
1080: EXCEPTION
1081: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1087: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,

1083: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1084: p_count => x_msg_count,
1085: p_data => x_msg_data);
1086: IF l_debug = 'Y' THEN
1087: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,
1088: 'UNEXPECTED ERROR IN PRIVATE:' );
1089: AHL_DEBUG_PUB.debug('AHL_MR_LOOP_CHAIN_RELNS_PVT.VIEW_MR_LOOP_CHAIN', l_debug_prefix);
1090: AHL_DEBUG_PUB.disable_debug;
1091: END IF;

Line 1089: AHL_DEBUG_PUB.debug('AHL_MR_LOOP_CHAIN_RELNS_PVT.VIEW_MR_LOOP_CHAIN', l_debug_prefix);

1085: p_data => x_msg_data);
1086: IF l_debug = 'Y' THEN
1087: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,
1088: 'UNEXPECTED ERROR IN PRIVATE:' );
1089: AHL_DEBUG_PUB.debug('AHL_MR_LOOP_CHAIN_RELNS_PVT.VIEW_MR_LOOP_CHAIN', l_debug_prefix);
1090: AHL_DEBUG_PUB.disable_debug;
1091: END IF;
1092:
1093: WHEN FND_API.G_EXC_ERROR THEN

Line 1090: AHL_DEBUG_PUB.disable_debug;

1086: IF l_debug = 'Y' THEN
1087: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,
1088: 'UNEXPECTED ERROR IN PRIVATE:' );
1089: AHL_DEBUG_PUB.debug('AHL_MR_LOOP_CHAIN_RELNS_PVT.VIEW_MR_LOOP_CHAIN', l_debug_prefix);
1090: AHL_DEBUG_PUB.disable_debug;
1091: END IF;
1092:
1093: WHEN FND_API.G_EXC_ERROR THEN
1094: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1099: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,

1095: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1096: p_count => x_msg_count,
1097: p_data => x_msg_data);
1098: IF l_debug = 'Y' THEN
1099: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,
1100: 'ERROR IN PRIVATE:' );
1101: AHL_DEBUG_PUB.debug('AHL_MR_LOOP_CHAIN_RELNS_PVT.VIEW_MR_LOOP_CHAIN', l_debug_prefix);
1102: AHL_DEBUG_PUB.disable_debug;
1103: END IF;

Line 1101: AHL_DEBUG_PUB.debug('AHL_MR_LOOP_CHAIN_RELNS_PVT.VIEW_MR_LOOP_CHAIN', l_debug_prefix);

1097: p_data => x_msg_data);
1098: IF l_debug = 'Y' THEN
1099: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,
1100: 'ERROR IN PRIVATE:' );
1101: AHL_DEBUG_PUB.debug('AHL_MR_LOOP_CHAIN_RELNS_PVT.VIEW_MR_LOOP_CHAIN', l_debug_prefix);
1102: AHL_DEBUG_PUB.disable_debug;
1103: END IF;
1104:
1105: WHEN OTHERS THEN

Line 1102: AHL_DEBUG_PUB.disable_debug;

1098: IF l_debug = 'Y' THEN
1099: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,
1100: 'ERROR IN PRIVATE:' );
1101: AHL_DEBUG_PUB.debug('AHL_MR_LOOP_CHAIN_RELNS_PVT.VIEW_MR_LOOP_CHAIN', l_debug_prefix);
1102: AHL_DEBUG_PUB.disable_debug;
1103: END IF;
1104:
1105: WHEN OTHERS THEN
1106: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1116: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data,

1112: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1113: p_count => x_msg_count,
1114: p_data => x_msg_data);
1115: IF l_debug = 'Y' THEN
1116: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data,
1117: 'OTHER ERROR IN PRIVATE:' );
1118: AHL_DEBUG_PUB.debug('AHL_MR_LOOP_CHAIN_RELNS_PVT.VIEW_MR_LOOP_CHAIN', l_debug_prefix);
1119: AHL_DEBUG_PUB.disable_debug;
1120: END IF;

Line 1118: AHL_DEBUG_PUB.debug('AHL_MR_LOOP_CHAIN_RELNS_PVT.VIEW_MR_LOOP_CHAIN', l_debug_prefix);

1114: p_data => x_msg_data);
1115: IF l_debug = 'Y' THEN
1116: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data,
1117: 'OTHER ERROR IN PRIVATE:' );
1118: AHL_DEBUG_PUB.debug('AHL_MR_LOOP_CHAIN_RELNS_PVT.VIEW_MR_LOOP_CHAIN', l_debug_prefix);
1119: AHL_DEBUG_PUB.disable_debug;
1120: END IF;
1121:
1122:

Line 1119: AHL_DEBUG_PUB.disable_debug;

1115: IF l_debug = 'Y' THEN
1116: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data,
1117: 'OTHER ERROR IN PRIVATE:' );
1118: AHL_DEBUG_PUB.debug('AHL_MR_LOOP_CHAIN_RELNS_PVT.VIEW_MR_LOOP_CHAIN', l_debug_prefix);
1119: AHL_DEBUG_PUB.disable_debug;
1120: END IF;
1121:
1122:
1123:

Line 1168: l_debug VARCHAR2(1) :=ahl_debug_pub.is_log_enabled;

1164: l_loop_index NUMBER := 0;
1165: l_mr_present CHAR(1) := 'N';
1166: l_start_mr_rel_id NUMBER;
1167: l_skip_mr_rel_id NUMBER;
1168: l_debug VARCHAR2(1) :=ahl_debug_pub.is_log_enabled;
1169: l_mr_rel_count NUMBER := 0;
1170: l_max_sequence NUMBER := 0;
1171: l_skip_sequence NUMBER := 0;
1172: l_debug_prefix VARCHAR2(70) := 'AHL_MR_LOOP_CHAIN_RELNS_PVT.get_valid_loop_chain_relns';

Line 1176: AHL_DEBUG_PUB.enable_debug;

1172: l_debug_prefix VARCHAR2(70) := 'AHL_MR_LOOP_CHAIN_RELNS_PVT.get_valid_loop_chain_relns';
1173: BEGIN
1174:
1175: IF l_debug = 'Y' THEN
1176: AHL_DEBUG_PUB.enable_debug;
1177: AHL_DEBUG_PUB.debug('Begin private API: AHL_MR_LOOP_CHAIN_RELNS_PVT.get_valid_loop_chain_relns');
1178: END IF;
1179:
1180: FOR l_loop_chain_rec IN get_loop_chain_relns(p_mr_header_id, p_effective_from, p_effective_to, p_rel_code)

Line 1177: AHL_DEBUG_PUB.debug('Begin private API: AHL_MR_LOOP_CHAIN_RELNS_PVT.get_valid_loop_chain_relns');

1173: BEGIN
1174:
1175: IF l_debug = 'Y' THEN
1176: AHL_DEBUG_PUB.enable_debug;
1177: AHL_DEBUG_PUB.debug('Begin private API: AHL_MR_LOOP_CHAIN_RELNS_PVT.get_valid_loop_chain_relns');
1178: END IF;
1179:
1180: FOR l_loop_chain_rec IN get_loop_chain_relns(p_mr_header_id, p_effective_from, p_effective_to, p_rel_code)
1181: LOOP

Line 1241: ahl_debug_pub.enable_debug;

1237: x_start_mr_relns.DELETE;
1238: END IF;
1239:
1240: IF l_debug = 'Y' THEN
1241: ahl_debug_pub.enable_debug;
1242: ahl_debug_pub.debug('End private API: AHL_MR_LOOP_CHAIN_RELNS_PVT.get_valid_loop_chain_relns');
1243: END IF;
1244:
1245: EXCEPTION

Line 1242: ahl_debug_pub.debug('End private API: AHL_MR_LOOP_CHAIN_RELNS_PVT.get_valid_loop_chain_relns');

1238: END IF;
1239:
1240: IF l_debug = 'Y' THEN
1241: ahl_debug_pub.enable_debug;
1242: ahl_debug_pub.debug('End private API: AHL_MR_LOOP_CHAIN_RELNS_PVT.get_valid_loop_chain_relns');
1243: END IF;
1244:
1245: EXCEPTION
1246: WHEN OTHERS THEN

Line 1251: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data, 'ERROR IN PRIVATE:' );

1247: x_return_status := FND_API.G_RET_STS_ERROR;
1248: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE, p_count => x_msg_count, p_data => x_msg_data);
1249:
1250: IF l_debug = 'Y' THEN
1251: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data, 'ERROR IN PRIVATE:' );
1252: AHL_DEBUG_PUB.DEBUG('AHL_MR_LOOP_CHAIN_RELNS_PVT.VIEW_MR_LOOP_CHAIN', l_debug_prefix);
1253: AHL_DEBUG_PUB.disable_debug;
1254: END IF;
1255:

Line 1252: AHL_DEBUG_PUB.DEBUG('AHL_MR_LOOP_CHAIN_RELNS_PVT.VIEW_MR_LOOP_CHAIN', l_debug_prefix);

1248: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE, p_count => x_msg_count, p_data => x_msg_data);
1249:
1250: IF l_debug = 'Y' THEN
1251: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data, 'ERROR IN PRIVATE:' );
1252: AHL_DEBUG_PUB.DEBUG('AHL_MR_LOOP_CHAIN_RELNS_PVT.VIEW_MR_LOOP_CHAIN', l_debug_prefix);
1253: AHL_DEBUG_PUB.disable_debug;
1254: END IF;
1255:
1256: END get_valid_loop_chain_relns;

Line 1253: AHL_DEBUG_PUB.disable_debug;

1249:
1250: IF l_debug = 'Y' THEN
1251: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data, 'ERROR IN PRIVATE:' );
1252: AHL_DEBUG_PUB.DEBUG('AHL_MR_LOOP_CHAIN_RELNS_PVT.VIEW_MR_LOOP_CHAIN', l_debug_prefix);
1253: AHL_DEBUG_PUB.disable_debug;
1254: END IF;
1255:
1256: END get_valid_loop_chain_relns;
1257: