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 630: x_return_status := FND_API.G_RET_STS_SUCCESS;

626:
627: BEGIN
628: l_progress := '000';
629:
630: x_return_status := FND_API.G_RET_STS_SUCCESS;
631:
632: IF (g_debug_stmt) THEN
633: PO_DEBUG.debug_begin
634: ( p_log_head => l_module

Line 688: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

684: l_progress := '020';
685: l_event.event_name := 'oracle.apps.po.asl.update';
686: ELSE
687: l_progress := '030';
688: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
689: END IF;
690:
691: l_event.event_key := p_asl_id;
692: l_event.event_status := 'SUCCESS';

Line 708: p_init_msg_list => FND_API.G_TRUE,

704: l_progress := '040';
705:
706: QA_EDR_STANDARD.raise_eres_event
707: ( p_api_version => 1.0,
708: p_init_msg_list => FND_API.G_TRUE,
709: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
710: x_return_status => l_return_status,
711: x_msg_count => l_msg_count,
712: x_msg_data => l_msg_data,

Line 709: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

705:
706: QA_EDR_STANDARD.raise_eres_event
707: ( p_api_version => 1.0,
708: p_init_msg_list => FND_API.G_TRUE,
709: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
710: x_return_status => l_return_status,
711: x_msg_count => l_msg_count,
712: x_msg_data => l_msg_data,
713: p_child_erecords => l_child_erecords,

Line 735: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 743: p_init_msg_list => FND_API.G_TRUE,

739: l_progress := '060';
740:
741: QA_EDR_STANDARD.send_ackn
742: ( p_api_version => 1.0,
743: p_init_msg_list => FND_API.G_TRUE,
744: x_return_status => l_return_status,
745: x_msg_count => l_msg_count,
746: x_msg_data => l_msg_data,
747: p_event_name => l_event.event_name,

Line 770: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 781: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

777: );
778: END IF;
779:
780: EXCEPTION
781: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
782: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
783:
784: IF (g_debug_unexp) THEN
785: PO_DEBUG.debug_exc

Line 782: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

778: END IF;
779:
780: EXCEPTION
781: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
782: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
783:
784: IF (g_debug_unexp) THEN
785: PO_DEBUG.debug_exc
786: ( p_log_head => l_module,

Line 816: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1163: p_autonomous_commit => FND_API.G_FALSE

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

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

1162: p_ackn_note => NULL,
1163: p_autonomous_commit => FND_API.G_FALSE
1164: );
1165:
1166: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1167: l_progress := '030';
1168:
1169:
1170: IF (g_debug_stmt) THEN

Line 1179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1175: 'with status ' || l_return_status
1176: );
1177: END IF;
1178:
1179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1180: END IF;
1181: END LOOP;
1182:
1183: -- bug3539651