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

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 230: SELECT relationship_code INTO l_mr_loop_chain_rel_cd FROM ahl_mr_loop_chain_relns WHERE mr_relationship_id = l_other_valid_start_mr;

226: IF l_other_valid_start_mr IS NOT NULL THEN
227: x_return_status := FND_API.G_RET_STS_ERROR;
228: x_mr_header_id(l_mr_index) := p_mr_relns(l_mr_index).mr_header_id;
229:
230: SELECT relationship_code INTO l_mr_loop_chain_rel_cd FROM ahl_mr_loop_chain_relns WHERE mr_relationship_id = l_other_valid_start_mr;
231:
232: IF l_mr_loop_chain_rel_cd IS NOT NULL AND l_mr_loop_chain_rel_cd = 'LOOP'
233: THEN
234: x_msg_data(l_mr_index) := 'AHL_FMP_MR_LOOP_REL_EXIST';

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 318: FROM ahl_mr_loop_chain_relns rel,

314: rel.relationship_code,
315: mr.mr_status_code,
316: mr.effective_from,
317: mr.effective_to
318: FROM ahl_mr_loop_chain_relns rel,
319: ahl_mr_headers_b mr
320: WHERE mr.mr_header_id = rel.mr_header_id
321: AND rel.start_mr_relationship_id IN
322: (SELECT start_mr_relationship_id

Line 323: FROM ahl_mr_loop_chain_relns A

319: ahl_mr_headers_b mr
320: WHERE mr.mr_header_id = rel.mr_header_id
321: AND rel.start_mr_relationship_id IN
322: (SELECT start_mr_relationship_id
323: FROM ahl_mr_loop_chain_relns A
324: WHERE mr_header_id = c_mr_header_id
325: AND ((c_rel_code IS NULL)
326: OR (relationship_code = c_rel_code))
327: AND ( c_start_mr_rel_id IS NULL

Line 331: ahl_mr_loop_chain_relns b

327: AND ( c_start_mr_rel_id IS NULL
328: OR (start_mr_relationship_id NOT IN
329: (SELECT b.start_mr_relationship_id
330: FROM ahl_mr_headers_b a,
331: ahl_mr_loop_chain_relns b
332: WHERE a.mr_header_id = b.mr_header_id
333: AND b.start_mr_relationship_id = c_start_mr_rel_id))
334: )
335: )

Line 340: (SELECT start_mr_relationship_id FROM ahl_mr_loop_chain_relns

336: AND ((c_effective_from IS NULL)
337: OR (TRUNC(c_effective_from) >= TRUNC(MR.effective_from)))
338: AND ((c_start_mr_header_id IS NULL)
339: OR (rel.start_mr_relationship_id NOT IN
340: (SELECT start_mr_relationship_id FROM ahl_mr_loop_chain_relns
341: WHERE mr_header_id IN (SELECT mr_header_id FROM
342: ahl_mr_headers_b WHERE title = c_start_mr_title
343: AND mr_header_id <> c_start_mr_header_id)
344: )))

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 394: SELECT MAX(sequence_number) INTO l_mr_rel_count FROM ahl_mr_loop_chain_relns WHERE start_mr_relationship_id = l_start_mr_rel_id;

390: -- identify the max sequence number of this relationship
391: IF l_loop_chain_rec.sequence_number = 1 THEN
392: l_sequence := 1;
393: l_start_mr_rel_id := l_loop_chain_rec.start_mr_relationship_id;
394: SELECT MAX(sequence_number) INTO l_mr_rel_count FROM ahl_mr_loop_chain_relns WHERE start_mr_relationship_id = l_start_mr_rel_id;
395: ELSE
396: -- If not starting MR and the sequence number is out of synch then set the l_valid
397: -- indicator to 0, which means that its not a valid relationship.(one or more MRs
398: -- not active)

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 454: FROM ahl_mr_loop_chain_relns rel,

450: rel.relationship_code,
451: mr.mr_status_code,
452: mr.effective_from,
453: mr.effective_to
454: FROM ahl_mr_loop_chain_relns rel,
455: ahl_mr_headers_b mr
456: WHERE mr.mr_header_id = rel.mr_header_id
457: and rel.start_mr_relationship_id in
458: (select reln.start_mr_relationship_id

Line 459: from ahl_mr_loop_chain_relns reln

455: ahl_mr_headers_b mr
456: WHERE mr.mr_header_id = rel.mr_header_id
457: and rel.start_mr_relationship_id in
458: (select reln.start_mr_relationship_id
459: from ahl_mr_loop_chain_relns reln
460: WHERE reln.mr_header_id = c_mr_header_id
461: and ((c_rel_code is null)
462: OR (reln.relationship_code = c_rel_code))
463: )

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 532: SELECT MAX(sequence_number) INTO l_max_rel_seq FROM ahl_mr_loop_chain_relns WHERE

528: IF l_loop_chain_rec.sequence_number = 1 THEN
529: l_sequence := 1;
530: l_start_mr_header_id := l_loop_chain_rec.mr_header_id;
531: l_mr_rel_id := l_loop_chain_rec.start_mr_relationship_id;
532: SELECT MAX(sequence_number) INTO l_max_rel_seq FROM ahl_mr_loop_chain_relns WHERE
533: start_mr_relationship_id = l_mr_rel_id;
534: l_current_max_seq := 1;
535: ELSE
536: IF l_loop_chain_rec.sequence_number > l_sequence THEN

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 752: AHL_MR_LOOP_CHAIN_RELNS rel

748: FROM FND_LOOKUP_VALUES
749: WHERE LOOKUP_TYPE = 'AHL_FMP_REVISION_STATUS'
750: AND LANGUAGE = USERENV('LANG')
751: ) STATUS,
752: AHL_MR_LOOP_CHAIN_RELNS rel
753: WHERE MR_TL.LANGUAGE = USERENV('LANG')
754: AND rel.start_mr_relationship_id = c_start_mr_reln_id
755: AND STATUS.LOOKUP_CODE = MR.mr_status_code
756: AND rel.mr_header_id = MR.mr_header_id

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 786: SELECT MAX(sequence_number) INTO l_max_seq FROM ahl_mr_loop_chain_relns WHERE start_mr_relationship_id = l_start_mr_reln_id;

782: IF l_start_mr_reln_id IS NULL THEN
783: l_start_mr_reln_id := get_valid_start_mr_rel(p_mr_header_id, NULL, NULL, NULL, NULL, SYSDATE, p_relationship);
784: END IF;
785:
786: SELECT MAX(sequence_number) INTO l_max_seq FROM ahl_mr_loop_chain_relns WHERE start_mr_relationship_id = l_start_mr_reln_id;
787:
788: FOR mr_loop_chain_rec IN mr_loop_chain_csr(l_start_mr_reln_id)
789: LOOP
790: IF((l_chainindex + 1) = mr_loop_chain_rec.sequence_no) THEN

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 1145: FROM ahl_mr_loop_chain_relns rel,

1141: rel.relationship_code,
1142: mr.mr_status_code,
1143: mr.effective_from,
1144: mr.effective_to
1145: FROM ahl_mr_loop_chain_relns rel,
1146: ahl_mr_headers_b mr
1147: WHERE mr.mr_header_id = rel.mr_header_id
1148: AND rel.start_mr_relationship_id IN
1149: (SELECT reln.start_mr_relationship_id

Line 1150: FROM ahl_mr_loop_chain_relns reln

1146: ahl_mr_headers_b mr
1147: WHERE mr.mr_header_id = rel.mr_header_id
1148: AND rel.start_mr_relationship_id IN
1149: (SELECT reln.start_mr_relationship_id
1150: FROM ahl_mr_loop_chain_relns reln
1151: WHERE reln.mr_header_id = c_mr_header_id
1152: AND (c_rel_code IS NULL
1153: OR reln.relationship_code = c_rel_code)
1154: )

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 1197: FROM ahl_mr_loop_chain_relns

1193: l_skip_sequence := 0;
1194:
1195: SELECT MAX(sequence_number)
1196: INTO l_mr_rel_count
1197: FROM ahl_mr_loop_chain_relns
1198: WHERE start_mr_relationship_id = l_start_mr_rel_id;
1199:
1200: ELSE
1201: IF l_loop_chain_rec.sequence_number > l_sequence THEN

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;