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

Line 1: PACKAGE BODY GMP_PLNG_DTL_REPORT_PKG AS

1: PACKAGE BODY GMP_PLNG_DTL_REPORT_PKG AS
2: /* $Header: GMPPLDRB.pls 120.13.12010000.2 2008/11/01 21:31:25 rpatangy ship $ */
3:
4: G_inst_id NUMBER;
5: G_org_id NUMBER;

Line 119: FND_FILE.PUT_LINE ( FND_FILE.LOG, 'In GMP_PLNG_DTL_REPORT_PKG ');

115: p_act_pdr_locale IN VARCHAR2
116: ) IS
117: BEGIN
118:
119: FND_FILE.PUT_LINE ( FND_FILE.LOG, 'In GMP_PLNG_DTL_REPORT_PKG ');
120:
121: retcode := 0;
122: G_inst_id := p_inst_id ;
123: G_org_id := p_org_id ;

Line 167: FND_FILE.PUT_LINE ( FND_FILE.LOG, 'Calling GMP_PLNG_DTL_REPORT_PKG with values ');

163: G_act_pdr := NVL(p_act_pdr,2) ;
164: G_act_pdr_temp := p_act_pdr_temp ;
165: G_act_pdr_locale := p_act_pdr_locale ;
166:
167: FND_FILE.PUT_LINE ( FND_FILE.LOG, 'Calling GMP_PLNG_DTL_REPORT_PKG with values ');
168: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_inst_id '||to_char(G_inst_id));
169: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_org_id '||to_char(G_org_id));
170: -- FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_name '||G_plan_name);
171: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_id '||to_char(G_plan_id));

Line 265: FND_FILE.PUT_LINE ( FND_FILE.LOG,' Error in package GMP_PLNG_DTL_REPORT_PKG.CREATE_PDR - '|| sqlerrm);

261: generate_xml;
262: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' After generate_xml ');
263: EXCEPTION
264: WHEN OTHERS THEN
265: FND_FILE.PUT_LINE ( FND_FILE.LOG,' Error in package GMP_PLNG_DTL_REPORT_PKG.CREATE_PDR - '|| sqlerrm);
266: RAISE;
267: END create_pdr;
268:
269: PROCEDURE validate_parameters IS

Line 483: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in package GMP_PLNG_DTL_REPORT_PKG '||sqlerrm);

479: dbms_sql.close_cursor (cur_item);
480:
481: EXCEPTION
482: WHEN OTHERS THEN
483: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in package GMP_PLNG_DTL_REPORT_PKG '||sqlerrm);
484: IF dbms_sql.is_open (cur_item) THEN
485: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION cur_item is Open');
486: dbms_sql.close_cursor (cur_item);
487: END IF;

Line 1018: ' gmp_plng_dtl_report_pkg.plan_name plan_name, '||

1014: G_header_stmt := ' SELECT ' ||
1015: ' msc_get_name.org_code ('||G_org_id||', '||G_inst_id||' ) master_org, '||
1016: ' msc_get_name.instance_code ('||G_inst_id||' ) instance_code, '||
1017: -- ''''||G_plan_name||''''||' plan_name, ' ||
1018: ' gmp_plng_dtl_report_pkg.plan_name plan_name, '||
1019: ' gmp_plng_dtl_report_pkg.plan_org ('||G_plan_org||' ) plan_org, '||
1020: G_day_bucket||' day_bucket, '||
1021: G_week_bucket||' week_bucket, '||
1022: G_period_bucket||' period_bucket, ';

Line 1019: ' gmp_plng_dtl_report_pkg.plan_org ('||G_plan_org||' ) plan_org, '||

1015: ' msc_get_name.org_code ('||G_org_id||', '||G_inst_id||' ) master_org, '||
1016: ' msc_get_name.instance_code ('||G_inst_id||' ) instance_code, '||
1017: -- ''''||G_plan_name||''''||' plan_name, ' ||
1018: ' gmp_plng_dtl_report_pkg.plan_name plan_name, '||
1019: ' gmp_plng_dtl_report_pkg.plan_org ('||G_plan_org||' ) plan_org, '||
1020: G_day_bucket||' day_bucket, '||
1021: G_week_bucket||' week_bucket, '||
1022: G_period_bucket||' period_bucket, ';
1023:

Line 1026: ' gmp_plng_dtl_report_pkg.lookup_meaning ('||''''||'GMP_DATA_SELECT'||''''||', '||G_fsort||' ) first_sort, ';

1022: G_period_bucket||' period_bucket, ';
1023:
1024: IF G_fsort IS NOT NULL THEN
1025: G_header_stmt := G_header_stmt ||
1026: ' gmp_plng_dtl_report_pkg.lookup_meaning ('||''''||'GMP_DATA_SELECT'||''''||', '||G_fsort||' ) first_sort, ';
1027: ELSE
1028: G_header_stmt := G_header_stmt ||
1029: ''''||G_fsort||''''||' first_sort, ';
1030: END IF;

Line 1034: ' gmp_plng_dtl_report_pkg.lookup_meaning ('||''''||'GMP_DATA_SELECT'||''''||', '||G_ssort||' ) second_sort, ';

1030: END IF;
1031:
1032: IF G_ssort IS NOT NULL THEN
1033: G_header_stmt := G_header_stmt ||
1034: ' gmp_plng_dtl_report_pkg.lookup_meaning ('||''''||'GMP_DATA_SELECT'||''''||', '||G_ssort||' ) second_sort, ';
1035: ELSE
1036: G_header_stmt := G_header_stmt ||
1037: ''''||G_ssort||''''||' second_sort, ';
1038: END IF;

Line 1042: ' gmp_plng_dtl_report_pkg.lookup_meaning ('||''''||'GMP_DATA_SELECT'||''''||', '||G_tsort||' ) third_sort, ';

1038: END IF;
1039:
1040: IF G_tsort IS NOT NULL THEN
1041: G_header_stmt := G_header_stmt ||
1042: ' gmp_plng_dtl_report_pkg.lookup_meaning ('||''''||'GMP_DATA_SELECT'||''''||', '||G_tsort||' ) third_sort, ';
1043: ELSE
1044: G_header_stmt := G_header_stmt ||
1045: ''''||G_tsort||''''||' third_sort, ' ;
1046: END IF;

Line 1064: ' gmp_plng_dtl_report_pkg.category_set_name ('||G_cat_set_id||' ) category_set_name, '||

1060: ''''||G_byr_low||''''||' buyer_low, ' ||
1061: ''''||G_byr_high||''''||' buyer_high, ' ||
1062: ''''||G_itm_low||''''||' item_low, ' ||
1063: ''''||G_itm_high||''''||' item_high, ' ||
1064: ' gmp_plng_dtl_report_pkg.category_set_name ('||G_cat_set_id||' ) category_set_name, '||
1065: /* ToDo : define the function category_set_name */
1066: ''''||G_category_low||''''||' category_low, ' ||
1067: ''''||G_category_high||''''||' category_high, ' ||
1068: ''''||G_abc_class_low||''''||' abc_class_low, ' ||

Line 1665: FND_FILE.PUT_LINE ( FND_FILE.LOG, 'Exception in procedure gmp_plng_dtl_report_pkg.xml_transfer '||SQLERRM);

1661: END IF;
1662: END LOOP;
1663: EXCEPTION
1664: WHEN OTHERS THEN
1665: FND_FILE.PUT_LINE ( FND_FILE.LOG, 'Exception in procedure gmp_plng_dtl_report_pkg.xml_transfer '||SQLERRM);
1666: END;
1667:
1668:
1669: END GMP_PLNG_DTL_REPORT_PKG;

Line 1669: END GMP_PLNG_DTL_REPORT_PKG;

1665: FND_FILE.PUT_LINE ( FND_FILE.LOG, 'Exception in procedure gmp_plng_dtl_report_pkg.xml_transfer '||SQLERRM);
1666: END;
1667:
1668:
1669: END GMP_PLNG_DTL_REPORT_PKG;