DBA Data[Home] [Help]

APPS.OKS_COVERAGES_PVT dependencies on FND_FILE

Line 6366: fnd_file.put_line(FND_FILE.LOG, 'PROGRAM_APPLICATION_ID....'||l_prog_appl_id);

6362: l_conc_request_id := NULL;
6363: END IF ;
6364:
6365: IF fnd_global.conc_request_id <> -1 THEN
6366: fnd_file.put_line(FND_FILE.LOG, 'PROGRAM_APPLICATION_ID....'||l_prog_appl_id);
6367: fnd_file.put_line(FND_FILE.LOG, 'PROGRAM_ID...'||l_conc_program_id);
6368: fnd_file.put_line(FND_FILE.LOG, 'PROGRAM_UPDATE_DATE...'||l_program_update_date);
6369: fnd_file.put_line(FND_FILE.LOG, 'REQUEST_ID...'||l_conc_request_id);
6370: fnd_file.put_line(FND_FILE.LOG, 'Processing for BP_LINE_ID.....'||bill_rate_rec.bp_line_id);

Line 6367: fnd_file.put_line(FND_FILE.LOG, 'PROGRAM_ID...'||l_conc_program_id);

6363: END IF ;
6364:
6365: IF fnd_global.conc_request_id <> -1 THEN
6366: fnd_file.put_line(FND_FILE.LOG, 'PROGRAM_APPLICATION_ID....'||l_prog_appl_id);
6367: fnd_file.put_line(FND_FILE.LOG, 'PROGRAM_ID...'||l_conc_program_id);
6368: fnd_file.put_line(FND_FILE.LOG, 'PROGRAM_UPDATE_DATE...'||l_program_update_date);
6369: fnd_file.put_line(FND_FILE.LOG, 'REQUEST_ID...'||l_conc_request_id);
6370: fnd_file.put_line(FND_FILE.LOG, 'Processing for BP_LINE_ID.....'||bill_rate_rec.bp_line_id);
6371: END IF;

Line 6368: fnd_file.put_line(FND_FILE.LOG, 'PROGRAM_UPDATE_DATE...'||l_program_update_date);

6364:
6365: IF fnd_global.conc_request_id <> -1 THEN
6366: fnd_file.put_line(FND_FILE.LOG, 'PROGRAM_APPLICATION_ID....'||l_prog_appl_id);
6367: fnd_file.put_line(FND_FILE.LOG, 'PROGRAM_ID...'||l_conc_program_id);
6368: fnd_file.put_line(FND_FILE.LOG, 'PROGRAM_UPDATE_DATE...'||l_program_update_date);
6369: fnd_file.put_line(FND_FILE.LOG, 'REQUEST_ID...'||l_conc_request_id);
6370: fnd_file.put_line(FND_FILE.LOG, 'Processing for BP_LINE_ID.....'||bill_rate_rec.bp_line_id);
6371: END IF;
6372:

Line 6369: fnd_file.put_line(FND_FILE.LOG, 'REQUEST_ID...'||l_conc_request_id);

6365: IF fnd_global.conc_request_id <> -1 THEN
6366: fnd_file.put_line(FND_FILE.LOG, 'PROGRAM_APPLICATION_ID....'||l_prog_appl_id);
6367: fnd_file.put_line(FND_FILE.LOG, 'PROGRAM_ID...'||l_conc_program_id);
6368: fnd_file.put_line(FND_FILE.LOG, 'PROGRAM_UPDATE_DATE...'||l_program_update_date);
6369: fnd_file.put_line(FND_FILE.LOG, 'REQUEST_ID...'||l_conc_request_id);
6370: fnd_file.put_line(FND_FILE.LOG, 'Processing for BP_LINE_ID.....'||bill_rate_rec.bp_line_id);
6371: END IF;
6372:
6373:

Line 6370: fnd_file.put_line(FND_FILE.LOG, 'Processing for BP_LINE_ID.....'||bill_rate_rec.bp_line_id);

