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 FND_API

Line 25: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

21: **/
22: PROCEDURE VALIDATE_LOOP_CHAIN
23: (
24: p_api_version IN NUMBER,
25: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
26: p_commit IN VARCHAR2 := FND_API.G_FALSE,
27: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
28: p_page_mode IN VARCHAR2 := 'CREATE',
29: x_return_status OUT NOCOPY VARCHAR2,

Line 26: p_commit IN VARCHAR2 := FND_API.G_FALSE,

22: PROCEDURE VALIDATE_LOOP_CHAIN
23: (
24: p_api_version IN NUMBER,
25: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
26: p_commit IN VARCHAR2 := FND_API.G_FALSE,
27: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
28: p_page_mode IN VARCHAR2 := 'CREATE',
29: x_return_status OUT NOCOPY VARCHAR2,
30: x_msg_count OUT NOCOPY NUMBER,

Line 27: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

23: (
24: p_api_version IN NUMBER,
25: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
26: p_commit IN VARCHAR2 := FND_API.G_FALSE,
27: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
28: p_page_mode IN VARCHAR2 := 'CREATE',
29: x_return_status OUT NOCOPY VARCHAR2,
30: x_msg_count OUT NOCOPY NUMBER,
31: x_msg_data OUT NOCOPY ERR_MSG_DATA,

Line 92: IF FND_API.to_boolean(p_init_msg_list) 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;
94: END IF;
95:
96: FOR l_mr_index IN p_mr_relns.FIRST..p_mr_relns.LAST

Line 116: x_return_status := FND_API.G_RET_STS_ERROR;

112:
113: --sukhwsin::Complex Assembly Maintenance Changes - starts
114: --Raise error if MR is having implementation status as soft limit because soft limit MR cannot be a part of any relationship.
115: IF (l_mr_header_rec.implement_status_code = 'SOFT_LIMIT') THEN
116: x_return_status := FND_API.G_RET_STS_ERROR;
117: x_mr_header_id(l_mr_index) := p_mr_relns(l_mr_index).mr_header_id;
118: x_msg_data(l_mr_index) := 'AHL_CAM_MR_IMP_STS_ERR';
119: END IF;
120: --sukhwsin::Complex Assembly Maintenance Changes - ends

Line 127: x_return_status := FND_API.G_RET_STS_ERROR;

123: IF l_mr_header_rec.implement_status_code = 'OPTIONAL_DO_NOT_IMPLEMENT' THEN
124: -- Unplanned MRs cannot be 1) part of a Loop, 2) Cannot be other than starting
125: -- MR in a chain
126: IF p_mr_relns(l_mr_index).RELATIONSHIP_CODE = 'CHAIN' AND p_mr_relns(l_mr_index).MR_SEQUENCE <> 1 THEN
127: x_return_status := FND_API.G_RET_STS_ERROR;
128: x_mr_header_id(l_mr_index) := p_mr_relns(l_mr_index).mr_header_id;
129: x_msg_data(l_mr_index) := 'AHL_FMP_CHAIN_UNPLANNED_MR';
130: -- Loop: all MRs should be planned.
131: ELSIF p_mr_relns(l_mr_index).RELATIONSHIP_CODE = 'LOOP' THEN

Line 132: x_return_status := FND_API.G_RET_STS_ERROR;

128: x_mr_header_id(l_mr_index) := p_mr_relns(l_mr_index).mr_header_id;
129: x_msg_data(l_mr_index) := 'AHL_FMP_CHAIN_UNPLANNED_MR';
130: -- Loop: all MRs should be planned.
131: ELSIF p_mr_relns(l_mr_index).RELATIONSHIP_CODE = 'LOOP' THEN
132: x_return_status := FND_API.G_RET_STS_ERROR;
133: x_mr_header_id(l_mr_index) := p_mr_relns(l_mr_index).mr_header_id;
134: x_msg_data(l_mr_index) := 'AHL_FMP_LOOP_UNPLANNED_MR';
135: END IF;
136:

Line 144: x_return_status := FND_API.G_RET_STS_ERROR;

140: FOR l_mr_relns_rec IN mr_relns_csr(p_mr_relns(l_mr_index).mr_header_id, NVL(l_mr_header_rec.effective_to, SYSDATE))
141: LOOP
142:
143: IF l_mr_relns_rec.relationship_code <> 'INITIATES' OR l_mr_relns_rec.mr_header_id = p_mr_relns(l_mr_index).mr_header_id OR p_mr_relns(l_mr_index).MR_SEQUENCE <> 1 THEN
144: x_return_status := FND_API.G_RET_STS_ERROR;
145: x_mr_header_id(l_mr_index) := p_mr_relns(l_mr_index).mr_header_id;
146: IF l_mr_relns_rec.relationship_code = 'INITIATES'
147: THEN
148: x_msg_data(l_mr_index) := 'AHL_FMP_MR_INIT_REL_EXIST';

Line 227: x_return_status := FND_API.G_RET_STS_ERROR;

223:
224: -- If there exist another Valid relationship, fetch the relationship type and
225: -- display the error message
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:

Line 249: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

245: END IF;
246:
247: END LOOP;
248:
249: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
250: RAISE FND_API.G_EXC_ERROR;
251:
252: ELSE
253: -- Check if there exist a common item for all MRs in the relationship,

Line 250: RAISE FND_API.G_EXC_ERROR;

246:
247: END LOOP;
248:
249: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
250: RAISE FND_API.G_EXC_ERROR;
251:
252: ELSE
253: -- Check if there exist a common item for all MRs in the relationship,
254: -- if not raise a warning

Line 255: GET_CM_AFFECTED_ITEMS(1.0,FND_API.G_TRUE,FND_API.G_TRUE,NULL, l_return_status, l_msg_count, l_msg_data, l_cm_instances, l_mr_loop_chain);

251:
252: ELSE
253: -- Check if there exist a common item for all MRs in the relationship,
254: -- if not raise a warning
255: GET_CM_AFFECTED_ITEMS(1.0,FND_API.G_TRUE,FND_API.G_TRUE,NULL, l_return_status, l_msg_count, l_msg_data, l_cm_instances, l_mr_loop_chain);
256:
257: IF l_cm_instances IS NULL OR l_cm_instances.count = 0 THEN
258: x_msg_data(0) := 'AHL_FMP_CM_AFF_ITEMS';
259: x_return_status := FND_API.G_RET_STS_ERROR;

Line 259: x_return_status := FND_API.G_RET_STS_ERROR;

255: GET_CM_AFFECTED_ITEMS(1.0,FND_API.G_TRUE,FND_API.G_TRUE,NULL, l_return_status, l_msg_count, l_msg_data, l_cm_instances, l_mr_loop_chain);
256:
257: IF l_cm_instances IS NULL OR l_cm_instances.count = 0 THEN
258: x_msg_data(0) := 'AHL_FMP_CM_AFF_ITEMS';
259: x_return_status := FND_API.G_RET_STS_ERROR;
260: RAISE FND_API.G_EXC_ERROR;
261: END IF;
262: END IF;
263:

Line 260: RAISE FND_API.G_EXC_ERROR;

256:
257: IF l_cm_instances IS NULL OR l_cm_instances.count = 0 THEN
258: x_msg_data(0) := 'AHL_FMP_CM_AFF_ITEMS';
259: x_return_status := FND_API.G_RET_STS_ERROR;
260: RAISE FND_API.G_EXC_ERROR;
261: END IF;
262: END IF;
263:
264: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 264: x_return_status := FND_API.G_RET_STS_SUCCESS;

260: RAISE FND_API.G_EXC_ERROR;
261: END IF;
262: END IF;
263:
264: x_return_status := FND_API.G_RET_STS_SUCCESS;
265:
266: IF mr_dtls_csr%ISOPEN THEN
267: CLOSE mr_dtls_csr;
268: END IF;

Line 276: WHEN FND_API.G_EXC_ERROR THEN

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
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;

Line 285: p_encoded => fnd_api.g_false);

281:
282: WHEN OTHERS THEN
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;

Line 595: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

591: */
592: PROCEDURE GET_CM_AFFECTED_ITEMS
593: (
594: p_api_version IN NUMBER,
595: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
596: p_commit IN VARCHAR2 := FND_API.G_FALSE,
597: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
598: x_return_status OUT NOCOPY VARCHAR2,
599: x_msg_count OUT NOCOPY NUMBER,

Line 596: p_commit IN VARCHAR2 := FND_API.G_FALSE,

592: PROCEDURE GET_CM_AFFECTED_ITEMS
593: (
594: p_api_version IN NUMBER,
595: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
596: p_commit IN VARCHAR2 := FND_API.G_FALSE,
597: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
598: x_return_status OUT NOCOPY VARCHAR2,
599: x_msg_count OUT NOCOPY NUMBER,
600: x_msg_data OUT NOCOPY VARCHAR2,

Line 597: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

593: (
594: p_api_version IN NUMBER,
595: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
596: p_commit IN VARCHAR2 := FND_API.G_FALSE,
597: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
598: x_return_status OUT NOCOPY VARCHAR2,
599: x_msg_count OUT NOCOPY NUMBER,
600: x_msg_data OUT NOCOPY VARCHAR2,
601: x_mr_item_instances OUT NOCOPY MR_ITEM_INSTANCE_TBL_TYPE,

Line 698: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

694: END IF;
695: EXCEPTION
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));

Line 704: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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,
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,

Line 888: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

884: */
885: PROCEDURE VIEW_MR_LOOP_CHAIN
886: (
887: p_api_version IN NUMBER,
888: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
889: p_commit IN VARCHAR2 := FND_API.G_FALSE,
890: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
891: x_return_status OUT NOCOPY VARCHAR2,
892: x_msg_count OUT NOCOPY NUMBER,

Line 889: p_commit IN VARCHAR2 := FND_API.G_FALSE,

885: PROCEDURE VIEW_MR_LOOP_CHAIN
886: (
887: p_api_version IN NUMBER,
888: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
889: p_commit IN VARCHAR2 := FND_API.G_FALSE,
890: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
891: x_return_status OUT NOCOPY VARCHAR2,
892: x_msg_count OUT NOCOPY NUMBER,
893: x_msg_data OUT NOCOPY VARCHAR2,

Line 890: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

886: (
887: p_api_version IN NUMBER,
888: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
889: p_commit IN VARCHAR2 := FND_API.G_FALSE,
890: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
891: x_return_status OUT NOCOPY VARCHAR2,
892: x_msg_count OUT NOCOPY NUMBER,
893: x_msg_data OUT NOCOPY VARCHAR2,
894: p_start_mr_reln_id IN NUMBER,

Line 966: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version,

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
969: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
970: END IF;

Line 969: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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
969: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
970: END IF;
971:
972: IF FND_API.to_boolean(p_init_msg_list) THEN
973: FND_MSG_PUB.initialize;

Line 972: IF FND_API.to_boolean(p_init_msg_list) THEN

968: THEN
969: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
970: END IF;
971:
972: IF FND_API.to_boolean(p_init_msg_list) THEN
973: FND_MSG_PUB.initialize;
974: END IF;
975:
976: --Loop through ahl_mr_relationships to find the relationship

Line 1012: GET_CM_AFFECTED_ITEMS(1.0,FND_API.G_TRUE,FND_API.G_TRUE,NULL, x_return_status, x_msg_count, x_msg_data, x_mr_item_instances, x_cm_mr_chain_loop);

1008:
1009: IF p_calling_module = 'FMP'
1010: THEN
1011:
1012: GET_CM_AFFECTED_ITEMS(1.0,FND_API.G_TRUE,FND_API.G_TRUE,NULL, x_return_status, x_msg_count, x_msg_data, x_mr_item_instances, x_cm_mr_chain_loop);
1013:
1014: ELSIF p_calling_module = 'UMP'
1015: THEN
1016:

Line 1081: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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
1082: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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);

Line 1082: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1078: END IF;
1079:
1080: EXCEPTION
1081: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1082: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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

Line 1083: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

1079:
1080: EXCEPTION
1081: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1082: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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,

Line 1093: WHEN FND_API.G_EXC_ERROR THEN

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;
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);

Line 1094: x_return_status := FND_API.G_RET_STS_ERROR;

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;
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

Line 1095: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

1091: END IF;
1092:
1093: WHEN FND_API.G_EXC_ERROR THEN
1094: x_return_status := FND_API.G_RET_STS_ERROR;
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,

Line 1106: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
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));

Line 1112: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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,
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,

Line 1247: x_return_status := FND_API.G_RET_STS_ERROR;

1243: END IF;
1244:
1245: EXCEPTION
1246: WHEN OTHERS THEN
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:' );

Line 1248: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE, p_count => x_msg_count, p_data => x_msg_data);

1244:
1245: EXCEPTION
1246: WHEN OTHERS THEN
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);