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.35.12020000.2 2012/07/24 15:13:40 vkinduri ship $ */
3:
4:
5: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('GMP_DEBUG_ENABLED'),'N'); -- BUG: 9366921

Line 154: gmp_debug_message(' Into GMP_PLNG_DTL_REPORT_PKG.create_pdr ');

150: AND (C_plan_org = -999 or C_plan_org = organization_id ) ;
151:
152: BEGIN
153:
154: gmp_debug_message(' Into GMP_PLNG_DTL_REPORT_PKG.create_pdr ');
155:
156: split_report := NVL(FND_PROFILE.VALUE('GMP_SPLIT_PDR_BY_ORGANIZATION'),'N'); -- Bug: 9458217 Vpedarla
157:
158: scale_report := NVL(FND_PROFILE.VALUE('GMP_SCALE_PDR'),'N'); -- Bug: 9265463 Vpedarla

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

288: end if;
289: -- Bug: 8363786 Vpedarla end
290:
291:
292: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' Calling GMP_PLNG_DTL_REPORT_PKG with values ');
293: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_inst_id '||to_char(G_inst_id));
294: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_org_id '||to_char(G_org_id));
295: -- FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_name '||G_plan_name);
296: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_plan_id '||to_char(G_plan_id));

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

444:
445:
446: EXCEPTION
447: WHEN OTHERS THEN
448: FND_FILE.PUT_LINE ( FND_FILE.LOG,' Error in package GMP_PLNG_DTL_REPORT_PKG.CREATE_PDR - '|| sqlerrm);
449: RAISE;
450: END create_pdr;
451:
452: PROCEDURE validate_parameters IS

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

672: dbms_sql.close_cursor (cur_item);
673:
674: EXCEPTION
675: WHEN OTHERS THEN
676: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in package GMP_PLNG_DTL_REPORT_PKG '||sqlerrm);
677: IF dbms_sql.is_open (cur_item) THEN
678: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION cur_item is Open');
679: dbms_sql.close_cursor (cur_item);
680: END IF;

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

1215: G_header_stmt := ' SELECT ' ||
1216: ' msc_get_name.org_code ('||G_org_id||', '||G_inst_id||' ) master_org, '||
1217: ' msc_get_name.instance_code ('||G_inst_id||' ) instance_code, '||
1218: -- ''''||G_plan_name||''''||' plan_name, ' ||
1219: ' gmp_plng_dtl_report_pkg.plan_name plan_name, '||
1220: ' gmp_plng_dtl_report_pkg.plan_org ('||G_plan_org||' ) plan_org, '||
1221: G_day_bucket||' day_bucket, '||
1222: G_week_bucket||' week_bucket, '||
1223: G_period_bucket||' period_bucket, ';

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

1216: ' msc_get_name.org_code ('||G_org_id||', '||G_inst_id||' ) master_org, '||
1217: ' msc_get_name.instance_code ('||G_inst_id||' ) instance_code, '||
1218: -- ''''||G_plan_name||''''||' plan_name, ' ||
1219: ' gmp_plng_dtl_report_pkg.plan_name plan_name, '||
1220: ' gmp_plng_dtl_report_pkg.plan_org ('||G_plan_org||' ) plan_org, '||
1221: G_day_bucket||' day_bucket, '||
1222: G_week_bucket||' week_bucket, '||
1223: G_period_bucket||' period_bucket, ';
1224:

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

1223: G_period_bucket||' period_bucket, ';
1224:
1225: IF G_fsort IS NOT NULL THEN
1226: G_header_stmt := G_header_stmt ||
1227: ' gmp_plng_dtl_report_pkg.lookup_meaning ('||''''||'GMP_DATA_SELECT'||''''||', '||G_fsort||' ) first_sort, ';
1228: ELSE
1229: G_header_stmt := G_header_stmt ||
1230: ''''||G_fsort||''''||' first_sort, ';
1231: END IF;

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

1231: END IF;
1232:
1233: IF G_ssort IS NOT NULL THEN
1234: G_header_stmt := G_header_stmt ||
1235: ' gmp_plng_dtl_report_pkg.lookup_meaning ('||''''||'GMP_DATA_SELECT'||''''||', '||G_ssort||' ) second_sort, ';
1236: ELSE
1237: G_header_stmt := G_header_stmt ||
1238: ''''||G_ssort||''''||' second_sort, ';
1239: END IF;

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

1239: END IF;
1240:
1241: IF G_tsort IS NOT NULL THEN
1242: G_header_stmt := G_header_stmt ||
1243: ' gmp_plng_dtl_report_pkg.lookup_meaning ('||''''||'GMP_DATA_SELECT'||''''||', '||G_tsort||' ) third_sort, ';
1244: ELSE
1245: G_header_stmt := G_header_stmt ||
1246: ''''||G_tsort||''''||' third_sort, ' ;
1247: END IF;

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

1264: ''''||G_byr_low||''''||' buyer_low, ' ||
1265: ''''||G_byr_high||''''||' buyer_high, ' ||
1266: ''''||G_itm_low||''''||' item_low, ' ||
1267: ''''||G_itm_high||''''||' item_high, ' ||
1268: ' gmp_plng_dtl_report_pkg.category_set_name ('||G_cat_set_id||' ) category_set_name, '||
1269: /* ToDo : define the function category_set_name */
1270: ''''||G_category_low||''''||' category_low, ' ||
1271: ''''||G_category_high||''''||' category_high, ' ||
1272: ''''||G_abc_class_low||''''||' abc_class_low, ' ||

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

2043: END LOOP;
2044: gmp_debug_message(' xml_transfer end of loop '|| to_char(sysdate, 'hh24:mi:ss'));
2045: EXCEPTION
2046: WHEN OTHERS THEN
2047: FND_FILE.PUT_LINE ( FND_FILE.LOG, 'Exception in procedure gmp_plng_dtl_report_pkg.xml_transfer '||SQLERRM);
2048: END;
2049:
2050: /*
2051: REM+=========================================================================+

Line 2067: END GMP_PLNG_DTL_REPORT_PKG;

2063: FND_FILE.PUT_LINE ( FND_FILE.LOG,pBUFF);
2064: END IF;
2065: END gmp_debug_message;
2066:
2067: END GMP_PLNG_DTL_REPORT_PKG;
2068: