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.CTO_AUTO_DROPSHIP_PK dependencies on OE_DEBUG_PUB

Line 24: | - Replaced fnd_file with oe_debug_pub for consistency |

20: | Fixed Bug 2367220 |
21: | 17-DEC-2003 : Bugfix 3319313 |
22: | - fixed source code issue |
23: | - fixed OQ-CQ issue in the cursor |
24: | - Replaced fnd_file with oe_debug_pub for consistency |
25: | 01-Jun-2005 : Renga Kannan Added NOCOPY HINT for all out parameters.
26:
27: | 05-Jul-2005 : Renga Kannan Modified code for MOAC project
28: | |

Line 161: oe_debug_pub.add('l_source_code = '||lsourcecode);

157: RETCODE := 0;
158:
159: lSourceCode := FND_PROFILE.VALUE('ONT_SOURCE_CODE'); --bugfix 3319313
160: IF PG_DEBUG <> 0 THEN
161: oe_debug_pub.add('l_source_code = '||lsourcecode);
162: END IF;
163:
164: -- set the batch_id to the request_id
165: l_batch_id := FND_GLOBAL.CONC_REQUEST_ID;

Line 173: oe_debug_pub.add('+---------------------------------------------------------------------------+');

169:
170: -- for all the sales order lines (entered, booked )
171: -- Given parameters.
172: IF PG_DEBUG <> 0 THEN
173: oe_debug_pub.add('+---------------------------------------------------------------------------+');
174: oe_debug_pub.add('+------------------ Parameters passed into the procedure ------------------+');
175: oe_debug_pub.add('Sales order : '||p_sales_order );
176: oe_debug_pub.add('Sales Order Line ID[Model] : '||to_char(p_sales_order_line_id));
177: oe_debug_pub.add('Organization_id : '||p_organization_id);

Line 174: oe_debug_pub.add('+------------------ Parameters passed into the procedure ------------------+');

170: -- for all the sales order lines (entered, booked )
171: -- Given parameters.
172: IF PG_DEBUG <> 0 THEN
173: oe_debug_pub.add('+---------------------------------------------------------------------------+');
174: oe_debug_pub.add('+------------------ Parameters passed into the procedure ------------------+');
175: oe_debug_pub.add('Sales order : '||p_sales_order );
176: oe_debug_pub.add('Sales Order Line ID[Model] : '||to_char(p_sales_order_line_id));
177: oe_debug_pub.add('Organization_id : '||p_organization_id);
178: oe_debug_pub.add('Offset Days : '||to_char(p_offset_days));

Line 175: oe_debug_pub.add('Sales order : '||p_sales_order );

171: -- Given parameters.
172: IF PG_DEBUG <> 0 THEN
173: oe_debug_pub.add('+---------------------------------------------------------------------------+');
174: oe_debug_pub.add('+------------------ Parameters passed into the procedure ------------------+');
175: oe_debug_pub.add('Sales order : '||p_sales_order );
176: oe_debug_pub.add('Sales Order Line ID[Model] : '||to_char(p_sales_order_line_id));
177: oe_debug_pub.add('Organization_id : '||p_organization_id);
178: oe_debug_pub.add('Offset Days : '||to_char(p_offset_days));
179: oe_debug_pub.add('+---------------------------------------------------------------------------+');

Line 176: oe_debug_pub.add('Sales Order Line ID[Model] : '||to_char(p_sales_order_line_id));

172: IF PG_DEBUG <> 0 THEN
173: oe_debug_pub.add('+---------------------------------------------------------------------------+');
174: oe_debug_pub.add('+------------------ Parameters passed into the procedure ------------------+');
175: oe_debug_pub.add('Sales order : '||p_sales_order );
176: oe_debug_pub.add('Sales Order Line ID[Model] : '||to_char(p_sales_order_line_id));
177: oe_debug_pub.add('Organization_id : '||p_organization_id);
178: oe_debug_pub.add('Offset Days : '||to_char(p_offset_days));
179: oe_debug_pub.add('+---------------------------------------------------------------------------+');
180: END IF;

Line 177: oe_debug_pub.add('Organization_id : '||p_organization_id);

