DBA Data[Home] [Help]

APPS.OCM_CREDIT_REQ_WITHDRAW_PUB dependencies on FND_API

Line 33: x_return_status := FND_API.G_RET_STS_SUCCESS;

29: debug ( 'p_credit_request_id ' ||p_credit_request_id );
30: debug ( 'p_withdraw_reason_code ' ||p_withdrawl_reason_code );
31: END IF;
32:
33: x_return_status := FND_API.G_RET_STS_SUCCESS;
34:
35: SAVEPOINT WITHDRAW_REQUEST;
36:
37: IF FND_API.to_Boolean( p_init_msg_list )

Line 37: IF FND_API.to_Boolean( p_init_msg_list )

33: x_return_status := FND_API.G_RET_STS_SUCCESS;
34:
35: SAVEPOINT WITHDRAW_REQUEST;
36:
37: IF FND_API.to_Boolean( p_init_msg_list )
38: THEN
39: FND_MSG_PUB.initialize;
40: END IF;
41:

Line 52: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

48: AND status NOT IN ('WITHDRAW', 'PROCESSED');
49:
50: EXCEPTION
51: WHEN NO_DATA_FOUND THEN
52: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
53: x_msg_count := 1;
54: x_msg_data := 'OCM_INVALID_WITHDRAW_REQUEST';
55: return;
56: WHEN OTHERS THEN

Line 57: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

53: x_msg_count := 1;
54: x_msg_data := 'OCM_INVALID_WITHDRAW_REQUEST';
55: return;
56: WHEN OTHERS THEN
57: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
58: x_msg_count := 1;
59: x_msg_data := sqlerrm;
60: return;
61: END;

Line 71: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

67: AND lookup_code = p_withdrawl_reason_code;
68:
69: EXCEPTION
70: WHEN NO_DATA_FOUND THEN
71: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
72: x_msg_count := 1;
73: x_msg_data := 'OCM_INVALID_WITHDRAW_REASON';
74: return;
75: WHEN OTHERS THEN

Line 76: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

72: x_msg_count := 1;
73: x_msg_data := 'OCM_INVALID_WITHDRAW_REASON';
74: return;
75: WHEN OTHERS THEN
76: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
77: x_msg_count := 1;
78: x_msg_data := sqlerrm;
79: return;
80: END;

Line 106: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

102:
103: EXCEPTION
104: WHEN OTHERS THEN
105: rollback to WITHDRAW_REQUEST;
106: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
107: x_msg_data := sqlerrm;
108:
109: END WITHDRAW_REQUEST;
110: