APPS.PSP_PQH_INTEGRATION dependencies on FND_API

Line 39: p_return_status:=FND_API.G_RET_STS_SUCCESS;

35: p_encumbrance_table.r_gl_enc_amount,
36: p_encumbrance_table.r_gms_enc_amount;
37: CLOSE GET_ASG_ENC_CUR;
38:
39: p_return_status:=FND_API.G_RET_STS_SUCCESS;
40:
41: EXCEPTION
42:
43: WHEN NO_DATA_FOUND THEN

Line 45: p_return_status:=FND_API.G_RET_STS_SUCCESS;

41: EXCEPTION
42:
43: WHEN NO_DATA_FOUND THEN
44: p_asg_psp_encumbered:=FALSE;
45: p_return_status:=FND_API.G_RET_STS_SUCCESS;
46: CLOSE GET_ASG_ENC_CUR;
47:
48:
49: WHEN OTHERS THEN

Line 51: p_return_Status:=FND_API.G_RET_STS_ERROR;

47:
48:
49: WHEN OTHERS THEN
50:
51: p_return_Status:=FND_API.G_RET_STS_ERROR;
52: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
53: CLOSE GET_ASG_ENC_CUR;
54:
55:

Line 52: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

48:
49: WHEN OTHERS THEN
50:
51: p_return_Status:=FND_API.G_RET_STS_ERROR;
52: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
53: CLOSE GET_ASG_ENC_CUR;
54:
55:
56: END get_asg_encumbrances;

Line 105: p_return_status:=FND_API.G_RET_STS_SUCCESS;

101: p_assignment_enc_ld_table.r_encumbrance_amount,
102: p_assignment_enc_ld_table.r_begin_time_period_id,
103: p_assignment_enc_ld_table.r_end_time_period_id;
104:
105: p_return_status:=FND_API.G_RET_STS_SUCCESS;
106:
107:
108: ELSE
109:

Line 118: p_return_status:=FND_API.G_RET_STS_SUCCESS;

114: p_assignment_enc_ld_table.r_encumbrance_amount,
115: p_assignment_enc_ld_table.r_begin_time_period_id,
116: p_assignment_enc_ld_table.r_end_time_period_id;
117:
118: p_return_status:=FND_API.G_RET_STS_SUCCESS;
119: CLOSE GET_ENC_DETAILS_LIQ_CUR;
120:
121: p_return_status:=FND_API.G_RET_STS_SUCCESS;
122:

Line 121: p_return_status:=FND_API.G_RET_STS_SUCCESS;

117:
118: p_return_status:=FND_API.G_RET_STS_SUCCESS;
119: CLOSE GET_ENC_DETAILS_LIQ_CUR;
120:
121: p_return_status:=FND_API.G_RET_STS_SUCCESS;
122:
123: END IF;
124:
125: EXCEPTION

Line 136: p_return_status:=FND_API.G_RET_STS_SUCCESS;

132: else
133: CLOSE GET_ENC_DETAILS_LIQ_CUR;
134: end if;
135:
136: p_return_status:=FND_API.G_RET_STS_SUCCESS;
137:
138:
139: WHEN OTHERS THEN
140: p_return_Status:=FND_API.G_RET_STS_ERROR;

Line 140: p_return_Status:=FND_API.G_RET_STS_ERROR;

136: p_return_status:=FND_API.G_RET_STS_SUCCESS;
137:
138:
139: WHEN OTHERS THEN
140: p_return_Status:=FND_API.G_RET_STS_ERROR;
141:
142: if p_calling_process='S' then
143: CLOSE GET_ENC_DETAILS_SUM_CUR;
144: else

Line 148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

144: else
145: CLOSE GET_ENC_DETAILS_LIQ_CUR;
146: end if;
147:
148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
149:
150: END get_Encumbrance_details;
151:
152: END PSP_PQH_INTEGRATION;