173: oe_debug_pub.add('+---------------------------------------------------------------------------+');
174: oe_debug_pub.add('+------------------ Parameters passed into the procedure ------------------+');
175: oe_debug_pub.add('Sales order : '||p_sales_order );
176: oe_debug_pub.add('Sales Order Line ID[Model] : '||to_char(p_sales_order_line_id));
177: oe_debug_pub.add('Organization_id : '||p_organization_id);
178: oe_debug_pub.add('Offset Days : '||to_char(p_offset_days));
179: oe_debug_pub.add('+---------------------------------------------------------------------------+');
180: END IF;
181:

Line 178: oe_debug_pub.add('Offset Days : '||to_char(p_offset_days));

174: oe_debug_pub.add('+------------------ Parameters passed into the procedure ------------------+');
175: oe_debug_pub.add('Sales order : '||p_sales_order );
176: oe_debug_pub.add('Sales Order Line ID[Model] : '||to_char(p_sales_order_line_id));
177: oe_debug_pub.add('Organization_id : '||p_organization_id);
178: oe_debug_pub.add('Offset Days : '||to_char(p_offset_days));
179: oe_debug_pub.add('+---------------------------------------------------------------------------+');
180: END IF;
181:
182: l_organization_id := p_organization_id;

Line 179: oe_debug_pub.add('+---------------------------------------------------------------------------+');

175: oe_debug_pub.add('Sales order : '||p_sales_order );
176: oe_debug_pub.add('Sales Order Line ID[Model] : '||to_char(p_sales_order_line_id));
177: oe_debug_pub.add('Organization_id : '||p_organization_id);
178: oe_debug_pub.add('Offset Days : '||to_char(p_offset_days));
179: oe_debug_pub.add('+---------------------------------------------------------------------------+');
180: END IF;
181:
182: l_organization_id := p_organization_id;
183:

Line 311: oe_debug_pub.add ('The dyanamic sql generated is');

307:
308: end if;
309:
310: IF PG_DEBUG <> 0 THEN
311: oe_debug_pub.add ('The dyanamic sql generated is');
312: oe_debug_pub.add ('SQL: ' || substr(sql_stmt,1, 1500));
313: oe_debug_pub.add (substr(sql_stmt,1501,3000));
314: oe_debug_pub.add ('The drive_mark is '||drive_mark);
315: END IF;

Line 312: oe_debug_pub.add ('SQL: ' || substr(sql_stmt,1, 1500));

308: end if;
309:
310: IF PG_DEBUG <> 0 THEN
311: oe_debug_pub.add ('The dyanamic sql generated is');
312: oe_debug_pub.add ('SQL: ' || substr(sql_stmt,1, 1500));
313: oe_debug_pub.add (substr(sql_stmt,1501,3000));
314: oe_debug_pub.add ('The drive_mark is '||drive_mark);
315: END IF;
316:

Line 313: oe_debug_pub.add (substr(sql_stmt,1501,3000));

