DBA Data[Home] [Help]

APPS.PA_CUSTOMER_INFO dependencies on FND_API

Line 417: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

413: ,x_customer_id => l_customer_id
414: ,x_return_status => l_return_status
415: ,x_error_msg_code => l_error_msg_code);
416:
417: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
418: X_Err_Code := 20;
419: X_Err_Stage := 'PA_CUSTOMER_ID_INVALID_BILL' ;
420: return;
421: end if;

Line 443: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

439: ,x_customer_id => l_customer_id
440: ,x_return_status => l_return_status
441: ,x_error_msg_code => l_error_msg_code);
442:
443: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
444: X_Err_Code := 20;
445: X_Err_Stage := 'PA_CUSTOMER_ID_INVALID_SHIP' ;
446: return;
447: end if;

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

1177: -- Pre-reqs : None.
1178: -- Parameters :
1179: -- p_project_id IN NUMBER Required
1180: -- p_customer_id IN NUMBER Required
1181: -- p_receiver_task_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
1182: -- x_bill_another_project_flag OUT VARCHAR2 Required
1183: -- x_return_status OUT VARCHAR2 Required
1184: -- x_error_msg_code OUT VARCHAR2 Required
1185: -- History

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

1191:
1192: PROCEDURE CHECK_RECEIVER_PROJ_ENTERABLE
1193: ( p_project_id IN NUMBER
1194: ,p_customer_id IN NUMBER
1195: ,p_receiver_task_id IN NUMBER := FND_API.G_MISS_NUM
1196: ,x_bill_another_project_flag IN OUT NOCOPY VARCHAR2 -- File.sql.39 Bug 4633405 (For new API)
1197: ,x_return_status OUT NOCOPY VARCHAR2 -- File.sql.39 Bug 4633405 (For new API)
1198: ,x_error_msg_code OUT NOCOPY VARCHAR2 -- File.sql.39 Bug 4633405 (For new API)
1199: )

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

1236: if pa_invoice_utils.check_draft_invoice_exists(p_project_id,
1237: p_customer_id) = 0 then
1238: --dbms_output.put_line('No draft invoice');
1239:
1240: if (p_receiver_task_id <> FND_API.G_MISS_NUM) AND (p_receiver_task_id is not NULL) then
1241: x_bill_another_project_flag := 'Y';
1242: else
1243: x_bill_another_project_flag := 'N';
1244: end if;

Line 1245: x_return_status := FND_API.G_RET_STS_SUCCESS;

1241: x_bill_another_project_flag := 'Y';
1242: else
1243: x_bill_another_project_flag := 'N';
1244: end if;
1245: x_return_status := FND_API.G_RET_STS_SUCCESS;
1246: else
1247: --dbms_output.put_line('draft invoice exists ');
1248:
1249: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1249: x_return_status := FND_API.G_RET_STS_ERROR;

1245: x_return_status := FND_API.G_RET_STS_SUCCESS;
1246: else
1247: --dbms_output.put_line('draft invoice exists ');
1248:
1249: x_return_status := FND_API.G_RET_STS_ERROR;
1250: x_error_msg_code := 'PA_REC_PROJ_NOT_ALLOWED';
1251: END if;
1252: else
1253:

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

1251: END if;
1252: else
1253:
1254:
1255: if (p_receiver_task_id <> FND_API.G_MISS_NUM) AND (p_receiver_task_id is not NULL) then
1256: x_return_status := FND_API.G_RET_STS_ERROR;
1257: x_error_msg_code := 'PA_REC_PROJ_NOT_ALLOWED';
1258: else
1259: x_bill_another_project_flag := 'N';

Line 1256: x_return_status := FND_API.G_RET_STS_ERROR;

1252: else
1253:
1254:
1255: if (p_receiver_task_id <> FND_API.G_MISS_NUM) AND (p_receiver_task_id is not NULL) then
1256: x_return_status := FND_API.G_RET_STS_ERROR;
1257: x_error_msg_code := 'PA_REC_PROJ_NOT_ALLOWED';
1258: else
1259: x_bill_another_project_flag := 'N';
1260: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1260: x_return_status := FND_API.G_RET_STS_SUCCESS;

1256: x_return_status := FND_API.G_RET_STS_ERROR;
1257: x_error_msg_code := 'PA_REC_PROJ_NOT_ALLOWED';
1258: else
1259: x_bill_another_project_flag := 'N';
1260: x_return_status := FND_API.G_RET_STS_SUCCESS;
1261: end if;
1262: end if;
1263: --dbms_output.put_line('Value of x_bill_another_project_flag'||x_bill_another_project_flag);
1264: close C1;

Line 1269: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1265: close C2;
1266: close C3;
1267: EXCEPTION
1268: when OTHERS then
1269: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1270: raise;
1271: END CHECK_RECEIVER_PROJ_ENTERABLE;
1272:
1273: END PA_CUSTOMER_INFO;