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.PO_COMMUNICATION_PVT dependencies on FND_LANGUAGES

Line 196: l_language_code fnd_languages.language_code%type;

192: l_with_terms PO_HEADERS_ALL.CONTERMS_EXIST_FLAG%TYPE;
193: l_set_lang boolean;
194: l_draft_id number; -- CLM
195: --
196: l_language_code fnd_languages.language_code%type;
197: l_language fnd_languages.nls_language%TYPE;
198: l_territory fnd_languages.nls_territory%TYPE;
199: --
200: /*Begin Changes by Akyanama Bug # 12969112*//*Declaring Exception*/

Line 197: l_language fnd_languages.nls_language%TYPE;

193: l_set_lang boolean;
194: l_draft_id number; -- CLM
195: --
196: l_language_code fnd_languages.language_code%type;
197: l_language fnd_languages.nls_language%TYPE;
198: l_territory fnd_languages.nls_territory%TYPE;
199: --
200: /*Begin Changes by Akyanama Bug # 12969112*//*Declaring Exception*/
201: submission_error exception;

Line 198: l_territory fnd_languages.nls_territory%TYPE;

194: l_draft_id number; -- CLM
195: --
196: l_language_code fnd_languages.language_code%type;
197: l_language fnd_languages.nls_language%TYPE;
198: l_territory fnd_languages.nls_territory%TYPE;
199: --
200: /*Begin Changes by Akyanama Bug # 12969112*//*Declaring Exception*/
201: submission_error exception;
202: /*End Changes by Akyanama Bug # 12969112*/

Line 261: FROM fnd_languages

257: --Bug 13069700 - Adding exception block.
258: BEGIN
259: SELECT nls_language, nls_territory
260: INTO l_language, l_territory
261: FROM fnd_languages
262: WHERE language_code = l_language_code;
263: EXCEPTION
264: WHEN NO_DATA_FOUND THEN
265: x_progress := 'PO_COMMUNICATION_PVT.GENERATE_PDF : in exception handler';

Line 468: l_language_code fnd_languages.language_code%type;

464: l_draft_id number; --CLM
465: l_draft_id_char varchar2(30); --CLM
466: l_orgid number;
467: l_entity_name varchar2(30);
468: l_language_code fnd_languages.language_code%type;
469: x_progress varchar2(100);
470: l_document_type po_headers.type_lookup_code%TYPE;
471:
472: Begin

Line 566: l_language_code fnd_languages.language_code%type;

562: actid IN NUMBER,
563: funcmode IN VARCHAR2,
564: resultout OUT NOCOPY VARCHAR2) is
565:
566: l_language_code fnd_languages.language_code%type;
567: l_document_id number;
568: l_revision_num number;
569: l_terms_flag po_headers_all.CONTERMS_EXIST_FLAG%type;
570: l_document_subtype po_headers_all.type_lookup_code%TYPE;

Line 917: FROM wf_languages wfl, fnd_languages_vl flv

913:
914: IF l_vendor_site_lang is NOT NULL then
915:
916: SELECT wfl.nls_language, wfl.nls_territory INTO l_adhocuser_lang, l_adhocuser_territory
917: FROM wf_languages wfl, fnd_languages_vl flv
918: WHERE wfl.code = flv.language_code AND flv.nls_language = l_vendor_site_lang;
919:
920: ELSE
921:

Line 923: FROM wf_languages wfl, fnd_languages_vl flv

919:
920: ELSE
921:
922: SELECT wfl.nls_language, wfl.nls_territory into l_adhocuser_lang, l_adhocuser_territory
923: FROM wf_languages wfl, fnd_languages_vl flv
924: WHERE wfl.code = flv.language_code AND flv.installed_flag = 'B';
925:
926: END IF;
927:

Line 1082: l_territory fnd_languages.nls_territory%type;

1078: l_document_id po_headers.po_header_id%TYPE;
1079: l_revision_num po_headers.revision_num%TYPE;
1080: l_document_subtype po_headers.type_lookup_code%TYPE;
1081: l_document_type po_headers.type_lookup_code%TYPE;
1082: l_territory fnd_languages.nls_territory%type;
1083: l_language_code fnd_languages.language_code%type;
1084: l_supp_lang po_vendor_sites_all.language%TYPE;
1085: l_language fnd_languages.nls_language%type;
1086: l_authorization_status po_headers.authorization_status%TYPE;

Line 1083: l_language_code fnd_languages.language_code%type;

1079: l_revision_num po_headers.revision_num%TYPE;
1080: l_document_subtype po_headers.type_lookup_code%TYPE;
1081: l_document_type po_headers.type_lookup_code%TYPE;
1082: l_territory fnd_languages.nls_territory%type;
1083: l_language_code fnd_languages.language_code%type;
1084: l_supp_lang po_vendor_sites_all.language%TYPE;
1085: l_language fnd_languages.nls_language%type;
1086: l_authorization_status po_headers.authorization_status%TYPE;
1087: l_header_id po_headers.po_header_id%TYPE;

Line 1085: l_language fnd_languages.nls_language%type;

1081: l_document_type po_headers.type_lookup_code%TYPE;
1082: l_territory fnd_languages.nls_territory%type;
1083: l_language_code fnd_languages.language_code%type;
1084: l_supp_lang po_vendor_sites_all.language%TYPE;
1085: l_language fnd_languages.nls_language%type;
1086: l_authorization_status po_headers.authorization_status%TYPE;
1087: l_header_id po_headers.po_header_id%TYPE;
1088:
1089: l_with_terms varchar2(1);

Line 1189: FROM fnd_languages

1185: BEGIN
1186:
1187: SELECT nls_language
1188: INTO l_language
1189: FROM fnd_languages
1190: WHERE language_code = l_language_code;
1191:
1192: EXCEPTION
1193: WHEN NO_DATA_FOUND THEN

Line 1207: FROM fnd_languages

1203: BEGIN
1204:
1205: SELECT nls_territory
1206: INTO l_territory
1207: FROM fnd_languages
1208: WHERE nls_language = l_supp_lang;
1209:
1210: EXCEPTION
1211: WHEN NO_DATA_FOUND THEN

Line 1353: l_language_code FND_LANGUAGES.language_code%TYPE;

1349: l_length_new number;
1350: l_set_lang boolean; /*Bug 8135201*/
1351: l_draft_id number; -- CLM
1352: --
1353: l_language_code FND_LANGUAGES.language_code%TYPE;
1354: l_language fnd_languages.nls_language%TYPE;
1355: l_territory fnd_languages.nls_territory%TYPE;
1356: --
1357: /*Begin Changes by Akyanama Bug # 12969112*//*Declaring Exception*/

Line 1354: l_language fnd_languages.nls_language%TYPE;

1350: l_set_lang boolean; /*Bug 8135201*/
1351: l_draft_id number; -- CLM
1352: --
1353: l_language_code FND_LANGUAGES.language_code%TYPE;
1354: l_language fnd_languages.nls_language%TYPE;
1355: l_territory fnd_languages.nls_territory%TYPE;
1356: --
1357: /*Begin Changes by Akyanama Bug # 12969112*//*Declaring Exception*/
1358: submission_error exception;

Line 1355: l_territory fnd_languages.nls_territory%TYPE;

1351: l_draft_id number; -- CLM
1352: --
1353: l_language_code FND_LANGUAGES.language_code%TYPE;
1354: l_language fnd_languages.nls_language%TYPE;
1355: l_territory fnd_languages.nls_territory%TYPE;
1356: --
1357: /*Begin Changes by Akyanama Bug # 12969112*//*Declaring Exception*/
1358: submission_error exception;
1359: /*End Changes by Akyanama Bug # 12969112*/

Line 1514: FROM fnd_languages

1510: --Bug 13069700 - Adding exception block.
1511: BEGIN
1512: SELECT nls_language, nls_territory
1513: INTO l_language, l_territory
1514: FROM fnd_languages
1515: WHERE language_code = l_language_code;
1516: EXCEPTION
1517: WHEN NO_DATA_FOUND THEN
1518: l_progress := 'PO_COMMUNICATION_PVT.GENERATE_PDF_BUYER : in exception handler';

Line 1909: l_language_code fnd_languages.language_code%type;

1905: l_request_id number;
1906: l_territory varchar2(30);
1907: l_set_lang boolean;
1908: x_progress varchar2(100);
1909: l_language_code fnd_languages.language_code%type;
1910: l_supp_lang varchar2(30);
1911: l_language varchar2(25);
1912: l_authorization_status varchar2(25);
1913: --l_old_request_id number; --Bug 7299381

Line 2014: FROM fnd_languages

2010: --set the suppliers language before launching the concurrent request
2011: -- Bug6841986/6528046 changed userenv('LANG')==> l_language_code
2012: BEGIN
2013: SELECT nls_language INTO l_language
2014: FROM fnd_languages
2015: WHERE language_code = l_language_code;
2016: EXCEPTION
2017: WHEN NO_DATA_FOUND THEN
2018: x_progress := 'PO_COMMUNICATION_PVT.GENERATE_PDF_SUPP -002: in exception handler';

Line 2028: select nls_territory into l_territory from fnd_languages where

2024: --End Bug6841986/6528046
2025:
2026: if l_language <> l_supp_lang then
2027: BEGIN
2028: select nls_territory into l_territory from fnd_languages where
2029: nls_language = l_supp_lang;
2030: EXCEPTION
2031: WHEN NO_DATA_FOUND THEN
2032: x_progress := 'PO_COMMUNICATION_PVT.GENERATE_PDF_SUPP -003: in exception handler';

Line 2162: l_language fnd_languages.nls_language%type ;

2158: l_territory varchar2(30);
2159: l_authorization_status varchar2(25);
2160: --l_language varchar2(10);
2161: /*Begin Changes by Akyanama Bug # 12969112*/
2162: l_language fnd_languages.nls_language%type ;
2163: /*End Changes by Akyanama Bug # 12969112*/
2164: l_draft_id number;
2165: /*Begin Changes by Akyanama Bug # 12969112*//*Declaring Exception*/
2166: submission_error exception;

Line 2184: select nls_territory into l_territory from fnd_languages where

2180: --set the suppliers language before launching the concurrent request
2181:
2182: --Bug 13069700 - Adding exception block.
2183: BEGIN
2184: select nls_territory into l_territory from fnd_languages where
2185: language_code = l_language_code;
2186: EXCEPTION
2187: WHEN NO_DATA_FOUND THEN
2188: x_progress := 'PO_COMMUNICATION_PVT.GENERATE_PDF_EMAIL_PROCESS -001: in exception handler';

Line 2238: select nls_language, nls_territory into l_language , l_territory from fnd_languages where

2234:
2235: --Bug 13069700 - Adding exception block.
2236: BEGIN
2237:
2238: select nls_language, nls_territory into l_language , l_territory from fnd_languages where
2239: language_code = l_language_code;
2240:
2241: EXCEPTION
2242: WHEN NO_DATA_FOUND THEN

Line 2637: l_supp_lang fnd_languages.nls_language%type;

2633: p_request_id out nocopy number)
2634: IS
2635:
2636: l_conterm_exists_flag po_headers_all.CONTERMS_EXIST_FLAG%type;
2637: l_supp_lang fnd_languages.nls_language%type;
2638: l_territory fnd_languages.nls_territory%type;
2639: l_revision_num number;
2640: l_set_lang boolean;
2641: l_doctype po_document_types_all.document_type_code%type;

Line 2638: l_territory fnd_languages.nls_territory%type;

2634: IS
2635:
2636: l_conterm_exists_flag po_headers_all.CONTERMS_EXIST_FLAG%type;
2637: l_supp_lang fnd_languages.nls_language%type;
2638: l_territory fnd_languages.nls_territory%type;
2639: l_revision_num number;
2640: l_set_lang boolean;
2641: l_doctype po_document_types_all.document_type_code%type;
2642: l_document_subtype po_document_types_all.document_subtype%type;

Line 2643: l_language_code fnd_languages.language_code%type;

2639: l_revision_num number;
2640: l_set_lang boolean;
2641: l_doctype po_document_types_all.document_type_code%type;
2642: l_document_subtype po_document_types_all.document_subtype%type;
2643: l_language_code fnd_languages.language_code%type;
2644: l_api_name CONSTANT VARCHAR2(25) := 'Communicate';
2645:
2646: l_pdf_tc_buyer_exists number(1); -- Whether PDF with Terms in buyers language already exists in Contracts Repository
2647: l_pdf_nt_buyer_exists number(1); -- Whether PDF without Terms in buyers language already exists in PO Repository

Line 2734: select language_code, nls_territory into l_language_code, l_territory from fnd_languages fl where

2730: end;
2731:
2732: l_progress := '020';
2733: if l_supp_lang is not null then
2734: select language_code, nls_territory into l_language_code, l_territory from fnd_languages fl where
2735: fl.nls_language = l_supp_lang;
2736: end if;
2737:
2738: l_buyer_language_code := userenv('LANG');

Line 2939: select nls_language, nls_territory into l_supp_lang, l_territory from fnd_languages fl where

2935: else -- if p_language_code = l_buyer_language_code
2936:
2937: l_progress := '095';
2938: -- Bug 4116063: Set the language if different from buyers lang
2939: select nls_language, nls_territory into l_supp_lang, l_territory from fnd_languages fl where
2940: fl.language_code = p_language_code ;
2941: l_set_lang := fnd_request.set_options('NO', 'NO', l_supp_lang, l_territory, NULL, FND_PROFILE.VALUE('ICX_NUMERIC_CHARACTERS')); --
2942:
2943: if l_pdf_tc_sup_exists = 0 then

Line 2978: select nls_language, nls_territory into l_supp_lang, l_territory from fnd_languages fl where

2974:
2975: else -- if p_language_code = l_buyer_language_code
2976:
2977: l_progress := '100';
2978: select nls_language, nls_territory into l_supp_lang, l_territory from fnd_languages fl where
2979: fl.language_code = p_language_code ;
2980: l_set_lang := fnd_request.set_options('NO', 'NO', l_supp_lang, l_territory, NULL, FND_PROFILE.VALUE('ICX_NUMERIC_CHARACTERS')); --
2981:
2982: if l_pdf_nt_sup_exists = 0 then

Line 3066: select nls_language, nls_territory into l_supp_lang, l_territory from fnd_languages fl where

3062: p_message => 'Generate Cache PDFs and store them in the repository');
3063: END IF;
3064:
3065: if l_tc_buyer_gen_flag = 'Y' then
3066: select nls_language, nls_territory into l_supp_lang, l_territory from fnd_languages fl where
3067: fl.language_code = l_buyer_language_code;
3068: l_set_lang := fnd_request.set_options('NO', 'NO', l_supp_lang, l_territory, NULL, FND_PROFILE.VALUE('ICX_NUMERIC_CHARACTERS')); --
3069:
3070: l_progress := '170';

Line 3088: select nls_language, nls_territory into l_supp_lang, l_territory from fnd_languages fl where

3084: end if;
3085:
3086: l_progress := '180';
3087: if l_nt_buyer_gen_flag = 'Y' then
3088: select nls_language, nls_territory into l_supp_lang, l_territory from fnd_languages fl where
3089: fl.language_code = l_buyer_language_code;
3090: l_set_lang := fnd_request.set_options('NO', 'NO', l_supp_lang, l_territory, NULL, FND_PROFILE.VALUE('ICX_NUMERIC_CHARACTERS')); --
3091:
3092: l_progress := '190';

Line 3122: select language_code, nls_territory into l_language_code, l_territory from fnd_languages fl where

3118: if l_nt_sup_gen_flag = 'Y' then
3119:
3120: l_progress := '210';
3121: if l_supp_lang is not null then
3122: select language_code, nls_territory into l_language_code, l_territory from fnd_languages fl where
3123: fl.nls_language = l_supp_lang;
3124: l_set_lang := fnd_request.set_options('NO', 'NO', l_supp_lang, l_territory, NULL, FND_PROFILE.VALUE('ICX_NUMERIC_CHARACTERS')); --
3125:
3126: l_progress := '220';

Line 3150: from fnd_languages fl

3146: l_progress := '220';
3147: if l_supp_lang is not null then
3148: select language_code, nls_territory
3149: into l_language_code, l_territory
3150: from fnd_languages fl
3151: where fl.nls_language = l_supp_lang;
3152:
3153: l_set_lang := fnd_request.set_options('NO', 'NO', l_supp_lang, l_territory, NULL, FND_PROFILE.VALUE('ICX_NUMERIC_CHARACTERS')); --
3154:

Line 3520: l_language fnd_languages.language_code%type;

3516: l_document_id number;
3517: l_document_type po_headers.type_lookup_code%TYPE;
3518: l_org_id number;
3519: l_revision_number number;
3520: l_language fnd_languages.language_code%type;
3521: l_entity_name varchar2(30);
3522: l_itemtype po_document_types.wf_approval_itemtype%type;
3523: l_itemkey varchar2(60);
3524: l_document blob;

Line 3689: l_language fnd_languages.language_code%type;

3685: l_document_id number;
3686: l_document_type po_headers.type_lookup_code%TYPE;
3687: l_org_id number;
3688: l_revision_number number;
3689: l_language fnd_languages.language_code%type;
3690: l_entity_name varchar2(30);
3691: l_itemtype po_document_types.wf_approval_itemtype%type;
3692: l_itemkey varchar2(60);
3693: l_document blob;

Line 3804: l_language fnd_languages.language_code%type;

3800: l_document_id number;
3801: l_document_type po_headers.type_lookup_code%TYPE;
3802: l_org_id number;
3803: l_revision_number number;
3804: l_language fnd_languages.language_code%type;
3805: l_entity_name varchar2(30);
3806: l_itemtype po_document_types.wf_approval_itemtype%type;
3807: l_itemkey varchar2(60);
3808: l_document blob;

Line 3868: from po_vendor_sites_all pvs, po_headers_all ph, fnd_languages fl

3864: Begin
3865:
3866: if l_document_type in ('PO', 'PA') then
3867: select fl.language_code into l_language
3868: from po_vendor_sites_all pvs, po_headers_all ph, fnd_languages fl
3869: where ph.vendor_site_id = pvs.vendor_site_id
3870: and ph.po_header_id = l_document_id
3871: and pvs.language = fl.nls_language;
3872: elsif l_document_type = 'RELEASE' then

Line 3875: po_releases_all pr, fnd_languages fl

3871: and pvs.language = fl.nls_language;
3872: elsif l_document_type = 'RELEASE' then
3873: select fl.language_code into l_language
3874: from po_vendor_sites_all pvs , po_headers_all ph,
3875: po_releases_all pr, fnd_languages fl
3876: where ph.po_header_id = pr.po_header_id
3877: and pr.po_release_id = l_document_id
3878: and ph.vendor_site_id = pvs.vendor_site_id
3879: and pvs.language = fl.nls_language;

Line 4052: l_language fnd_languages.language_code%type;

4048: l_po_document_type po_headers.type_lookup_code%TYPE;
4049: l_po_document_subtype po_headers.type_lookup_code%TYPE;
4050: l_po_org_id number;
4051: l_po_revision_number number;
4052: l_language fnd_languages.language_code%type;
4053: l_withTerms varchar2(1);
4054:
4055: l_itemtype po_document_types.wf_approval_itemtype%type;
4056: l_itemkey PO_HEADERS_ALL.wf_item_key%TYPE;

Line 4240: l_language fnd_languages.language_code%type;

4236: l_document_number po_headers_all.segment1%type;
4237: l_document_type po_headers_all.type_lookup_code%TYPE;
4238: l_org_id po_headers_all.org_id%type;
4239: l_revision_number po_headers_all.revision_num%type;
4240: l_language fnd_languages.language_code%type;
4241: l_entity_name fnd_attached_documents.entity_name%type;
4242: l_itemtype wf_items.item_type%type;
4243: l_itemkey wf_items.item_key%type;
4244: l_document fnd_lobs.file_data%type;

Line 7539: l_language_code fnd_languages.language_code%type;

7535: p_extension varchar2,
7536: p_is_conf_doc varchar2 default 'N') RETURN varchar2 IS
7537:
7538: l_po_number po_drafts.modification_number%type;
7539: l_language_code fnd_languages.language_code%type;
7540: l_api_name CONSTANT VARCHAR2(25) := 'PDFFileName';
7541: l_file_name fnd_lobs.file_name%type;
7542: l_revision_num po_drafts.revision_num%type;
7543: l_progress VARCHAR2(3);