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 4041: ---------------------- FND Logging -----------------------------------

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

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

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

Line 4044: FND_LOG.String

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

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

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

Line 4048: FND_LOG.String

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

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

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

Line 4052: FND_LOG.String

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

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

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

Line 4056: FND_LOG.String

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

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

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

Line 4061: FND_LOG.String

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

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

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

Line 4066: FND_LOG.String

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

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

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

Line 4071: FND_LOG.String

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

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

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

Line 4107: -- Added FND_LOG

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

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

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

Line 4109: FND_LOG.String

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

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

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

Line 4126: -- Added FND_LOG

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

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

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

Line 4128: FND_LOG.String

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

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

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

Line 4148: -- Added FND_LOG

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

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

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

Line 4150: FND_LOG.String

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

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

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

Line 4157: -- Added FND_LOG

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

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

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

Line 4159: FND_LOG.String

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

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

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

Line 4166: -- Added FND_LOG

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

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

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

Line 4168: FND_LOG.String

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

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

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

Line 4221: -- Added FND_LOG

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

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

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

Line 4223: FND_LOG.String

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

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

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

Line 4272: -- Added FND_LOG

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

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

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

Line 4274: FND_LOG.String

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

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

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

Line 4288: -- Added FND_LOG

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

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

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

Line 4290: FND_LOG.String

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

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

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

Line 4321: -- Added FND_LOG

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

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

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

Line 4323: FND_LOG.String

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

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

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

Line 4330: -- Added FND_LOG

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

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

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

Line 4332: FND_LOG.String

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

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

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

Line 4466: -- Added FND_LOG

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

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

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

Line 4468: FND_LOG.String

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

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

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

Line 4489: -- Added FND_LOG

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

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

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

Line 4491: FND_LOG.String

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

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

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

Line 4498: -- Added FND_LOG

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

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

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

Line 4500: FND_LOG.String

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

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

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

Line 4507: -- Added FND_LOG

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

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

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

Line 4509: FND_LOG.String

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

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

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

Line 4552: -- Added FND_LOG

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

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

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

Line 4554: FND_LOG.String

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

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

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

Line 4602: -- Added FND_LOG

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

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

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

Line 4604: FND_LOG.String

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

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

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

Line 4612: -- Added FND_LOG

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

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

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

Line 4614: FND_LOG.String

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

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

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

Line 4642: -- Added FND_LOG

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

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

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

Line 4644: FND_LOG.String

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

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

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

Line 4651: -- Added FND_LOG

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

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

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

Line 4653: FND_LOG.String

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

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

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

Line 4772: ---------------------- FND Logging -----------------------------------

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

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

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

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

6488: l_attr_index BINARY_INTEGER;
6489:
6490: BEGIN
6491:
6492: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
6493: -- For Attribute Group
6494: l_attr_grp_index := p_ext_attr_grp_tbl.FIRST;
6495: WHILE l_attr_grp_index IS NOT NULL LOOP
6496:

Line 6497: FND_LOG.String

6493: -- For Attribute Group
6494: l_attr_grp_index := p_ext_attr_grp_tbl.FIRST;
6495: WHILE l_attr_grp_index IS NOT NULL LOOP
6496:
6497: FND_LOG.String
6498: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6499: , 'row_identifier :' || p_ext_attr_grp_tbl(l_attr_grp_index).row_identifier
6500: );
6501:

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

6494: l_attr_grp_index := p_ext_attr_grp_tbl.FIRST;
6495: WHILE l_attr_grp_index IS NOT NULL LOOP
6496:
6497: FND_LOG.String
6498: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6499: , 'row_identifier :' || p_ext_attr_grp_tbl(l_attr_grp_index).row_identifier
6500: );
6501:
6502: FND_LOG.String

Line 6502: FND_LOG.String

6498: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6499: , 'row_identifier :' || p_ext_attr_grp_tbl(l_attr_grp_index).row_identifier
6500: );
6501:
6502: FND_LOG.String
6503: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6504: , 'attr_group_id :' || p_ext_attr_grp_tbl(l_attr_grp_index).ATTR_GROUP_ID
6505: );
6506:

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

6499: , 'row_identifier :' || p_ext_attr_grp_tbl(l_attr_grp_index).row_identifier
6500: );
6501:
6502: FND_LOG.String
6503: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6504: , 'attr_group_id :' || p_ext_attr_grp_tbl(l_attr_grp_index).ATTR_GROUP_ID
6505: );
6506:
6507: FND_LOG.String

Line 6507: FND_LOG.String

6503: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6504: , 'attr_group_id :' || p_ext_attr_grp_tbl(l_attr_grp_index).ATTR_GROUP_ID
6505: );
6506:
6507: FND_LOG.String
6508: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6509: , 'attr_group_app_id :' || p_ext_attr_grp_tbl(l_attr_grp_index).ATTR_GROUP_APP_ID
6510: );
6511:

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

6504: , 'attr_group_id :' || p_ext_attr_grp_tbl(l_attr_grp_index).ATTR_GROUP_ID
6505: );
6506:
6507: FND_LOG.String
6508: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6509: , 'attr_group_app_id :' || p_ext_attr_grp_tbl(l_attr_grp_index).ATTR_GROUP_APP_ID
6510: );
6511:
6512: FND_LOG.String

Line 6512: FND_LOG.String

6508: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6509: , 'attr_group_app_id :' || p_ext_attr_grp_tbl(l_attr_grp_index).ATTR_GROUP_APP_ID
6510: );
6511:
6512: FND_LOG.String
6513: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6514: , 'attr_group_type :' || p_ext_attr_grp_tbl(l_attr_grp_index).ATTR_GROUP_TYPE
6515: );
6516:

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

6509: , 'attr_group_app_id :' || p_ext_attr_grp_tbl(l_attr_grp_index).ATTR_GROUP_APP_ID
6510: );
6511:
6512: FND_LOG.String
6513: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6514: , 'attr_group_type :' || p_ext_attr_grp_tbl(l_attr_grp_index).ATTR_GROUP_TYPE
6515: );
6516:
6517: FND_LOG.String

Line 6517: FND_LOG.String

6513: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6514: , 'attr_group_type :' || p_ext_attr_grp_tbl(l_attr_grp_index).ATTR_GROUP_TYPE
6515: );
6516:
6517: FND_LOG.String
6518: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6519: , 'attr_group_name :' || p_ext_attr_grp_tbl(l_attr_grp_index).ATTR_GROUP_NAME
6520: );
6521:

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

6514: , 'attr_group_type :' || p_ext_attr_grp_tbl(l_attr_grp_index).ATTR_GROUP_TYPE
6515: );
6516:
6517: FND_LOG.String
6518: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6519: , 'attr_group_name :' || p_ext_attr_grp_tbl(l_attr_grp_index).ATTR_GROUP_NAME
6520: );
6521:
6522: FND_LOG.String

Line 6522: FND_LOG.String

6518: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6519: , 'attr_group_name :' || p_ext_attr_grp_tbl(l_attr_grp_index).ATTR_GROUP_NAME
6520: );
6521:
6522: FND_LOG.String
6523: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6524: , 'data_level_1 :' || p_ext_attr_grp_tbl(l_attr_grp_index).DATA_LEVEL_1
6525: );
6526:

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

6519: , 'attr_group_name :' || p_ext_attr_grp_tbl(l_attr_grp_index).ATTR_GROUP_NAME
6520: );
6521:
6522: FND_LOG.String
6523: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6524: , 'data_level_1 :' || p_ext_attr_grp_tbl(l_attr_grp_index).DATA_LEVEL_1
6525: );
6526:
6527: FND_LOG.String

Line 6527: FND_LOG.String

6523: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6524: , 'data_level_1 :' || p_ext_attr_grp_tbl(l_attr_grp_index).DATA_LEVEL_1
6525: );
6526:
6527: FND_LOG.String
6528: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6529: , 'data_level_2 :' || p_ext_attr_grp_tbl(l_attr_grp_index).DATA_LEVEL_2
6530: );
6531:

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

