APPS.JAI_AR_IMPORT_SYNC_PKG dependencies on JAI_AR_IMPORT_SYNC_PKG

Line 1: PACKAGE BODY JAI_AR_IMPORT_SYNC_PKG AS

1: PACKAGE BODY JAI_AR_IMPORT_SYNC_PKG AS
2: /* $Header: jai_ar_import_sync.plb 120.4.12020000.1 2013/03/12 07:15:13 appldev noship $ */
3:
4: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

Line 11: G_MODULE_NAME CONSTANT VARCHAR2(40) := 'JAI.PLSQL.JAI_AR_IMPORT_SYNC_PKG.';

7: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
8: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
9: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
10: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
11: G_MODULE_NAME CONSTANT VARCHAR2(40) := 'JAI.PLSQL.JAI_AR_IMPORT_SYNC_PKG.';
12: G_PKG_NAME CONSTANT VARCHAR2(30) := 'JAI_AR_IMPORT_SYNC_PKG';
13:
14:
15: /*

Line 12: G_PKG_NAME CONSTANT VARCHAR2(30) := 'JAI_AR_IMPORT_SYNC_PKG';

8: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
9: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
10: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
11: G_MODULE_NAME CONSTANT VARCHAR2(40) := 'JAI.PLSQL.JAI_AR_IMPORT_SYNC_PKG.';
12: G_PKG_NAME CONSTANT VARCHAR2(30) := 'JAI_AR_IMPORT_SYNC_PKG';
13:
14:
15: /*
16: || foll function created by csahoo - for seperate vat invoice num for unreg dealers

Line 291: Pv_return_message := 'Encountered an error in JAI_AR_IMPORT_SYNC_PKG.GEN_VAT_FOR_INV ' || substr(sqlerrm,1,1900);

287:
288: EXCEPTION
289: WHEN OTHERS THEN
290: Pv_return_code := jai_constants.unexpected_error;
291: Pv_return_message := 'Encountered an error in JAI_AR_IMPORT_SYNC_PKG.GEN_VAT_FOR_INV ' || substr(sqlerrm,1,1900);
292: END gen_vat_for_inv ;
293:
294: /*
295: REM +======================================================================+

Line 566: Pv_return_message := 'Encountered an error in JAI_AR_IMPORT_SYNC_PKG.UPDATE_TRX_NUMBER ' || substr(sqlerrm,1,1900);

562:
563: EXCEPTION
564: WHEN OTHERS THEN
565: Pv_return_code := jai_constants.unexpected_error;
566: Pv_return_message := 'Encountered an error in JAI_AR_IMPORT_SYNC_PKG.UPDATE_TRX_NUMBER ' || substr(sqlerrm,1,1900);
567: END update_trx_number ;
568:
569: /*
570: REM +======================================================================+

Line 2033: Pv_return_message := 'Encountered an error in JAI_AR_IMPORT_SYNC_PKG.UPDATE_COMPLETE_FLAG ' || substr(sqlerrm,1,1900);

2029:
2030: EXCEPTION
2031: WHEN OTHERS THEN
2032: Pv_return_code := jai_constants.unexpected_error;
2033: Pv_return_message := 'Encountered an error in JAI_AR_IMPORT_SYNC_PKG.UPDATE_COMPLETE_FLAG ' || substr(sqlerrm,1,1900);
2034:
2035: END update_complete_flag ;
2036:
2037:

Line 2613: Pv_return_message := 'Encountered an error in JAI_AR_IMPORT_SYNC_PKG.PROCESS_CM_VAT_REPO ' || substr(sqlerrm,1,1900);

2609:
2610: EXCEPTION
2611: WHEN OTHERS THEN
2612: Pv_return_code := jai_constants.unexpected_error;
2613: Pv_return_message := 'Encountered an error in JAI_AR_IMPORT_SYNC_PKG.PROCESS_CM_VAT_REPO ' || substr(sqlerrm,1,1900);
2614:
2615: END process_cm_vat_repo ;
2616:
2617:

Line 2620: END JAI_AR_IMPORT_SYNC_PKG ;

2616:
2617:
2618:
2619:
2620: END JAI_AR_IMPORT_SYNC_PKG ;