120: END IF;
121: --ER6137652 End
122:
123: -- for debugging
124: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_mode to trigger: ' || p_mode);
125: FND_FILE.PUT_LINE(FND_FILE.LOG,'where clause:' || pwhereclause);
126: FND_FILE.PUT_LINE(FND_FILE.LOG,'orderby clause:' || orderbyclause);
127: FND_FILE.PUT_LINE(FND_FILE.LOG,'partselect :' || partselect);
128: FND_FILE.PUT_LINE(FND_FILE.LOG,'partgroupby:' || partgroupby);
121: --ER6137652 End
122:
123: -- for debugging
124: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_mode to trigger: ' || p_mode);
125: FND_FILE.PUT_LINE(FND_FILE.LOG,'where clause:' || pwhereclause);
126: FND_FILE.PUT_LINE(FND_FILE.LOG,'orderby clause:' || orderbyclause);
127: FND_FILE.PUT_LINE(FND_FILE.LOG,'partselect :' || partselect);
128: FND_FILE.PUT_LINE(FND_FILE.LOG,'partgroupby:' || partgroupby);
129: FND_FILE.PUT_LINE(FND_FILE.LOG,'amount type:' || p_amt_type);
122:
123: -- for debugging
124: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_mode to trigger: ' || p_mode);
125: FND_FILE.PUT_LINE(FND_FILE.LOG,'where clause:' || pwhereclause);
126: FND_FILE.PUT_LINE(FND_FILE.LOG,'orderby clause:' || orderbyclause);
127: FND_FILE.PUT_LINE(FND_FILE.LOG,'partselect :' || partselect);
128: FND_FILE.PUT_LINE(FND_FILE.LOG,'partgroupby:' || partgroupby);
129: FND_FILE.PUT_LINE(FND_FILE.LOG,'amount type:' || p_amt_type);
130:
123: -- for debugging
124: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_mode to trigger: ' || p_mode);
125: FND_FILE.PUT_LINE(FND_FILE.LOG,'where clause:' || pwhereclause);
126: FND_FILE.PUT_LINE(FND_FILE.LOG,'orderby clause:' || orderbyclause);
127: FND_FILE.PUT_LINE(FND_FILE.LOG,'partselect :' || partselect);
128: FND_FILE.PUT_LINE(FND_FILE.LOG,'partgroupby:' || partgroupby);
129: FND_FILE.PUT_LINE(FND_FILE.LOG,'amount type:' || p_amt_type);
130:
131: log(C_STATE_LEVEL, l_procedure_name, 'pwhereclause='||pwhereclause);
124: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_mode to trigger: ' || p_mode);
125: FND_FILE.PUT_LINE(FND_FILE.LOG,'where clause:' || pwhereclause);
126: FND_FILE.PUT_LINE(FND_FILE.LOG,'orderby clause:' || orderbyclause);
127: FND_FILE.PUT_LINE(FND_FILE.LOG,'partselect :' || partselect);
128: FND_FILE.PUT_LINE(FND_FILE.LOG,'partgroupby:' || partgroupby);
129: FND_FILE.PUT_LINE(FND_FILE.LOG,'amount type:' || p_amt_type);
130:
131: log(C_STATE_LEVEL, l_procedure_name, 'pwhereclause='||pwhereclause);
132: log(C_STATE_LEVEL, l_procedure_name, 'orderbyclause='||orderbyclause);
125: FND_FILE.PUT_LINE(FND_FILE.LOG,'where clause:' || pwhereclause);
126: FND_FILE.PUT_LINE(FND_FILE.LOG,'orderby clause:' || orderbyclause);
127: FND_FILE.PUT_LINE(FND_FILE.LOG,'partselect :' || partselect);
128: FND_FILE.PUT_LINE(FND_FILE.LOG,'partgroupby:' || partgroupby);
129: FND_FILE.PUT_LINE(FND_FILE.LOG,'amount type:' || p_amt_type);
130:
131: log(C_STATE_LEVEL, l_procedure_name, 'pwhereclause='||pwhereclause);
132: log(C_STATE_LEVEL, l_procedure_name, 'orderbyclause='||orderbyclause);
133: log(C_STATE_LEVEL, l_procedure_name, 'partselect='||partselect);