DBA Data[Home] [Help]

APPS.PO_ASL_SV dependencies on FND_API

Line 284: l_return_status := FND_API.G_RET_STS_SUCCESS;

280: FOR i IN 1..l_asl_id_tbl.COUNT LOOP
281:
282: l_progress := '030';
283:
284: l_return_status := FND_API.G_RET_STS_SUCCESS;
285:
286: IF (g_debug_stmt) THEN
287: PO_DEBUG.debug_stmt
288: ( p_log_head => l_module,

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

302: p_entity_name => 'ASL',
303: p_entity_id => l_asl_id_tbl(i)
304: );
305:
306: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
307: l_progress := '040';
308:
309: IF (g_debug_stmt) THEN
310:

Line 337: END IF; -- IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

333: p_token => l_progress,
334: p_message => l_msg_buf
335: );
336: END IF;
337: END IF; -- IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
338:
339: PO_ASL_SV.raise_asl_eres_event
340: ( x_return_status => l_return_status,
341: p_asl_id => l_asl_id_tbl(i),

Line 345: p_autonomous_commit => FND_API.G_FALSE

341: p_asl_id => l_asl_id_tbl(i),
342: p_action => PO_ASL_SV.G_EVENT_UPDATE,
343: p_calling_from => 'PO_ASL_SV.udpate_vendor_status',
344: p_ackn_note => NULL,
345: p_autonomous_commit => FND_API.G_FALSE
346: );
347:
348: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
349: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

344: p_ackn_note => NULL,
345: p_autonomous_commit => FND_API.G_FALSE
346: );
347:
348: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
349: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
350: END IF;
351: END LOOP;
352:

Line 349: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

345: p_autonomous_commit => FND_API.G_FALSE
346: );
347:
348: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
349: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
350: END IF;
351: END LOOP;
352:
353: IF (g_debug_stmt) THEN

Line 634: x_return_status := FND_API.G_RET_STS_SUCCESS;

630:
631: BEGIN
632: l_progress := '000';
633:
634: x_return_status := FND_API.G_RET_STS_SUCCESS;
635:
636: IF (g_debug_stmt) THEN
637: PO_DEBUG.debug_begin
638: ( p_log_head => l_module

Line 692: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

688: l_progress := '020';
689: l_event.event_name := 'oracle.apps.po.asl.update';
690: ELSE
691: l_progress := '030';
692: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
693: END IF;
694:
695: l_event.event_key := p_asl_id;
696: l_event.event_status := 'SUCCESS';

Line 712: p_init_msg_list => FND_API.G_TRUE,

708: l_progress := '040';
709:
710: QA_EDR_STANDARD.raise_eres_event
711: ( p_api_version => 1.0,
712: p_init_msg_list => FND_API.G_TRUE,
713: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
714: x_return_status => l_return_status,
715: x_msg_count => l_msg_count,
716: x_msg_data => l_msg_data,

Line 713: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

709:
710: QA_EDR_STANDARD.raise_eres_event
711: ( p_api_version => 1.0,
712: p_init_msg_list => FND_API.G_TRUE,
713: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
714: x_return_status => l_return_status,
715: x_msg_count => l_msg_count,
716: x_msg_data => l_msg_data,
717: p_child_erecords => l_child_erecords,

Line 739: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

735: -- and returns with pending status
736: IF (l_event.event_status NOT IN ('SUCCESS', 'NOACTION','PENDING')) THEN
737: l_progress := '050';
738: l_subroutine := 'QA_EDR_STANDARD.raise_eres_event';
739: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
740: END IF;
741:
742: IF (l_event.erecord_id > 0) THEN
743: l_progress := '060';

Line 747: p_init_msg_list => FND_API.G_TRUE,

743: l_progress := '060';
744:
745: QA_EDR_STANDARD.send_ackn
746: ( p_api_version => 1.0,
747: p_init_msg_list => FND_API.G_TRUE,
748: x_return_status => l_return_status,
749: x_msg_count => l_msg_count,
750: x_msg_data => l_msg_data,
751: p_event_name => l_event.event_name,

Line 774: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

770: --Bug 4745270 dont error incase of 'PENDING' status
771: IF (l_event.event_status NOT IN ('SUCCESS', 'NOACTION','PENDING')) THEN
772: l_progress := '070';
773: l_subroutine := 'QA_EDR_STANDARD.send_ackn';
774: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
775: END IF;
776: END IF;
777:
778: IF (g_debug_stmt) THEN

Line 785: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

781: );
782: END IF;
783:
784: EXCEPTION
785: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
786: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
787:
788: IF (g_debug_unexp) THEN
789: PO_DEBUG.debug_exc

Line 786: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

782: END IF;
783:
784: EXCEPTION
785: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
786: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
787:
788: IF (g_debug_unexp) THEN
789: PO_DEBUG.debug_exc
790: ( p_log_head => l_module,

Line 820: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

816: FND_MESSAGE.set_token ('SUBROUTINE', l_subroutine);
817: FND_MESSAGE.set_token ('ERROR_MSG', l_msg_data);
818:
819: WHEN OTHERS THEN
820: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
821:
822: IF (g_debug_unexp) THEN
823: PO_DEBUG.debug_exc
824: ( p_log_head => l_module,

Line 1167: p_autonomous_commit => FND_API.G_FALSE

1163: p_asl_id => g_asl_activities(i).asl_id,
1164: p_action => g_asl_activities(i).action,
1165: p_calling_from => 'PO_ASL_SV.process_asl_activity_tbl',
1166: p_ackn_note => NULL,
1167: p_autonomous_commit => FND_API.G_FALSE
1168: );
1169:
1170: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1171: l_progress := '030';

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

1166: p_ackn_note => NULL,
1167: p_autonomous_commit => FND_API.G_FALSE
1168: );
1169:
1170: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1171: l_progress := '030';
1172:
1173:
1174: IF (g_debug_stmt) THEN

Line 1183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1179: 'with status ' || l_return_status
1180: );
1181: END IF;
1182:
1183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1184: END IF;
1185: END LOOP;
1186:
1187: -- bug3539651