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.CSP_RELATED_ITEMS_PKG dependencies on FND_LOG

Line 495: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

491: l_module_name varchar2(100);
492: BEGIN
493: l_module_name := 'csp.plsql.csp_related_items_pkg.delete_row';
494:
495: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
496: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
497: 'begin... X_Rowid = ' || X_Rowid);
498: end if;
499:

Line 496: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

492: BEGIN
493: l_module_name := 'csp.plsql.csp_related_items_pkg.delete_row';
494:
495: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
496: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
497: 'begin... X_Rowid = ' || X_Rowid);
498: end if;
499:
500: -- bug # 10396984

Line 509: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

505: into p_mst_org_id_pk1, p_replaced_item_id_pk2, p_replacing_item_pk3,p_relation_type_pk4
506: from MTL_RELATED_ITEMS
507: WHERE rowid = X_Rowid;
508:
509: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
510: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
511: 'p_mst_org_id_pk1 = ' || p_mst_org_id_pk1);
512: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
513: 'p_replaced_item_id_pk2 = ' || p_replaced_item_id_pk2);

Line 510: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

506: from MTL_RELATED_ITEMS
507: WHERE rowid = X_Rowid;
508:
509: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
510: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
511: 'p_mst_org_id_pk1 = ' || p_mst_org_id_pk1);
512: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
513: 'p_replaced_item_id_pk2 = ' || p_replaced_item_id_pk2);
514: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

Line 512: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

508:
509: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
510: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
511: 'p_mst_org_id_pk1 = ' || p_mst_org_id_pk1);
512: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
513: 'p_replaced_item_id_pk2 = ' || p_replaced_item_id_pk2);
514: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
515: 'p_replacing_item_pk3 = ' || p_replacing_item_pk3);
516: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

Line 514: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

510: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
511: 'p_mst_org_id_pk1 = ' || p_mst_org_id_pk1);
512: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
513: 'p_replaced_item_id_pk2 = ' || p_replaced_item_id_pk2);
514: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
515: 'p_replacing_item_pk3 = ' || p_replacing_item_pk3);
516: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
517: 'p_relation_type_pk4 = ' || p_relation_type_pk4);
518: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

Line 516: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

512: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
513: 'p_replaced_item_id_pk2 = ' || p_replaced_item_id_pk2);
514: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
515: 'p_replacing_item_pk3 = ' || p_replacing_item_pk3);
516: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
517: 'p_relation_type_pk4 = ' || p_relation_type_pk4);
518: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
519: 'deleting related item record...');
520: end if;

Line 518: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

514: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
515: 'p_replacing_item_pk3 = ' || p_replacing_item_pk3);
516: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
517: 'p_relation_type_pk4 = ' || p_relation_type_pk4);
518: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
519: 'deleting related item record...');
520: end if;
521:
522: DELETE FROM MTL_RELATED_ITEMS

Line 532: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

528: if (SQL%NOTFOUND) then
529: Raise NO_DATA_FOUND;
530: end if;
531:
532: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
533: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
534: 'record deleted...');
535: end if;
536:

Line 533: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

529: Raise NO_DATA_FOUND;
530: end if;
531:
532: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
533: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
534: 'record deleted...');
535: end if;
536:
537: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 537: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

533: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
534: 'record deleted...');
535: end if;
536:
537: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
538: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
539: 'deleting attachments for ...');
540: end if;
541:

Line 538: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

534: 'record deleted...');
535: end if;
536:
537: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
538: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
539: 'deleting attachments for ...');
540: end if;
541:
542: fnd_attached_documents2_pkg.delete_attachments(X_entity_name => 'RELATED_ITEMS',

Line 550: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

546: X_pk4_value => to_char(p_relation_type_pk4),
547: X_delete_document_flag => 'Y'
548: );
549:
550: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
551: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
552: 'attachements deleted...');
553: end if;
554:

Line 551: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

547: X_delete_document_flag => 'Y'
548: );
549:
550: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
551: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
552: 'attachements deleted...');
553: end if;
554:
555: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 555: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

551: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
552: 'attachements deleted...');
553: end if;
554:
555: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
556: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
557: 'done...');
558: end if;
559:

Line 556: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

552: 'attachements deleted...');
553: end if;
554:
555: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
556: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
557: 'done...');
558: end if;
559:
560: END Delete_Row;