DBA Data[Home] [Help]

APPS.AHL_OPERATIONS_APPROVAL_PVT dependencies on FND_API

Line 68: l_return_status :=fnd_api.g_ret_sts_success;

64: AHL_DEBUG_PUB.debug( 'Set_Activity_Details Route','+DebugWfOper+');
65: END IF;
66: fnd_msg_pub.initialize;
67:
68: l_return_status :=fnd_api.g_ret_sts_success;
69:
70: l_object_id := wf_engine.getitemattrnumber(
71: itemtype => itemtype
72: ,itemkey => itemkey

Line 169: IF l_return_status = fnd_api.g_ret_sts_success THEN

165: x_approver_seq => l_approver_seq,
166: x_return_status => l_return_status
167: );
168:
169: IF l_return_status = fnd_api.g_ret_sts_success THEN
170:
171: wf_engine.setitemattrnumber(
172: itemtype => itemtype,
173: itemkey => itemkey,

Line 190: RAISE fnd_api.G_EXC_ERROR;

186:
187: RETURN;
188:
189: ELSE
190: RAISE fnd_api.G_EXC_ERROR;
191: END IF;
192: END IF;
193:
194: IF (funcmode = 'CANCEL') THEN

Line 206: WHEN fnd_api.G_EXC_ERROR THEN

202: RETURN;
203: END IF;
204:
205: EXCEPTION
206: WHEN fnd_api.G_EXC_ERROR THEN
207:
208: FND_MSG_PUB.Count_And_Get (
209: p_encoded => FND_API.G_FALSE,
210: p_count => l_msg_count,

Line 209: p_encoded => FND_API.G_FALSE,

205: EXCEPTION
206: WHEN fnd_api.G_EXC_ERROR THEN
207:
208: FND_MSG_PUB.Count_And_Get (
209: p_encoded => FND_API.G_FALSE,
210: p_count => l_msg_count,
211: p_data => l_msg_data
212: );
213:

Line 336: WHEN FND_API.G_EXC_ERROR THEN

332: document := document || l_body;
333: RETURN;
334:
335: EXCEPTION
336: WHEN FND_API.G_EXC_ERROR THEN
337: FND_MSG_PUB.Count_And_Get (
338: p_encoded => FND_API.G_FALSE,
339: p_count => l_msg_count,
340: p_data => l_msg_data

Line 338: p_encoded => FND_API.G_FALSE,

334:
335: EXCEPTION
336: WHEN FND_API.G_EXC_ERROR THEN
337: FND_MSG_PUB.Count_And_Get (
338: p_encoded => FND_API.G_FALSE,
339: p_count => l_msg_count,
340: p_data => l_msg_data
341: );
342: ahl_generic_aprv_pvt.Handle_Error

Line 456: WHEN FND_API.G_EXC_ERROR THEN

452:
453: RETURN;
454:
455: EXCEPTION
456: WHEN FND_API.G_EXC_ERROR THEN
457: FND_MSG_PUB.Count_And_Get (
458: p_encoded => FND_API.G_FALSE,
459: p_count => l_msg_count,
460: p_data => l_msg_data

Line 458: p_encoded => FND_API.G_FALSE,

454:
455: EXCEPTION
456: WHEN FND_API.G_EXC_ERROR THEN
457: FND_MSG_PUB.Count_And_Get (
458: p_encoded => FND_API.G_FALSE,
459: p_count => l_msg_count,
460: p_data => l_msg_data
461: );
462: ahl_generic_aprv_pvt.Handle_Error

Line 561: WHEN FND_API.G_EXC_ERROR THEN

557:
558: RETURN;
559:
560: EXCEPTION
561: WHEN FND_API.G_EXC_ERROR THEN
562: FND_MSG_PUB.Count_And_Get (
563: p_encoded => FND_API.G_FALSE,
564: p_count => l_msg_count,
565: p_data => l_msg_data

Line 563: p_encoded => FND_API.G_FALSE,

559:
560: EXCEPTION
561: WHEN FND_API.G_EXC_ERROR THEN
562: FND_MSG_PUB.Count_And_Get (
563: p_encoded => FND_API.G_FALSE,
564: p_count => l_msg_count,
565: p_data => l_msg_data
566: );
567: ahl_generic_aprv_pvt.Handle_Error

Line 678: WHEN FND_API.G_EXC_ERROR THEN

674:
675: RETURN;
676:
677: EXCEPTION
678: WHEN FND_API.G_EXC_ERROR THEN
679: FND_MSG_PUB.Count_And_Get (
680: p_encoded => FND_API.G_FALSE,
681: p_count => l_msg_count,
682: p_data => l_msg_data

Line 680: p_encoded => FND_API.G_FALSE,

676:
677: EXCEPTION
678: WHEN FND_API.G_EXC_ERROR THEN
679: FND_MSG_PUB.Count_And_Get (
680: p_encoded => FND_API.G_FALSE,
681: p_count => l_msg_count,
682: p_data => l_msg_data
683: );
684: ahl_generic_aprv_pvt.Handle_Error

Line 806: WHEN FND_API.G_EXC_ERROR THEN

802:
803: RETURN;
804:
805: EXCEPTION
806: WHEN FND_API.G_EXC_ERROR THEN
807: FND_MSG_PUB.Count_And_Get (
808: p_encoded => FND_API.G_FALSE,
809: p_count => l_msg_count,
810: p_data => l_msg_data

Line 808: p_encoded => FND_API.G_FALSE,

804:
805: EXCEPTION
806: WHEN FND_API.G_EXC_ERROR THEN
807: FND_MSG_PUB.Count_And_Get (
808: p_encoded => FND_API.G_FALSE,
809: p_count => l_msg_count,
810: p_data => l_msg_data
811: );
812: ahl_generic_aprv_pvt.Handle_Error

Line 931: WHEN FND_API.G_EXC_ERROR THEN

927:
928: RETURN;
929:
930: EXCEPTION
931: WHEN FND_API.G_EXC_ERROR THEN
932: FND_MSG_PUB.Count_And_Get (
933: p_encoded => FND_API.G_FALSE,
934: p_count => l_msg_count,
935: p_data => l_msg_data

Line 933: p_encoded => FND_API.G_FALSE,

929:
930: EXCEPTION
931: WHEN FND_API.G_EXC_ERROR THEN
932: FND_MSG_PUB.Count_And_Get (
933: p_encoded => FND_API.G_FALSE,
934: p_count => l_msg_count,
935: p_data => l_msg_data
936: );
937: ahl_generic_aprv_pvt.Handle_Error

Line 1051: WHEN FND_API.G_EXC_ERROR THEN

1047:
1048: RETURN;
1049:
1050: EXCEPTION
1051: WHEN FND_API.G_EXC_ERROR THEN
1052: FND_MSG_PUB.Count_And_Get (
1053: p_encoded => FND_API.G_FALSE,
1054: p_count => l_msg_count,
1055: p_data => l_msg_data

Line 1053: p_encoded => FND_API.G_FALSE,

1049:
1050: EXCEPTION
1051: WHEN FND_API.G_EXC_ERROR THEN
1052: FND_MSG_PUB.Count_And_Get (
1053: p_encoded => FND_API.G_FALSE,
1054: p_count => l_msg_count,
1055: p_data => l_msg_data
1056: );
1057: ahl_generic_aprv_pvt.Handle_Error

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

1091: l_msg_data VARCHAR2(4000);
1092: -- Variables for executing Complete_mr_Revision
1093: l_api_name CONSTANT VARCHAR2(30) := 'Update_Status';
1094:
1095: l_commit VARCHAR2(1):=FND_API.G_TRUE;
1096: l_OPERATION_ID number:=0;
1097: l_comp_OPERATION_ID number:=0;
1098: l_api_version NUMBER:=1.0;
1099: l_init_msg_list VARCHAR2(1):= FND_API.G_TRUE;

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

1095: l_commit VARCHAR2(1):=FND_API.G_TRUE;
1096: l_OPERATION_ID number:=0;
1097: l_comp_OPERATION_ID number:=0;
1098: l_api_version NUMBER:=1.0;
1099: l_init_msg_list VARCHAR2(1):= FND_API.G_TRUE;
1100: l_validate_only VARCHAR2(1):= FND_API.G_TRUE;
1101: l_validation_level NUMBER:= FND_API.G_VALID_LEVEL_FULL;
1102: l_module_type VARCHAR2(1);
1103: x_return_status VARCHAR2(2000);

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

1096: l_OPERATION_ID number:=0;
1097: l_comp_OPERATION_ID number:=0;
1098: l_api_version NUMBER:=1.0;
1099: l_init_msg_list VARCHAR2(1):= FND_API.G_TRUE;
1100: l_validate_only VARCHAR2(1):= FND_API.G_TRUE;
1101: l_validation_level NUMBER:= FND_API.G_VALID_LEVEL_FULL;
1102: l_module_type VARCHAR2(1);
1103: x_return_status VARCHAR2(2000);
1104: l_return_status VARCHAR2(1);

Line 1101: l_validation_level NUMBER:= FND_API.G_VALID_LEVEL_FULL;

1097: l_comp_OPERATION_ID number:=0;
1098: l_api_version NUMBER:=1.0;
1099: l_init_msg_list VARCHAR2(1):= FND_API.G_TRUE;
1100: l_validate_only VARCHAR2(1):= FND_API.G_TRUE;
1101: l_validation_level NUMBER:= FND_API.G_VALID_LEVEL_FULL;
1102: l_module_type VARCHAR2(1);
1103: x_return_status VARCHAR2(2000);
1104: l_return_status VARCHAR2(1);
1105: x_msg_count NUMBER;

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

1103: x_return_status VARCHAR2(2000);
1104: l_return_status VARCHAR2(1);
1105: x_msg_count NUMBER;
1106: x_msg_data VARCHAR2(2000);
1107: l_default VARCHAR2(1):= FND_API.G_FALSE;
1108: l_status VARCHAR2(30);
1109: l_body VARCHAR2(2000);
1110: l_approver_note VARCHAR2(2000);
1111:

Line 1225: WHEN fnd_api.g_exc_error THEN

1221: END IF;
1222:
1223:
1224: EXCEPTION
1225: WHEN fnd_api.g_exc_error THEN
1226: IF G_DEBUG='Y' THEN
1227: AHL_DEBUG_PUB.debug( 'GExec Error:'||sqlerrm,'+DebugWfOper+');
1228: END IF;
1229: FND_MSG_PUB.Count_And_Get (

Line 1230: p_encoded => FND_API.G_FALSE,

1226: IF G_DEBUG='Y' THEN
1227: AHL_DEBUG_PUB.debug( 'GExec Error:'||sqlerrm,'+DebugWfOper+');
1228: END IF;
1229: FND_MSG_PUB.Count_And_Get (
1230: p_encoded => FND_API.G_FALSE,
1231: p_count => l_msg_count,
1232: p_data => l_msg_data
1233: );
1234: ahl_generic_aprv_pvt.Handle_Error

Line 1344: WHEN fnd_api.g_exc_error THEN

1340: END IF;
1341:
1342:
1343: EXCEPTION
1344: WHEN fnd_api.g_exc_error THEN
1345: FND_MSG_PUB.Count_And_Get (
1346: p_encoded => FND_API.G_FALSE,
1347: p_count => l_msg_count,
1348: p_data => l_msg_data

Line 1346: p_encoded => FND_API.G_FALSE,

1342:
1343: EXCEPTION
1344: WHEN fnd_api.g_exc_error THEN
1345: FND_MSG_PUB.Count_And_Get (
1346: p_encoded => FND_API.G_FALSE,
1347: p_count => l_msg_count,
1348: p_data => l_msg_data
1349: );
1350: ahl_generic_aprv_pvt.Handle_Error