309:
310: IF PG_DEBUG <> 0 THEN
311: oe_debug_pub.add ('The dyanamic sql generated is');
312: oe_debug_pub.add ('SQL: ' || substr(sql_stmt,1, 1500));
313: oe_debug_pub.add (substr(sql_stmt,1501,3000));
314: oe_debug_pub.add ('The drive_mark is '||drive_mark);
315: END IF;
316:
317: /*

Line 314: oe_debug_pub.add ('The drive_mark is '||drive_mark);

310: IF PG_DEBUG <> 0 THEN
311: oe_debug_pub.add ('The dyanamic sql generated is');
312: oe_debug_pub.add ('SQL: ' || substr(sql_stmt,1, 1500));
313: oe_debug_pub.add (substr(sql_stmt,1501,3000));
314: oe_debug_pub.add ('The drive_mark is '||drive_mark);
315: END IF;
316:
317: /*
318: Below, we execute the sql statement according to which parameters

Line 388: oe_debug_pub.add ('INCORRECT COMBINATION of parameters');

384: -- Order_Number, Line_id, Organization_id and Offset_Days is passed
385: EXECUTE IMMEDIATE sql_stmt USING p_sales_order, p_sales_order_line_id, l_organization_id, p_offset_days;
386:
387: else
388: oe_debug_pub.add ('INCORRECT COMBINATION of parameters');
389:
390: end if;
391:
392: select line_id, org_id, ship_from_org_id, schedule_ship_date

Line 411: oe_debug_pub.add('+-------- Processing for --------------------------------------------------+');

407: v_rec_count := v_rec_count + 1;
408:
409: -- Log all the record being processed.
410: IF PG_DEBUG <> 0 THEN
411: oe_debug_pub.add('+-------- Processing for --------------------------------------------------+');
412: oe_debug_pub.add('Sales order : '||p_sales_order );
413: oe_debug_pub.add('Sales Order Line ID[Config] : '||to_char(line_id_arr(i)));
414: oe_debug_pub.add('Ship from Org : '||to_char(ship_from_org_id_arr(i)));
415: END IF;

Line 412: oe_debug_pub.add('Sales order : '||p_sales_order );

408:
409: -- Log all the record being processed.
410: IF PG_DEBUG <> 0 THEN
411: oe_debug_pub.add('+-------- Processing for --------------------------------------------------+');
412: oe_debug_pub.add('Sales order : '||p_sales_order );
413: oe_debug_pub.add('Sales Order Line ID[Config] : '||to_char(line_id_arr(i)));
414: oe_debug_pub.add('Ship from Org : '||to_char(ship_from_org_id_arr(i)));
415: END IF;
416:

Line 413: oe_debug_pub.add('Sales Order Line ID[Config] : '||to_char(line_id_arr(i)));

409: -- Log all the record being processed.
410: IF PG_DEBUG <> 0 THEN
411: oe_debug_pub.add('+-------- Processing for --------------------------------------------------+');
412: oe_debug_pub.add('Sales order : '||p_sales_order );
413: oe_debug_pub.add('Sales Order Line ID[Config] : '||to_char(line_id_arr(i)));
414: oe_debug_pub.add('Ship from Org : '||to_char(ship_from_org_id_arr(i)));
415: END IF;
416:
417: l_stmt_num := 10;

Line 414: oe_debug_pub.add('Ship from Org : '||to_char(ship_from_org_id_arr(i)));

410: IF PG_DEBUG <> 0 THEN
411: oe_debug_pub.add('+-------- Processing for --------------------------------------------------+');
412: oe_debug_pub.add('Sales order : '||p_sales_order );
413: oe_debug_pub.add('Sales Order Line ID[Config] : '||to_char(line_id_arr(i)));
414: oe_debug_pub.add('Ship from Org : '||to_char(ship_from_org_id_arr(i)));
415: END IF;
416:
417: l_stmt_num := 10;
418:

Line 438: oe_debug_pub.add('This line is locked by another process ');

434: FOR UPDATE NOWAIT;
435: exception
436: when record_locked then
437: IF PG_DEBUG <> 0 THEN
438: oe_debug_pub.add('This line is locked by another process ');
439: END IF;
440: goto EndOfLoop;
441:
442: when no_data_found then

Line 444: oe_debug_pub.add('This line is no longer eligible for processing ');

440: goto EndOfLoop;
441:
442: when no_data_found then
443: IF PG_DEBUG <> 0 THEN
444: oe_debug_pub.add('This line is no longer eligible for processing ');
445: END IF;
446: goto EndOfLoop;
447:
448: end;

Line 476: oe_debug_pub.add('Set_created_by_context API ended with expected error',1);

472: x_msg_count => x_msg_count,
473: x_msg_data => x_msg_data);
474: If x_return_status = FND_API.G_RET_STS_ERROR then
475: if PG_DEBUG <> 0 then
476: oe_debug_pub.add('Set_created_by_context API ended with expected error',1);
477: end if;
478: raise FND_API.G_EXC_ERROR;
479: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
480: if PG_DEBUG <> 0 then

Line 481: oe_debug_pub.add('Set_created_by_context API ended with unexpected error',1);

477: end if;
478: raise FND_API.G_EXC_ERROR;
479: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
480: if PG_DEBUG <> 0 then
481: oe_debug_pub.add('Set_created_by_context API ended with unexpected error',1);
482: end if;
483: raise FND_API.G_EXC_UNEXPECTED_ERROR;
484: end if; /*x_return_staus = FND_API.G_EXC_ERROR */
485: l_current_org_id := org_id_arr(i);

Line 508: oe_debug_pub.add('auto_create_dropship: ' || 'Error occurred in updating the workflow status - Stmt_num'||to_char(l_stmt_num),1);

504: p_itemkey =>line_id_arr(i),
505: p_activity_name=>'CREATE_SUPPLY_ORDER_ELIGIBLE',
506: p_result_code=>'COMPLETE');
507: IF NOT l_res THEN
508: oe_debug_pub.add('auto_create_dropship: ' || 'Error occurred in updating the workflow status - Stmt_num'||to_char(l_stmt_num),1);
509: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
510: END IF;
511:
512: ELSE

