eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_AR_IMPORT_POPU_PKG dependencies on JAI_AR_IMPORT_POPU_PKG

Line 1: PACKAGE BODY JAI_AR_IMPORT_POPU_PKG AS

1: PACKAGE BODY JAI_AR_IMPORT_POPU_PKG AS
2: /* $Header: jai_ar_import_popu.plb 120.7.12020000.1 2013/03/12 07:16:31 appldev noship $ */
3:
4:
5: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 12: G_MODULE_NAME CONSTANT VARCHAR2(40) := 'JAI.PLSQL.JAI_AR_IMPORT_POPU_PKG.';

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

Line 13: G_PKG_NAME CONSTANT VARCHAR2(30) := 'JAI_AR_IMPORT_POPU_PKG';

9: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
12: G_MODULE_NAME CONSTANT VARCHAR2(40) := 'JAI.PLSQL.JAI_AR_IMPORT_POPU_PKG.';
13: G_PKG_NAME CONSTANT VARCHAR2(30) := 'JAI_AR_IMPORT_POPU_PKG';
14:
15:
16:
17: procedure process_order(pr_old t_rec%type ,

Line 2961: pv_return_message := 'Encountered an error in JAI_AR_IMPORT_POPU_PKG.PROCESS_ORDER ' || lv_return_message;

2957: end if;
2958: EXCEPTION
2959: when le_error then
2960: pv_return_code := jai_constants.unexpected_error;
2961: pv_return_message := 'Encountered an error in JAI_AR_IMPORT_POPU_PKG.PROCESS_ORDER ' || lv_return_message;
2962: fnd_file.put_line(FND_FILE.LOG,'Encountered an error in JAI_AR_IMPORT_POPU_PKG.PROCESS_ORDER ' || lv_return_message);
2963: WHEN OTHERS THEN
2964: pv_return_code := jai_constants.unexpected_error;
2965: pv_return_message := 'Encountered an error in JAI_AR_IMPORT_POPU_PKG.PROCESS_ORDER ' || substr(sqlerrm,1,1900);

Line 2962: fnd_file.put_line(FND_FILE.LOG,'Encountered an error in JAI_AR_IMPORT_POPU_PKG.PROCESS_ORDER ' || lv_return_message);

2958: EXCEPTION
2959: when le_error then
2960: pv_return_code := jai_constants.unexpected_error;
2961: pv_return_message := 'Encountered an error in JAI_AR_IMPORT_POPU_PKG.PROCESS_ORDER ' || lv_return_message;
2962: fnd_file.put_line(FND_FILE.LOG,'Encountered an error in JAI_AR_IMPORT_POPU_PKG.PROCESS_ORDER ' || lv_return_message);
2963: WHEN OTHERS THEN
2964: pv_return_code := jai_constants.unexpected_error;
2965: pv_return_message := 'Encountered an error in JAI_AR_IMPORT_POPU_PKG.PROCESS_ORDER ' || substr(sqlerrm,1,1900);
2966: fnd_file.put_line(FND_FILE.LOG,'Encountered an error in JAI_AR_IMPORT_POPU_PKG.PROCESS_ORDER ' || substr(sqlerrm,1,1900));

Line 2965: pv_return_message := 'Encountered an error in JAI_AR_IMPORT_POPU_PKG.PROCESS_ORDER ' || substr(sqlerrm,1,1900);

2961: pv_return_message := 'Encountered an error in JAI_AR_IMPORT_POPU_PKG.PROCESS_ORDER ' || lv_return_message;
2962: fnd_file.put_line(FND_FILE.LOG,'Encountered an error in JAI_AR_IMPORT_POPU_PKG.PROCESS_ORDER ' || lv_return_message);
2963: WHEN OTHERS THEN
2964: pv_return_code := jai_constants.unexpected_error;
2965: pv_return_message := 'Encountered an error in JAI_AR_IMPORT_POPU_PKG.PROCESS_ORDER ' || substr(sqlerrm,1,1900);
2966: fnd_file.put_line(FND_FILE.LOG,'Encountered an error in JAI_AR_IMPORT_POPU_PKG.PROCESS_ORDER ' || substr(sqlerrm,1,1900));
2967:
2968: end process_order;
2969:

Line 2966: fnd_file.put_line(FND_FILE.LOG,'Encountered an error in JAI_AR_IMPORT_POPU_PKG.PROCESS_ORDER ' || substr(sqlerrm,1,1900));

2962: fnd_file.put_line(FND_FILE.LOG,'Encountered an error in JAI_AR_IMPORT_POPU_PKG.PROCESS_ORDER ' || lv_return_message);
2963: WHEN OTHERS THEN
2964: pv_return_code := jai_constants.unexpected_error;
2965: pv_return_message := 'Encountered an error in JAI_AR_IMPORT_POPU_PKG.PROCESS_ORDER ' || substr(sqlerrm,1,1900);
2966: fnd_file.put_line(FND_FILE.LOG,'Encountered an error in JAI_AR_IMPORT_POPU_PKG.PROCESS_ORDER ' || substr(sqlerrm,1,1900));
2967:
2968: end process_order;
2969:
2970: procedure process_supplement(

Line 4265: pv_return_message := 'Encountered an error in JAI_AR_IMPORT_POPU_PKG.PROCESS_SUPPLEMENT ' || lv_return_message;

4261: END IF;
4262: EXCEPTION
4263: when le_error then
4264: pv_return_code := jai_constants.unexpected_error;
4265: pv_return_message := 'Encountered an error in JAI_AR_IMPORT_POPU_PKG.PROCESS_SUPPLEMENT ' || lv_return_message;
4266: fnd_file.put_line(FND_FILE.LOG,'Encountered an error in JAI_AR_IMPORT_POPU_PKG.PROCESS_SUPPLEMENT ' || lv_return_message);
4267: WHEN OTHERS THEN
4268: pv_return_code := jai_constants.unexpected_error;
4269: pv_return_message := 'Encountered an error in JAI_AR_IMPORT_POPU_PKG.PROCESS_SUPPLEMENT ' || substr(sqlerrm,1,1900);

Line 4266: fnd_file.put_line(FND_FILE.LOG,'Encountered an error in JAI_AR_IMPORT_POPU_PKG.PROCESS_SUPPLEMENT ' || lv_return_message);

4262: EXCEPTION
4263: when le_error then
4264: pv_return_code := jai_constants.unexpected_error;
4265: pv_return_message := 'Encountered an error in JAI_AR_IMPORT_POPU_PKG.PROCESS_SUPPLEMENT ' || lv_return_message;
4266: fnd_file.put_line(FND_FILE.LOG,'Encountered an error in JAI_AR_IMPORT_POPU_PKG.PROCESS_SUPPLEMENT ' || lv_return_message);
4267: WHEN OTHERS THEN
4268: pv_return_code := jai_constants.unexpected_error;
4269: pv_return_message := 'Encountered an error in JAI_AR_IMPORT_POPU_PKG.PROCESS_SUPPLEMENT ' || substr(sqlerrm,1,1900);
4270: fnd_file.put_line(FND_FILE.LOG,'Encountered an error in JAI_AR_IMPORT_POPU_PKG.PROCESS_SUPPLEMENT ' || substr(sqlerrm,1,1900));

Line 4269: pv_return_message := 'Encountered an error in JAI_AR_IMPORT_POPU_PKG.PROCESS_SUPPLEMENT ' || substr(sqlerrm,1,1900);

4265: pv_return_message := 'Encountered an error in JAI_AR_IMPORT_POPU_PKG.PROCESS_SUPPLEMENT ' || lv_return_message;
4266: fnd_file.put_line(FND_FILE.LOG,'Encountered an error in JAI_AR_IMPORT_POPU_PKG.PROCESS_SUPPLEMENT ' || lv_return_message);
4267: WHEN OTHERS THEN
4268: pv_return_code := jai_constants.unexpected_error;
4269: pv_return_message := 'Encountered an error in JAI_AR_IMPORT_POPU_PKG.PROCESS_SUPPLEMENT ' || substr(sqlerrm,1,1900);
4270: fnd_file.put_line(FND_FILE.LOG,'Encountered an error in JAI_AR_IMPORT_POPU_PKG.PROCESS_SUPPLEMENT ' || substr(sqlerrm,1,1900));
4271:
4272: end process_supplement;
4273:

Line 4270: fnd_file.put_line(FND_FILE.LOG,'Encountered an error in JAI_AR_IMPORT_POPU_PKG.PROCESS_SUPPLEMENT ' || substr(sqlerrm,1,1900));

4266: fnd_file.put_line(FND_FILE.LOG,'Encountered an error in JAI_AR_IMPORT_POPU_PKG.PROCESS_SUPPLEMENT ' || lv_return_message);
4267: WHEN OTHERS THEN
4268: pv_return_code := jai_constants.unexpected_error;
4269: pv_return_message := 'Encountered an error in JAI_AR_IMPORT_POPU_PKG.PROCESS_SUPPLEMENT ' || substr(sqlerrm,1,1900);
4270: fnd_file.put_line(FND_FILE.LOG,'Encountered an error in JAI_AR_IMPORT_POPU_PKG.PROCESS_SUPPLEMENT ' || substr(sqlerrm,1,1900));
4271:
4272: end process_supplement;
4273:
4274: /*

Line 4735: Pv_return_message := 'Encountered an error in JAI_AR_IMPORT_POPU_PKG.POP_JAI_INV_AND_SUPPL ' || lv_return_message;

4731: end if;
4732: EXCEPTION
4733: WHEN le_error then
4734: Pv_return_code := jai_constants.unexpected_error;
4735: Pv_return_message := 'Encountered an error in JAI_AR_IMPORT_POPU_PKG.POP_JAI_INV_AND_SUPPL ' || lv_return_message;
4736: fnd_file.put_line(FND_FILE.LOG,'Encountered an error in JAI_AR_IMPORT_POPU_PKG.POP_JAI_INV_AND_SUPPL ' || lv_return_message);
4737: WHEN OTHERS THEN
4738: vsqlerrm := SQLERRM;
4739:

Line 4736: fnd_file.put_line(FND_FILE.LOG,'Encountered an error in JAI_AR_IMPORT_POPU_PKG.POP_JAI_INV_AND_SUPPL ' || lv_return_message);

4732: EXCEPTION
4733: WHEN le_error then
4734: Pv_return_code := jai_constants.unexpected_error;
4735: Pv_return_message := 'Encountered an error in JAI_AR_IMPORT_POPU_PKG.POP_JAI_INV_AND_SUPPL ' || lv_return_message;
4736: fnd_file.put_line(FND_FILE.LOG,'Encountered an error in JAI_AR_IMPORT_POPU_PKG.POP_JAI_INV_AND_SUPPL ' || lv_return_message);
4737: WHEN OTHERS THEN
4738: vsqlerrm := SQLERRM;
4739:
4740:

Line 4742: Pv_return_message := 'Encountered an error in JAI_AR_IMPORT_POPU_PKG.POP_JAI_INV_AND_SUPPL ' || substr(sqlerrm,1,1900);

4738: vsqlerrm := SQLERRM;
4739:
4740:
4741: Pv_return_code := jai_constants.unexpected_error;
4742: Pv_return_message := 'Encountered an error in JAI_AR_IMPORT_POPU_PKG.POP_JAI_INV_AND_SUPPL ' || substr(sqlerrm,1,1900);
4743: fnd_file.put_line(FND_FILE.LOG,'Encountered an error in JAI_AR_IMPORT_POPU_PKG.POP_JAI_INV_AND_SUPPL ' || substr(sqlerrm,1,1900));
4744:
4745: /*lv_appl_src := 'JA_IN_OE_AR_LINES_INSERT_TRG' ;
4746: lv_err_msg := 'EXCEPTION Occured' ;

Line 4743: fnd_file.put_line(FND_FILE.LOG,'Encountered an error in JAI_AR_IMPORT_POPU_PKG.POP_JAI_INV_AND_SUPPL ' || substr(sqlerrm,1,1900));

4739:
4740:
4741: Pv_return_code := jai_constants.unexpected_error;
4742: Pv_return_message := 'Encountered an error in JAI_AR_IMPORT_POPU_PKG.POP_JAI_INV_AND_SUPPL ' || substr(sqlerrm,1,1900);
4743: fnd_file.put_line(FND_FILE.LOG,'Encountered an error in JAI_AR_IMPORT_POPU_PKG.POP_JAI_INV_AND_SUPPL ' || substr(sqlerrm,1,1900));
4744:
4745: /*lv_appl_src := 'JA_IN_OE_AR_LINES_INSERT_TRG' ;
4746: lv_err_msg := 'EXCEPTION Occured' ;
4747:

Line 6217: Pv_return_message := 'Encountered an error in JAI_AR_IMPORT_POPU_PKG.POP_JAI_RMACM ' || lv_return_message;

6213:
6214: EXCEPTION
6215: WHEN le_error then
6216: Pv_return_code := jai_constants.unexpected_error;
6217: Pv_return_message := 'Encountered an error in JAI_AR_IMPORT_POPU_PKG.POP_JAI_RMACM ' || lv_return_message;
6218: fnd_file.put_line(FND_FILE.LOG,'Encountered an error in JAI_AR_IMPORT_POPU_PKG.POP_JAI_RMACM ' || lv_return_message);
6219:
6220: WHEN OTHERS THEN
6221: Pv_return_code := jai_constants.unexpected_error;

Line 6218: fnd_file.put_line(FND_FILE.LOG,'Encountered an error in JAI_AR_IMPORT_POPU_PKG.POP_JAI_RMACM ' || lv_return_message);

6214: EXCEPTION
6215: WHEN le_error then
6216: Pv_return_code := jai_constants.unexpected_error;
6217: Pv_return_message := 'Encountered an error in JAI_AR_IMPORT_POPU_PKG.POP_JAI_RMACM ' || lv_return_message;
6218: fnd_file.put_line(FND_FILE.LOG,'Encountered an error in JAI_AR_IMPORT_POPU_PKG.POP_JAI_RMACM ' || lv_return_message);
6219:
6220: WHEN OTHERS THEN
6221: Pv_return_code := jai_constants.unexpected_error;
6222: Pv_return_message := 'Encountered an error in JAI_AR_IMPORT_POPU_PKG.POP_JAI_RMACM ' || substr(sqlerrm,1,1900);

Line 6222: Pv_return_message := 'Encountered an error in JAI_AR_IMPORT_POPU_PKG.POP_JAI_RMACM ' || substr(sqlerrm,1,1900);

6218: fnd_file.put_line(FND_FILE.LOG,'Encountered an error in JAI_AR_IMPORT_POPU_PKG.POP_JAI_RMACM ' || lv_return_message);
6219:
6220: WHEN OTHERS THEN
6221: Pv_return_code := jai_constants.unexpected_error;
6222: Pv_return_message := 'Encountered an error in JAI_AR_IMPORT_POPU_PKG.POP_JAI_RMACM ' || substr(sqlerrm,1,1900);
6223: fnd_file.put_line(FND_FILE.LOG,'Encountered an error in JAI_AR_IMPORT_POPU_PKG.POP_JAI_RMACM ' || substr(sqlerrm,1,1900));
6224: END pop_jai_rmacm ;
6225:
6226:

Line 6223: fnd_file.put_line(FND_FILE.LOG,'Encountered an error in JAI_AR_IMPORT_POPU_PKG.POP_JAI_RMACM ' || substr(sqlerrm,1,1900));

6219:
6220: WHEN OTHERS THEN
6221: Pv_return_code := jai_constants.unexpected_error;
6222: Pv_return_message := 'Encountered an error in JAI_AR_IMPORT_POPU_PKG.POP_JAI_RMACM ' || substr(sqlerrm,1,1900);
6223: fnd_file.put_line(FND_FILE.LOG,'Encountered an error in JAI_AR_IMPORT_POPU_PKG.POP_JAI_RMACM ' || substr(sqlerrm,1,1900));
6224: END pop_jai_rmacm ;
6225:
6226:
6227:

Line 6697: pv_err_msg := 'Encountered an error in JAI_AR_IMPORT_POPU_PKG.import_project_taxes ' || lv_return_message;

6693: --Added by Zhiwei for ZX prototype begin
6694: EXCEPTION
6695: WHEN le_error then
6696: pv_err_flg := jai_constants.unexpected_error;
6697: pv_err_msg := 'Encountered an error in JAI_AR_IMPORT_POPU_PKG.import_project_taxes ' || lv_return_message;
6698: fnd_file.put_line(FND_FILE.LOG,'Encountered an error in JAI_AR_IMPORT_POPU_PKG.import_project_taxes ' || lv_return_message);
6699:
6700: WHEN OTHERS THEN
6701: pv_err_flg := jai_constants.unexpected_error;

Line 6698: fnd_file.put_line(FND_FILE.LOG,'Encountered an error in JAI_AR_IMPORT_POPU_PKG.import_project_taxes ' || lv_return_message);

6694: EXCEPTION
6695: WHEN le_error then
6696: pv_err_flg := jai_constants.unexpected_error;
6697: pv_err_msg := 'Encountered an error in JAI_AR_IMPORT_POPU_PKG.import_project_taxes ' || lv_return_message;
6698: fnd_file.put_line(FND_FILE.LOG,'Encountered an error in JAI_AR_IMPORT_POPU_PKG.import_project_taxes ' || lv_return_message);
6699:
6700: WHEN OTHERS THEN
6701: pv_err_flg := jai_constants.unexpected_error;
6702: pv_err_msg := 'Encountered an error in JAI_AR_IMPORT_POPU_PKG.import_project_taxes ' || substr(sqlerrm,1,1900);

Line 6702: pv_err_msg := 'Encountered an error in JAI_AR_IMPORT_POPU_PKG.import_project_taxes ' || substr(sqlerrm,1,1900);

6698: fnd_file.put_line(FND_FILE.LOG,'Encountered an error in JAI_AR_IMPORT_POPU_PKG.import_project_taxes ' || lv_return_message);
6699:
6700: WHEN OTHERS THEN
6701: pv_err_flg := jai_constants.unexpected_error;
6702: pv_err_msg := 'Encountered an error in JAI_AR_IMPORT_POPU_PKG.import_project_taxes ' || substr(sqlerrm,1,1900);
6703: fnd_file.put_line(FND_FILE.LOG,'Encountered an error in JAI_AR_IMPORT_POPU_PKG.import_project_taxes ' || substr(sqlerrm,1,1900));
6704:
6705: --Added by Zhiwei for ZX prototype end
6706:

Line 6703: fnd_file.put_line(FND_FILE.LOG,'Encountered an error in JAI_AR_IMPORT_POPU_PKG.import_project_taxes ' || substr(sqlerrm,1,1900));

6699:
6700: WHEN OTHERS THEN
6701: pv_err_flg := jai_constants.unexpected_error;
6702: pv_err_msg := 'Encountered an error in JAI_AR_IMPORT_POPU_PKG.import_project_taxes ' || substr(sqlerrm,1,1900);
6703: fnd_file.put_line(FND_FILE.LOG,'Encountered an error in JAI_AR_IMPORT_POPU_PKG.import_project_taxes ' || substr(sqlerrm,1,1900));
6704:
6705: --Added by Zhiwei for ZX prototype end
6706:
6707: end import_projects_taxes;

Line 6876: END JAI_AR_IMPORT_POPU_PKG;

6872: return v_service_type;
6873:
6874: END;
6875:
6876: END JAI_AR_IMPORT_POPU_PKG;