DBA Data[Home] [Help]

APPS.AHL_PRD_BLK_PARTS_CHANGE_PVT dependencies on FND_API

Line 69: -- Always call this method with p_commit value : FND_API.G_FALSE

65: -- Procedure name : Get_Bulk_Part_Chg_Details
66: -- Type : Public
67: -- Function : This procedure will update the temparory table to show data in hGrid.
68: -- Since this table is global temporary with ON COMMIT DELETE ROWS,
69: -- Always call this method with p_commit value : FND_API.G_FALSE
70: -- Pre-reqs :
71: -- Parameters :
72: --
73: -- Get_Bulk_Part_Chg_Details Parameters

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

78:
79: PROCEDURE Get_Bulk_Part_Chg_Details
80: (
81: p_api_version IN NUMBER := 1.0,
82: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
83: p_commit IN VARCHAR2 := FND_API.G_FALSE,
84: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
85: p_default IN VARCHAR2 := FND_API.G_FALSE,
86: p_module_type IN VARCHAR2 := NULL,

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

79: PROCEDURE Get_Bulk_Part_Chg_Details
80: (
81: p_api_version IN NUMBER := 1.0,
82: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
83: p_commit IN VARCHAR2 := FND_API.G_FALSE,
84: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
85: p_default IN VARCHAR2 := FND_API.G_FALSE,
86: p_module_type IN VARCHAR2 := NULL,
87: p_workorder_id IN NUMBER,

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

80: (
81: p_api_version IN NUMBER := 1.0,
82: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
83: p_commit IN VARCHAR2 := FND_API.G_FALSE,
84: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
85: p_default IN VARCHAR2 := FND_API.G_FALSE,
86: p_module_type IN VARCHAR2 := NULL,
87: p_workorder_id IN NUMBER,
88: p_bulk_process_flag IN VARCHAR2,

Line 85: p_default IN VARCHAR2 := FND_API.G_FALSE,

81: p_api_version IN NUMBER := 1.0,
82: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
83: p_commit IN VARCHAR2 := FND_API.G_FALSE,
84: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
85: p_default IN VARCHAR2 := FND_API.G_FALSE,
86: p_module_type IN VARCHAR2 := NULL,
87: p_workorder_id IN NUMBER,
88: p_bulk_process_flag IN VARCHAR2,
89: x_uc_details_tbl OUT NOCOPY uc_details_hgrid_tbl_type,

Line 115: x_return_status := FND_API.G_RET_STS_SUCCESS;

111: l_count NUMBER;
112:
113: BEGIN
114: --Initialize API return status to success
115: x_return_status := FND_API.G_RET_STS_SUCCESS;
116:
117: --Standard call to check for call compatibility.
118: IF NOT FND_API.compatible_api_call(
119: l_api_version,

Line 118: IF NOT FND_API.compatible_api_call(

114: --Initialize API return status to success
115: x_return_status := FND_API.G_RET_STS_SUCCESS;
116:
117: --Standard call to check for call compatibility.
118: IF NOT FND_API.compatible_api_call(
119: l_api_version,
120: p_api_version,
121: l_api_name,
122: G_PKG_NAME)

Line 124: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

120: p_api_version,
121: l_api_name,
122: G_PKG_NAME)
123: THEN
124: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
125: END IF;
126:
127: --Initialize message list if p_init_msg_list is set to TRUE.
128: IF FND_API.to_boolean( p_init_msg_list ) THEN

Line 128: IF FND_API.to_boolean( p_init_msg_list ) THEN

124: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
125: END IF;
126:
127: --Initialize message list if p_init_msg_list is set to TRUE.
128: IF FND_API.to_boolean( p_init_msg_list ) THEN
129: FND_MSG_PUB.initialize;
130: END IF;
131:
132: -- Get unit header id for the given work order (derived using Visit followed by Task instance if required)

Line 348: IF(p_commit = FND_API.G_TRUE) THEN

344: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_full_name,
345: 'Records in Table are ' || l_count);
346: END IF;
347:
348: IF(p_commit = FND_API.G_TRUE) THEN
349: COMMIT WORK;
350: END IF;
351:
352: -- Get all the error messages from the previous steps (if any) and raise the appropriate Exception

Line 355: RAISE FND_API.G_EXC_ERROR;

351:
352: -- Get all the error messages from the previous steps (if any) and raise the appropriate Exception
353: x_msg_count := FND_MSG_PUB.count_msg;
354: IF x_msg_count > 0 THEN
355: RAISE FND_API.G_EXC_ERROR;
356: END IF;
357:
358: -- Count and Get messages (optional)
359: FND_MSG_PUB.count_and_get(

Line 360: p_encoded => FND_API.G_FALSE,

356: END IF;
357:
358: -- Count and Get messages (optional)
359: FND_MSG_PUB.count_and_get(
360: p_encoded => FND_API.G_FALSE,
361: p_count => x_msg_count,
362: p_data => x_msg_data);
363:
364: EXCEPTION

Line 365: WHEN FND_API.G_EXC_ERROR THEN

361: p_count => x_msg_count,
362: p_data => x_msg_data);
363:
364: EXCEPTION
365: WHEN FND_API.G_EXC_ERROR THEN
366: x_return_status := FND_API.G_RET_STS_ERROR ;
367: FND_MSG_PUB.count_and_get(
368: p_encoded => FND_API.G_FALSE,
369: p_count => x_msg_count,

Line 366: x_return_status := FND_API.G_RET_STS_ERROR ;

362: p_data => x_msg_data);
363:
364: EXCEPTION
365: WHEN FND_API.G_EXC_ERROR THEN
366: x_return_status := FND_API.G_RET_STS_ERROR ;
367: FND_MSG_PUB.count_and_get(
368: p_encoded => FND_API.G_FALSE,
369: p_count => x_msg_count,
370: p_data => x_msg_data);

Line 368: p_encoded => FND_API.G_FALSE,

364: EXCEPTION
365: WHEN FND_API.G_EXC_ERROR THEN
366: x_return_status := FND_API.G_RET_STS_ERROR ;
367: FND_MSG_PUB.count_and_get(
368: p_encoded => FND_API.G_FALSE,
369: p_count => x_msg_count,
370: p_data => x_msg_data);
371:
372: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 372: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

368: p_encoded => FND_API.G_FALSE,
369: p_count => x_msg_count,
370: p_data => x_msg_data);
371:
372: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
373: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
374: FND_MSG_PUB.count_and_get(
375: p_encoded => FND_API.G_FALSE,
376: p_count => x_msg_count,

Line 373: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

369: p_count => x_msg_count,
370: p_data => x_msg_data);
371:
372: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
373: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
374: FND_MSG_PUB.count_and_get(
375: p_encoded => FND_API.G_FALSE,
376: p_count => x_msg_count,
377: p_data => x_msg_data);

Line 375: p_encoded => FND_API.G_FALSE,

371:
372: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
373: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
374: FND_MSG_PUB.count_and_get(
375: p_encoded => FND_API.G_FALSE,
376: p_count => x_msg_count,
377: p_data => x_msg_data);
378:
379: WHEN OTHERS THEN

Line 380: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

376: p_count => x_msg_count,
377: p_data => x_msg_data);
378:
379: WHEN OTHERS THEN
380: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
381: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
382: THEN
383: FND_MSG_PUB.add_exc_msg(
384: p_pkg_name => G_PKG_NAME,

Line 389: p_encoded => FND_API.G_FALSE,

385: p_procedure_name => l_api_name,
386: p_error_text => SUBSTRB(SQLERRM,1,240));
387: END IF;
388: FND_MSG_PUB.count_and_get(
389: p_encoded => FND_API.G_FALSE,
390: p_count => x_msg_count,
391: p_data => x_msg_data);
392: END Get_Bulk_Part_Chg_Details;
393: ------------------------------------------------------------------------------------

Line 728: p_init_msg_list => FND_API.G_TRUE,

724: END IF;
725:
726: AHL_UC_TREE_PVT.get_whole_uc_tree(
727: p_api_version => 1.0,
728: p_init_msg_list => FND_API.G_TRUE,
729: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
730: x_return_status => l_return_status,
731: x_msg_count => l_msg_count,
732: x_msg_data => l_msg_data,

Line 729: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

725:
726: AHL_UC_TREE_PVT.get_whole_uc_tree(
727: p_api_version => 1.0,
728: p_init_msg_list => FND_API.G_TRUE,
729: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
730: x_return_status => l_return_status,
731: x_msg_count => l_msg_count,
732: x_msg_data => l_msg_data,
733: p_uc_header_id => p_unit_header_id,

Line 735: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS)THEN

731: x_msg_count => l_msg_count,
732: x_msg_data => l_msg_data,
733: p_uc_header_id => p_unit_header_id,
734: x_uc_descendant_tbl => l_uc_descendant_tbl);
735: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
736: RAISE FND_API.G_EXC_ERROR;
737: END IF;
738:
739: OPEN get_max_pk_count;

Line 736: RAISE FND_API.G_EXC_ERROR;

732: x_msg_data => l_msg_data,
733: p_uc_header_id => p_unit_header_id,
734: x_uc_descendant_tbl => l_uc_descendant_tbl);
735: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
736: RAISE FND_API.G_EXC_ERROR;
737: END IF;
738:
739: OPEN get_max_pk_count;
740: FETCH get_max_pk_count INTO l_curr_pk;

Line 925: p_init_msg_list => FND_API.G_FALSE,

921: IF(l_uc_details_tbl(l_curr_row).is_position_srl_controlled = 'Y') THEN
922: --Populate Disposition Details
923: AHL_PRD_DISP_UTIL_PVT.Get_Part_Change_Disposition (
924: p_api_version => 1.0,
925: p_init_msg_list => FND_API.G_FALSE,
926: p_commit => FND_API.G_FALSE,
927: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
928: x_return_status => l_return_status,
929: x_msg_count => l_msg_count,

Line 926: p_commit => FND_API.G_FALSE,

922: --Populate Disposition Details
923: AHL_PRD_DISP_UTIL_PVT.Get_Part_Change_Disposition (
924: p_api_version => 1.0,
925: p_init_msg_list => FND_API.G_FALSE,
926: p_commit => FND_API.G_FALSE,
927: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
928: x_return_status => l_return_status,
929: x_msg_count => l_msg_count,
930: x_msg_data => l_msg_data,

Line 927: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

923: AHL_PRD_DISP_UTIL_PVT.Get_Part_Change_Disposition (
924: p_api_version => 1.0,
925: p_init_msg_list => FND_API.G_FALSE,
926: p_commit => FND_API.G_FALSE,
927: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
928: x_return_status => l_return_status,
929: x_msg_count => l_msg_count,
930: x_msg_data => l_msg_data,
931: p_workorder_id => p_workorder_id,

Line 946: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

942: l_full_name,
943: 'Returned from call to AHL_PRD_DISP_UTIL_PVT.Get_Part_Change_Disposition: l_return_status ' || l_return_status);
944: END IF;
945:
946: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
947: RAISE FND_API.G_EXC_ERROR;
948: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
949: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
950: END IF;

Line 947: RAISE FND_API.G_EXC_ERROR;

943: 'Returned from call to AHL_PRD_DISP_UTIL_PVT.Get_Part_Change_Disposition: l_return_status ' || l_return_status);
944: END IF;
945:
946: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
947: RAISE FND_API.G_EXC_ERROR;
948: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
949: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
950: END IF;
951:

Line 948: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

944: END IF;
945:
946: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
947: RAISE FND_API.G_EXC_ERROR;
948: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
949: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
950: END IF;
951:
952: l_uc_details_tbl(l_curr_row).disposition_id := l_disposition_rec.disposition_id;

Line 949: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

945:
946: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
947: RAISE FND_API.G_EXC_ERROR;
948: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
949: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
950: END IF;
951:
952: l_uc_details_tbl(l_curr_row).disposition_id := l_disposition_rec.disposition_id;
953: l_uc_details_tbl(l_curr_row).disposition_obj_ver_num := l_disposition_rec.object_version_number;

Line 1197: p_init_msg_list => FND_API.G_FALSE,

1193:
1194: AHL_UC_INSTANCE_PVT.Get_Available_Instances
1195: (
1196: p_api_version => 1.0,
1197: p_init_msg_list => FND_API.G_FALSE,
1198: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1199: x_return_status => l_return_status,
1200: x_msg_count => l_msg_count,
1201: x_msg_data => l_msg_data,

Line 1198: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1194: AHL_UC_INSTANCE_PVT.Get_Available_Instances
1195: (
1196: p_api_version => 1.0,
1197: p_init_msg_list => FND_API.G_FALSE,
1198: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1199: x_return_status => l_return_status,
1200: x_msg_count => l_msg_count,
1201: x_msg_data => l_msg_data,
1202: p_parent_instance_id => l_uc_details_tbl(l_curr_row).parent_instance_id,

Line 1217: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

1213: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_full_name, 'After call to API AHL_UC_INSTANCE_PVT.Get_Available_Instances. Return Status=' || l_return_status
1214: || ' Total Available Instances=' || l_total_available_instances);
1215: END IF;
1216:
1217: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1218: RAISE FND_API.G_EXC_ERROR;
1219: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1220: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1221: END IF;

Line 1218: RAISE FND_API.G_EXC_ERROR;

1214: || ' Total Available Instances=' || l_total_available_instances);
1215: END IF;
1216:
1217: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1218: RAISE FND_API.G_EXC_ERROR;
1219: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1220: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1221: END IF;
1222:

Line 1219: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1215: END IF;
1216:
1217: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1218: RAISE FND_API.G_EXC_ERROR;
1219: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1220: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1221: END IF;
1222:
1223: -- If there is only 1 available instance for the current position, then default it.

Line 1220: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1216:
1217: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1218: RAISE FND_API.G_EXC_ERROR;
1219: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1220: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1221: END IF;
1222:
1223: -- If there is only 1 available instance for the current position, then default it.
1224: -- Otherwise, no defaulting is required.

Line 1922: -- Always call this method with p_commit value : FND_API.G_FALSE

1918: -- Procedure name : Filter_records_uc_details
1919: -- Type : Public
1920: -- Function : This procedure will update the temparory table to filter data details in hGrid.
1921: -- Since this table is global temporary with ON COMMIT DELETE ROWS,
1922: -- Always call this method with p_commit value : FND_API.G_FALSE
1923: -- It returns the hGrid_node path of the only node, null otherwise.
1924: -- Currently it filters positions based on following search params
1925: -- UnitHeaderId : Always required
1926: -- Position

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

1937:
1938: PROCEDURE Filter_records_uc_details
1939: (
1940: p_api_version IN NUMBER := 1.0,
1941: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1942: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1943: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1944: p_default IN VARCHAR2 := FND_API.G_FALSE,
1945: p_module_type IN VARCHAR2 := NULL,

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

1938: PROCEDURE Filter_records_uc_details
1939: (
1940: p_api_version IN NUMBER := 1.0,
1941: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1942: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1943: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1944: p_default IN VARCHAR2 := FND_API.G_FALSE,
1945: p_module_type IN VARCHAR2 := NULL,
1946: p_filter_records_tbl IN filter_records_tbl_type,

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

1939: (
1940: p_api_version IN NUMBER := 1.0,
1941: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1942: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1943: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1944: p_default IN VARCHAR2 := FND_API.G_FALSE,
1945: p_module_type IN VARCHAR2 := NULL,
1946: p_filter_records_tbl IN filter_records_tbl_type,
1947: x_hGrid_node_path OUT NOCOPY VARCHAR2,

Line 1944: p_default IN VARCHAR2 := FND_API.G_FALSE,

1940: p_api_version IN NUMBER := 1.0,
1941: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1942: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1943: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1944: p_default IN VARCHAR2 := FND_API.G_FALSE,
1945: p_module_type IN VARCHAR2 := NULL,
1946: p_filter_records_tbl IN filter_records_tbl_type,
1947: x_hGrid_node_path OUT NOCOPY VARCHAR2,
1948: x_return_status OUT NOCOPY VARCHAR2,

Line 2096: WHEN FND_API.G_EXC_ERROR THEN

2092: x_hGrid_node_path := l_hGrid_node_path;
2093: END IF;
2094:
2095: EXCEPTION
2096: WHEN FND_API.G_EXC_ERROR THEN
2097: x_return_status := FND_API.G_RET_STS_ERROR ;
2098: FND_MSG_PUB.count_and_get(
2099: p_encoded => FND_API.G_FALSE,
2100: p_count => x_msg_count,

Line 2097: x_return_status := FND_API.G_RET_STS_ERROR ;

2093: END IF;
2094:
2095: EXCEPTION
2096: WHEN FND_API.G_EXC_ERROR THEN
2097: x_return_status := FND_API.G_RET_STS_ERROR ;
2098: FND_MSG_PUB.count_and_get(
2099: p_encoded => FND_API.G_FALSE,
2100: p_count => x_msg_count,
2101: p_data => x_msg_data);

Line 2099: p_encoded => FND_API.G_FALSE,

2095: EXCEPTION
2096: WHEN FND_API.G_EXC_ERROR THEN
2097: x_return_status := FND_API.G_RET_STS_ERROR ;
2098: FND_MSG_PUB.count_and_get(
2099: p_encoded => FND_API.G_FALSE,
2100: p_count => x_msg_count,
2101: p_data => x_msg_data);
2102:
2103: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2103: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2099: p_encoded => FND_API.G_FALSE,
2100: p_count => x_msg_count,
2101: p_data => x_msg_data);
2102:
2103: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2104: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2105: FND_MSG_PUB.count_and_get(
2106: p_encoded => FND_API.G_FALSE,
2107: p_count => x_msg_count,

Line 2104: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2100: p_count => x_msg_count,
2101: p_data => x_msg_data);
2102:
2103: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2104: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2105: FND_MSG_PUB.count_and_get(
2106: p_encoded => FND_API.G_FALSE,
2107: p_count => x_msg_count,
2108: p_data => x_msg_data);

Line 2106: p_encoded => FND_API.G_FALSE,

2102:
2103: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2104: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2105: FND_MSG_PUB.count_and_get(
2106: p_encoded => FND_API.G_FALSE,
2107: p_count => x_msg_count,
2108: p_data => x_msg_data);
2109:
2110: WHEN OTHERS THEN

Line 2111: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2107: p_count => x_msg_count,
2108: p_data => x_msg_data);
2109:
2110: WHEN OTHERS THEN
2111: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2112: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2113: THEN
2114: FND_MSG_PUB.add_exc_msg(
2115: p_pkg_name => G_PKG_NAME,

Line 2120: p_encoded => FND_API.G_FALSE,

2116: p_procedure_name => l_api_name,
2117: p_error_text => SUBSTRB(SQLERRM,1,240));
2118: END IF;
2119: FND_MSG_PUB.count_and_get(
2120: p_encoded => FND_API.G_FALSE,
2121: p_count => x_msg_count,
2122: p_data => x_msg_data);
2123: END Filter_records_uc_details;
2124: ------------------------------------------------------------------------------------

Line 2129: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,

2125:
2126: ------------------------------------------------------------------------------------
2127: PROCEDURE PROCESS_PART_CHANGES(
2128: P_API_VERSION IN NUMBER DEFAULT 1.0,
2129: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2130: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2131: P_VALIDATION_LEVEL IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
2132: P_MODULE_TYPE IN VARCHAR2 DEFAULT NULL,
2133: P_DEFAULT IN VARCHAR2 DEFAULT FND_API.G_TRUE,

Line 2130: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,

2126: ------------------------------------------------------------------------------------
2127: PROCEDURE PROCESS_PART_CHANGES(
2128: P_API_VERSION IN NUMBER DEFAULT 1.0,
2129: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2130: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2131: P_VALIDATION_LEVEL IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
2132: P_MODULE_TYPE IN VARCHAR2 DEFAULT NULL,
2133: P_DEFAULT IN VARCHAR2 DEFAULT FND_API.G_TRUE,
2134: P_X_PARTS_REC_TBL IN OUT NOCOPY PART_CHANGE_TBL_TYPE,

Line 2131: P_VALIDATION_LEVEL IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

2127: PROCEDURE PROCESS_PART_CHANGES(
2128: P_API_VERSION IN NUMBER DEFAULT 1.0,
2129: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2130: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2131: P_VALIDATION_LEVEL IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
2132: P_MODULE_TYPE IN VARCHAR2 DEFAULT NULL,
2133: P_DEFAULT IN VARCHAR2 DEFAULT FND_API.G_TRUE,
2134: P_X_PARTS_REC_TBL IN OUT NOCOPY PART_CHANGE_TBL_TYPE,
2135: P_MR_ASSO_TBL IN AHL_PRD_NONROUTINE_PVT.MR_ASSOCIATION_TBL_TYPE,

Line 2133: P_DEFAULT IN VARCHAR2 DEFAULT FND_API.G_TRUE,

2129: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2130: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2131: P_VALIDATION_LEVEL IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
2132: P_MODULE_TYPE IN VARCHAR2 DEFAULT NULL,
2133: P_DEFAULT IN VARCHAR2 DEFAULT FND_API.G_TRUE,
2134: P_X_PARTS_REC_TBL IN OUT NOCOPY PART_CHANGE_TBL_TYPE,
2135: P_MR_ASSO_TBL IN AHL_PRD_NONROUTINE_PVT.MR_ASSOCIATION_TBL_TYPE,
2136: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
2137: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 2173: IF NOT FND_API.COMPATIBLE_API_CALL(L_API_VERSION,

2169: ' Entering procedure');
2170: END IF;
2171:
2172: -- Standard call to check for call compatibility
2173: IF NOT FND_API.COMPATIBLE_API_CALL(L_API_VERSION,
2174: P_API_VERSION,
2175: L_API_NAME,
2176: G_PKG_NAME) THEN
2177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2173: IF NOT FND_API.COMPATIBLE_API_CALL(L_API_VERSION,
2174: P_API_VERSION,
2175: L_API_NAME,
2176: G_PKG_NAME) THEN
2177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2178: END IF;
2179:
2180: -- Initialize message list if p_init_msg_list is set to TRUE
2181: IF FND_API.TO_BOOLEAN(P_INIT_MSG_LIST) THEN

Line 2181: IF FND_API.TO_BOOLEAN(P_INIT_MSG_LIST) THEN

2177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2178: END IF;
2179:
2180: -- Initialize message list if p_init_msg_list is set to TRUE
2181: IF FND_API.TO_BOOLEAN(P_INIT_MSG_LIST) THEN
2182: FND_MSG_PUB.INITIALIZE;
2183: END IF;
2184:
2185: -- Initialize API return status to success

Line 2186: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

2182: FND_MSG_PUB.INITIALIZE;
2183: END IF;
2184:
2185: -- Initialize API return status to success
2186: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2187: l_error_msg_index := 0;
2188: IF(P_X_PARTS_REC_TBL IS NULL OR P_X_PARTS_REC_TBL.COUNT < 1)THEN
2189: RETURN;
2190: End if;

Line 2326: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

2322: FND_MESSAGE.SET_TOKEN('PARENT_INSTALLED_SERIAL',l_serial,false);
2323: X_ERROR_MSG_TBL(l_error_msg_index).MESSAGE_LEVEL := 'E' ;
2324: X_ERROR_MSG_TBL(l_error_msg_index).MESSAGE := FND_MESSAGE.get;
2325: l_error_msg_index := l_error_msg_index + 1;
2326: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2327: ELSIF(P_X_PARTS_REC_TBL(j).OPERATION_TYPE = 'D' AND
2328: (P_X_PARTS_REC_TBL(j).REMOVED_INSTANCE_NUM IS NULL OR P_X_PARTS_REC_TBL(j).PARENT_INSTALLED_INSTANCE_NUM IS NULL))THEN
2329: FND_MESSAGE.SET_NAME('AHL', 'AHL_PRD_BLK_PC_REM_ERR_INPUT');
2330: FND_MESSAGE.SET_TOKEN('OPERATION_SEQUENCE_NUM',P_X_PARTS_REC_TBL(j).OPERATION_SEQUENCE_NUM,false);

Line 2354: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

2350: FND_MESSAGE.SET_TOKEN('PARENT_INSTALLED_SERIAL',l_serial,false);
2351: X_ERROR_MSG_TBL(l_error_msg_index).MESSAGE_LEVEL := 'E' ;
2352: X_ERROR_MSG_TBL(l_error_msg_index).MESSAGE := FND_MESSAGE.get;
2353: l_error_msg_index := l_error_msg_index + 1;
2354: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2355: END IF;
2356: END LOOP;
2357:
2358: IF ( X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS) THEN

Line 2358: IF ( X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS) THEN

2354: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2355: END IF;
2356: END LOOP;
2357:
2358: IF ( X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS) THEN
2359: -- Initialize message list if p_init_msg_list is set to TRUE
2360: IF FND_API.TO_BOOLEAN(P_INIT_MSG_LIST) THEN
2361: FND_MSG_PUB.INITIALIZE;
2362: END IF;

Line 2360: IF FND_API.TO_BOOLEAN(P_INIT_MSG_LIST) THEN

2356: END LOOP;
2357:
2358: IF ( X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS) THEN
2359: -- Initialize message list if p_init_msg_list is set to TRUE
2360: IF FND_API.TO_BOOLEAN(P_INIT_MSG_LIST) THEN
2361: FND_MSG_PUB.INITIALIZE;
2362: END IF;
2363: FND_MESSAGE.Set_Name('AHL', 'AHL_PRD_BLK_PC_ERRORS');
2364: FND_MSG_PUB.ADD;

Line 2365: RAISE FND_API.G_EXC_ERROR;

2361: FND_MSG_PUB.INITIALIZE;
2362: END IF;
2363: FND_MESSAGE.Set_Name('AHL', 'AHL_PRD_BLK_PC_ERRORS');
2364: FND_MSG_PUB.ADD;
2365: RAISE FND_API.G_EXC_ERROR;
2366: END IF;
2367:
2368: GET_ORDERED_PCRECS(
2369: P_PARTS_REC_TBL => P_X_PARTS_REC_TBL,

Line 2420: IF ( l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS) THEN

2416: fnd_log.string(l_log_statement, l_debug_key,
2417: ' parts change API Return status:' || l_RETURN_STATUS ||
2418: ': l_MSG_COUNT:' || l_MSG_COUNT || ': l_MSG_DATA:' || l_MSG_DATA);
2419: END IF;
2420: IF ( l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS) THEN
2421: IF (l_log_error >= l_log_current_level) THEN
2422: fnd_log.string(l_log_error, l_debug_key,
2423: ' parts change API Return returned error status');
2424: END IF;

Line 2473: p_encoded => FND_API.G_FALSE,

2469: ELSE
2470: FOR i IN 1..l_MSG_COUNT LOOP
2471: FND_MSG_PUB.get (
2472: p_msg_index => i,
2473: p_encoded => FND_API.G_FALSE,
2474: p_data => l_MSG_DATA,
2475: p_msg_index_out => l_msg_index_out );
2476: X_ERROR_MSG_TBL(l_error_msg_index).MESSAGE := X_ERROR_MSG_TBL(l_error_msg_index).MESSAGE || l_MSG_DATA ;
2477: END LOOP;

Line 2491: IF ( X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS) THEN

2487: END LOOP;
2488: END LOOP;
2489: END IF;
2490:
2491: IF ( X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS) THEN
2492: IF(X_ERROR_MSG_TBL IS NOT NULL AND X_ERROR_MSG_TBL.COUNT>0) THEN
2493: FOR i IN X_ERROR_MSG_TBL.FIRST..X_ERROR_MSG_TBL.LAST LOOP
2494: IF (l_log_error >= l_log_current_level) THEN
2495: fnd_log.string(l_log_error, l_debug_key,

Line 2501: IF FND_API.TO_BOOLEAN(P_INIT_MSG_LIST) THEN

2497: END IF;
2498: END LOOP;
2499: END IF;
2500: -- Initialize message list if p_init_msg_list is set to TRUE
2501: IF FND_API.TO_BOOLEAN(P_INIT_MSG_LIST) THEN
2502: FND_MSG_PUB.INITIALIZE;
2503: END IF;
2504: FND_MESSAGE.Set_Name('AHL', 'AHL_PRD_BLK_PC_ERRORS');
2505: FND_MSG_PUB.ADD;

Line 2506: RAISE FND_API.G_EXC_ERROR;

2502: FND_MSG_PUB.INITIALIZE;
2503: END IF;
2504: FND_MESSAGE.Set_Name('AHL', 'AHL_PRD_BLK_PC_ERRORS');
2505: FND_MSG_PUB.ADD;
2506: RAISE FND_API.G_EXC_ERROR;
2507: END IF;
2508: -- Standard check of p_commit
2509: IF FND_API.TO_BOOLEAN(P_COMMIT) THEN
2510: COMMIT WORK;

Line 2509: IF FND_API.TO_BOOLEAN(P_COMMIT) THEN

2505: FND_MSG_PUB.ADD;
2506: RAISE FND_API.G_EXC_ERROR;
2507: END IF;
2508: -- Standard check of p_commit
2509: IF FND_API.TO_BOOLEAN(P_COMMIT) THEN
2510: COMMIT WORK;
2511: END IF;
2512: -- Standard call to get message count and if count is 1, get message
2513: FND_MSG_PUB.COUNT_AND_GET

Line 2516: P_ENCODED => FND_API.G_FALSE);

2512: -- Standard call to get message count and if count is 1, get message
2513: FND_MSG_PUB.COUNT_AND_GET
2514: ( P_COUNT => X_MSG_COUNT,
2515: P_DATA => X_MSG_DATA,
2516: P_ENCODED => FND_API.G_FALSE);
2517:
2518: IF (l_log_procedure >= l_log_current_level) THEN
2519: fnd_log.string(l_log_procedure, l_debug_key,
2520: ' Exiting procedure');

Line 2523: WHEN FND_API.G_EXC_ERROR THEN

2519: fnd_log.string(l_log_procedure, l_debug_key,
2520: ' Exiting procedure');
2521: END IF;
2522: EXCEPTION
2523: WHEN FND_API.G_EXC_ERROR THEN
2524: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2525: ROLLBACK TO PRD_BLK_PARTS_CHNG_PVT;
2526: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT,
2527: P_DATA => X_MSG_DATA,

Line 2524: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

2520: ' Exiting procedure');
2521: END IF;
2522: EXCEPTION
2523: WHEN FND_API.G_EXC_ERROR THEN
2524: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2525: ROLLBACK TO PRD_BLK_PARTS_CHNG_PVT;
2526: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT,
2527: P_DATA => X_MSG_DATA,
2528: P_ENCODED => FND_API.G_FALSE);

Line 2528: P_ENCODED => FND_API.G_FALSE);

2524: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2525: ROLLBACK TO PRD_BLK_PARTS_CHNG_PVT;
2526: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT,
2527: P_DATA => X_MSG_DATA,
2528: P_ENCODED => FND_API.G_FALSE);
2529:
2530: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2531: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
2532: ROLLBACK TO PRD_BLK_PARTS_CHNG_PVT;

Line 2530: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2526: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT,
2527: P_DATA => X_MSG_DATA,
2528: P_ENCODED => FND_API.G_FALSE);
2529:
2530: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2531: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
2532: ROLLBACK TO PRD_BLK_PARTS_CHNG_PVT;
2533: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT,
2534: P_DATA => X_MSG_DATA,

Line 2531: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

2527: P_DATA => X_MSG_DATA,
2528: P_ENCODED => FND_API.G_FALSE);
2529:
2530: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2531: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
2532: ROLLBACK TO PRD_BLK_PARTS_CHNG_PVT;
2533: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT,
2534: P_DATA => X_MSG_DATA,
2535: P_ENCODED => FND_API.G_FALSE);

Line 2535: P_ENCODED => FND_API.G_FALSE);

2531: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
2532: ROLLBACK TO PRD_BLK_PARTS_CHNG_PVT;
2533: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT,
2534: P_DATA => X_MSG_DATA,
2535: P_ENCODED => FND_API.G_FALSE);
2536:
2537: WHEN OTHERS THEN
2538: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
2539: ROLLBACK TO PRD_BLK_PARTS_CHNG_PVT;

Line 2538: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

2534: P_DATA => X_MSG_DATA,
2535: P_ENCODED => FND_API.G_FALSE);
2536:
2537: WHEN OTHERS THEN
2538: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
2539: ROLLBACK TO PRD_BLK_PARTS_CHNG_PVT;
2540:
2541: FND_MSG_PUB.ADD_EXC_MSG(P_PKG_NAME => 'AHL_PRD_BLK_PARTS_CHANGE_PVT',
2542: P_PROCEDURE_NAME => 'PROCESS_PART_CHANGES',

Line 2547: P_ENCODED => FND_API.G_FALSE);

2543: P_ERROR_TEXT => SQLERRM);
2544: --END IF;
2545: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT,
2546: P_DATA => X_MSG_DATA,
2547: P_ENCODED => FND_API.G_FALSE);
2548:
2549:
2550: END PROCESS_PART_CHANGES;
2551: ------------------------------------------------------------------------------------