Line 533: oe_debug_pub.add('auto_create_dropship: ' || 'Error occurred in updating the workflow status - Stmt_num'||to_char(l_stmt_num),1);

529: p_activity_name=>'PURCHASE RELEASE ELIGIBLE',
530: p_result_code=>'COMPLETE');
531:
532: IF NOT l_res THEN
533: oe_debug_pub.add('auto_create_dropship: ' || 'Error occurred in updating the workflow status - Stmt_num'||to_char(l_stmt_num),1);
534: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
535: END IF;
536: END IF;
537: END IF;

Line 547: oe_debug_pub.add('+---------------------------------------------------------------------------+');

543:
544: END LOOP; -- Sales Order Lines.
545:
546: IF PG_DEBUG <> 0 THEN
547: oe_debug_pub.add('+---------------------------------------------------------------------------+');
548: oe_debug_pub.add('The Batch ID for this run was : '||to_char(l_batch_id));
549: oe_debug_pub.add('+---------------------------------------------------------------------------+');
550: oe_debug_pub.add('Number of records Processed : '||to_char(v_rec_count));
551: END IF;

Line 548: oe_debug_pub.add('The Batch ID for this run was : '||to_char(l_batch_id));

544: END LOOP; -- Sales Order Lines.
545:
546: IF PG_DEBUG <> 0 THEN
547: oe_debug_pub.add('+---------------------------------------------------------------------------+');
548: oe_debug_pub.add('The Batch ID for this run was : '||to_char(l_batch_id));
549: oe_debug_pub.add('+---------------------------------------------------------------------------+');
550: oe_debug_pub.add('Number of records Processed : '||to_char(v_rec_count));
551: END IF;
552:

Line 549: oe_debug_pub.add('+---------------------------------------------------------------------------+');

545:
546: IF PG_DEBUG <> 0 THEN
547: oe_debug_pub.add('+---------------------------------------------------------------------------+');
548: oe_debug_pub.add('The Batch ID for this run was : '||to_char(l_batch_id));
549: oe_debug_pub.add('+---------------------------------------------------------------------------+');
550: oe_debug_pub.add('Number of records Processed : '||to_char(v_rec_count));
551: END IF;
552:
553: -- The following part of the code

Line 550: oe_debug_pub.add('Number of records Processed : '||to_char(v_rec_count));

546: IF PG_DEBUG <> 0 THEN
547: oe_debug_pub.add('+---------------------------------------------------------------------------+');
548: oe_debug_pub.add('The Batch ID for this run was : '||to_char(l_batch_id));
549: oe_debug_pub.add('+---------------------------------------------------------------------------+');
550: oe_debug_pub.add('Number of records Processed : '||to_char(v_rec_count));
551: END IF;
552:
553: -- The following part of the code
554: -- is modified by Renga Kannan on 11/12/01

Line 573: oe_debug_pub.add('auto_create_dropship: ' || ':exp error::'||to_char(l_stmt_num)||'::'||sqlerrm,1);

569:
570:
571: EXCEPTION
572: WHEN FND_API.G_EXC_ERROR THEN
573: oe_debug_pub.add('auto_create_dropship: ' || ':exp error::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
574: x_return_status := FND_API.G_RET_STS_ERROR;
575: RETCODE := 2;
576: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',Current_Error_Code);
577:

Line 579: oe_debug_pub.add('auto_create_dropship: ' || ':exp error::'||to_char(l_stmt_num)||'::'||sqlerrm,1);

575: RETCODE := 2;
576: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',Current_Error_Code);
577:
578: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
579: oe_debug_pub.add('auto_create_dropship: ' || ':exp error::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
580: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
581: RETCODE := 2;
582: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',Current_Error_Code);
583:

Line 585: oe_debug_pub.add('auto_create_dropship: ' || ':exp error::'||to_char(l_stmt_num)||'::'||sqlerrm,1);

581: RETCODE := 2;
582: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',Current_Error_Code);
583:
584: WHEN OTHERS THEN
585: oe_debug_pub.add('auto_create_dropship: ' || ':exp error::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
586: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
587: RETCODE := 2;
588: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',Current_Error_Code);
589: