DBA Data[Home] [Help]

APPS.PA_CUSTOMER_INFO dependencies on FND_API

Line 408: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

404: ,x_customer_id => l_customer_id
405: ,x_return_status => l_return_status
406: ,x_error_msg_code => l_error_msg_code);
407:
408: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
409: X_Err_Code := 20;
410: X_Err_Stage := 'PA_CUSTOMER_ID_INVALID_BILL' ;
411: return;
412: end if;

Line 434: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

430: ,x_customer_id => l_customer_id
431: ,x_return_status => l_return_status
432: ,x_error_msg_code => l_error_msg_code);
433:
434: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
435: X_Err_Code := 20;
436: X_Err_Stage := 'PA_CUSTOMER_ID_INVALID_SHIP' ;
437: return;
438: end if;

Line 1172: -- p_receiver_task_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

1168: -- Pre-reqs : None.
1169: -- Parameters :
1170: -- p_project_id IN NUMBER Required
1171: -- p_customer_id IN NUMBER Required
1172: -- p_receiver_task_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
1173: -- x_bill_another_project_flag OUT VARCHAR2 Required
1174: -- x_return_status OUT VARCHAR2 Required
1175: -- x_error_msg_code OUT VARCHAR2 Required
1176: -- History

Line 1186: ,p_receiver_task_id IN NUMBER := FND_API.G_MISS_NUM

1182:
1183: PROCEDURE CHECK_RECEIVER_PROJ_ENTERABLE
1184: ( p_project_id IN NUMBER
1185: ,p_customer_id IN NUMBER
1186: ,p_receiver_task_id IN NUMBER := FND_API.G_MISS_NUM
1187: ,x_bill_another_project_flag IN OUT NOCOPY VARCHAR2 -- File.sql.39 Bug 4633405 (For new API)
1188: ,x_return_status OUT NOCOPY VARCHAR2 -- File.sql.39 Bug 4633405 (For new API)
1189: ,x_error_msg_code OUT NOCOPY VARCHAR2 -- File.sql.39 Bug 4633405 (For new API)
1190: )

Line 1231: if (p_receiver_task_id <> FND_API.G_MISS_NUM) AND (p_receiver_task_id is not NULL) then

1227: if pa_invoice_utils.check_draft_invoice_exists(p_project_id,
1228: p_customer_id) = 0 then
1229: --dbms_output.put_line('No draft invoice');
1230:
1231: if (p_receiver_task_id <> FND_API.G_MISS_NUM) AND (p_receiver_task_id is not NULL) then
1232: x_bill_another_project_flag := 'Y';
1233: else
1234: x_bill_another_project_flag := 'N';
1235: end if;

Line 1236: x_return_status := FND_API.G_RET_STS_SUCCESS;

1232: x_bill_another_project_flag := 'Y';
1233: else
1234: x_bill_another_project_flag := 'N';
1235: end if;
1236: x_return_status := FND_API.G_RET_STS_SUCCESS;
1237: else
1238: --dbms_output.put_line('draft invoice exists ');
1239:
1240: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1240: x_return_status := FND_API.G_RET_STS_ERROR;

1236: x_return_status := FND_API.G_RET_STS_SUCCESS;
1237: else
1238: --dbms_output.put_line('draft invoice exists ');
1239:
1240: x_return_status := FND_API.G_RET_STS_ERROR;
1241: x_error_msg_code := 'PA_REC_PROJ_NOT_ALLOWED';
1242: END if;
1243: else
1244:

Line 1246: if (p_receiver_task_id <> FND_API.G_MISS_NUM) AND (p_receiver_task_id is not NULL) then

1242: END if;
1243: else
1244:
1245:
1246: if (p_receiver_task_id <> FND_API.G_MISS_NUM) AND (p_receiver_task_id is not NULL) then
1247: x_return_status := FND_API.G_RET_STS_ERROR;
1248: x_error_msg_code := 'PA_REC_PROJ_NOT_ALLOWED';
1249: else
1250: x_bill_another_project_flag := 'N';

Line 1247: x_return_status := FND_API.G_RET_STS_ERROR;

1243: else
1244:
1245:
1246: if (p_receiver_task_id <> FND_API.G_MISS_NUM) AND (p_receiver_task_id is not NULL) then
1247: x_return_status := FND_API.G_RET_STS_ERROR;
1248: x_error_msg_code := 'PA_REC_PROJ_NOT_ALLOWED';
1249: else
1250: x_bill_another_project_flag := 'N';
1251: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1251: x_return_status := FND_API.G_RET_STS_SUCCESS;

1247: x_return_status := FND_API.G_RET_STS_ERROR;
1248: x_error_msg_code := 'PA_REC_PROJ_NOT_ALLOWED';
1249: else
1250: x_bill_another_project_flag := 'N';
1251: x_return_status := FND_API.G_RET_STS_SUCCESS;
1252: end if;
1253: end if;
1254: --dbms_output.put_line('Value of x_bill_another_project_flag'||x_bill_another_project_flag);
1255: close C1;

Line 1260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1256: close C2;
1257: close C3;
1258: EXCEPTION
1259: when OTHERS then
1260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1261: raise;
1262: END CHECK_RECEIVER_PROJ_ENTERABLE;
1263:
1264: END PA_CUSTOMER_INFO;