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

Line 383: ---------------------- FND Logging -----------------------------------

379:
380: --DBMS_OUTPUT.PUT_LINE('In Process_User_Ext_Attrs');
381: --DBMS_OUTPUT.PUT_LINE('p_ext_attr_grp_tbl.COUNT'||p_ext_attr_grp_tbl.COUNT);
382:
383: ---------------------- FND Logging -----------------------------------
384: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
385: THEN
386: FND_LOG.String
387: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'

Line 384: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level

380: --DBMS_OUTPUT.PUT_LINE('In Process_User_Ext_Attrs');
381: --DBMS_OUTPUT.PUT_LINE('p_ext_attr_grp_tbl.COUNT'||p_ext_attr_grp_tbl.COUNT);
382:
383: ---------------------- FND Logging -----------------------------------
384: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
385: THEN
386: FND_LOG.String
387: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'
388: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'

Line 386: FND_LOG.String

382:
383: ---------------------- FND Logging -----------------------------------
384: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
385: THEN
386: FND_LOG.String
387: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'
388: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
389: );
390: FND_LOG.String

Line 387: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'

383: ---------------------- FND Logging -----------------------------------
384: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
385: THEN
386: FND_LOG.String
387: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'
388: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
389: );
390: FND_LOG.String
391: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 390: FND_LOG.String

386: FND_LOG.String
387: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'
388: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
389: );
390: FND_LOG.String
391: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
392: , 'p_api_version:' || p_api_version
393: );
394: FND_LOG.String

Line 391: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

387: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'
388: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
389: );
390: FND_LOG.String
391: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
392: , 'p_api_version:' || p_api_version
393: );
394: FND_LOG.String
395: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 394: FND_LOG.String

390: FND_LOG.String
391: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
392: , 'p_api_version:' || p_api_version
393: );
394: FND_LOG.String
395: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
396: , 'p_init_msg_list:' || p_init_msg_list
397: );
398: FND_LOG.String

Line 395: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

391: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
392: , 'p_api_version:' || p_api_version
393: );
394: FND_LOG.String
395: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
396: , 'p_init_msg_list:' || p_init_msg_list
397: );
398: FND_LOG.String
399: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 398: FND_LOG.String

394: FND_LOG.String
395: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
396: , 'p_init_msg_list:' || p_init_msg_list
397: );
398: FND_LOG.String
399: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
400: , 'p_commit:' || p_commit
401: );
402:

Line 399: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

395: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
396: , 'p_init_msg_list:' || p_init_msg_list
397: );
398: FND_LOG.String
399: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
400: , 'p_commit:' || p_commit
401: );
402:
403:

Line 437: -- Added FND_LOG

433:
434: IF p_ext_attr_grp_tbl(i).context <> l_old_context AND
435: l_old_context IS NOT NULL THEN
436:
437: -- Added FND_LOG
438: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
439: FND_LOG.String
440: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
441: , 'Transaction has two contexts. First Context :'

Line 438: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN

434: IF p_ext_attr_grp_tbl(i).context <> l_old_context AND
435: l_old_context IS NOT NULL THEN
436:
437: -- Added FND_LOG
438: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
439: FND_LOG.String
440: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
441: , 'Transaction has two contexts. First Context :'
442: || l_old_context

Line 439: FND_LOG.String

435: l_old_context IS NOT NULL THEN
436:
437: -- Added FND_LOG
438: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
439: FND_LOG.String
440: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
441: , 'Transaction has two contexts. First Context :'
442: || l_old_context
443: );

Line 440: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

436:
437: -- Added FND_LOG
438: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
439: FND_LOG.String
440: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
441: , 'Transaction has two contexts. First Context :'
442: || l_old_context
443: );
444: END IF;

Line 451: -- Added FND_LOG

447:
448: IF l_cont_chg_on_update = 'Y'
449: THEN
450:
451: -- Added FND_LOG
452: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
453: FND_LOG.String
454: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
455: , 'The context for the Service Request has Changed :'

Line 452: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN

448: IF l_cont_chg_on_update = 'Y'
449: THEN
450:
451: -- Added FND_LOG
452: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
453: FND_LOG.String
454: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
455: , 'The context for the Service Request has Changed :'
456: || l_cont_chg_on_update

Line 453: FND_LOG.String

449: THEN
450:
451: -- Added FND_LOG
452: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
453: FND_LOG.String
454: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
455: , 'The context for the Service Request has Changed :'
456: || l_cont_chg_on_update
457: );

Line 454: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

450:
451: -- Added FND_LOG
452: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
453: FND_LOG.String
454: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
455: , 'The context for the Service Request has Changed :'
456: || l_cont_chg_on_update
457: );
458: END IF;

Line 475: -- Added FND_LOG

471: FND_MSG_PUB.Add;
472: RAISE FND_API.G_EXC_ERROR;
473: END IF;
474:
475: -- Added FND_LOG
476: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
477: THEN
478: FND_LOG.String
479: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 476: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level

472: RAISE FND_API.G_EXC_ERROR;
473: END IF;
474:
475: -- Added FND_LOG
476: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
477: THEN
478: FND_LOG.String
479: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
480: , 'Information for old context deleted'

Line 478: FND_LOG.String

474:
475: -- Added FND_LOG
476: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
477: THEN
478: FND_LOG.String
479: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
480: , 'Information for old context deleted'
481: );
482: END IF;

Line 479: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

475: -- Added FND_LOG
476: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
477: THEN
478: FND_LOG.String
479: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
480: , 'Information for old context deleted'
481: );
482: END IF;
483:

Line 486: -- Added FND_LOG

482: END IF;
483:
484: END IF; -- l_cont_chg_on_update = 'Y'
485:
486: -- Added FND_LOG
487: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
488: THEN
489: FND_LOG.String
490: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 487: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level

483:
484: END IF; -- l_cont_chg_on_update = 'Y'
485:
486: -- Added FND_LOG
487: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
488: THEN
489: FND_LOG.String
490: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
491: , 'Calling PLM API to process first context'

Line 489: FND_LOG.String

485:
486: -- Added FND_LOG
487: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
488: THEN
489: FND_LOG.String
490: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
491: , 'Calling PLM API to process first context'
492: );
493: END IF;

Line 490: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

486: -- Added FND_LOG
487: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
488: THEN
489: FND_LOG.String
490: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
491: , 'Calling PLM API to process first context'
492: );
493: END IF;
494: --context has changed

Line 528: --Added FND_LOG

524: FND_MSG_PUB.Add;
525: RAISE FND_API.G_EXC_ERROR;
526: END IF;
527:
528: --Added FND_LOG
529: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
530: FND_LOG.String
531: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
532: , 'After processing first context: PLM status :' ||

Line 529: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN

525: RAISE FND_API.G_EXC_ERROR;
526: END IF;
527:
528: --Added FND_LOG
529: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
530: FND_LOG.String
531: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
532: , 'After processing first context: PLM status :' ||
533: x_return_status

Line 530: FND_LOG.String

526: END IF;
527:
528: --Added FND_LOG
529: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
530: FND_LOG.String
531: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
532: , 'After processing first context: PLM status :' ||
533: x_return_status
534: );

Line 531: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

527:
528: --Added FND_LOG
529: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
530: FND_LOG.String
531: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
532: , 'After processing first context: PLM status :' ||
533: x_return_status
534: );
535: END IF;

Line 557: --Added FND_LOG

553: RAISE FND_API.G_EXC_ERROR;
554: END IF;
555: END LOOP;
556:
557: --Added FND_LOG
558: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
559: FND_LOG.String
560: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
561: , 'Calling Audit API to audit the first context :'

Line 558: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN

554: END IF;
555: END LOOP;
556:
557: --Added FND_LOG
558: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
559: FND_LOG.String
560: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
561: , 'Calling Audit API to audit the first context :'
562: );

Line 559: FND_LOG.String

555: END LOOP;
556:
557: --Added FND_LOG
558: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
559: FND_LOG.String
560: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
561: , 'Calling Audit API to audit the first context :'
562: );
563: END IF;

Line 560: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

556:
557: --Added FND_LOG
558: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
559: FND_LOG.String
560: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
561: , 'Calling Audit API to audit the first context :'
562: );
563: END IF;
564:

Line 583: --Added FND_LOG

579: FND_MSG_PUB.Add;
580: RAISE FND_API.G_EXC_ERROR;
581: END IF;
582:
583: --Added FND_LOG
584: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
585: FND_LOG.String
586: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
587: , 'After auditing first context: Audit status :' ||

Line 584: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN

580: RAISE FND_API.G_EXC_ERROR;
581: END IF;
582:
583: --Added FND_LOG
584: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
585: FND_LOG.String
586: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
587: , 'After auditing first context: Audit status :' ||
588: x_return_status

Line 585: FND_LOG.String

581: END IF;
582:
583: --Added FND_LOG
584: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
585: FND_LOG.String
586: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
587: , 'After auditing first context: Audit status :' ||
588: x_return_status
589: );

Line 586: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

582:
583: --Added FND_LOG
584: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
585: FND_LOG.String
586: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
587: , 'After auditing first context: Audit status :' ||
588: x_return_status
589: );
590: END IF;

Line 656: --Added FND_LOG

652: l_new_Ext_Attr_Audit_table(l_new_audit_count).pk_column_1 := p_ext_attr_grp_tbl(i).pk_column_1;
653:
654: --DBMS_OUTPUT.PUT_LINE('l_new_Ext_Attr_Audit_table.pk_column_1'||l_new_Ext_Attr_Audit_table(l_new_audit_count).pk_column_1);
655:
656: --Added FND_LOG
657: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
658: FND_LOG.String
659: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
660: , 'Primary Key Validation for Service Request Extensible Attributes successful :'

Line 657: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN

653:
654: --DBMS_OUTPUT.PUT_LINE('l_new_Ext_Attr_Audit_table.pk_column_1'||l_new_Ext_Attr_Audit_table(l_new_audit_count).pk_column_1);
655:
656: --Added FND_LOG
657: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
658: FND_LOG.String
659: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
660: , 'Primary Key Validation for Service Request Extensible Attributes successful :'
661: );

Line 658: FND_LOG.String

654: --DBMS_OUTPUT.PUT_LINE('l_new_Ext_Attr_Audit_table.pk_column_1'||l_new_Ext_Attr_Audit_table(l_new_audit_count).pk_column_1);
655:
656: --Added FND_LOG
657: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
658: FND_LOG.String
659: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
660: , 'Primary Key Validation for Service Request Extensible Attributes successful :'
661: );
662: END IF;

Line 659: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

655:
656: --Added FND_LOG
657: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
658: FND_LOG.String
659: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
660: , 'Primary Key Validation for Service Request Extensible Attributes successful :'
661: );
662: END IF;
663:

Line 706: --Added FND_LOG

702: l_new_Ext_Attr_Audit_table(l_new_audit_count).context := p_ext_attr_grp_tbl(i).context;
703:
704: --DBMS_OUTPUT.PUT_LINE('Context matches'||l_new_Ext_Attr_Audit_table(l_new_audit_count).context);
705:
706: --Added FND_LOG
707: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
708: FND_LOG.String
709: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
710: , 'Context Validation for Service Request Extensible Attributes successful :'

Line 707: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN

703:
704: --DBMS_OUTPUT.PUT_LINE('Context matches'||l_new_Ext_Attr_Audit_table(l_new_audit_count).context);
705:
706: --Added FND_LOG
707: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
708: FND_LOG.String
709: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
710: , 'Context Validation for Service Request Extensible Attributes successful :'
711: );

Line 708: FND_LOG.String

704: --DBMS_OUTPUT.PUT_LINE('Context matches'||l_new_Ext_Attr_Audit_table(l_new_audit_count).context);
705:
706: --Added FND_LOG
707: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
708: FND_LOG.String
709: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
710: , 'Context Validation for Service Request Extensible Attributes successful :'
711: );
712: END IF;

Line 709: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

705:
706: --Added FND_LOG
707: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
708: FND_LOG.String
709: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
710: , 'Context Validation for Service Request Extensible Attributes successful :'
711: );
712: END IF;
713:

Line 812: --Added FND_LOG

808: --DBMS_OUTPUT.PUT_LINE('operation is update and attr_group_id is not null');
809:
810: l_attr_group_id := p_ext_attr_grp_tbl(i).attr_group_id;
811:
812: --Added FND_LOG
813: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
814: FND_LOG.String
815: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
816: , 'Operation is UPDATE - populate the audit structure :'

Line 813: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN

809:
810: l_attr_group_id := p_ext_attr_grp_tbl(i).attr_group_id;
811:
812: --Added FND_LOG
813: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
814: FND_LOG.String
815: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
816: , 'Operation is UPDATE - populate the audit structure :'
817: );

Line 814: FND_LOG.String

810: l_attr_group_id := p_ext_attr_grp_tbl(i).attr_group_id;
811:
812: --Added FND_LOG
813: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
814: FND_LOG.String
815: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
816: , 'Operation is UPDATE - populate the audit structure :'
817: );
818: END IF;

Line 815: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

811:
812: --Added FND_LOG
813: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
814: FND_LOG.String
815: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
816: , 'Operation is UPDATE - populate the audit structure :'
817: );
818: END IF;
819:

Line 831: --Added FND_LOG

827: ,p_sr_audit_rec_table => l_old_Ext_Attr_Audit_table
828: ,x_rec_found => l_rec_found
829: );
830:
831: --Added FND_LOG
832: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
833: FND_LOG.String
834: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
835: , 'Status of record found for audit :' ||

Line 832: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN

828: ,x_rec_found => l_rec_found
829: );
830:
831: --Added FND_LOG
832: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
833: FND_LOG.String
834: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
835: , 'Status of record found for audit :' ||
836: l_rec_found

Line 833: FND_LOG.String

829: );
830:
831: --Added FND_LOG
832: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
833: FND_LOG.String
834: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
835: , 'Status of record found for audit :' ||
836: l_rec_found
837: );

Line 834: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

830:
831: --Added FND_LOG
832: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
833: FND_LOG.String
834: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
835: , 'Status of record found for audit :' ||
836: l_rec_found
837: );
838: END IF;

Line 846: --Added FND_LOG

842: IF l_rec_found = 'N' THEN
843: -- call check_sr_context_change to check if context has changed during the update
844: -- operation
845:
846: --Added FND_LOG
847: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
848: FND_LOG.String
849: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
850: , 'Record not found for audit checking if context is changed for Service Request :'

Line 847: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN

843: -- call check_sr_context_change to check if context has changed during the update
844: -- operation
845:
846: --Added FND_LOG
847: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
848: FND_LOG.String
849: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
850: , 'Record not found for audit checking if context is changed for Service Request :'
851: );

Line 848: FND_LOG.String

844: -- operation
845:
846: --Added FND_LOG
847: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
848: FND_LOG.String
849: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
850: , 'Record not found for audit checking if context is changed for Service Request :'
851: );
852: END IF;

Line 849: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

845:
846: --Added FND_LOG
847: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
848: FND_LOG.String
849: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
850: , 'Record not found for audit checking if context is changed for Service Request :'
851: );
852: END IF;
853: check_sr_context_change(

Line 860: --Added FND_LOG

856: ,x_context_changed => l_cont_chg_on_update
857: ,x_db_incident_id => l_db_incident_id
858: ,x_db_context => l_db_sr_context);
859:
860: --Added FND_LOG
861: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
862: FND_LOG.String
863: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
864: , 'Status of contect change check :' ||

Line 861: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN

857: ,x_db_incident_id => l_db_incident_id
858: ,x_db_context => l_db_sr_context);
859:
860: --Added FND_LOG
861: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
862: FND_LOG.String
863: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
864: , 'Status of contect change check :' ||
865: l_cont_chg_on_update

Line 862: FND_LOG.String

858: ,x_db_context => l_db_sr_context);
859:
860: --Added FND_LOG
861: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
862: FND_LOG.String
863: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
864: , 'Status of contect change check :' ||
865: l_cont_chg_on_update
866: );

Line 863: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

859:
860: --Added FND_LOG
861: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
862: FND_LOG.String
863: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
864: , 'Status of contect change check :' ||
865: l_cont_chg_on_update
866: );
867: END IF;

Line 870: --Added FND_LOG

866: );
867: END IF;
868:
869:
870: --Added FND_LOG
871: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
872: FND_LOG.String
873: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
874: , 'Database Service Request identifier :' ||

Line 871: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN

867: END IF;
868:
869:
870: --Added FND_LOG
871: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
872: FND_LOG.String
873: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
874: , 'Database Service Request identifier :' ||
875: l_db_incident_id

Line 872: FND_LOG.String

868:
869:
870: --Added FND_LOG
871: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
872: FND_LOG.String
873: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
874: , 'Database Service Request identifier :' ||
875: l_db_incident_id
876: );

Line 873: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

869:
870: --Added FND_LOG
871: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
872: FND_LOG.String
873: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
874: , 'Database Service Request identifier :' ||
875: l_db_incident_id
876: );
877: END IF;

Line 879: --Added FND_LOG

875: l_db_incident_id
876: );
877: END IF;
878:
879: --Added FND_LOG
880: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
881: FND_LOG.String
882: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
883: , 'Database context :' ||

Line 880: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN

876: );
877: END IF;
878:
879: --Added FND_LOG
880: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
881: FND_LOG.String
882: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
883: , 'Database context :' ||
884: l_db_sr_context

Line 881: FND_LOG.String

877: END IF;
878:
879: --Added FND_LOG
880: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
881: FND_LOG.String
882: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
883: , 'Database context :' ||
884: l_db_sr_context
885: );

Line 882: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

878:
879: --Added FND_LOG
880: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
881: FND_LOG.String
882: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
883: , 'Database context :' ||
884: l_db_sr_context
885: );
886: END IF;

Line 899: --Added FND_LOG

895:
896: IF l_cont_chg_on_update = 'Y' THEN
897: --treat this record as a 'CREATE'
898:
899: --Added FND_LOG
900: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
901: FND_LOG.String
902: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
903: , 'Context has changed on Service :'

Line 900: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN

896: IF l_cont_chg_on_update = 'Y' THEN
897: --treat this record as a 'CREATE'
898:
899: --Added FND_LOG
900: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
901: FND_LOG.String
902: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
903: , 'Context has changed on Service :'
904: );

Line 901: FND_LOG.String

897: --treat this record as a 'CREATE'
898:
899: --Added FND_LOG
900: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
901: FND_LOG.String
902: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
903: , 'Context has changed on Service :'
904: );
905: END IF;

Line 902: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

898:
899: --Added FND_LOG
900: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
901: FND_LOG.String
902: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
903: , 'Context has changed on Service :'
904: );
905: END IF;
906:

Line 4039: ---------------------- FND Logging -----------------------------------

4035:
4036: -- Initialize API return status to SUCCESS
4037: x_return_status := FND_API.G_RET_STS_SUCCESS;
4038:
4039: ---------------------- FND Logging -----------------------------------
4040: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
4041: THEN
4042: FND_LOG.String
4043: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'

Line 4040: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level

4036: -- Initialize API return status to SUCCESS
4037: x_return_status := FND_API.G_RET_STS_SUCCESS;
4038:
4039: ---------------------- FND Logging -----------------------------------
4040: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
4041: THEN
4042: FND_LOG.String
4043: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'
4044: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'

Line 4042: FND_LOG.String

4038:
4039: ---------------------- FND Logging -----------------------------------
4040: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
4041: THEN
4042: FND_LOG.String
4043: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'
4044: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
4045: );
4046: FND_LOG.String

Line 4043: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'

4039: ---------------------- FND Logging -----------------------------------
4040: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
4041: THEN
4042: FND_LOG.String
4043: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'
4044: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
4045: );
4046: FND_LOG.String
4047: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 4046: FND_LOG.String

4042: FND_LOG.String
4043: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'
4044: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
4045: );
4046: FND_LOG.String
4047: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4048: , 'p_api_version:' || p_api_version
4049: );
4050: FND_LOG.String

Line 4047: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

4043: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'
4044: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
4045: );
4046: FND_LOG.String
4047: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4048: , 'p_api_version:' || p_api_version
4049: );
4050: FND_LOG.String
4051: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 4050: FND_LOG.String

4046: FND_LOG.String
4047: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4048: , 'p_api_version:' || p_api_version
4049: );
4050: FND_LOG.String
4051: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4052: , 'p_init_msg_list:' || p_init_msg_list
4053: );
4054: FND_LOG.String

Line 4051: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

4047: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4048: , 'p_api_version:' || p_api_version
4049: );
4050: FND_LOG.String
4051: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4052: , 'p_init_msg_list:' || p_init_msg_list
4053: );
4054: FND_LOG.String
4055: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

Line 4054: FND_LOG.String

4050: FND_LOG.String
4051: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4052: , 'p_init_msg_list:' || p_init_msg_list
4053: );
4054: FND_LOG.String
4055: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4056: , 'p_commit:' || p_commit
4057: );
4058:

Line 4055: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

4051: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4052: , 'p_init_msg_list:' || p_init_msg_list
4053: );
4054: FND_LOG.String
4055: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4056: , 'p_commit:' || p_commit
4057: );
4058:
4059: FND_LOG.String

Line 4059: FND_LOG.String

4055: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4056: , 'p_commit:' || p_commit
4057: );
4058:
4059: FND_LOG.String
4060: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4061: , 'p_incident_id:' || p_commit
4062: );
4063:

Line 4060: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

4056: , 'p_commit:' || p_commit
4057: );
4058:
4059: FND_LOG.String
4060: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4061: , 'p_incident_id:' || p_commit
4062: );
4063:
4064: FND_LOG.String

Line 4064: FND_LOG.String

4060: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4061: , 'p_incident_id:' || p_commit
4062: );
4063:
4064: FND_LOG.String
4065: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4066: , 'p_incident_id:' || p_incident_id
4067: );
4068:

Line 4065: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

4061: , 'p_incident_id:' || p_commit
4062: );
4063:
4064: FND_LOG.String
4065: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4066: , 'p_incident_id:' || p_incident_id
4067: );
4068:
4069: FND_LOG.String

Line 4069: FND_LOG.String

4065: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4066: , 'p_incident_id:' || p_incident_id
4067: );
4068:
4069: FND_LOG.String
4070: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4071: , 'p_object_name:' || p_object_name
4072: );
4073:

Line 4070: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

4066: , 'p_incident_id:' || p_incident_id
4067: );
4068:
4069: FND_LOG.String
4070: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4071: , 'p_object_name:' || p_object_name
4072: );
4073:
4074: END IF;

Line 4105: -- Added FND_LOG

4101: RAISE FND_API.G_EXC_ERROR;
4102:
4103: END IF;
4104:
4105: -- Added FND_LOG
4106: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
4107: FND_LOG.String
4108: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4109: , 'Incident Passed is Valid :'

Line 4106: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN

4102:
4103: END IF;
4104:
4105: -- Added FND_LOG
4106: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
4107: FND_LOG.String
4108: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4109: , 'Incident Passed is Valid :'
4110: || p_incident_id

Line 4107: FND_LOG.String

4103: END IF;
4104:
4105: -- Added FND_LOG
4106: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
4107: FND_LOG.String
4108: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4109: , 'Incident Passed is Valid :'
4110: || p_incident_id
4111: );

Line 4108: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

4104:
4105: -- Added FND_LOG
4106: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
4107: FND_LOG.String
4108: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4109: , 'Incident Passed is Valid :'
4110: || p_incident_id
4111: );
4112: END IF;

Line 4124: -- Added FND_LOG

4120:
4121: --set l_record_exists to 'y'
4122: l_record_exists := 'Y';
4123:
4124: -- Added FND_LOG
4125: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
4126: FND_LOG.String
4127: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4128: , 'Service Request Extensible Attributes exist for Incident passed :'

Line 4125: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN

4121: --set l_record_exists to 'y'
4122: l_record_exists := 'Y';
4123:
4124: -- Added FND_LOG
4125: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
4126: FND_LOG.String
4127: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4128: , 'Service Request Extensible Attributes exist for Incident passed :'
4129: );

Line 4126: FND_LOG.String

4122: l_record_exists := 'Y';
4123:
4124: -- Added FND_LOG
4125: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
4126: FND_LOG.String
4127: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4128: , 'Service Request Extensible Attributes exist for Incident passed :'
4129: );
4130: END IF;

Line 4127: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

4123:
4124: -- Added FND_LOG
4125: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
4126: FND_LOG.String
4127: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4128: , 'Service Request Extensible Attributes exist for Incident passed :'
4129: );
4130: END IF;
4131:

Line 4146: -- Added FND_LOG

4142: ,x_application_id => l_application_id
4143: ,x_attr_group_type => l_attr_group_type
4144: ,x_attr_group_name => l_attr_group_name);
4145:
4146: -- Added FND_LOG
4147: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
4148: FND_LOG.String
4149: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4150: , 'Attribute Group Metadata -> Application ID :'

Line 4147: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN

4143: ,x_attr_group_type => l_attr_group_type
4144: ,x_attr_group_name => l_attr_group_name);
4145:
4146: -- Added FND_LOG
4147: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
4148: FND_LOG.String
4149: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4150: , 'Attribute Group Metadata -> Application ID :'
4151: || l_application_id

Line 4148: FND_LOG.String

4144: ,x_attr_group_name => l_attr_group_name);
4145:
4146: -- Added FND_LOG
4147: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
4148: FND_LOG.String
4149: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4150: , 'Attribute Group Metadata -> Application ID :'
4151: || l_application_id
4152: );

Line 4149: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

4145:
4146: -- Added FND_LOG
4147: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
4148: FND_LOG.String
4149: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4150: , 'Attribute Group Metadata -> Application ID :'
4151: || l_application_id
4152: );
4153: END IF;

Line 4155: -- Added FND_LOG

4151: || l_application_id
4152: );
4153: END IF;
4154:
4155: -- Added FND_LOG
4156: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
4157: FND_LOG.String
4158: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4159: , 'Attribute Group Metadata -> Attribute Group Type :'

Line 4156: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN

4152: );
4153: END IF;
4154:
4155: -- Added FND_LOG
4156: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
4157: FND_LOG.String
4158: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4159: , 'Attribute Group Metadata -> Attribute Group Type :'
4160: || l_attr_group_type

Line 4157: FND_LOG.String

4153: END IF;
4154:
4155: -- Added FND_LOG
4156: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
4157: FND_LOG.String
4158: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4159: , 'Attribute Group Metadata -> Attribute Group Type :'
4160: || l_attr_group_type
4161: );

Line 4158: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

4154:
4155: -- Added FND_LOG
4156: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
4157: FND_LOG.String
4158: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4159: , 'Attribute Group Metadata -> Attribute Group Type :'
4160: || l_attr_group_type
4161: );
4162: END IF;

Line 4164: -- Added FND_LOG

4160: || l_attr_group_type
4161: );
4162: END IF;
4163:
4164: -- Added FND_LOG
4165: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
4166: FND_LOG.String
4167: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4168: , 'Attribute Group Metadata -> Attribute Group Name :'

Line 4165: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN

4161: );
4162: END IF;
4163:
4164: -- Added FND_LOG
4165: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
4166: FND_LOG.String
4167: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4168: , 'Attribute Group Metadata -> Attribute Group Name :'
4169: || l_attr_group_name

Line 4166: FND_LOG.String

4162: END IF;
4163:
4164: -- Added FND_LOG
4165: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
4166: FND_LOG.String
4167: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4168: , 'Attribute Group Metadata -> Attribute Group Name :'
4169: || l_attr_group_name
4170: );

Line 4167: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

4163:
4164: -- Added FND_LOG
4165: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
4166: FND_LOG.String
4167: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4168: , 'Attribute Group Metadata -> Attribute Group Name :'
4169: || l_attr_group_name
4170: );
4171: END IF;

Line 4219: -- Added FND_LOG

4215:
4216: --DBMS_OUTPUT.PUT_LINE('constructed string');
4217: --DBMS_OUTPUT.PUT_LINE('constructed string: '||l_internal_name_str);
4218:
4219: -- Added FND_LOG
4220: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
4221: FND_LOG.String
4222: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4223: , 'Attribute String to Pass to PLM :'

Line 4220: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN

4216: --DBMS_OUTPUT.PUT_LINE('constructed string');
4217: --DBMS_OUTPUT.PUT_LINE('constructed string: '||l_internal_name_str);
4218:
4219: -- Added FND_LOG
4220: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
4221: FND_LOG.String
4222: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4223: , 'Attribute String to Pass to PLM :'
4224: || l_internal_name_str

Line 4221: FND_LOG.String

4217: --DBMS_OUTPUT.PUT_LINE('constructed string: '||l_internal_name_str);
4218:
4219: -- Added FND_LOG
4220: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
4221: FND_LOG.String
4222: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4223: , 'Attribute String to Pass to PLM :'
4224: || l_internal_name_str
4225: );

Line 4222: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

4218:
4219: -- Added FND_LOG
4220: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
4221: FND_LOG.String
4222: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4223: , 'Attribute String to Pass to PLM :'
4224: || l_internal_name_str
4225: );
4226: END IF;

Line 4270: -- Added FND_LOG

4266: IF l_record_exists <> 'Y' THEN
4267: --no count for that incident was found in the table
4268: --do not call PLM
4269:
4270: -- Added FND_LOG
4271: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
4272: FND_LOG.String
4273: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4274: , 'No Service Request Extensible Attributes data exists for this Incident'

Line 4271: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN

4267: --no count for that incident was found in the table
4268: --do not call PLM
4269:
4270: -- Added FND_LOG
4271: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
4272: FND_LOG.String
4273: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4274: , 'No Service Request Extensible Attributes data exists for this Incident'
4275: );

Line 4272: FND_LOG.String

4268: --do not call PLM
4269:
4270: -- Added FND_LOG
4271: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
4272: FND_LOG.String
4273: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4274: , 'No Service Request Extensible Attributes data exists for this Incident'
4275: );
4276: END IF;

Line 4273: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

4269:
4270: -- Added FND_LOG
4271: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
4272: FND_LOG.String
4273: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4274: , 'No Service Request Extensible Attributes data exists for this Incident'
4275: );
4276: END IF;
4277: RETURN;

Line 4286: -- Added FND_LOG

4282: l_user_privileges_on_object := EGO_VARCHAR_TBL_TYPE();
4283: l_user_privileges_on_object.EXTEND();
4284: --Call PLM Get_User_Attrs_Data API
4285:
4286: -- Added FND_LOG
4287: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
4288: FND_LOG.String
4289: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4290: , 'Calling PLM Get User Attrs Data API'

Line 4287: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN

4283: l_user_privileges_on_object.EXTEND();
4284: --Call PLM Get_User_Attrs_Data API
4285:
4286: -- Added FND_LOG
4287: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
4288: FND_LOG.String
4289: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4290: , 'Calling PLM Get User Attrs Data API'
4291: );

Line 4288: FND_LOG.String

4284: --Call PLM Get_User_Attrs_Data API
4285:
4286: -- Added FND_LOG
4287: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
4288: FND_LOG.String
4289: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4290: , 'Calling PLM Get User Attrs Data API'
4291: );
4292: END IF;

Line 4289: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

4285:
4286: -- Added FND_LOG
4287: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
4288: FND_LOG.String
4289: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4290: , 'Calling PLM Get User Attrs Data API'
4291: );
4292: END IF;
4293:

Line 4319: -- Added FND_LOG

4315: ,x_msg_data => x_msg_data );
4316:
4317: --DBMS_OUTPUT.PUT_LINE( 'x_msg_data'||x_msg_data);
4318:
4319: -- Added FND_LOG
4320: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
4321: FND_LOG.String
4322: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4323: , 'PLM get User Attrs Data return status :'

Line 4320: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN

4316:
4317: --DBMS_OUTPUT.PUT_LINE( 'x_msg_data'||x_msg_data);
4318:
4319: -- Added FND_LOG
4320: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
4321: FND_LOG.String
4322: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4323: , 'PLM get User Attrs Data return status :'
4324: || x_return_status

Line 4321: FND_LOG.String

4317: --DBMS_OUTPUT.PUT_LINE( 'x_msg_data'||x_msg_data);
4318:
4319: -- Added FND_LOG
4320: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
4321: FND_LOG.String
4322: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4323: , 'PLM get User Attrs Data return status :'
4324: || x_return_status
4325: );

Line 4322: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

4318:
4319: -- Added FND_LOG
4320: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
4321: FND_LOG.String
4322: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4323: , 'PLM get User Attrs Data return status :'
4324: || x_return_status
4325: );
4326: END IF;

Line 4328: -- Added FND_LOG

4324: || x_return_status
4325: );
4326: END IF;
4327:
4328: -- Added FND_LOG
4329: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
4330: FND_LOG.String
4331: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4332: , 'PLM get User Attrs Data msg data :'

Line 4329: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN

4325: );
4326: END IF;
4327:
4328: -- Added FND_LOG
4329: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
4330: FND_LOG.String
4331: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4332: , 'PLM get User Attrs Data msg data :'
4333: || x_msg_data

Line 4330: FND_LOG.String

4326: END IF;
4327:
4328: -- Added FND_LOG
4329: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
4330: FND_LOG.String
4331: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4332: , 'PLM get User Attrs Data msg data :'
4333: || x_msg_data
4334: );

Line 4331: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

4327:
4328: -- Added FND_LOG
4329: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
4330: FND_LOG.String
4331: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4332: , 'PLM get User Attrs Data msg data :'
4333: || x_msg_data
4334: );
4335: END IF;

Line 4464: -- Added FND_LOG

4460:
4461: --set l_record_exists to 'y'
4462: l_record_exists := 'Y';
4463:
4464: -- Added FND_LOG
4465: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
4466: FND_LOG.String
4467: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4468: , 'Party Role Extensible Attributes exist for Incident passed :'

Line 4465: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN

4461: --set l_record_exists to 'y'
4462: l_record_exists := 'Y';
4463:
4464: -- Added FND_LOG
4465: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
4466: FND_LOG.String
4467: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4468: , 'Party Role Extensible Attributes exist for Incident passed :'
4469: );

Line 4466: FND_LOG.String

4462: l_record_exists := 'Y';
4463:
4464: -- Added FND_LOG
4465: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
4466: FND_LOG.String
4467: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4468: , 'Party Role Extensible Attributes exist for Incident passed :'
4469: );
4470: END IF;

Line 4467: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

4463:
4464: -- Added FND_LOG
4465: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
4466: FND_LOG.String
4467: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4468: , 'Party Role Extensible Attributes exist for Incident passed :'
4469: );
4470: END IF;
4471:

Line 4487: -- Added FND_LOG

4483: ,x_application_id => l_application_id
4484: ,x_attr_group_type => l_attr_group_type
4485: ,x_attr_group_name => l_attr_group_name);
4486:
4487: -- Added FND_LOG
4488: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
4489: FND_LOG.String
4490: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4491: , 'Attribute Group Metadata -> Application ID :'

Line 4488: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN

4484: ,x_attr_group_type => l_attr_group_type
4485: ,x_attr_group_name => l_attr_group_name);
4486:
4487: -- Added FND_LOG
4488: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
4489: FND_LOG.String
4490: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4491: , 'Attribute Group Metadata -> Application ID :'
4492: || l_application_id

Line 4489: FND_LOG.String

4485: ,x_attr_group_name => l_attr_group_name);
4486:
4487: -- Added FND_LOG
4488: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
4489: FND_LOG.String
4490: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4491: , 'Attribute Group Metadata -> Application ID :'
4492: || l_application_id
4493: );

Line 4490: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

4486:
4487: -- Added FND_LOG
4488: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
4489: FND_LOG.String
4490: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4491: , 'Attribute Group Metadata -> Application ID :'
4492: || l_application_id
4493: );
4494: END IF;

Line 4496: -- Added FND_LOG

4492: || l_application_id
4493: );
4494: END IF;
4495:
4496: -- Added FND_LOG
4497: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
4498: FND_LOG.String
4499: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4500: , 'Attribute Group Metadata -> Attribute Group Type :'

Line 4497: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN

4493: );
4494: END IF;
4495:
4496: -- Added FND_LOG
4497: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
4498: FND_LOG.String
4499: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4500: , 'Attribute Group Metadata -> Attribute Group Type :'
4501: || l_attr_group_type

Line 4498: FND_LOG.String

4494: END IF;
4495:
4496: -- Added FND_LOG
4497: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
4498: FND_LOG.String
4499: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4500: , 'Attribute Group Metadata -> Attribute Group Type :'
4501: || l_attr_group_type
4502: );

Line 4499: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

4495:
4496: -- Added FND_LOG
4497: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
4498: FND_LOG.String
4499: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4500: , 'Attribute Group Metadata -> Attribute Group Type :'
4501: || l_attr_group_type
4502: );
4503: END IF;

Line 4505: -- Added FND_LOG

4501: || l_attr_group_type
4502: );
4503: END IF;
4504:
4505: -- Added FND_LOG
4506: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
4507: FND_LOG.String
4508: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4509: , 'Attribute Group Metadata -> Attribute Group Name :'

Line 4506: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN

4502: );
4503: END IF;
4504:
4505: -- Added FND_LOG
4506: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
4507: FND_LOG.String
4508: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4509: , 'Attribute Group Metadata -> Attribute Group Name :'
4510: || l_attr_group_name

Line 4507: FND_LOG.String

4503: END IF;
4504:
4505: -- Added FND_LOG
4506: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
4507: FND_LOG.String
4508: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4509: , 'Attribute Group Metadata -> Attribute Group Name :'
4510: || l_attr_group_name
4511: );

Line 4508: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

4504:
4505: -- Added FND_LOG
4506: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
4507: FND_LOG.String
4508: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4509: , 'Attribute Group Metadata -> Attribute Group Name :'
4510: || l_attr_group_name
4511: );
4512: END IF;

Line 4550: -- Added FND_LOG

4546: l_internal_name_str := l_internal_name_str || l_ext_attr_tbl(i).attr_name;
4547:
4548: END LOOP;
4549:
4550: -- Added FND_LOG
4551: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
4552: FND_LOG.String
4553: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4554: , 'Attribute String to Pass to PLM :'

Line 4551: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN

4547:
4548: END LOOP;
4549:
4550: -- Added FND_LOG
4551: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
4552: FND_LOG.String
4553: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4554: , 'Attribute String to Pass to PLM :'
4555: || l_internal_name_str

Line 4552: FND_LOG.String

4548: END LOOP;
4549:
4550: -- Added FND_LOG
4551: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
4552: FND_LOG.String
4553: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4554: , 'Attribute String to Pass to PLM :'
4555: || l_internal_name_str
4556: );

Line 4553: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

4549:
4550: -- Added FND_LOG
4551: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
4552: FND_LOG.String
4553: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4554: , 'Attribute String to Pass to PLM :'
4555: || l_internal_name_str
4556: );
4557: END IF;

Line 4600: -- Added FND_LOG

4596:
4597: IF l_record_exists <> 'Y' THEN
4598: --no count for that incident was found in the table
4599: --do not call PLM
4600: -- Added FND_LOG
4601: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
4602: FND_LOG.String
4603: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4604: , 'No Party Role Extensible Attributes exist for Incident passed :'

Line 4601: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN

4597: IF l_record_exists <> 'Y' THEN
4598: --no count for that incident was found in the table
4599: --do not call PLM
4600: -- Added FND_LOG
4601: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
4602: FND_LOG.String
4603: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4604: , 'No Party Role Extensible Attributes exist for Incident passed :'
4605: );

Line 4602: FND_LOG.String

4598: --no count for that incident was found in the table
4599: --do not call PLM
4600: -- Added FND_LOG
4601: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
4602: FND_LOG.String
4603: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4604: , 'No Party Role Extensible Attributes exist for Incident passed :'
4605: );
4606: END IF;

Line 4603: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

4599: --do not call PLM
4600: -- Added FND_LOG
4601: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
4602: FND_LOG.String
4603: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4604: , 'No Party Role Extensible Attributes exist for Incident passed :'
4605: );
4606: END IF;
4607: RETURN;

Line 4610: -- Added FND_LOG

4606: END IF;
4607: RETURN;
4608: END IF;
4609:
4610: -- Added FND_LOG
4611: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
4612: FND_LOG.String
4613: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4614: , 'Calling PLM Get User Attrs Data API :'

Line 4611: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN

4607: RETURN;
4608: END IF;
4609:
4610: -- Added FND_LOG
4611: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
4612: FND_LOG.String
4613: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4614: , 'Calling PLM Get User Attrs Data API :'
4615: );

Line 4612: FND_LOG.String

4608: END IF;
4609:
4610: -- Added FND_LOG
4611: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
4612: FND_LOG.String
4613: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4614: , 'Calling PLM Get User Attrs Data API :'
4615: );
4616: END IF;

Line 4613: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

4609:
4610: -- Added FND_LOG
4611: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
4612: FND_LOG.String
4613: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4614: , 'Calling PLM Get User Attrs Data API :'
4615: );
4616: END IF;
4617:

Line 4640: -- Added FND_LOG

4636: ,x_errorcode => l_errorcode
4637: ,x_msg_count => x_msg_count
4638: ,x_msg_data => x_msg_data);
4639:
4640: -- Added FND_LOG
4641: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
4642: FND_LOG.String
4643: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4644: , 'PLM get User Attrs Data return status :'

Line 4641: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN

4637: ,x_msg_count => x_msg_count
4638: ,x_msg_data => x_msg_data);
4639:
4640: -- Added FND_LOG
4641: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
4642: FND_LOG.String
4643: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4644: , 'PLM get User Attrs Data return status :'
4645: || x_return_status

Line 4642: FND_LOG.String

4638: ,x_msg_data => x_msg_data);
4639:
4640: -- Added FND_LOG
4641: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
4642: FND_LOG.String
4643: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4644: , 'PLM get User Attrs Data return status :'
4645: || x_return_status
4646: );

Line 4643: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

4639:
4640: -- Added FND_LOG
4641: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
4642: FND_LOG.String
4643: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4644: , 'PLM get User Attrs Data return status :'
4645: || x_return_status
4646: );
4647: END IF;

Line 4649: -- Added FND_LOG

4645: || x_return_status
4646: );
4647: END IF;
4648:
4649: -- Added FND_LOG
4650: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
4651: FND_LOG.String
4652: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4653: , 'PLM get User Attrs Data msg data :'

Line 4650: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN

4646: );
4647: END IF;
4648:
4649: -- Added FND_LOG
4650: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
4651: FND_LOG.String
4652: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4653: , 'PLM get User Attrs Data msg data :'
4654: || x_msg_data

Line 4651: FND_LOG.String

4647: END IF;
4648:
4649: -- Added FND_LOG
4650: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
4651: FND_LOG.String
4652: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4653: , 'PLM get User Attrs Data msg data :'
4654: || x_msg_data
4655: );

Line 4652: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

4648:
4649: -- Added FND_LOG
4650: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
4651: FND_LOG.String
4652: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
4653: , 'PLM get User Attrs Data msg data :'
4654: || x_msg_data
4655: );
4656: END IF;

Line 4770: ---------------------- FND Logging -----------------------------------

4766: END IF ; -- l_attributes_row_table.COUNT IS NOT NULL
4767:
4768: END IF;
4769:
4770: ---------------------- FND Logging -----------------------------------
4771: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
4772: THEN
4773:
4774: -- --------------------------------------------------------------------------

Line 4771: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level

4767:
4768: END IF;
4769:
4770: ---------------------- FND Logging -----------------------------------
4771: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
4772: THEN
4773:
4774: -- --------------------------------------------------------------------------
4775: -- This procedure Logs the extensible attributes table.

Line 6465: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN

6461: l_attr_index BINARY_INTEGER;
6462:
6463: BEGIN
6464:
6465: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
6466: -- For Attribute Group
6467: l_attr_grp_index := p_ext_attr_grp_tbl.FIRST;
6468: WHILE l_attr_grp_index IS NOT NULL LOOP
6469:

Line 6470: FND_LOG.String

6466: -- For Attribute Group
6467: l_attr_grp_index := p_ext_attr_grp_tbl.FIRST;
6468: WHILE l_attr_grp_index IS NOT NULL LOOP
6469:
6470: FND_LOG.String
6471: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6472: , 'row_identifier :' || p_ext_attr_grp_tbl(l_attr_grp_index).row_identifier
6473: );
6474:

Line 6471: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

6467: l_attr_grp_index := p_ext_attr_grp_tbl.FIRST;
6468: WHILE l_attr_grp_index IS NOT NULL LOOP
6469:
6470: FND_LOG.String
6471: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6472: , 'row_identifier :' || p_ext_attr_grp_tbl(l_attr_grp_index).row_identifier
6473: );
6474:
6475: FND_LOG.String

Line 6475: FND_LOG.String

6471: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6472: , 'row_identifier :' || p_ext_attr_grp_tbl(l_attr_grp_index).row_identifier
6473: );
6474:
6475: FND_LOG.String
6476: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6477: , 'attr_group_id :' || p_ext_attr_grp_tbl(l_attr_grp_index).ATTR_GROUP_ID
6478: );
6479:

Line 6476: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

6472: , 'row_identifier :' || p_ext_attr_grp_tbl(l_attr_grp_index).row_identifier
6473: );
6474:
6475: FND_LOG.String
6476: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6477: , 'attr_group_id :' || p_ext_attr_grp_tbl(l_attr_grp_index).ATTR_GROUP_ID
6478: );
6479:
6480: FND_LOG.String

Line 6480: FND_LOG.String

6476: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6477: , 'attr_group_id :' || p_ext_attr_grp_tbl(l_attr_grp_index).ATTR_GROUP_ID
6478: );
6479:
6480: FND_LOG.String
6481: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6482: , 'attr_group_app_id :' || p_ext_attr_grp_tbl(l_attr_grp_index).ATTR_GROUP_APP_ID
6483: );
6484:

Line 6481: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

6477: , 'attr_group_id :' || p_ext_attr_grp_tbl(l_attr_grp_index).ATTR_GROUP_ID
6478: );
6479:
6480: FND_LOG.String
6481: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6482: , 'attr_group_app_id :' || p_ext_attr_grp_tbl(l_attr_grp_index).ATTR_GROUP_APP_ID
6483: );
6484:
6485: FND_LOG.String

Line 6485: FND_LOG.String

6481: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6482: , 'attr_group_app_id :' || p_ext_attr_grp_tbl(l_attr_grp_index).ATTR_GROUP_APP_ID
6483: );
6484:
6485: FND_LOG.String
6486: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6487: , 'attr_group_type :' || p_ext_attr_grp_tbl(l_attr_grp_index).ATTR_GROUP_TYPE
6488: );
6489:

Line 6486: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

6482: , 'attr_group_app_id :' || p_ext_attr_grp_tbl(l_attr_grp_index).ATTR_GROUP_APP_ID
6483: );
6484:
6485: FND_LOG.String
6486: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6487: , 'attr_group_type :' || p_ext_attr_grp_tbl(l_attr_grp_index).ATTR_GROUP_TYPE
6488: );
6489:
6490: FND_LOG.String

Line 6490: FND_LOG.String

6486: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6487: , 'attr_group_type :' || p_ext_attr_grp_tbl(l_attr_grp_index).ATTR_GROUP_TYPE
6488: );
6489:
6490: FND_LOG.String
6491: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6492: , 'attr_group_name :' || p_ext_attr_grp_tbl(l_attr_grp_index).ATTR_GROUP_NAME
6493: );
6494:

Line 6491: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

6487: , 'attr_group_type :' || p_ext_attr_grp_tbl(l_attr_grp_index).ATTR_GROUP_TYPE
6488: );
6489:
6490: FND_LOG.String
6491: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6492: , 'attr_group_name :' || p_ext_attr_grp_tbl(l_attr_grp_index).ATTR_GROUP_NAME
6493: );
6494:
6495: FND_LOG.String

Line 6495: FND_LOG.String

6491: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6492: , 'attr_group_name :' || p_ext_attr_grp_tbl(l_attr_grp_index).ATTR_GROUP_NAME
6493: );
6494:
6495: FND_LOG.String
6496: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6497: , 'data_level_1 :' || p_ext_attr_grp_tbl(l_attr_grp_index).DATA_LEVEL_1
6498: );
6499:

Line 6496: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

6492: , 'attr_group_name :' || p_ext_attr_grp_tbl(l_attr_grp_index).ATTR_GROUP_NAME
6493: );
6494:
6495: FND_LOG.String
6496: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6497: , 'data_level_1 :' || p_ext_attr_grp_tbl(l_attr_grp_index).DATA_LEVEL_1
6498: );
6499:
6500: FND_LOG.String

Line 6500: FND_LOG.String

6496: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6497: , 'data_level_1 :' || p_ext_attr_grp_tbl(l_attr_grp_index).DATA_LEVEL_1
6498: );
6499:
6500: FND_LOG.String
6501: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6502: , 'data_level_2 :' || p_ext_attr_grp_tbl(l_attr_grp_index).DATA_LEVEL_2
6503: );
6504:

Line 6501: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

6497: , 'data_level_1 :' || p_ext_attr_grp_tbl(l_attr_grp_index).DATA_LEVEL_1
6498: );
6499:
6500: FND_LOG.String
6501: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6502: , 'data_level_2 :' || p_ext_attr_grp_tbl(l_attr_grp_index).DATA_LEVEL_2
6503: );
6504:
6505: FND_LOG.String

Line 6505: FND_LOG.String

6501: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6502: , 'data_level_2 :' || p_ext_attr_grp_tbl(l_attr_grp_index).DATA_LEVEL_2
6503: );
6504:
6505: FND_LOG.String
6506: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6507: , 'data_level_3 :' || p_ext_attr_grp_tbl(l_attr_grp_index).DATA_LEVEL_3
6508: );
6509:

Line 6506: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

6502: , 'data_level_2 :' || p_ext_attr_grp_tbl(l_attr_grp_index).DATA_LEVEL_2
6503: );
6504:
6505: FND_LOG.String
6506: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6507: , 'data_level_3 :' || p_ext_attr_grp_tbl(l_attr_grp_index).DATA_LEVEL_3
6508: );
6509:
6510: FND_LOG.String

Line 6510: FND_LOG.String

6506: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6507: , 'data_level_3 :' || p_ext_attr_grp_tbl(l_attr_grp_index).DATA_LEVEL_3
6508: );
6509:
6510: FND_LOG.String
6511: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6512: , 'transaction_type :' || p_ext_attr_grp_tbl(l_attr_grp_index).TRANSACTION_TYPE
6513: );
6514:

Line 6511: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

6507: , 'data_level_3 :' || p_ext_attr_grp_tbl(l_attr_grp_index).DATA_LEVEL_3
6508: );
6509:
6510: FND_LOG.String
6511: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6512: , 'transaction_type :' || p_ext_attr_grp_tbl(l_attr_grp_index).TRANSACTION_TYPE
6513: );
6514:
6515: END LOOP;

Line 6520: FND_LOG.String

6516:
6517: l_attr_index := p_ext_attr_tbl.FIRST;
6518: WHILE l_attr_index IS NOT NULL LOOP
6519:
6520: FND_LOG.String
6521: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6522: , 'row_identifier :' || p_ext_attr_tbl(l_attr_index).row_identifier
6523: );
6524:

Line 6521: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

6517: l_attr_index := p_ext_attr_tbl.FIRST;
6518: WHILE l_attr_index IS NOT NULL LOOP
6519:
6520: FND_LOG.String
6521: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6522: , 'row_identifier :' || p_ext_attr_tbl(l_attr_index).row_identifier
6523: );
6524:
6525: FND_LOG.String

Line 6525: FND_LOG.String

6521: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6522: , 'row_identifier :' || p_ext_attr_tbl(l_attr_index).row_identifier
6523: );
6524:
6525: FND_LOG.String
6526: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6527: , 'attr_name :' || p_ext_attr_tbl(l_attr_index).ATTR_NAME
6528: );
6529:

Line 6526: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

6522: , 'row_identifier :' || p_ext_attr_tbl(l_attr_index).row_identifier
6523: );
6524:
6525: FND_LOG.String
6526: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6527: , 'attr_name :' || p_ext_attr_tbl(l_attr_index).ATTR_NAME
6528: );
6529:
6530: FND_LOG.String

Line 6530: FND_LOG.String

6526: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6527: , 'attr_name :' || p_ext_attr_tbl(l_attr_index).ATTR_NAME
6528: );
6529:
6530: FND_LOG.String
6531: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6532: , 'attr_value_str :' || p_ext_attr_tbl(l_attr_index).ATTR_VALUE_STR
6533: );
6534:

Line 6531: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

6527: , 'attr_name :' || p_ext_attr_tbl(l_attr_index).ATTR_NAME
6528: );
6529:
6530: FND_LOG.String
6531: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6532: , 'attr_value_str :' || p_ext_attr_tbl(l_attr_index).ATTR_VALUE_STR
6533: );
6534:
6535: FND_LOG.String

Line 6535: FND_LOG.String

6531: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6532: , 'attr_value_str :' || p_ext_attr_tbl(l_attr_index).ATTR_VALUE_STR
6533: );
6534:
6535: FND_LOG.String
6536: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6537: , 'attr_value_num :' || p_ext_attr_tbl(l_attr_index).ATTR_VALUE_NUM
6538: );
6539:

Line 6536: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

6532: , 'attr_value_str :' || p_ext_attr_tbl(l_attr_index).ATTR_VALUE_STR
6533: );
6534:
6535: FND_LOG.String
6536: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6537: , 'attr_value_num :' || p_ext_attr_tbl(l_attr_index).ATTR_VALUE_NUM
6538: );
6539:
6540: FND_LOG.String

Line 6540: FND_LOG.String

6536: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6537: , 'attr_value_num :' || p_ext_attr_tbl(l_attr_index).ATTR_VALUE_NUM
6538: );
6539:
6540: FND_LOG.String
6541: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6542: , 'attr_value_date :' || p_ext_attr_tbl(l_attr_index).ATTR_VALUE_DATE
6543: );
6544:

Line 6541: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

6537: , 'attr_value_num :' || p_ext_attr_tbl(l_attr_index).ATTR_VALUE_NUM
6538: );
6539:
6540: FND_LOG.String
6541: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6542: , 'attr_value_date :' || p_ext_attr_tbl(l_attr_index).ATTR_VALUE_DATE
6543: );
6544:
6545: FND_LOG.String

Line 6545: FND_LOG.String

6541: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6542: , 'attr_value_date :' || p_ext_attr_tbl(l_attr_index).ATTR_VALUE_DATE
6543: );
6544:
6545: FND_LOG.String
6546: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6547: , 'attr_value_display :' || p_ext_attr_tbl(l_attr_index).ATTR_DISP_VALUE
6548: );
6549:

Line 6546: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

6542: , 'attr_value_date :' || p_ext_attr_tbl(l_attr_index).ATTR_VALUE_DATE
6543: );
6544:
6545: FND_LOG.String
6546: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6547: , 'attr_value_display :' || p_ext_attr_tbl(l_attr_index).ATTR_DISP_VALUE
6548: );
6549:
6550: FND_LOG.String

Line 6550: FND_LOG.String

6546: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6547: , 'attr_value_display :' || p_ext_attr_tbl(l_attr_index).ATTR_DISP_VALUE
6548: );
6549:
6550: FND_LOG.String
6551: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6552: , 'attr_uom :' || p_ext_attr_tbl(l_attr_index).ATTR_UNIT_OF_MEASURE
6553: );
6554:

Line 6551: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

6547: , 'attr_value_display :' || p_ext_attr_tbl(l_attr_index).ATTR_DISP_VALUE
6548: );
6549:
6550: FND_LOG.String
6551: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6552: , 'attr_uom :' || p_ext_attr_tbl(l_attr_index).ATTR_UNIT_OF_MEASURE
6553: );
6554:
6555: FND_LOG.String

Line 6555: FND_LOG.String

6551: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6552: , 'attr_uom :' || p_ext_attr_tbl(l_attr_index).ATTR_UNIT_OF_MEASURE
6553: );
6554:
6555: FND_LOG.String
6556: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6557: , 'attr_row_id :' || p_ext_attr_tbl(l_attr_index).USER_ROW_IDENTIFIER
6558: );
6559:

Line 6556: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

6552: , 'attr_uom :' || p_ext_attr_tbl(l_attr_index).ATTR_UNIT_OF_MEASURE
6553: );
6554:
6555: FND_LOG.String
6556: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6557: , 'attr_row_id :' || p_ext_attr_tbl(l_attr_index).USER_ROW_IDENTIFIER
6558: );
6559:
6560: END LOOP;

Line 6593: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN

6589: l_attr_index BINARY_INTEGER;
6590:
6591: BEGIN
6592:
6593: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
6594:
6595: -- For Attribute Group
6596: l_attr_grp_index := p_ext_attr_grp_tbl.FIRST;
6597: WHILE l_attr_grp_index IS NOT NULL LOOP

Line 6599: FND_LOG.String

6595: -- For Attribute Group
6596: l_attr_grp_index := p_ext_attr_grp_tbl.FIRST;
6597: WHILE l_attr_grp_index IS NOT NULL LOOP
6598:
6599: FND_LOG.String
6600: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6601: , 'row_identifier :' || p_ext_attr_grp_tbl(l_attr_grp_index).row_identifier
6602: );
6603:

Line 6600: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

6596: l_attr_grp_index := p_ext_attr_grp_tbl.FIRST;
6597: WHILE l_attr_grp_index IS NOT NULL LOOP
6598:
6599: FND_LOG.String
6600: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6601: , 'row_identifier :' || p_ext_attr_grp_tbl(l_attr_grp_index).row_identifier
6602: );
6603:
6604: FND_LOG.String

Line 6604: FND_LOG.String

6600: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6601: , 'row_identifier :' || p_ext_attr_grp_tbl(l_attr_grp_index).row_identifier
6602: );
6603:
6604: FND_LOG.String
6605: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6606: , 'pk_column_1 :' || p_ext_attr_grp_tbl(l_attr_grp_index).pk_column_1
6607: );
6608:

Line 6605: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

6601: , 'row_identifier :' || p_ext_attr_grp_tbl(l_attr_grp_index).row_identifier
6602: );
6603:
6604: FND_LOG.String
6605: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6606: , 'pk_column_1 :' || p_ext_attr_grp_tbl(l_attr_grp_index).pk_column_1
6607: );
6608:
6609: FND_LOG.String

Line 6609: FND_LOG.String

6605: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6606: , 'pk_column_1 :' || p_ext_attr_grp_tbl(l_attr_grp_index).pk_column_1
6607: );
6608:
6609: FND_LOG.String
6610: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6611: , 'pk_column_2 :' || p_ext_attr_grp_tbl(l_attr_grp_index).pk_column_2
6612: );
6613:

Line 6610: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

6606: , 'pk_column_1 :' || p_ext_attr_grp_tbl(l_attr_grp_index).pk_column_1
6607: );
6608:
6609: FND_LOG.String
6610: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6611: , 'pk_column_2 :' || p_ext_attr_grp_tbl(l_attr_grp_index).pk_column_2
6612: );
6613:
6614: FND_LOG.String

Line 6614: FND_LOG.String

6610: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6611: , 'pk_column_2 :' || p_ext_attr_grp_tbl(l_attr_grp_index).pk_column_2
6612: );
6613:
6614: FND_LOG.String
6615: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6616: , 'pk_column_3 :' || p_ext_attr_grp_tbl(l_attr_grp_index).pk_column_3
6617: );
6618:

Line 6615: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

6611: , 'pk_column_2 :' || p_ext_attr_grp_tbl(l_attr_grp_index).pk_column_2
6612: );
6613:
6614: FND_LOG.String
6615: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6616: , 'pk_column_3 :' || p_ext_attr_grp_tbl(l_attr_grp_index).pk_column_3
6617: );
6618:
6619: FND_LOG.String

Line 6619: FND_LOG.String

6615: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6616: , 'pk_column_3 :' || p_ext_attr_grp_tbl(l_attr_grp_index).pk_column_3
6617: );
6618:
6619: FND_LOG.String
6620: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6621: , 'pk_column_4 :' || p_ext_attr_grp_tbl(l_attr_grp_index).pk_column_4
6622: );
6623:

Line 6620: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

6616: , 'pk_column_3 :' || p_ext_attr_grp_tbl(l_attr_grp_index).pk_column_3
6617: );
6618:
6619: FND_LOG.String
6620: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6621: , 'pk_column_4 :' || p_ext_attr_grp_tbl(l_attr_grp_index).pk_column_4
6622: );
6623:
6624: FND_LOG.String

Line 6624: FND_LOG.String

6620: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6621: , 'pk_column_4 :' || p_ext_attr_grp_tbl(l_attr_grp_index).pk_column_4
6622: );
6623:
6624: FND_LOG.String
6625: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6626: , 'pk_column_5 :' || p_ext_attr_grp_tbl(l_attr_grp_index).pk_column_5
6627: );
6628:

Line 6625: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

6621: , 'pk_column_4 :' || p_ext_attr_grp_tbl(l_attr_grp_index).pk_column_4
6622: );
6623:
6624: FND_LOG.String
6625: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6626: , 'pk_column_5 :' || p_ext_attr_grp_tbl(l_attr_grp_index).pk_column_5
6627: );
6628:
6629: FND_LOG.String

Line 6629: FND_LOG.String

6625: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6626: , 'pk_column_5 :' || p_ext_attr_grp_tbl(l_attr_grp_index).pk_column_5
6627: );
6628:
6629: FND_LOG.String
6630: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6631: , 'context :' || p_ext_attr_grp_tbl(l_attr_grp_index).context
6632: );
6633:

Line 6630: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

6626: , 'pk_column_5 :' || p_ext_attr_grp_tbl(l_attr_grp_index).pk_column_5
6627: );
6628:
6629: FND_LOG.String
6630: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6631: , 'context :' || p_ext_attr_grp_tbl(l_attr_grp_index).context
6632: );
6633:
6634: FND_LOG.String

Line 6634: FND_LOG.String

6630: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6631: , 'context :' || p_ext_attr_grp_tbl(l_attr_grp_index).context
6632: );
6633:
6634: FND_LOG.String
6635: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6636: , 'object_name :' || p_ext_attr_grp_tbl(l_attr_grp_index).object_name
6637: );
6638:

Line 6635: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

6631: , 'context :' || p_ext_attr_grp_tbl(l_attr_grp_index).context
6632: );
6633:
6634: FND_LOG.String
6635: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6636: , 'object_name :' || p_ext_attr_grp_tbl(l_attr_grp_index).object_name
6637: );
6638:
6639: FND_LOG.String

Line 6639: FND_LOG.String

6635: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6636: , 'object_name :' || p_ext_attr_grp_tbl(l_attr_grp_index).object_name
6637: );
6638:
6639: FND_LOG.String
6640: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6641: , 'attr_group_id :' || p_ext_attr_grp_tbl(l_attr_grp_index).attr_group_id
6642: );
6643:

Line 6640: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

6636: , 'object_name :' || p_ext_attr_grp_tbl(l_attr_grp_index).object_name
6637: );
6638:
6639: FND_LOG.String
6640: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6641: , 'attr_group_id :' || p_ext_attr_grp_tbl(l_attr_grp_index).attr_group_id
6642: );
6643:
6644: FND_LOG.String

Line 6644: FND_LOG.String

6640: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6641: , 'attr_group_id :' || p_ext_attr_grp_tbl(l_attr_grp_index).attr_group_id
6642: );
6643:
6644: FND_LOG.String
6645: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6646: , 'attr_group_app_id :' || p_ext_attr_grp_tbl(l_attr_grp_index).attr_group_app_id
6647: );
6648:

Line 6645: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

6641: , 'attr_group_id :' || p_ext_attr_grp_tbl(l_attr_grp_index).attr_group_id
6642: );
6643:
6644: FND_LOG.String
6645: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6646: , 'attr_group_app_id :' || p_ext_attr_grp_tbl(l_attr_grp_index).attr_group_app_id
6647: );
6648:
6649: FND_LOG.String

Line 6649: FND_LOG.String

6645: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6646: , 'attr_group_app_id :' || p_ext_attr_grp_tbl(l_attr_grp_index).attr_group_app_id
6647: );
6648:
6649: FND_LOG.String
6650: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6651: , 'attr_group_type :' || p_ext_attr_grp_tbl(l_attr_grp_index).attr_group_type
6652: );
6653:

Line 6650: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

6646: , 'attr_group_app_id :' || p_ext_attr_grp_tbl(l_attr_grp_index).attr_group_app_id
6647: );
6648:
6649: FND_LOG.String
6650: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6651: , 'attr_group_type :' || p_ext_attr_grp_tbl(l_attr_grp_index).attr_group_type
6652: );
6653:
6654: FND_LOG.String

Line 6654: FND_LOG.String

6650: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6651: , 'attr_group_type :' || p_ext_attr_grp_tbl(l_attr_grp_index).attr_group_type
6652: );
6653:
6654: FND_LOG.String
6655: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6656: , 'attr_group_name :' || p_ext_attr_grp_tbl(l_attr_grp_index).attr_group_name
6657: );
6658:

Line 6655: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

6651: , 'attr_group_type :' || p_ext_attr_grp_tbl(l_attr_grp_index).attr_group_type
6652: );
6653:
6654: FND_LOG.String
6655: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6656: , 'attr_group_name :' || p_ext_attr_grp_tbl(l_attr_grp_index).attr_group_name
6657: );
6658:
6659: FND_LOG.String

Line 6659: FND_LOG.String

6655: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6656: , 'attr_group_name :' || p_ext_attr_grp_tbl(l_attr_grp_index).attr_group_name
6657: );
6658:
6659: FND_LOG.String
6660: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6661: , 'attr_group_disp_name :' || p_ext_attr_grp_tbl(l_attr_grp_index).attr_group_disp_name
6662: );
6663:

Line 6660: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

6656: , 'attr_group_name :' || p_ext_attr_grp_tbl(l_attr_grp_index).attr_group_name
6657: );
6658:
6659: FND_LOG.String
6660: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6661: , 'attr_group_disp_name :' || p_ext_attr_grp_tbl(l_attr_grp_index).attr_group_disp_name
6662: );
6663:
6664: FND_LOG.String

Line 6664: FND_LOG.String

6660: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6661: , 'attr_group_disp_name :' || p_ext_attr_grp_tbl(l_attr_grp_index).attr_group_disp_name
6662: );
6663:
6664: FND_LOG.String
6665: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6666: , 'mapping_req :' || p_ext_attr_grp_tbl(l_attr_grp_index).mapping_req
6667: );
6668:

Line 6665: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

6661: , 'attr_group_disp_name :' || p_ext_attr_grp_tbl(l_attr_grp_index).attr_group_disp_name
6662: );
6663:
6664: FND_LOG.String
6665: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6666: , 'mapping_req :' || p_ext_attr_grp_tbl(l_attr_grp_index).mapping_req
6667: );
6668:
6669: FND_LOG.String

Line 6669: FND_LOG.String

6665: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6666: , 'mapping_req :' || p_ext_attr_grp_tbl(l_attr_grp_index).mapping_req
6667: );
6668:
6669: FND_LOG.String
6670: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6671: , 'operation :' || p_ext_attr_grp_tbl(l_attr_grp_index).operation
6672: );
6673: l_attr_grp_index := p_ext_attr_grp_tbl.NEXT(l_attr_grp_index);

Line 6670: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

6666: , 'mapping_req :' || p_ext_attr_grp_tbl(l_attr_grp_index).mapping_req
6667: );
6668:
6669: FND_LOG.String
6670: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6671: , 'operation :' || p_ext_attr_grp_tbl(l_attr_grp_index).operation
6672: );
6673: l_attr_grp_index := p_ext_attr_grp_tbl.NEXT(l_attr_grp_index);
6674: END LOOP;

Line 6680: FND_LOG.String

6676: -- For Attribute
6677: l_attr_index := p_ext_attr_tbl.FIRST;
6678: WHILE l_attr_index IS NOT NULL LOOP
6679:
6680: FND_LOG.String
6681: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6682: , 'row_identifier :' || p_ext_attr_tbl(l_attr_index).row_identifier
6683: );
6684:

Line 6681: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

6677: l_attr_index := p_ext_attr_tbl.FIRST;
6678: WHILE l_attr_index IS NOT NULL LOOP
6679:
6680: FND_LOG.String
6681: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6682: , 'row_identifier :' || p_ext_attr_tbl(l_attr_index).row_identifier
6683: );
6684:
6685: FND_LOG.String

Line 6685: FND_LOG.String

6681: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6682: , 'row_identifier :' || p_ext_attr_tbl(l_attr_index).row_identifier
6683: );
6684:
6685: FND_LOG.String
6686: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6687: , 'column_name :' || p_ext_attr_tbl(l_attr_index).column_name
6688: );
6689:

Line 6686: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

6682: , 'row_identifier :' || p_ext_attr_tbl(l_attr_index).row_identifier
6683: );
6684:
6685: FND_LOG.String
6686: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6687: , 'column_name :' || p_ext_attr_tbl(l_attr_index).column_name
6688: );
6689:
6690: FND_LOG.String

Line 6690: FND_LOG.String

6686: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6687: , 'column_name :' || p_ext_attr_tbl(l_attr_index).column_name
6688: );
6689:
6690: FND_LOG.String
6691: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6692: , 'attr_name :' || p_ext_attr_tbl(l_attr_index).attr_name
6693: );
6694:

Line 6691: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

6687: , 'column_name :' || p_ext_attr_tbl(l_attr_index).column_name
6688: );
6689:
6690: FND_LOG.String
6691: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6692: , 'attr_name :' || p_ext_attr_tbl(l_attr_index).attr_name
6693: );
6694:
6695: FND_LOG.String

Line 6695: FND_LOG.String

6691: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6692: , 'attr_name :' || p_ext_attr_tbl(l_attr_index).attr_name
6693: );
6694:
6695: FND_LOG.String
6696: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6697: , 'attr_disp_name :' || p_ext_attr_tbl(l_attr_index).attr_disp_name
6698: );
6699:

Line 6696: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

6692: , 'attr_name :' || p_ext_attr_tbl(l_attr_index).attr_name
6693: );
6694:
6695: FND_LOG.String
6696: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6697: , 'attr_disp_name :' || p_ext_attr_tbl(l_attr_index).attr_disp_name
6698: );
6699:
6700:

Line 6701: FND_LOG.String

6697: , 'attr_disp_name :' || p_ext_attr_tbl(l_attr_index).attr_disp_name
6698: );
6699:
6700:
6701: FND_LOG.String
6702: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6703: , 'attr_value_str :' || p_ext_attr_tbl(l_attr_index).attr_value_str
6704: );
6705:

Line 6702: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

6698: );
6699:
6700:
6701: FND_LOG.String
6702: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6703: , 'attr_value_str :' || p_ext_attr_tbl(l_attr_index).attr_value_str
6704: );
6705:
6706: FND_LOG.String

Line 6706: FND_LOG.String

6702: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6703: , 'attr_value_str :' || p_ext_attr_tbl(l_attr_index).attr_value_str
6704: );
6705:
6706: FND_LOG.String
6707: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6708: , 'attr_value_num :' || p_ext_attr_tbl(l_attr_index).attr_value_num
6709: );
6710:

Line 6707: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

6703: , 'attr_value_str :' || p_ext_attr_tbl(l_attr_index).attr_value_str
6704: );
6705:
6706: FND_LOG.String
6707: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6708: , 'attr_value_num :' || p_ext_attr_tbl(l_attr_index).attr_value_num
6709: );
6710:
6711:

Line 6712: FND_LOG.String

6708: , 'attr_value_num :' || p_ext_attr_tbl(l_attr_index).attr_value_num
6709: );
6710:
6711:
6712: FND_LOG.String
6713: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6714: , 'attr_value_date :' || p_ext_attr_tbl(l_attr_index).attr_value_date
6715: );
6716:

Line 6713: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

6709: );
6710:
6711:
6712: FND_LOG.String
6713: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6714: , 'attr_value_date :' || p_ext_attr_tbl(l_attr_index).attr_value_date
6715: );
6716:
6717:

Line 6718: FND_LOG.String

6714: , 'attr_value_date :' || p_ext_attr_tbl(l_attr_index).attr_value_date
6715: );
6716:
6717:
6718: FND_LOG.String
6719: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6720: , 'attr_value_display :' || p_ext_attr_tbl(l_attr_index).attr_value_display
6721: );
6722:

Line 6719: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

6715: );
6716:
6717:
6718: FND_LOG.String
6719: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6720: , 'attr_value_display :' || p_ext_attr_tbl(l_attr_index).attr_value_display
6721: );
6722:
6723:

Line 6724: FND_LOG.String

6720: , 'attr_value_display :' || p_ext_attr_tbl(l_attr_index).attr_value_display
6721: );
6722:
6723:
6724: FND_LOG.String
6725: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6726: , 'attr_unit_of_measure :' || p_ext_attr_tbl(l_attr_index).attr_unit_of_measure
6727: );
6728:

Line 6725: ( FND_LOG.level_procedure , L_LOG_MODULE || ''

6721: );
6722:
6723:
6724: FND_LOG.String
6725: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6726: , 'attr_unit_of_measure :' || p_ext_attr_tbl(l_attr_index).attr_unit_of_measure
6727: );
6728:
6729: l_attr_index := p_ext_attr_tbl.NEXT(l_attr_index);