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.JTF_TAE_GEN_PVT dependencies on JTF_TAE_GEN_PVT

Line 1: PACKAGE BODY jtf_tae_gen_pvt AS

1: PACKAGE BODY jtf_tae_gen_pvt AS
2: /* $Header: jtfvtaeb.pls 120.0 2005/06/02 18:22:34 appldev ship $ */
3: -- Start of Comments
4: -- ---------------------------------------------------
5: -- PACKAGE NAME: JTF_TAE_GEN_PVT

Line 5: -- PACKAGE NAME: JTF_TAE_GEN_PVT

1: PACKAGE BODY jtf_tae_gen_pvt AS
2: /* $Header: jtfvtaeb.pls 120.0 2005/06/02 18:22:34 appldev ship $ */
3: -- Start of Comments
4: -- ---------------------------------------------------
5: -- PACKAGE NAME: JTF_TAE_GEN_PVT
6: -- ---------------------------------------------------
7: -- PURPOSE
8: -- Joint task force core territory manager public api's.
9: -- This package is used to generate the complete territory

Line 143: Write_Log(1, 'INSIDE function JTF_TAE_GEN_PVT.build_predicate_for_operator: ' );

139:
140: BEGIN
141: --dbms_output.put_line('Inside Call_Create_Package PACKAGE_NAME - ' || 'x' || ' g_pointer - ' || to_char(g_pointer - 1) || 'x' || 'x');
142: IF G_Debug THEN
143: Write_Log(1, 'INSIDE function JTF_TAE_GEN_PVT.build_predicate_for_operator: ' );
144: END IF;
145:
146: l_result := op_common_where;
147:

Line 249: Write_Log(1, 'INSIDE PROCEDURE JTF_TAE_GEN_PVT.Call_Create_Package: PACKAGE_NAME = ' || package_name );

245: BEGIN
246:
247: --dbms_output.put_line('Inside Call_Create_Package PACKAGE_NAME - ' || package_name || ' g_pointer - ' || to_char(g_pointer - 1) || is_package_body || is_package_body);
248: IF G_Debug THEN
249: Write_Log(1, 'INSIDE PROCEDURE JTF_TAE_GEN_PVT.Call_Create_Package: PACKAGE_NAME = ' || package_name );
250: END IF;
251:
252: l_result := fnd_installation.get_app_info('FND',
253: l_status,

Line 310: Write_Log(1, 'INSIDE PROCEDURE JTF_TAE_GEN_PVT.generate_package_header: v_package_name = ' || v_package_name );

306:
307: v_package_name := LOWER(p_package_name);
308:
309: IF G_Debug THEN
310: Write_Log(1, 'INSIDE PROCEDURE JTF_TAE_GEN_PVT.generate_package_header: v_package_name = ' || v_package_name );
311: END IF;
312:
313: /* -- The description was commented out as part of AD_DDL error
314: -- that caused others exception.

Line 362: Write_Log(1, 'INSIDE PROCEDURE JTF_TAE_GEN_PVT.generate_end_of_package: v_package_name = ' || v_package_name );

358:
359: v_package_name := LOWER (p_package_name);
360:
361: IF G_Debug THEN
362: Write_Log(1, 'INSIDE PROCEDURE JTF_TAE_GEN_PVT.generate_end_of_package: v_package_name = ' || v_package_name );
363: END IF;
364:
365: Add_To_PackageTable (' ' );
366: Add_To_PackageTable ('END ' || v_package_name || ';');

Line 390: Write_Log(1, 'INSIDE PROCEDURE JTF_TAE_GEN_PVT.generate_end_of_procedure: p_procedure_name = ' || p_procedure_name );

386:
387: BEGIN
388:
389: IF G_Debug THEN
390: Write_Log(1, 'INSIDE PROCEDURE JTF_TAE_GEN_PVT.generate_end_of_procedure: p_procedure_name = ' || p_procedure_name );
391: END IF;
392:
393: lp_pkg_name := 'JTF_TAE_'|| TO_CHAR(ABS(p_source_id)) ||'_' || p_target_type || '_DYN';
394:

Line 465: Write_Log(1, 'INSIDE PROCEDURE JTF_TAE_GEN_PVT.generate_object_definition: procedure_name = ' || procedure_name );

461: IS
462: BEGIN
463:
464: IF G_Debug THEN
465: Write_Log(1, 'INSIDE PROCEDURE JTF_TAE_GEN_PVT.generate_object_definition: procedure_name = ' || procedure_name );
466: END IF;
467:
468: -- Generate procedure header and parameters in both spec and body
469: IF (procedure_type = 'P')

Line 3369: Write_Log(1, 'INSIDE PROCEDURE JTF_TAE_GEN_PVT.gen_terr_rules_recurse');

3365: BEGIN
3366: --dbms_output.put_line('gen_terr_rules_recurse.p_search_name: ' || p_search_name);
3367:
3368: IF G_Debug THEN
3369: Write_Log(1, 'INSIDE PROCEDURE JTF_TAE_GEN_PVT.gen_terr_rules_recurse');
3370: END IF;
3371:
3372: --dbms_output.put_line('Value of p_qualifier_type_id='|| l_indent||TO_CHAR(p_qualifier_type_id));
3373:

Line 3788: --dbms_output.put_line('JTF_TAE_GEN_PVT.generate_ap: BEGIN');

3784: l_Msg_Data VARCHAR2(2000);
3785:
3786: BEGIN
3787:
3788: --dbms_output.put_line('JTF_TAE_GEN_PVT.generate_ap: BEGIN');
3789: -- Initialize Global variables
3790:
3791: G_Debug := FALSE;
3792:

Line 3855: --dbms_output.put_line('JTF_TAE_GEN_PVT:' || num_of_combination);

3851: FROM jtf_tae_qual_products jtqp
3852: WHERE jtqp.source_id = p_source_id
3853: AND jtqp.trans_object_type_id = p_trans_object_type_id;
3854:
3855: --dbms_output.put_line('JTF_TAE_GEN_PVT:' || num_of_combination);
3856:
3857: EXCEPTION
3858: WHEN NO_DATA_FOUND THEN
3859: num_of_combination := 0;

Line 4051: -- dbms_output.put_line('JTF_TAE_GEN_PVT.generate_ap: BEGIN');

4047: l_Msg_Count NUMBER;
4048: l_Msg_Data VARCHAR2(2000);
4049:
4050: BEGIN
4051: -- dbms_output.put_line('JTF_TAE_GEN_PVT.generate_ap: BEGIN');
4052:
4053: -- Initialize Global variables
4054: G_Debug := FALSE;
4055:

Line 4118: --dbms_output.put_line('JTF_TAE_GEN_PVT:' || num_of_combination);

4114: FROM jtf_tae_qual_products jtqp
4115: WHERE jtqp.source_id = p_source_id
4116: AND jtqp.trans_object_type_id = p_trans_object_type_id;
4117:
4118: --dbms_output.put_line('JTF_TAE_GEN_PVT:' || num_of_combination);
4119:
4120: EXCEPTION
4121: WHEN NO_DATA_FOUND THEN
4122: num_of_combination := 0;

Line 4300: --dbms_output.put_line('JTF_TAE_GEN_PVT.generate_ap: BEGIN');

4296: l_Msg_Data VARCHAR2(2000);
4297:
4298: BEGIN
4299:
4300: --dbms_output.put_line('JTF_TAE_GEN_PVT.generate_ap: BEGIN');
4301: -- Initialize Global variables
4302:
4303: G_Debug := FALSE;
4304:

Line 4354: --dbms_output.put_line('JTF_TAE_GEN_PVT:' || num_of_combination);

4350: FROM jtf_tae_qual_products jtqp
4351: WHERE jtqp.source_id = p_source_id
4352: AND jtqp.trans_object_type_id = p_trans_object_type_id;
4353:
4354: --dbms_output.put_line('JTF_TAE_GEN_PVT:' || num_of_combination);
4355:
4356: EXCEPTION
4357: WHEN NO_DATA_FOUND THEN
4358: num_of_combination := 0;

Line 4557: --dbms_output.put_line('JTF_TAE_GEN_PVT.generate_ap: BEGIN');

4553: l_sc_Retcode VARCHAR2(10);
4554:
4555: BEGIN
4556:
4557: --dbms_output.put_line('JTF_TAE_GEN_PVT.generate_ap: BEGIN');
4558: -- Initialize Global variables
4559:
4560: G_Debug := FALSE;
4561:

Line 4649: --dbms_output.put_line('JTF_TAE_GEN_PVT:' || num_of_combination);

4645: FROM jtf_tae_qual_products jtqp
4646: WHERE jtqp.source_id = p_source_id
4647: AND jtqp.trans_object_type_id = p_trans_object_type_id;
4648:
4649: --dbms_output.put_line('JTF_TAE_GEN_PVT:' || num_of_combination);
4650:
4651: EXCEPTION
4652: WHEN NO_DATA_FOUND THEN
4653: num_of_combination := 0;

Line 4829: END JTF_TAE_GEN_PVT;

4825: ERRBUF := 'Program terminated with OTHERS exception. ' || SQLERRM;
4826: RETCODE := 2;
4827: END generate_api;
4828:
4829: END JTF_TAE_GEN_PVT;