Line 2673: P_INIT_MSG_LIST => FND_API.G_TRUE,

2669: ' invoking AHL_PRD_PARTS_CHANGE_PVT.PROCESS_PART ');
2670: END IF;
2671: AHL_PRD_PARTS_CHANGE_PVT.PROCESS_PART (
2672: P_API_VERSION => 1.0,
2673: P_INIT_MSG_LIST => FND_API.G_TRUE,
2674: P_COMMIT => FND_API.G_FALSE,
2675: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
2676: P_MODULE_TYPE => 'OAF',
2677: P_DEFAULT => FND_API.G_TRUE,

Line 2674: P_COMMIT => FND_API.G_FALSE,

2670: END IF;
2671: AHL_PRD_PARTS_CHANGE_PVT.PROCESS_PART (
2672: P_API_VERSION => 1.0,
2673: P_INIT_MSG_LIST => FND_API.G_TRUE,
2674: P_COMMIT => FND_API.G_FALSE,
2675: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
2676: P_MODULE_TYPE => 'OAF',
2677: P_DEFAULT => FND_API.G_TRUE,
2678: P_X_PARTS_REC_TBL => L_PARTS_REC_TBL,

Line 2675: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,

2671: AHL_PRD_PARTS_CHANGE_PVT.PROCESS_PART (
2672: P_API_VERSION => 1.0,
2673: P_INIT_MSG_LIST => FND_API.G_TRUE,
2674: P_COMMIT => FND_API.G_FALSE,
2675: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
2676: P_MODULE_TYPE => 'OAF',
2677: P_DEFAULT => FND_API.G_TRUE,
2678: P_X_PARTS_REC_TBL => L_PARTS_REC_TBL,
2679: X_ERROR_CODE => L_ERROR_CODE,

Line 2677: P_DEFAULT => FND_API.G_TRUE,

2673: P_INIT_MSG_LIST => FND_API.G_TRUE,
2674: P_COMMIT => FND_API.G_FALSE,
2675: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
2676: P_MODULE_TYPE => 'OAF',
2677: P_DEFAULT => FND_API.G_TRUE,
2678: P_X_PARTS_REC_TBL => L_PARTS_REC_TBL,
2679: X_ERROR_CODE => L_ERROR_CODE,
2680: X_RETURN_STATUS => X_RETURN_STATUS,
2681: X_MSG_COUNT => X_MSG_COUNT,

Line 2690: IF ( X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS) THEN

2686: fnd_log.string(l_log_statement, l_debug_key,
2687: ' AHL_PRD_PARTS_CHANGE_PVT.PROCESS_PART return status : ' || X_RETURN_STATUS);
2688: END IF;
2689:
2690: IF ( X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS) THEN
2691: RETURN;
2692: ELSE
2693: IF (l_log_statement >= l_log_current_level) THEN
2694: fnd_log.string(l_log_statement, l_debug_key,

Line 2775: P_INIT_MSG_LIST => FND_API.G_TRUE,

2771: ' invoking AHL_PRD_DISPOSITION_PVT.PROCESS_DISPOSITION ');
2772: END IF;
2773: AHL_PRD_DISPOSITION_PVT.PROCESS_DISPOSITION(
2774: P_API_VERSION => 1.0,
2775: P_INIT_MSG_LIST => FND_API.G_TRUE,
2776: P_COMMIT => FND_API.G_FALSE,
2777: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
2778: P_MODULE_TYPE => 'JSP',
2779: P_X_DISPOSITION_REC => L_DISPOSITION_REC,

Line 2776: P_COMMIT => FND_API.G_FALSE,

2772: END IF;
2773: AHL_PRD_DISPOSITION_PVT.PROCESS_DISPOSITION(
2774: P_API_VERSION => 1.0,
2775: P_INIT_MSG_LIST => FND_API.G_TRUE,
2776: P_COMMIT => FND_API.G_FALSE,
2777: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
2778: P_MODULE_TYPE => 'JSP',
2779: P_X_DISPOSITION_REC => L_DISPOSITION_REC,
2780: P_MR_ASSO_TBL => L_MR_ASSO_TBL,

Line 2777: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,

2773: AHL_PRD_DISPOSITION_PVT.PROCESS_DISPOSITION(
2774: P_API_VERSION => 1.0,
2775: P_INIT_MSG_LIST => FND_API.G_TRUE,
2776: P_COMMIT => FND_API.G_FALSE,
2777: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
2778: P_MODULE_TYPE => 'JSP',
2779: P_X_DISPOSITION_REC => L_DISPOSITION_REC,
2780: P_MR_ASSO_TBL => L_MR_ASSO_TBL,
2781: X_RETURN_STATUS => X_RETURN_STATUS,