DBA Data[Home] [Help]

APPS.CS_STD dependencies on FND_API

Line 602: IF (p_return_status = FND_API.G_RET_STS_SUCCESS) THEN

598: procedure Output_Messages( p_return_status VARCHAR2,
599: p_msg_count NUMBER) IS
600: l_message VARCHAR2(2000);
601: BEGIN
602: IF (p_return_status = FND_API.G_RET_STS_SUCCESS) THEN
603: DBMS_OUTPUT.PUT_LINE('Result: Successful');
604: ELSIF (p_return_status = FND_API.G_RET_STS_ERROR) THEN
605: DBMS_OUTPUT.PUT_LINE('Result: Error');
606: ELSIF (p_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 604: ELSIF (p_return_status = FND_API.G_RET_STS_ERROR) THEN

600: l_message VARCHAR2(2000);
601: BEGIN
602: IF (p_return_status = FND_API.G_RET_STS_SUCCESS) THEN
603: DBMS_OUTPUT.PUT_LINE('Result: Successful');
604: ELSIF (p_return_status = FND_API.G_RET_STS_ERROR) THEN
605: DBMS_OUTPUT.PUT_LINE('Result: Error');
606: ELSIF (p_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
607: DBMS_OUTPUT.PUT_LINE('Result: Unexpected Error');
608: ELSE

Line 606: ELSIF (p_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

602: IF (p_return_status = FND_API.G_RET_STS_SUCCESS) THEN
603: DBMS_OUTPUT.PUT_LINE('Result: Successful');
604: ELSIF (p_return_status = FND_API.G_RET_STS_ERROR) THEN
605: DBMS_OUTPUT.PUT_LINE('Result: Error');
606: ELSIF (p_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
607: DBMS_OUTPUT.PUT_LINE('Result: Unexpected Error');
608: ELSE
609: DBMS_OUTPUT.PUT_LINE('Result: Fatal Error - unrecognized return status code');
610: END IF;

Line 616: l_message := fnd_msg_pub.get(counter, FND_API.G_FALSE);

612: IF (p_msg_count > 0) THEN
613:
614: FOR counter IN REVERSE 1..p_msg_count LOOP
615:
616: l_message := fnd_msg_pub.get(counter, FND_API.G_FALSE);
617: DBMS_OUTPUT.PUT_LINE(' MSG('||to_char(counter)||'): '||
618: l_message);
619:
620: END LOOP;

Line 927: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

923: x_formatted_address => l_formatted_address,
924: x_formatted_lines_cnt => l_formatted_lines_cnt,
925: x_formatted_address_tbl => l_formatted_address_tbl
926: );
927: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
928: return l_formatted_address;
929: ELSE
930: return(format_address_concat( address_style,
931: address1,