DBA Data[Home] [Help]

APPS.AHL_FMP_MR_APPROVAL_PVT dependencies on FND_API

Line 45: l_return_status := fnd_api.g_ret_sts_success;

41: AHL_DEBUG_PUB.debug( 'Start Set Actvity Details');
42: END IF;
43:
44: fnd_msg_pub.initialize;
45: l_return_status := fnd_api.g_ret_sts_success;
46:
47: l_object_id := wf_engine.getitemattrnumber(
48: itemtype => itemtype
49: ,itemkey => itemkey

Line 212: IF l_return_status = fnd_api.g_ret_sts_success THEN

208: IF G_DEBUG='Y' THEN
209: AHL_DEBUG_PUB.debug('Get approval details-->'||l_APPROVAL_RULE_ID);
210: END IF;
211:
212: IF l_return_status = fnd_api.g_ret_sts_success THEN
213:
214: wf_engine.setitemattrnumber(
215: itemtype => itemtype,
216: itemkey => itemkey,

Line 235: RAISE fnd_api.G_EXC_ERROR;

231: RETURN;
232:
233: ELSE
234:
235: RAISE fnd_api.G_EXC_ERROR;
236:
237: END IF;
238: END IF;
239:

Line 263: WHEN fnd_api.G_EXC_ERROR THEN

259: AHL_DEBUG_PUB.disable_debug;
260: END IF;
261:
262: EXCEPTION
263: WHEN fnd_api.G_EXC_ERROR THEN
264:
265: FND_MSG_PUB.Count_And_Get (
266: p_encoded => FND_API.G_FALSE,
267: p_count => l_msg_count,

Line 266: p_encoded => FND_API.G_FALSE,

262: EXCEPTION
263: WHEN fnd_api.G_EXC_ERROR THEN
264:
265: FND_MSG_PUB.Count_And_Get (
266: p_encoded => FND_API.G_FALSE,
267: p_count => l_msg_count,
268: p_data => l_msg_data
269: );
270: ahl_generic_aprv_pvt.Handle_Error

Line 408: WHEN FND_API.G_EXC_ERROR THEN

404: END IF;
405: RETURN;
406:
407: EXCEPTION
408: WHEN FND_API.G_EXC_ERROR THEN
409: FND_MSG_PUB.Count_And_Get (
410: p_encoded => FND_API.G_FALSE,
411: p_count => l_msg_count,
412: p_data => l_msg_data

Line 410: p_encoded => FND_API.G_FALSE,

406:
407: EXCEPTION
408: WHEN FND_API.G_EXC_ERROR THEN
409: FND_MSG_PUB.Count_And_Get (
410: p_encoded => FND_API.G_FALSE,
411: p_count => l_msg_count,
412: p_data => l_msg_data
413: );
414: ahl_generic_aprv_pvt.Handle_Error

Line 530: WHEN FND_API.G_EXC_ERROR THEN

526:
527: RETURN;
528:
529: EXCEPTION
530: WHEN FND_API.G_EXC_ERROR THEN
531: FND_MSG_PUB.Count_And_Get (
532: p_encoded => FND_API.G_FALSE,
533: p_count => l_msg_count,
534: p_data => l_msg_data

Line 532: p_encoded => FND_API.G_FALSE,

528:
529: EXCEPTION
530: WHEN FND_API.G_EXC_ERROR THEN
531: FND_MSG_PUB.Count_And_Get (
532: p_encoded => FND_API.G_FALSE,
533: p_count => l_msg_count,
534: p_data => l_msg_data
535: );
536: ahl_generic_aprv_pvt.Handle_Error

Line 655: WHEN FND_API.G_EXC_ERROR THEN

651:
652: RETURN;
653:
654: EXCEPTION
655: WHEN FND_API.G_EXC_ERROR THEN
656: FND_MSG_PUB.Count_And_Get (
657: p_encoded => FND_API.G_FALSE,
658: p_count => l_msg_count,
659: p_data => l_msg_data

Line 657: p_encoded => FND_API.G_FALSE,

653:
654: EXCEPTION
655: WHEN FND_API.G_EXC_ERROR THEN
656: FND_MSG_PUB.Count_And_Get (
657: p_encoded => FND_API.G_FALSE,
658: p_count => l_msg_count,
659: p_data => l_msg_data
660: );
661: ahl_generic_aprv_pvt.Handle_Error

Line 777: WHEN FND_API.G_EXC_ERROR THEN

773: END IF;
774: RETURN;
775:
776: EXCEPTION
777: WHEN FND_API.G_EXC_ERROR THEN
778: FND_MSG_PUB.Count_And_Get (
779: p_encoded => FND_API.G_FALSE,
780: p_count => l_msg_count,
781: p_data => l_msg_data

Line 779: p_encoded => FND_API.G_FALSE,

775:
776: EXCEPTION
777: WHEN FND_API.G_EXC_ERROR THEN
778: FND_MSG_PUB.Count_And_Get (
779: p_encoded => FND_API.G_FALSE,
780: p_count => l_msg_count,
781: p_data => l_msg_data
782: );
783: ahl_generic_aprv_pvt.Handle_Error

Line 904: WHEN FND_API.G_EXC_ERROR THEN

900: AHL_DEBUG_PUB.disable_debug;
901: END IF;
902: RETURN;
903: EXCEPTION
904: WHEN FND_API.G_EXC_ERROR THEN
905: FND_MSG_PUB.Count_And_Get (
906: p_encoded => FND_API.G_FALSE,
907: p_count => l_msg_count,
908: p_data => l_msg_data

Line 906: p_encoded => FND_API.G_FALSE,

902: RETURN;
903: EXCEPTION
904: WHEN FND_API.G_EXC_ERROR THEN
905: FND_MSG_PUB.Count_And_Get (
906: p_encoded => FND_API.G_FALSE,
907: p_count => l_msg_count,
908: p_data => l_msg_data
909: );
910: ahl_generic_aprv_pvt.Handle_Error

Line 1026: WHEN FND_API.G_EXC_ERROR THEN

1022:
1023: RETURN;
1024:
1025: EXCEPTION
1026: WHEN FND_API.G_EXC_ERROR THEN
1027: FND_MSG_PUB.Count_And_Get (
1028: p_encoded => FND_API.G_FALSE,
1029: p_count => l_msg_count,
1030: p_data => l_msg_data

Line 1028: p_encoded => FND_API.G_FALSE,

1024:
1025: EXCEPTION
1026: WHEN FND_API.G_EXC_ERROR THEN
1027: FND_MSG_PUB.Count_And_Get (
1028: p_encoded => FND_API.G_FALSE,
1029: p_count => l_msg_count,
1030: p_data => l_msg_data
1031: );
1032: ahl_generic_aprv_pvt.Handle_Error

Line 1147: WHEN FND_API.G_EXC_ERROR THEN

1143:
1144: RETURN;
1145:
1146: EXCEPTION
1147: WHEN FND_API.G_EXC_ERROR THEN
1148: FND_MSG_PUB.Count_And_Get (
1149: p_encoded => FND_API.G_FALSE,
1150: p_count => l_msg_count,
1151: p_data => l_msg_data

Line 1149: p_encoded => FND_API.G_FALSE,

1145:
1146: EXCEPTION
1147: WHEN FND_API.G_EXC_ERROR THEN
1148: FND_MSG_PUB.Count_And_Get (
1149: p_encoded => FND_API.G_FALSE,
1150: p_count => l_msg_count,
1151: p_data => l_msg_data
1152: );
1153: ahl_generic_aprv_pvt.Handle_Error

Line 1197: l_commit VARCHAR2(1):=FND_API.G_TRUE;

1193: l_msg_data VARCHAR2(4000);
1194: -- Variables for executing Complete_mr_Revision
1195: l_api_name CONSTANT VARCHAR2(30) := 'Update_Status';
1196: l_subject VARCHAR2(500);
1197: l_commit VARCHAR2(1):=FND_API.G_TRUE;
1198: l_mr_header_id number:=0;
1199: l_api_version NUMBER:=1.0;
1200: l_init_msg_list VARCHAR2(1):= FND_API.G_TRUE;
1201: l_validate_only VARCHAR2(1):= FND_API.G_TRUE;

Line 1200: l_init_msg_list VARCHAR2(1):= FND_API.G_TRUE;

1196: l_subject VARCHAR2(500);
1197: l_commit VARCHAR2(1):=FND_API.G_TRUE;
1198: l_mr_header_id number:=0;
1199: l_api_version NUMBER:=1.0;
1200: l_init_msg_list VARCHAR2(1):= FND_API.G_TRUE;
1201: l_validate_only VARCHAR2(1):= FND_API.G_TRUE;
1202: l_validation_level NUMBER:= FND_API.G_VALID_LEVEL_FULL;
1203: l_module_type VARCHAR2(1);
1204: x_return_status VARCHAR2(1);

Line 1201: l_validate_only VARCHAR2(1):= FND_API.G_TRUE;

1197: l_commit VARCHAR2(1):=FND_API.G_TRUE;
1198: l_mr_header_id number:=0;
1199: l_api_version NUMBER:=1.0;
1200: l_init_msg_list VARCHAR2(1):= FND_API.G_TRUE;
1201: l_validate_only VARCHAR2(1):= FND_API.G_TRUE;
1202: l_validation_level NUMBER:= FND_API.G_VALID_LEVEL_FULL;
1203: l_module_type VARCHAR2(1);
1204: x_return_status VARCHAR2(1);
1205: l_return_status VARCHAR2(1);

Line 1202: l_validation_level NUMBER:= FND_API.G_VALID_LEVEL_FULL;

1198: l_mr_header_id number:=0;
1199: l_api_version NUMBER:=1.0;
1200: l_init_msg_list VARCHAR2(1):= FND_API.G_TRUE;
1201: l_validate_only VARCHAR2(1):= FND_API.G_TRUE;
1202: l_validation_level NUMBER:= FND_API.G_VALID_LEVEL_FULL;
1203: l_module_type VARCHAR2(1);
1204: x_return_status VARCHAR2(1);
1205: l_return_status VARCHAR2(1);
1206: x_msg_count NUMBER;

Line 1209: l_default VARCHAR2(1):= FND_API.G_FALSE;

1205: l_return_status VARCHAR2(1);
1206: x_msg_count NUMBER;
1207: x_msg_data VARCHAR2(2000);
1208: l_mr_header_rec ahl_FMP_mr_header_pvt.mr_header_Rec;
1209: l_default VARCHAR2(1):= FND_API.G_FALSE;
1210:
1211: BEGIN
1212: IF G_DEBUG='Y' THEN
1213: AHL_DEBUG_PUB.enable_debug;

Line 1259: p_commit =>FND_API.G_FALSE,

1255: AHL_FMP_MR_REVISION_PVT.COMPLETE_MR_REVISION
1256: (
1257: p_api_version =>l_api_version,
1258: p_init_msg_list =>l_init_msg_list,
1259: p_commit =>FND_API.G_FALSE,
1260: p_validation_level =>l_validation_level ,
1261: p_default =>l_default ,
1262: p_module_type =>'null',
1263: x_return_status =>l_return_status,

Line 1304: WHEN fnd_api.g_exc_error THEN

1300: END IF;
1301:
1302:
1303: EXCEPTION
1304: WHEN fnd_api.g_exc_error THEN
1305: IF G_DEBUG='Y' THEN
1306: AHL_DEBUG_PUB.debug( ' Error in workflow:'||sqlerrm||'Update_status');
1307: END IF;
1308:

Line 1310: p_encoded => FND_API.G_FALSE,

1306: AHL_DEBUG_PUB.debug( ' Error in workflow:'||sqlerrm||'Update_status');
1307: END IF;
1308:
1309: FND_MSG_PUB.Count_And_Get (
1310: p_encoded => FND_API.G_FALSE,
1311: p_count => l_msg_count,
1312: p_data => l_msg_data
1313: );
1314: ahl_generic_aprv_pvt.Handle_Error

Line 1415: l_return_status := FND_API.G_RET_STS_ERROR;

1411: then
1412: FND_MESSAGE.Set_Name('AHL','AHL_APRV_OBJ_CHANGED');
1413: FND_MSG_PUB.Add;
1414:
1415: l_return_status := FND_API.G_RET_STS_ERROR;
1416: return;
1417:
1418: end if;
1419: IF G_DEBUG='Y' THEN

Line 1445: WHEN fnd_api.g_exc_error THEN

1441: END IF;
1442:
1443:
1444: EXCEPTION
1445: WHEN fnd_api.g_exc_error THEN
1446: FND_MSG_PUB.Count_And_Get (
1447: p_encoded => FND_API.G_FALSE,
1448: p_count => l_msg_count,
1449: p_data => l_msg_data

Line 1447: p_encoded => FND_API.G_FALSE,

1443:
1444: EXCEPTION
1445: WHEN fnd_api.g_exc_error THEN
1446: FND_MSG_PUB.Count_And_Get (
1447: p_encoded => FND_API.G_FALSE,
1448: p_count => l_msg_count,
1449: p_data => l_msg_data
1450: );
1451: ahl_generic_aprv_pvt.Handle_Error