6524: , 'data_level_1 :' || p_ext_attr_grp_tbl(l_attr_grp_index).DATA_LEVEL_1
6525: );
6526:
6527: FND_LOG.String
6528: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6529: , 'data_level_2 :' || p_ext_attr_grp_tbl(l_attr_grp_index).DATA_LEVEL_2
6530: );
6531:
6532: FND_LOG.String

Line 6532: FND_LOG.String

6528: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6529: , 'data_level_2 :' || p_ext_attr_grp_tbl(l_attr_grp_index).DATA_LEVEL_2
6530: );
6531:
6532: FND_LOG.String
6533: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6534: , 'data_level_3 :' || p_ext_attr_grp_tbl(l_attr_grp_index).DATA_LEVEL_3
6535: );
6536:

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

6529: , 'data_level_2 :' || p_ext_attr_grp_tbl(l_attr_grp_index).DATA_LEVEL_2
6530: );
6531:
6532: FND_LOG.String
6533: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6534: , 'data_level_3 :' || p_ext_attr_grp_tbl(l_attr_grp_index).DATA_LEVEL_3
6535: );
6536:
6537: FND_LOG.String

Line 6537: FND_LOG.String

6533: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6534: , 'data_level_3 :' || p_ext_attr_grp_tbl(l_attr_grp_index).DATA_LEVEL_3
6535: );
6536:
6537: FND_LOG.String
6538: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6539: , 'transaction_type :' || p_ext_attr_grp_tbl(l_attr_grp_index).TRANSACTION_TYPE
6540: );
6541:

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

6534: , 'data_level_3 :' || p_ext_attr_grp_tbl(l_attr_grp_index).DATA_LEVEL_3
6535: );
6536:
6537: FND_LOG.String
6538: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6539: , 'transaction_type :' || p_ext_attr_grp_tbl(l_attr_grp_index).TRANSACTION_TYPE
6540: );
6541:
6542: END LOOP;

Line 6547: FND_LOG.String

6543:
6544: l_attr_index := p_ext_attr_tbl.FIRST;
6545: WHILE l_attr_index IS NOT NULL LOOP
6546:
6547: FND_LOG.String
6548: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6549: , 'row_identifier :' || p_ext_attr_tbl(l_attr_index).row_identifier
6550: );
6551:

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

6544: l_attr_index := p_ext_attr_tbl.FIRST;
6545: WHILE l_attr_index IS NOT NULL LOOP
6546:
6547: FND_LOG.String
6548: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6549: , 'row_identifier :' || p_ext_attr_tbl(l_attr_index).row_identifier
6550: );
6551:
6552: FND_LOG.String

Line 6552: FND_LOG.String

6548: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6549: , 'row_identifier :' || p_ext_attr_tbl(l_attr_index).row_identifier
6550: );
6551:
6552: FND_LOG.String
6553: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6554: , 'attr_name :' || p_ext_attr_tbl(l_attr_index).ATTR_NAME
6555: );
6556:

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

6549: , 'row_identifier :' || p_ext_attr_tbl(l_attr_index).row_identifier
6550: );
6551:
6552: FND_LOG.String
6553: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6554: , 'attr_name :' || p_ext_attr_tbl(l_attr_index).ATTR_NAME
6555: );
6556:
6557: FND_LOG.String

Line 6557: FND_LOG.String

6553: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6554: , 'attr_name :' || p_ext_attr_tbl(l_attr_index).ATTR_NAME
6555: );
6556:
6557: FND_LOG.String
6558: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6559: , 'attr_value_str :' || p_ext_attr_tbl(l_attr_index).ATTR_VALUE_STR
6560: );
6561:

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

6554: , 'attr_name :' || p_ext_attr_tbl(l_attr_index).ATTR_NAME
6555: );
6556:
6557: FND_LOG.String
6558: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6559: , 'attr_value_str :' || p_ext_attr_tbl(l_attr_index).ATTR_VALUE_STR
6560: );
6561:
6562: FND_LOG.String

Line 6562: FND_LOG.String

6558: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6559: , 'attr_value_str :' || p_ext_attr_tbl(l_attr_index).ATTR_VALUE_STR
6560: );
6561:
6562: FND_LOG.String
6563: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6564: , 'attr_value_num :' || p_ext_attr_tbl(l_attr_index).ATTR_VALUE_NUM
6565: );
6566:

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

6559: , 'attr_value_str :' || p_ext_attr_tbl(l_attr_index).ATTR_VALUE_STR
6560: );
6561:
6562: FND_LOG.String
6563: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6564: , 'attr_value_num :' || p_ext_attr_tbl(l_attr_index).ATTR_VALUE_NUM
6565: );
6566:
6567: FND_LOG.String

Line 6567: FND_LOG.String

6563: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6564: , 'attr_value_num :' || p_ext_attr_tbl(l_attr_index).ATTR_VALUE_NUM
6565: );
6566:
6567: FND_LOG.String
6568: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6569: , 'attr_value_date :' || p_ext_attr_tbl(l_attr_index).ATTR_VALUE_DATE
6570: );
6571:

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

6564: , 'attr_value_num :' || p_ext_attr_tbl(l_attr_index).ATTR_VALUE_NUM
6565: );
6566:
6567: FND_LOG.String
6568: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6569: , 'attr_value_date :' || p_ext_attr_tbl(l_attr_index).ATTR_VALUE_DATE
6570: );
6571:
6572: FND_LOG.String

Line 6572: FND_LOG.String

6568: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6569: , 'attr_value_date :' || p_ext_attr_tbl(l_attr_index).ATTR_VALUE_DATE
6570: );
6571:
6572: FND_LOG.String
6573: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6574: , 'attr_value_display :' || p_ext_attr_tbl(l_attr_index).ATTR_DISP_VALUE
6575: );
6576:

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

6569: , 'attr_value_date :' || p_ext_attr_tbl(l_attr_index).ATTR_VALUE_DATE
6570: );
6571:
6572: FND_LOG.String
6573: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6574: , 'attr_value_display :' || p_ext_attr_tbl(l_attr_index).ATTR_DISP_VALUE
6575: );
6576:
6577: FND_LOG.String

Line 6577: FND_LOG.String

6573: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6574: , 'attr_value_display :' || p_ext_attr_tbl(l_attr_index).ATTR_DISP_VALUE
6575: );
6576:
6577: FND_LOG.String
6578: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6579: , 'attr_uom :' || p_ext_attr_tbl(l_attr_index).ATTR_UNIT_OF_MEASURE
6580: );
6581:

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

6574: , 'attr_value_display :' || p_ext_attr_tbl(l_attr_index).ATTR_DISP_VALUE
6575: );
6576:
6577: FND_LOG.String
6578: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6579: , 'attr_uom :' || p_ext_attr_tbl(l_attr_index).ATTR_UNIT_OF_MEASURE
6580: );
6581:
6582: FND_LOG.String

Line 6582: FND_LOG.String

6578: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6579: , 'attr_uom :' || p_ext_attr_tbl(l_attr_index).ATTR_UNIT_OF_MEASURE
6580: );
6581:
6582: FND_LOG.String
6583: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6584: , 'attr_row_id :' || p_ext_attr_tbl(l_attr_index).USER_ROW_IDENTIFIER
6585: );
6586:

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

6579: , 'attr_uom :' || p_ext_attr_tbl(l_attr_index).ATTR_UNIT_OF_MEASURE
6580: );
6581:
6582: FND_LOG.String
6583: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6584: , 'attr_row_id :' || p_ext_attr_tbl(l_attr_index).USER_ROW_IDENTIFIER
6585: );
6586:
6587: END LOOP;

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

6616: l_attr_index BINARY_INTEGER;
6617:
6618: BEGIN
6619:
6620: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
6621:
6622: -- For Attribute Group
6623: l_attr_grp_index := p_ext_attr_grp_tbl.FIRST;
6624: WHILE l_attr_grp_index IS NOT NULL LOOP

Line 6626: FND_LOG.String

6622: -- For Attribute Group
6623: l_attr_grp_index := p_ext_attr_grp_tbl.FIRST;
6624: WHILE l_attr_grp_index IS NOT NULL LOOP
6625:
6626: FND_LOG.String
6627: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6628: , 'row_identifier :' || p_ext_attr_grp_tbl(l_attr_grp_index).row_identifier
6629: );
6630:

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

6623: l_attr_grp_index := p_ext_attr_grp_tbl.FIRST;
6624: WHILE l_attr_grp_index IS NOT NULL LOOP
6625:
6626: FND_LOG.String
6627: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6628: , 'row_identifier :' || p_ext_attr_grp_tbl(l_attr_grp_index).row_identifier
6629: );
6630:
6631: FND_LOG.String

Line 6631: FND_LOG.String

6627: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6628: , 'row_identifier :' || p_ext_attr_grp_tbl(l_attr_grp_index).row_identifier
6629: );
6630:
6631: FND_LOG.String
6632: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6633: , 'pk_column_1 :' || p_ext_attr_grp_tbl(l_attr_grp_index).pk_column_1
6634: );
6635:

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

6628: , 'row_identifier :' || p_ext_attr_grp_tbl(l_attr_grp_index).row_identifier
6629: );
6630:
6631: FND_LOG.String
6632: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6633: , 'pk_column_1 :' || p_ext_attr_grp_tbl(l_attr_grp_index).pk_column_1
6634: );
6635:
6636: FND_LOG.String

Line 6636: FND_LOG.String

6632: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6633: , 'pk_column_1 :' || p_ext_attr_grp_tbl(l_attr_grp_index).pk_column_1
6634: );
6635:
6636: FND_LOG.String
6637: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6638: , 'pk_column_2 :' || p_ext_attr_grp_tbl(l_attr_grp_index).pk_column_2
6639: );
6640:

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

6633: , 'pk_column_1 :' || p_ext_attr_grp_tbl(l_attr_grp_index).pk_column_1
6634: );
6635:
6636: FND_LOG.String
6637: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6638: , 'pk_column_2 :' || p_ext_attr_grp_tbl(l_attr_grp_index).pk_column_2
6639: );
6640:
6641: FND_LOG.String

Line 6641: FND_LOG.String

6637: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6638: , 'pk_column_2 :' || p_ext_attr_grp_tbl(l_attr_grp_index).pk_column_2
6639: );
6640:
6641: FND_LOG.String
6642: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6643: , 'pk_column_3 :' || p_ext_attr_grp_tbl(l_attr_grp_index).pk_column_3
6644: );
6645:

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

6638: , 'pk_column_2 :' || p_ext_attr_grp_tbl(l_attr_grp_index).pk_column_2
6639: );
6640:
6641: FND_LOG.String
6642: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6643: , 'pk_column_3 :' || p_ext_attr_grp_tbl(l_attr_grp_index).pk_column_3
6644: );
6645:
6646: FND_LOG.String

Line 6646: FND_LOG.String

6642: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6643: , 'pk_column_3 :' || p_ext_attr_grp_tbl(l_attr_grp_index).pk_column_3
6644: );
6645:
6646: FND_LOG.String
6647: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6648: , 'pk_column_4 :' || p_ext_attr_grp_tbl(l_attr_grp_index).pk_column_4
6649: );
6650:

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

6643: , 'pk_column_3 :' || p_ext_attr_grp_tbl(l_attr_grp_index).pk_column_3
6644: );
6645:
6646: FND_LOG.String
6647: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6648: , 'pk_column_4 :' || p_ext_attr_grp_tbl(l_attr_grp_index).pk_column_4
6649: );
6650:
6651: FND_LOG.String

Line 6651: FND_LOG.String

6647: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6648: , 'pk_column_4 :' || p_ext_attr_grp_tbl(l_attr_grp_index).pk_column_4
6649: );
6650:
6651: FND_LOG.String
6652: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6653: , 'pk_column_5 :' || p_ext_attr_grp_tbl(l_attr_grp_index).pk_column_5
6654: );
6655:

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

6648: , 'pk_column_4 :' || p_ext_attr_grp_tbl(l_attr_grp_index).pk_column_4
6649: );
6650:
6651: FND_LOG.String
6652: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6653: , 'pk_column_5 :' || p_ext_attr_grp_tbl(l_attr_grp_index).pk_column_5
6654: );
6655:
6656: FND_LOG.String

Line 6656: FND_LOG.String

6652: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6653: , 'pk_column_5 :' || p_ext_attr_grp_tbl(l_attr_grp_index).pk_column_5
6654: );
6655:
6656: FND_LOG.String
6657: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6658: , 'context :' || p_ext_attr_grp_tbl(l_attr_grp_index).context
6659: );
6660:

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

6653: , 'pk_column_5 :' || p_ext_attr_grp_tbl(l_attr_grp_index).pk_column_5
6654: );
6655:
6656: FND_LOG.String
6657: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6658: , 'context :' || p_ext_attr_grp_tbl(l_attr_grp_index).context
6659: );
6660:
6661: FND_LOG.String

Line 6661: FND_LOG.String

6657: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6658: , 'context :' || p_ext_attr_grp_tbl(l_attr_grp_index).context
6659: );
6660:
6661: FND_LOG.String
6662: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6663: , 'object_name :' || p_ext_attr_grp_tbl(l_attr_grp_index).object_name
6664: );
6665:

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

6658: , 'context :' || p_ext_attr_grp_tbl(l_attr_grp_index).context
6659: );
6660:
6661: FND_LOG.String
6662: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6663: , 'object_name :' || p_ext_attr_grp_tbl(l_attr_grp_index).object_name
6664: );
6665:
6666: FND_LOG.String

Line 6666: FND_LOG.String

6662: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6663: , 'object_name :' || p_ext_attr_grp_tbl(l_attr_grp_index).object_name
6664: );
6665:
6666: FND_LOG.String
6667: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6668: , 'attr_group_id :' || p_ext_attr_grp_tbl(l_attr_grp_index).attr_group_id
6669: );
6670:

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

6663: , 'object_name :' || p_ext_attr_grp_tbl(l_attr_grp_index).object_name
6664: );
6665:
6666: FND_LOG.String
6667: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6668: , 'attr_group_id :' || p_ext_attr_grp_tbl(l_attr_grp_index).attr_group_id
6669: );
6670:
6671: FND_LOG.String

Line 6671: FND_LOG.String

6667: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6668: , 'attr_group_id :' || p_ext_attr_grp_tbl(l_attr_grp_index).attr_group_id
6669: );
6670:
6671: FND_LOG.String
6672: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6673: , 'attr_group_app_id :' || p_ext_attr_grp_tbl(l_attr_grp_index).attr_group_app_id
6674: );
6675:

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

6668: , 'attr_group_id :' || p_ext_attr_grp_tbl(l_attr_grp_index).attr_group_id
6669: );
6670:
6671: FND_LOG.String
6672: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6673: , 'attr_group_app_id :' || p_ext_attr_grp_tbl(l_attr_grp_index).attr_group_app_id
6674: );
6675:
6676: FND_LOG.String

Line 6676: FND_LOG.String

6672: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6673: , 'attr_group_app_id :' || p_ext_attr_grp_tbl(l_attr_grp_index).attr_group_app_id
6674: );
6675:
6676: FND_LOG.String
6677: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6678: , 'attr_group_type :' || p_ext_attr_grp_tbl(l_attr_grp_index).attr_group_type
6679: );
6680:

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

6673: , 'attr_group_app_id :' || p_ext_attr_grp_tbl(l_attr_grp_index).attr_group_app_id
6674: );
6675:
6676: FND_LOG.String
6677: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6678: , 'attr_group_type :' || p_ext_attr_grp_tbl(l_attr_grp_index).attr_group_type
6679: );
6680:
6681: FND_LOG.String