6366: fnd_file.put_line(FND_FILE.LOG, 'PROGRAM_APPLICATION_ID....'||l_prog_appl_id);
6367: fnd_file.put_line(FND_FILE.LOG, 'PROGRAM_ID...'||l_conc_program_id);
6368: fnd_file.put_line(FND_FILE.LOG, 'PROGRAM_UPDATE_DATE...'||l_program_update_date);
6369: fnd_file.put_line(FND_FILE.LOG, 'REQUEST_ID...'||l_conc_request_id);
6370: fnd_file.put_line(FND_FILE.LOG, 'Processing for BP_LINE_ID.....'||bill_rate_rec.bp_line_id);
6371: END IF;
6372:
6373:
6374: l_bill_rate_exists := 'N' ;

Line 6433: fnd_file.put_line(FND_FILE.LOG, 'AFTER OKS_BRS_PVT.UPDATE_ROW......');

6429: p_oks_billrate_schedules_v_tbl => l_bill_rate_tbl_in,
6430: x_oks_billrate_schedules_v_tbl => x_bill_rate_tbl_out);
6431:
6432: IF fnd_global.conc_request_id <> -1 THEN
6433: fnd_file.put_line(FND_FILE.LOG, 'AFTER OKS_BRS_PVT.UPDATE_ROW......');
6434: fnd_file.put_line(FND_FILE.LOG, 'Return Status from OKS_BRS_PVT.UPDATE_ROW API...'||l_return_status);
6435: END IF;
6436:
6437:

Line 6434: fnd_file.put_line(FND_FILE.LOG, 'Return Status from OKS_BRS_PVT.UPDATE_ROW API...'||l_return_status);

6430: x_oks_billrate_schedules_v_tbl => x_bill_rate_tbl_out);
6431:
6432: IF fnd_global.conc_request_id <> -1 THEN
6433: fnd_file.put_line(FND_FILE.LOG, 'AFTER OKS_BRS_PVT.UPDATE_ROW......');
6434: fnd_file.put_line(FND_FILE.LOG, 'Return Status from OKS_BRS_PVT.UPDATE_ROW API...'||l_return_status);
6435: END IF;
6436:
6437:
6438:

Line 6472: fnd_file.put_line(FND_FILE.LOG, 'AFTER OKC_CONTRACT_PUB.CREATE_CONTRACT_LINE......');

6468:
6469:
6470:
6471: IF fnd_global.conc_request_id <> -1 THEN
6472: fnd_file.put_line(FND_FILE.LOG, 'AFTER OKC_CONTRACT_PUB.CREATE_CONTRACT_LINE......');
6473: fnd_file.put_line(FND_FILE.LOG, 'Return Status from OKC_CONTRACT_PUB.CREATE_CONTRACT_LINE API...'||l_return_status);
6474: END IF;
6475:
6476:

Line 6473: fnd_file.put_line(FND_FILE.LOG, 'Return Status from OKC_CONTRACT_PUB.CREATE_CONTRACT_LINE API...'||l_return_status);

6469:
6470:
6471: IF fnd_global.conc_request_id <> -1 THEN
6472: fnd_file.put_line(FND_FILE.LOG, 'AFTER OKC_CONTRACT_PUB.CREATE_CONTRACT_LINE......');
6473: fnd_file.put_line(FND_FILE.LOG, 'Return Status from OKC_CONTRACT_PUB.CREATE_CONTRACT_LINE API...'||l_return_status);
6474: END IF;
6475:
6476:
6477: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN

Line 6529: fnd_file.put_line(FND_FILE.LOG, 'AFTER OKS_BRS_PVT.INSERT_ROW......');

6525: x_return_status := l_return_status;
6526:
6527:
6528: IF fnd_global.conc_request_id <> -1 THEN
6529: fnd_file.put_line(FND_FILE.LOG, 'AFTER OKS_BRS_PVT.INSERT_ROW......');
6530: fnd_file.put_line(FND_FILE.LOG, 'Return Status from OKS_BRS_PVT.INSERT_ROW API...'||l_return_status);
6531: END IF;
6532:
6533:

Line 6530: fnd_file.put_line(FND_FILE.LOG, 'Return Status from OKS_BRS_PVT.INSERT_ROW API...'||l_return_status);

6526:
6527:
6528: IF fnd_global.conc_request_id <> -1 THEN
6529: fnd_file.put_line(FND_FILE.LOG, 'AFTER OKS_BRS_PVT.INSERT_ROW......');
6530: fnd_file.put_line(FND_FILE.LOG, 'Return Status from OKS_BRS_PVT.INSERT_ROW API...'||l_return_status);
6531: END IF;
6532:
6533:
6534:

Line 6566: fnd_file.put_line(FND_FILE.LOG, 'AFTER OKC_RULE_PUB.UPDATE_RULE......Updating RULE_INFORMATION10 to Y');

6562: p_rulv_tbl => l_rulv_tbl_in,
6563: x_rulv_tbl => l_rulv_tbl_out); */
6564:
6565: IF fnd_global.conc_request_id <> -1 THEN
6566: fnd_file.put_line(FND_FILE.LOG, 'AFTER OKC_RULE_PUB.UPDATE_RULE......Updating RULE_INFORMATION10 to Y');
6567: -- fnd_file.put_line(FND_FILE.LOG, 'Return Status from OKC_RULE_PUB.UPDATE_RULE API...'||l_return_status);
6568: END IF;
6569:
6570:

Line 6567: -- fnd_file.put_line(FND_FILE.LOG, 'Return Status from OKC_RULE_PUB.UPDATE_RULE API...'||l_return_status);

6563: x_rulv_tbl => l_rulv_tbl_out); */
6564:
6565: IF fnd_global.conc_request_id <> -1 THEN
6566: fnd_file.put_line(FND_FILE.LOG, 'AFTER OKC_RULE_PUB.UPDATE_RULE......Updating RULE_INFORMATION10 to Y');
6567: -- fnd_file.put_line(FND_FILE.LOG, 'Return Status from OKC_RULE_PUB.UPDATE_RULE API...'||l_return_status);
6568: END IF;
6569:
6570:
6571:

Line 6579: fnd_file.put_line(FND_FILE.LOG, 'Return Status from API...'||x_return_status);

6575: END LOOP ;
6576: x_return_status := OKC_API.G_RET_STS_SUCCESS;
6577:
6578: IF fnd_global.conc_request_id <> -1 THEN
6579: fnd_file.put_line(FND_FILE.LOG, 'Return Status from API...'||x_return_status);
6580: END IF;
6581:
6582:
6583: EXCEPTION

Line 6595: fnd_file.put_line(FND_FILE.LOG, 'Raised Exception...||G_EXCEPTION_RULE_UPDATE');

6591: '_PVT'
6592: );
6593: ROLLBACK ;
6594: IF fnd_global.conc_request_id <> -1 THEN
6595: fnd_file.put_line(FND_FILE.LOG, 'Raised Exception...||G_EXCEPTION_RULE_UPDATE');
6596: END IF;
6597:
6598:
6599:

Line 6611: fnd_file.put_line(FND_FILE.LOG, 'Raised Exception...||G_EXCEPTION_BRS_UPDATE');

6607: '_PVT'
6608: );
6609: ROLLBACK ;
6610: IF fnd_global.conc_request_id <> -1 THEN
6611: fnd_file.put_line(FND_FILE.LOG, 'Raised Exception...||G_EXCEPTION_BRS_UPDATE');
6612: END IF;
6613:
6614: WHEN G_EXCEPTION_HALT_VALIDATION THEN
6615: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 6627: fnd_file.put_line(FND_FILE.LOG, 'Raised Exception...||G_EXCEPTION_HALT_VALIDATION');

6623: );
6624: ROLLBACK ;
6625:
6626: IF fnd_global.conc_request_id <> -1 THEN
6627: fnd_file.put_line(FND_FILE.LOG, 'Raised Exception...||G_EXCEPTION_HALT_VALIDATION');
6628: END IF;
6629:
6630: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
6631: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 6642: fnd_file.put_line(FND_FILE.LOG, 'Raised Exception...||G_EXCEPTION_UNEXPECTED_ERROR');

6638: '_PVT'
6639: );
6640: ROLLBACK;
6641: IF fnd_global.conc_request_id <> -1 THEN
6642: fnd_file.put_line(FND_FILE.LOG, 'Raised Exception...||G_EXCEPTION_UNEXPECTED_ERROR');
6643: END IF;
6644:
6645:
6646: WHEN OTHERS THEN

Line 6658: fnd_file.put_line(FND_FILE.LOG, 'Raised Exception...||OTHERS');

6654: '_PVT'
6655: );
6656: ROLLBACK ;
6657: IF fnd_global.conc_request_id <> -1 THEN
6658: fnd_file.put_line(FND_FILE.LOG, 'Raised Exception...||OTHERS');
6659: END IF;
6660:
6661:
6662: END oks_billrate_mapping ;