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 409: WHEN FND_API.G_EXC_ERROR THEN

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

Line 411: p_encoded => FND_API.G_FALSE,

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

Line 531: WHEN FND_API.G_EXC_ERROR THEN

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

Line 533: p_encoded => FND_API.G_FALSE,

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

Line 656: WHEN FND_API.G_EXC_ERROR THEN

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

Line 658: p_encoded => FND_API.G_FALSE,

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

Line 778: WHEN FND_API.G_EXC_ERROR THEN

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

Line 780: p_encoded => FND_API.G_FALSE,

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

Line 905: WHEN FND_API.G_EXC_ERROR THEN

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

Line 907: p_encoded => FND_API.G_FALSE,

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

Line 1027: WHEN FND_API.G_EXC_ERROR THEN

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

Line 1029: p_encoded => FND_API.G_FALSE,

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

Line 1148: WHEN FND_API.G_EXC_ERROR THEN

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

Line 1150: p_encoded => FND_API.G_FALSE,

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

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

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

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

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

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

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

Line 1203: l_validation_level NUMBER:= FND_API.G_VALID_LEVEL_FULL;

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

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

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

Line 1260: p_commit =>FND_API.G_FALSE,

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

Line 1305: WHEN fnd_api.g_exc_error THEN

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

Line 1311: p_encoded => FND_API.G_FALSE,

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

Line 1416: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1446: WHEN fnd_api.g_exc_error THEN

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

Line 1448: p_encoded => FND_API.G_FALSE,

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