APPS.IEU_WPACTIONS_PVT dependencies on FND_PROFILE

Line 145: l_note_status := nvl(fnd_profile.value('JTF_NTS_NOTE_STATUS'),'I');

141:
142:
143: BEGIN
144:
145: l_note_status := nvl(fnd_profile.value('JTF_NTS_NOTE_STATUS'),'I');
146: --DELETE FROM msista_tmp;
147: --commit;
148: --INSERT INTO msista_Tmp values (11, 'P_Action_Type is '|| P_Action_Type);
149: --commit;

Line 709: IF (FND_PROFILE.VALUE('IEU_AUTO_RELATED') = 'Y') THEN -- this is for source document

705: IF NOT (l_return_status = G_SUCCESS) THEN
706: RAISE fail_exception;
707: ELSE
708: -- we have to do some additional work if 'auto-relate note' is true
709: IF (FND_PROFILE.VALUE('IEU_AUTO_RELATED') = 'Y') THEN -- this is for source document
710: l_continue := 0;
711: select count(source_object_id) into l_continue
712: from jtf_tasks_b
713: where task_id = l_task_rec_tbl(i).id;

Line 756: IF (FND_PROFILE.VALUE('AS_NOTES_LEAD_CUSTOMER') = 'Y') THEN

752: END IF;
753:
754: END IF; -- auto_relate = 1
755:
756: IF (FND_PROFILE.VALUE('AS_NOTES_LEAD_CUSTOMER') = 'Y') THEN
757: l_continue := 0;
758: select count(customer_id) into l_continue
759: from jtf_tasks_b
760: where task_id = l_task_rec_tbl(i).id;

Line 806: IF (FND_PROFILE.VALUE('AS_NOTES_LEAD_CONTACT') = 'Y') THEN

802:
803: END IF; -- if AS_NOTES_LEAD_CUSTOMER
804:
805:
806: IF (FND_PROFILE.VALUE('AS_NOTES_LEAD_CONTACT') = 'Y') THEN
807: --INSERT INTO msista_Tmp values (70, 'auto related profile is YES' );
808: --commit;
809: l_continue := 0;
810: for c2_rec in C_note_context_id (l_task_rec_tbl(i).id)

Line 852: END IF; -- IF (FND_PROFILE.VALUE('AS_NOTES_LEAD_CONTACT') = 'Y')

848: IF (c_task_src%ISOPEN) THEN
849: CLOSE c_task_src;
850: END IF;
851:
852: END IF; -- IF (FND_PROFILE.VALUE('AS_NOTES_LEAD_CONTACT') = 'Y')
853:
854: IF (FND_PROFILE.VALUE('AS_NOTES_OPP_CUSTOMER') = 'Y') THEN
855: --INSERT INTO msista_Tmp values (70, 'auto related profile is YES' );
856: --commit;

Line 854: IF (FND_PROFILE.VALUE('AS_NOTES_OPP_CUSTOMER') = 'Y') THEN

850: END IF;
851:
852: END IF; -- IF (FND_PROFILE.VALUE('AS_NOTES_LEAD_CONTACT') = 'Y')
853:
854: IF (FND_PROFILE.VALUE('AS_NOTES_OPP_CUSTOMER') = 'Y') THEN
855: --INSERT INTO msista_Tmp values (70, 'auto related profile is YES' );
856: --commit;
857: l_continue := 0;
858: select count(customer_id) into l_continue

Line 908: END IF; -- IF (FND_PROFILE.VALUE('AS_NOTES_OPP_CUSTOMER') = 'Y')

904: IF (c_task_src%ISOPEN) THEN
905: CLOSE c_task_src;
906: END IF;
907:
908: END IF; -- IF (FND_PROFILE.VALUE('AS_NOTES_OPP_CUSTOMER') = 'Y')
909:
910:
911: IF (FND_PROFILE.VALUE('AS_NOTES_OPP_CONTACT') = 'Y') THEN
912: --INSERT INTO msista_Tmp values (70, 'auto related profile is YES' );

Line 911: IF (FND_PROFILE.VALUE('AS_NOTES_OPP_CONTACT') = 'Y') THEN

907:
908: END IF; -- IF (FND_PROFILE.VALUE('AS_NOTES_OPP_CUSTOMER') = 'Y')
909:
910:
911: IF (FND_PROFILE.VALUE('AS_NOTES_OPP_CONTACT') = 'Y') THEN
912: --INSERT INTO msista_Tmp values (70, 'auto related profile is YES' );
913: --commit;
914: l_continue := 0;
915: for c2_rec in C_note_context_id (l_task_rec_tbl(i).id)

Line 957: END IF; -- IF (FND_PROFILE.VALUE('AS_NOTES_OPP_CONTACT') = 'Y')

953:
954: IF (c_task_src%ISOPEN) THEN
955: CLOSE c_task_src;
956: END IF;
957: END IF; -- IF (FND_PROFILE.VALUE('AS_NOTES_OPP_CONTACT') = 'Y')
958:
959: IF (FND_PROFILE.VALUE('AS_NOTES_REL_OBJECT') = 'Y') THEN
960: l_continue := 0;
961: select count(a.object_id) into l_continue

Line 959: IF (FND_PROFILE.VALUE('AS_NOTES_REL_OBJECT') = 'Y') THEN

955: CLOSE c_task_src;
956: END IF;
957: END IF; -- IF (FND_PROFILE.VALUE('AS_NOTES_OPP_CONTACT') = 'Y')
958:
959: IF (FND_PROFILE.VALUE('AS_NOTES_REL_OBJECT') = 'Y') THEN
960: l_continue := 0;
961: select count(a.object_id) into l_continue
962: from hz_relationships a, hz_parties b
963: where b.party_type = 'PARTY_RELATIONSHIP'

Line 1020: END IF; --IF (FND_PROFILE.VALUE('AS_NOTES_REL_OBJECT') = 'Y')

1016:
1017: IF (c_task_src%ISOPEN) THEN
1018: CLOSE c_task_src;
1019: END IF;
1020: END IF; --IF (FND_PROFILE.VALUE('AS_NOTES_REL_OBJECT') = 'Y')
1021:
1022:
1023: IF (FND_PROFILE.VALUE('AS_NOTES_REL_SUBJECT') = 'Y') THEN
1024: l_continue := 0;

Line 1023: IF (FND_PROFILE.VALUE('AS_NOTES_REL_SUBJECT') = 'Y') THEN

1019: END IF;
1020: END IF; --IF (FND_PROFILE.VALUE('AS_NOTES_REL_OBJECT') = 'Y')
1021:
1022:
1023: IF (FND_PROFILE.VALUE('AS_NOTES_REL_SUBJECT') = 'Y') THEN
1024: l_continue := 0;
1025: select count(a.subject_id) into l_continue
1026: from hz_relationships a, hz_parties b
1027: where b.party_type = 'PARTY_RELATIONSHIP'

Line 1084: END IF; -- if FND_PROFILE.VALUE('AS_NOTES_REL_SUBJECT') = 'Y')

1080:
1081: IF (c_task_src%ISOPEN) THEN
1082: CLOSE c_task_src;
1083: END IF;
1084: END IF; -- if FND_PROFILE.VALUE('AS_NOTES_REL_SUBJECT') = 'Y')
1085: END IF; -- if create_note ok
1086: END IF; -- IF (l_note IS NOT NULL)
1087:
1088: -- continue with rest of task items