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_MR_LOOP_CHAIN_RELNS_PVT

Line 1: PACKAGE BODY AHL_MR_LOOP_CHAIN_RELNS_PVT AS

1: PACKAGE BODY AHL_MR_LOOP_CHAIN_RELNS_PVT AS
2: /* $Header: AHLVLCRB.pls 120.0.12020000.2 2012/12/10 13:43:11 shnatu noship $ */
3: G_PKG_NAME VARCHAR2(30) := 'AHL_MR_LOOP_CHAIN_RELNS_PVT';
4:
5: /* local procedures declaration

Line 3: G_PKG_NAME VARCHAR2(30) := 'AHL_MR_LOOP_CHAIN_RELNS_PVT';

1: PACKAGE BODY AHL_MR_LOOP_CHAIN_RELNS_PVT AS
2: /* $Header: AHLVLCRB.pls 120.0.12020000.2 2012/12/10 13:43:11 shnatu noship $ */
3: G_PKG_NAME VARCHAR2(30) := 'AHL_MR_LOOP_CHAIN_RELNS_PVT';
4:
5: /* local procedures declaration
6: */
7: PROCEDURE GET_MR_LOOP_CHAIN_DTLS

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 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 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 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 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 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 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 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 700: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'AHL_MR_LOOP_CHAIN_RELNS_PVT',

696: WHEN OTHERS THEN
697: ROLLBACK TO GET_CM_AFFECTED_ITEMS_PVT;
698: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
699: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
700: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'AHL_MR_LOOP_CHAIN_RELNS_PVT',
701: p_procedure_name => 'GET_CM_AFFECTED_ITEMS',
702: p_error_text => SUBSTRB(SQLERRM,1,240));
703: END IF;
704: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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 770: l_debug_prefix VARCHAR2(50) := 'AHL_MR_LOOP_CHAIN_RELNS_PVT.GET_MR_LOOP_CHAIN_DTLS';

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';
771: l_start_mr_reln_id NUMBER;
772: l_max_seq NUMBER;
773:
774: BEGIN

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 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 958: l_debug_prefix VARCHAR2(50) := 'AHL_MR_LOOP_CHAIN_RELNS_PVT.VIEW_MR_LOOP_CHAIN';

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;
960:
961: BEGIN
962: IF l_debug = 'Y' THEN

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 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 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 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 1108: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'AHL_MR_LOOP_CHAIN_RELNS_PVT',

1104:
1105: WHEN OTHERS THEN
1106: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1107: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1108: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'AHL_MR_LOOP_CHAIN_RELNS_PVT',
1109: p_procedure_name => 'VIEW_MR_LOOP_CHAIN',
1110: p_error_text => SUBSTRB(SQLERRM,1,240));
1111: END IF;
1112: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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 1172: l_debug_prefix VARCHAR2(70) := 'AHL_MR_LOOP_CHAIN_RELNS_PVT.get_valid_loop_chain_relns';

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';
1173: BEGIN
1174:
1175: IF l_debug = 'Y' THEN
1176: AHL_DEBUG_PUB.enable_debug;

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 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 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 1380: END AHL_MR_LOOP_CHAIN_RELNS_PVT;

1376: RETURN l_result ;
1377:
1378: END IS_MR_IN_CHAIN;
1379:
1380: END AHL_MR_LOOP_CHAIN_RELNS_PVT;