APPS.OKL_REBOOK_CM_PVT dependencies on OKL_TRX_AR_INVOICES_B

Line 659: UPDATE okl_trx_ar_invoices_b

655: END IF;
656:
657:
658: IF (x_return_status <> 'S' ) THEN
659: UPDATE okl_trx_ar_invoices_b
660: SET trx_status_code = 'ERROR'
661: WHERE id = lx_taiv_rec.id;
662: FND_FILE.PUT_LINE (FND_FILE.LOG, 'ERROR Creating Billing Transactions.');
663: ELSE

Line 677: UPDATE okl_trx_ar_invoices_b

673: FOR i in err_tbl.FIRST..err_tbl.LAST LOOP
674: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Reversing Invoice for '||err_tbl(i).amount);
675:
676:
677: UPDATE okl_trx_ar_invoices_b
678: SET trx_status_code = 'ERROR'
679: WHERE id = err_tbl(i).tai_id;
680: END LOOP;
681:

Line 906: UPDATE okl_trx_ar_invoices_b

902: ||err_tbl(i).amount);
903: END IF;
904:
905:
906: UPDATE okl_trx_ar_invoices_b
907: SET trx_status_code = 'ERROR'
908: WHERE id = err_tbl(i).tai_id;
909: END LOOP;
910: ELSE

Line 920: --UPDATE okl_trx_ar_invoices_b

916: WHERE id = adj_streams_rec.sel_id;
917: END IF;
918:
919:
920: --UPDATE okl_trx_ar_invoices_b
921: --SET trx_status_code = 'ERROR'
922: --WHERE id = x_taiv_rec.id;
923: --FND_FILE.PUT_LINE (FND_FILE.LOG, 'ERROR Creating Accounting Distributions.');
924: ELSE

Line 942: UPDATE okl_trx_ar_invoices_b

938: ||err_tbl(i).amount);
939: END IF;
940:
941:
942: UPDATE okl_trx_ar_invoices_b
943: SET trx_status_code = 'ERROR'
944: WHERE id = err_tbl(i).tai_id;
945: END LOOP;
946: ELSE

Line 1347: UPDATE okl_trx_ar_invoices_b

1343: END IF;
1344:
1345:
1346: IF (x_return_status <> 'S' ) THEN
1347: UPDATE okl_trx_ar_invoices_b
1348: SET trx_status_code = 'ERROR'
1349: WHERE id = lx_taiv_rec.id;
1350: FND_FILE.PUT_LINE (FND_FILE.LOG, 'ERROR Creating Billing Transactions.');
1351: ELSE

Line 1452: UPDATE okl_trx_ar_invoices_b

1448: END IF;
1449:
1450:
1451: IF (x_return_status <> 'S' ) THEN
1452: UPDATE okl_trx_ar_invoices_b
1453: SET trx_status_code = 'ERROR'
1454: WHERE id = lx_taiv_rec.id;
1455: FND_FILE.PUT_LINE (FND_FILE.LOG, 'ERROR Creating Billing Transactions.');
1456: ELSE

Line 2205: UPDATE okl_trx_ar_invoices_b

2201: END IF;
2202:
2203:
2204: IF (x_return_status <> 'S' ) THEN
2205: UPDATE okl_trx_ar_invoices_b
2206: SET trx_status_code = 'ERROR'
2207: WHERE id = lx_taiv_rec.id;
2208: FND_FILE.PUT_LINE (FND_FILE.LOG, 'ERROR Creating Accounting Distributions.');
2209: ELSE

Line 2223: UPDATE okl_trx_ar_invoices_b

2219: FOR j in err_tbl.FIRST..err_tbl.LAST LOOP
2220: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Reversing Invoice for '||err_tbl(j).amount);
2221:
2222:
2223: UPDATE okl_trx_ar_invoices_b
2224: SET trx_status_code = 'ERROR'
2225: WHERE id = err_tbl(j).tai_id;
2226: END LOOP;
2227: END IF;

Line 2450: UPDATE okl_trx_ar_invoices_b

2446: ||err_tbl(j).amount);
2447: END IF;
2448:
2449:
2450: UPDATE okl_trx_ar_invoices_b
2451: SET trx_status_code = 'ERROR'
2452: WHERE id = err_tbl(j).tai_id;
2453: END LOOP;
2454: END IF;

Line 2457: --UPDATE okl_trx_ar_invoices_b

2453: END LOOP;
2454: END IF;
2455:
2456:
2457: --UPDATE okl_trx_ar_invoices_b
2458: --SET trx_status_code = 'ERROR'
2459: --WHERE id = x_taiv_rec.id;
2460: --FND_FILE.PUT_LINE (FND_FILE.LOG, 'ERROR Creating Accounting Distributions.');
2461: ELSE

Line 2479: UPDATE okl_trx_ar_invoices_b

2475: ||err_tbl(j).amount);
2476: END IF;
2477:
2478:
2479: UPDATE okl_trx_ar_invoices_b
2480: SET trx_status_code = 'ERROR'
2481: WHERE id = err_tbl(j).tai_id;
2482: END LOOP;
2483: END IF;

Line 2783: UPDATE okl_trx_ar_invoices_b

2779: END IF;
2780:
2781:
2782: IF (x_return_status <> 'S' ) THEN
2783: UPDATE okl_trx_ar_invoices_b
2784: SET trx_status_code = 'ERROR'
2785: WHERE id = lx_taiv_rec.id;
2786: FND_FILE.PUT_LINE (FND_FILE.LOG, 'ERROR Creating Billing Transactions.');
2787: END IF;

Line 2884: UPDATE okl_trx_ar_invoices_b

2880: END IF;
2881:
2882:
2883: IF (x_return_status <> 'S' ) THEN
2884: UPDATE okl_trx_ar_invoices_b
2885: SET trx_status_code = 'ERROR'
2886: WHERE id = lx_taiv_rec.id;
2887: FND_FILE.PUT_LINE (FND_FILE.LOG, 'ERROR Creating Billing Transactions');
2888: END IF;