Line 6681: FND_LOG.String

6677: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6678: , 'attr_group_type :' || p_ext_attr_grp_tbl(l_attr_grp_index).attr_group_type
6679: );
6680:
6681: FND_LOG.String
6682: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6683: , 'attr_group_name :' || p_ext_attr_grp_tbl(l_attr_grp_index).attr_group_name
6684: );
6685:

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

6678: , 'attr_group_type :' || p_ext_attr_grp_tbl(l_attr_grp_index).attr_group_type
6679: );
6680:
6681: FND_LOG.String
6682: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6683: , 'attr_group_name :' || p_ext_attr_grp_tbl(l_attr_grp_index).attr_group_name
6684: );
6685:
6686: FND_LOG.String

Line 6686: FND_LOG.String

6682: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6683: , 'attr_group_name :' || p_ext_attr_grp_tbl(l_attr_grp_index).attr_group_name
6684: );
6685:
6686: FND_LOG.String
6687: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6688: , 'attr_group_disp_name :' || p_ext_attr_grp_tbl(l_attr_grp_index).attr_group_disp_name
6689: );
6690:

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

6683: , 'attr_group_name :' || p_ext_attr_grp_tbl(l_attr_grp_index).attr_group_name
6684: );
6685:
6686: FND_LOG.String
6687: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6688: , 'attr_group_disp_name :' || p_ext_attr_grp_tbl(l_attr_grp_index).attr_group_disp_name
6689: );
6690:
6691: FND_LOG.String

Line 6691: FND_LOG.String

6687: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6688: , 'attr_group_disp_name :' || p_ext_attr_grp_tbl(l_attr_grp_index).attr_group_disp_name
6689: );
6690:
6691: FND_LOG.String
6692: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6693: , 'mapping_req :' || p_ext_attr_grp_tbl(l_attr_grp_index).mapping_req
6694: );
6695:

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

6688: , 'attr_group_disp_name :' || p_ext_attr_grp_tbl(l_attr_grp_index).attr_group_disp_name
6689: );
6690:
6691: FND_LOG.String
6692: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6693: , 'mapping_req :' || p_ext_attr_grp_tbl(l_attr_grp_index).mapping_req
6694: );
6695:
6696: FND_LOG.String

Line 6696: FND_LOG.String

6692: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6693: , 'mapping_req :' || p_ext_attr_grp_tbl(l_attr_grp_index).mapping_req
6694: );
6695:
6696: FND_LOG.String
6697: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6698: , 'operation :' || p_ext_attr_grp_tbl(l_attr_grp_index).operation
6699: );
6700: l_attr_grp_index := p_ext_attr_grp_tbl.NEXT(l_attr_grp_index);

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

6693: , 'mapping_req :' || p_ext_attr_grp_tbl(l_attr_grp_index).mapping_req
6694: );
6695:
6696: FND_LOG.String
6697: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6698: , 'operation :' || p_ext_attr_grp_tbl(l_attr_grp_index).operation
6699: );
6700: l_attr_grp_index := p_ext_attr_grp_tbl.NEXT(l_attr_grp_index);
6701: END LOOP;

Line 6707: FND_LOG.String

6703: -- For Attribute
6704: l_attr_index := p_ext_attr_tbl.FIRST;
6705: WHILE l_attr_index IS NOT NULL LOOP
6706:
6707: FND_LOG.String
6708: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6709: , 'row_identifier :' || p_ext_attr_tbl(l_attr_index).row_identifier
6710: );
6711:

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

6704: l_attr_index := p_ext_attr_tbl.FIRST;
6705: WHILE l_attr_index IS NOT NULL LOOP
6706:
6707: FND_LOG.String
6708: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6709: , 'row_identifier :' || p_ext_attr_tbl(l_attr_index).row_identifier
6710: );
6711:
6712: FND_LOG.String

Line 6712: FND_LOG.String

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

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

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

Line 6717: FND_LOG.String

6713: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6714: , 'column_name :' || p_ext_attr_tbl(l_attr_index).column_name
6715: );
6716:
6717: FND_LOG.String
6718: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6719: , 'attr_name :' || p_ext_attr_tbl(l_attr_index).attr_name
6720: );
6721:

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

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

Line 6722: FND_LOG.String

6718: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6719: , 'attr_name :' || p_ext_attr_tbl(l_attr_index).attr_name
6720: );
6721:
6722: FND_LOG.String
6723: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6724: , 'attr_disp_name :' || p_ext_attr_tbl(l_attr_index).attr_disp_name
6725: );
6726:

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

6719: , 'attr_name :' || p_ext_attr_tbl(l_attr_index).attr_name
6720: );
6721:
6722: FND_LOG.String
6723: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6724: , 'attr_disp_name :' || p_ext_attr_tbl(l_attr_index).attr_disp_name
6725: );
6726:
6727:

Line 6728: FND_LOG.String

6724: , 'attr_disp_name :' || p_ext_attr_tbl(l_attr_index).attr_disp_name
6725: );
6726:
6727:
6728: FND_LOG.String
6729: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6730: , 'attr_value_str :' || p_ext_attr_tbl(l_attr_index).attr_value_str
6731: );
6732:

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

6725: );
6726:
6727:
6728: FND_LOG.String
6729: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6730: , 'attr_value_str :' || p_ext_attr_tbl(l_attr_index).attr_value_str
6731: );
6732:
6733: FND_LOG.String

Line 6733: FND_LOG.String

6729: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6730: , 'attr_value_str :' || p_ext_attr_tbl(l_attr_index).attr_value_str
6731: );
6732:
6733: FND_LOG.String
6734: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6735: , 'attr_value_num :' || p_ext_attr_tbl(l_attr_index).attr_value_num
6736: );
6737:

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

6730: , 'attr_value_str :' || p_ext_attr_tbl(l_attr_index).attr_value_str
6731: );
6732:
6733: FND_LOG.String
6734: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6735: , 'attr_value_num :' || p_ext_attr_tbl(l_attr_index).attr_value_num
6736: );
6737:
6738:

Line 6739: FND_LOG.String

6735: , 'attr_value_num :' || p_ext_attr_tbl(l_attr_index).attr_value_num
6736: );
6737:
6738:
6739: FND_LOG.String
6740: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6741: , 'attr_value_date :' || p_ext_attr_tbl(l_attr_index).attr_value_date
6742: );
6743:

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

6736: );
6737:
6738:
6739: FND_LOG.String
6740: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6741: , 'attr_value_date :' || p_ext_attr_tbl(l_attr_index).attr_value_date
6742: );
6743:
6744:

Line 6745: FND_LOG.String

6741: , 'attr_value_date :' || p_ext_attr_tbl(l_attr_index).attr_value_date
6742: );
6743:
6744:
6745: FND_LOG.String
6746: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6747: , 'attr_value_display :' || p_ext_attr_tbl(l_attr_index).attr_value_display
6748: );
6749:

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

6742: );
6743:
6744:
6745: FND_LOG.String
6746: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6747: , 'attr_value_display :' || p_ext_attr_tbl(l_attr_index).attr_value_display
6748: );
6749:
6750:

Line 6751: FND_LOG.String

6747: , 'attr_value_display :' || p_ext_attr_tbl(l_attr_index).attr_value_display
6748: );
6749:
6750:
6751: FND_LOG.String
6752: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6753: , 'attr_unit_of_measure :' || p_ext_attr_tbl(l_attr_index).attr_unit_of_measure
6754: );
6755:

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

6748: );
6749:
6750:
6751: FND_LOG.String
6752: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
6753: , 'attr_unit_of_measure :' || p_ext_attr_tbl(l_attr_index).attr_unit_of_measure
6754: );
6755:
6756: l_attr_index := p_ext_attr_tbl.NEXT(l_attr_index);