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 PO_DEBUG

Line 120: g_debug_stmt CONSTANT BOOLEAN := PO_DEBUG.is_debug_stmt_on;

116: /*Bug#35833910 the variable determines whether the po has Terms and Conditions */
117: g_with_terms po_headers_all.conterms_exist_flag%type;
118:
119: -- Use proper debug logging
120: g_debug_stmt CONSTANT BOOLEAN := PO_DEBUG.is_debug_stmt_on;
121: g_debug_unexp CONSTANT BOOLEAN := PO_DEBUG.is_debug_unexp_on;
122: --
123:
124: g_documentName varchar2(200) := null; --bug#3630737:Holds concatinated value of DocumentType, po number and revision number

Line 121: g_debug_unexp CONSTANT BOOLEAN := PO_DEBUG.is_debug_unexp_on;

117: g_with_terms po_headers_all.conterms_exist_flag%type;
118:
119: -- Use proper debug logging
120: g_debug_stmt CONSTANT BOOLEAN := PO_DEBUG.is_debug_stmt_on;
121: g_debug_unexp CONSTANT BOOLEAN := PO_DEBUG.is_debug_unexp_on;
122: --
123:
124: g_documentName varchar2(200) := null; --bug#3630737:Holds concatinated value of DocumentType, po number and revision number
125:

Line 2670: PO_DEBUG.debug_begin(p_log_head => g_log_head || l_api_name);

2666:
2667: BEGIN
2668: l_progress := '000';
2669: IF g_debug_stmt THEN
2670: PO_DEBUG.debug_begin(p_log_head => g_log_head || l_api_name);
2671: PO_DEBUG.debug_stmt(p_log_head => g_log_head || l_api_name,
2672: p_token => l_progress,
2673: p_message => 'Communication method '|| p_mode);
2674: PO_DEBUG.debug_stmt(p_log_head => g_log_head || l_api_name,

Line 2671: PO_DEBUG.debug_stmt(p_log_head => g_log_head || l_api_name,

2667: BEGIN
2668: l_progress := '000';
2669: IF g_debug_stmt THEN
2670: PO_DEBUG.debug_begin(p_log_head => g_log_head || l_api_name);
2671: PO_DEBUG.debug_stmt(p_log_head => g_log_head || l_api_name,
2672: p_token => l_progress,
2673: p_message => 'Communication method '|| p_mode);
2674: PO_DEBUG.debug_stmt(p_log_head => g_log_head || l_api_name,
2675: p_token => l_progress,

Line 2674: PO_DEBUG.debug_stmt(p_log_head => g_log_head || l_api_name,

2670: PO_DEBUG.debug_begin(p_log_head => g_log_head || l_api_name);
2671: PO_DEBUG.debug_stmt(p_log_head => g_log_head || l_api_name,
2672: p_token => l_progress,
2673: p_message => 'Communication method '|| p_mode);
2674: PO_DEBUG.debug_stmt(p_log_head => g_log_head || l_api_name,
2675: p_token => l_progress,
2676: p_message => 'Document Type '|| p_document_type);
2677: PO_DEBUG.debug_stmt(p_log_head => g_log_head || l_api_name,
2678: p_token => l_progress,

Line 2677: PO_DEBUG.debug_stmt(p_log_head => g_log_head || l_api_name,

2673: p_message => 'Communication method '|| p_mode);
2674: PO_DEBUG.debug_stmt(p_log_head => g_log_head || l_api_name,
2675: p_token => l_progress,
2676: p_message => 'Document Type '|| p_document_type);
2677: PO_DEBUG.debug_stmt(p_log_head => g_log_head || l_api_name,
2678: p_token => l_progress,
2679: p_message => 'Authorization Status '|| p_authorization_status);
2680: PO_DEBUG.debug_stmt(p_log_head => g_log_head || l_api_name,
2681: p_token => l_progress,

Line 2680: PO_DEBUG.debug_stmt(p_log_head => g_log_head || l_api_name,

2676: p_message => 'Document Type '|| p_document_type);
2677: PO_DEBUG.debug_stmt(p_log_head => g_log_head || l_api_name,
2678: p_token => l_progress,
2679: p_message => 'Authorization Status '|| p_authorization_status);
2680: PO_DEBUG.debug_stmt(p_log_head => g_log_head || l_api_name,
2681: p_token => l_progress,
2682: p_message => 'Document Id '|| p_document_id);
2683: PO_DEBUG.debug_stmt(p_log_head => g_log_head || l_api_name,
2684: p_token => l_progress,

Line 2683: PO_DEBUG.debug_stmt(p_log_head => g_log_head || l_api_name,

2679: p_message => 'Authorization Status '|| p_authorization_status);
2680: PO_DEBUG.debug_stmt(p_log_head => g_log_head || l_api_name,
2681: p_token => l_progress,
2682: p_message => 'Document Id '|| p_document_id);
2683: PO_DEBUG.debug_stmt(p_log_head => g_log_head || l_api_name,
2684: p_token => l_progress,
2685: p_message => 'With Terms '|| p_with_terms);
2686: END IF;
2687:

Line 2719: PO_DEBUG.debug_stmt(p_log_head => g_log_head || l_api_name,

2715: where ph.po_header_id = pr.po_header_id and pr.po_release_id = p_document_id and
2716: ph.vendor_site_id = pvs.vendor_site_id ;
2717: end if;
2718: IF g_debug_stmt THEN
2719: PO_DEBUG.debug_stmt(p_log_head => g_log_head || l_api_name,
2720: p_token => l_progress,
2721: p_message => 'Supplier Language: '|| l_supp_lang);
2722: END IF;
2723: exception

Line 2726: PO_DEBUG.debug_stmt(p_log_head => g_log_head || l_api_name,

2722: END IF;
2723: exception
2724: when others then l_supp_lang := NULL;
2725: IF g_debug_stmt THEN
2726: PO_DEBUG.debug_stmt(p_log_head => g_log_head || l_api_name,
2727: p_token => l_progress,
2728: p_message => 'Supplier Language not found');
2729: END IF;
2730: end;

Line 2755: PO_DEBUG.debug_stmt(p_log_head => g_log_head || l_api_name,

2751:
2752: if l_conterm_exists_flag = 'Y' then
2753: l_progress := '030';
2754: IF g_debug_stmt THEN
2755: PO_DEBUG.debug_stmt(p_log_head => g_log_head || l_api_name,
2756: p_token => l_progress,
2757: p_message => 'Checking for latest PDF with terms in Contracts Repository');
2758: END IF;
2759:

Line 2784: PO_DEBUG.debug_stmt(p_log_head => g_log_head || l_api_name,

2780:
2781: else
2782: l_progress := '031';
2783: IF g_debug_stmt THEN
2784: PO_DEBUG.debug_stmt(p_log_head => g_log_head || l_api_name,
2785: p_token => l_progress,
2786: p_message => 'Checking for latest PDF without terms in suppliers language in PO Repository');
2787: END IF;
2788:

Line 2815: PO_DEBUG.debug_stmt(p_log_head => g_log_head || l_api_name,

2811: end if;
2812:
2813: l_progress := '040';
2814: IF g_debug_stmt THEN
2815: PO_DEBUG.debug_stmt(p_log_head => g_log_head || l_api_name,
2816: p_token => l_progress,
2817: p_message => 'Checking for latest PDF without terms in buyers language in PO Repository');
2818: END IF;
2819:

Line 2842: PO_DEBUG.debug_stmt(p_log_head => g_log_head || l_api_name,

2838:
2839: else
2840: l_progress := '050';
2841: IF g_debug_stmt THEN
2842: PO_DEBUG.debug_stmt(p_log_head => g_log_head || l_api_name,
2843: p_token => l_progress,
2844: p_message => 'Checking for latest PDF without terms in suppliers language in PO Repository');
2845: END IF;
2846:

Line 2886: PO_DEBUG.debug_exc(p_log_head => g_log_head || l_api_name,

2882: Exception
2883: When others then
2884: l_progress := '070';
2885: IF g_debug_unexp THEN
2886: PO_DEBUG.debug_exc(p_log_head => g_log_head || l_api_name,
2887: p_progress => l_progress);
2888: END IF;
2889: raise;
2890: End;

Line 2896: PO_DEBUG.debug_exc(p_log_head => g_log_head || l_api_name,

2892: -- Instead it would return null, so raise exception explicitly
2893: IF l_revision_num IS NULL THEN
2894: l_progress := '080';
2895: IF g_debug_unexp THEN
2896: PO_DEBUG.debug_exc(p_log_head => g_log_head || l_api_name,
2897: p_progress => l_progress);
2898: END IF;
2899: raise no_data_found;
2900: END IF;

Line 2913: PO_DEBUG.debug_stmt(p_log_head => g_log_head || l_api_name,

2909: end if; -- if (p_authorization_status = 'APPROVED' or p_authorization_status = 'PRE-APPROVED')
2910:
2911: l_progress := '090';
2912: IF g_debug_stmt THEN
2913: PO_DEBUG.debug_stmt(p_log_head => g_log_head || l_api_name,
2914: p_token => l_progress,
2915: p_message => 'Decide on which PDFs to generate and store');
2916: END IF;
2917:

Line 2996: PO_DEBUG.debug_stmt(p_log_head => g_log_head || l_api_name,

2992: end if; -- if p_with_terms = 'Y'
2993:
2994: l_progress := '110';
2995: IF g_debug_stmt THEN
2996: PO_DEBUG.debug_stmt(p_log_head => g_log_head || l_api_name,
2997: p_token => l_progress,
2998: p_message => 'Lanuch Communicate Requests');
2999: END IF;
3000:

Line 3060: PO_DEBUG.debug_stmt(p_log_head => g_log_head || l_api_name,

3056:
3057: -- Now make cache documents
3058: l_progress := '160';
3059: IF g_debug_stmt THEN
3060: PO_DEBUG.debug_stmt(p_log_head => g_log_head || l_api_name,
3061: p_token => l_progress,
3062: p_message => 'Generate Cache PDFs and store them in the repository');
3063: END IF;
3064:

Line 3177: PO_DEBUG.debug_end(p_log_head => g_log_head || l_api_name);

3173: commit;
3174:
3175: l_progress := '230';
3176: IF g_debug_stmt THEN
3177: PO_DEBUG.debug_end(p_log_head => g_log_head || l_api_name);
3178: END IF;
3179:
3180: exception
3181: when others then

Line 3183: PO_DEBUG.debug_exc(p_log_head => g_log_head || l_api_name,

3179:
3180: exception
3181: when others then
3182: IF g_debug_unexp THEN
3183: PO_DEBUG.debug_exc(p_log_head => g_log_head || l_api_name,
3184: p_progress => l_progress);
3185: END IF;
3186: raise;
3187: end Communicate;

Line 3274: PO_DEBUG.debug_begin(p_log_head => g_log_head || l_api_name);

3270:
3271: Begin
3272: l_progress := '000';
3273: IF g_debug_stmt THEN
3274: PO_DEBUG.debug_begin(p_log_head => g_log_head || l_api_name);
3275: PO_DEBUG.debug_stmt(p_log_head => g_log_head || l_api_name,
3276: p_token => l_progress,
3277: p_message => p_document_type ||' '|| p_document_id ||' '|| p_revision_number ||' '|| p_blob_type);
3278: END IF;

Line 3275: PO_DEBUG.debug_stmt(p_log_head => g_log_head || l_api_name,

3271: Begin
3272: l_progress := '000';
3273: IF g_debug_stmt THEN
3274: PO_DEBUG.debug_begin(p_log_head => g_log_head || l_api_name);
3275: PO_DEBUG.debug_stmt(p_log_head => g_log_head || l_api_name,
3276: p_token => l_progress,
3277: p_message => p_document_type ||' '|| p_document_id ||' '|| p_revision_number ||' '|| p_blob_type);
3278: END IF;
3279:

Line 3292: PO_DEBUG.debug_stmt(p_log_head => g_log_head || l_api_name,

3288: l_file_name := p_file_name;
3289: ELSIF p_blob_type = 'ZIP' THEN
3290: l_org_id := po_moac_utils_pvt.get_current_org_id; --
3291: IF g_debug_stmt THEN
3292: PO_DEBUG.debug_stmt(p_log_head => g_log_head || l_api_name,
3293: p_token => l_progress,
3294: p_message => 'Calculated org_id = '|| l_org_id);
3295: END IF;
3296:

Line 3352: PO_DEBUG.debug_stmt(p_log_head => g_log_head || l_api_name,

3348: End;
3349: END IF;
3350: l_progress := '040';
3351: IF g_debug_stmt THEN
3352: PO_DEBUG.debug_stmt(p_log_head => g_log_head || l_api_name,
3353: p_token => l_progress,
3354: p_message => 'x_media_id = '|| x_media_id);
3355: END IF;
3356:

Line 3499: PO_DEBUG.debug_end(p_log_head => g_log_head || l_api_name);

3495: l_progress := '080';
3496: END IF;
3497:
3498: IF g_debug_stmt THEN
3499: PO_DEBUG.debug_end(p_log_head => g_log_head || l_api_name);
3500: END IF;
3501:
3502: Exception
3503: WHEN OTHERS THEN

Line 3505: PO_DEBUG.debug_exc(p_log_head => g_log_head || l_api_name,

3501:
3502: Exception
3503: WHEN OTHERS THEN
3504: IF g_debug_unexp THEN
3505: PO_DEBUG.debug_exc(p_log_head => g_log_head || l_api_name,
3506: p_progress => l_progress);
3507: END IF;
3508: raise;
3509: end Store_Blob;

Line 7552: PO_DEBUG.debug_begin(p_log_head => g_log_head || l_api_name);

7548:
7549: l_progress := '000';
7550:
7551: IF g_debug_stmt THEN
7552: PO_DEBUG.debug_begin(p_log_head => g_log_head || l_api_name);
7553: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_document_id', p_document_id);
7554: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_document_type', p_document_type);
7555: END IF;
7556:

Line 7553: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_document_id', p_document_id);

7549: l_progress := '000';
7550:
7551: IF g_debug_stmt THEN
7552: PO_DEBUG.debug_begin(p_log_head => g_log_head || l_api_name);
7553: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_document_id', p_document_id);
7554: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_document_type', p_document_type);
7555: END IF;
7556:
7557: BEGIN

Line 7554: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_document_type', p_document_type);

7550:
7551: IF g_debug_stmt THEN
7552: PO_DEBUG.debug_begin(p_log_head => g_log_head || l_api_name);
7553: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_document_id', p_document_id);
7554: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_document_type', p_document_type);
7555: END IF;
7556:
7557: BEGIN
7558:

Line 7571: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'l_language_code', l_language_code);

7567:
7568: l_progress := '020';
7569:
7570: IF g_debug_stmt THEN
7571: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'l_language_code', l_language_code);
7572: END IF;
7573:
7574: -- Query for getting the PO number i.e segment1.
7575: IF p_document_type in ('PO', 'PA') THEN

Line 7619: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'l_file_name', l_file_name);

7615: END IF;
7616: /* Begin Edit By Akyanama Bug # 13342437*/
7617: l_progress := '900';
7618: IF g_debug_stmt THEN
7619: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'l_file_name', l_file_name);
7620: PO_DEBUG.debug_end(g_log_head || l_api_name);
7621: END IF;
7622:
7623: RETURN l_file_name;

Line 7620: PO_DEBUG.debug_end(g_log_head || l_api_name);

7616: /* Begin Edit By Akyanama Bug # 13342437*/
7617: l_progress := '900';
7618: IF g_debug_stmt THEN
7619: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'l_file_name', l_file_name);
7620: PO_DEBUG.debug_end(g_log_head || l_api_name);
7621: END IF;
7622:
7623: RETURN l_file_name;
7624:

Line 8292: PO_DEBUG.debug_begin(p_log_head => g_log_head || l_api_name);

8288: BEGIN
8289: l_progress := '000';
8290:
8291: IF g_debug_stmt THEN
8292: PO_DEBUG.debug_begin(p_log_head => g_log_head || l_api_name);
8293: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_document_id', p_document_id);
8294: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_document_type', p_document_type);
8295: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_profile_option', p_profile_option);
8296: END IF;

Line 8293: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_document_id', p_document_id);

8289: l_progress := '000';
8290:
8291: IF g_debug_stmt THEN
8292: PO_DEBUG.debug_begin(p_log_head => g_log_head || l_api_name);
8293: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_document_id', p_document_id);
8294: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_document_type', p_document_type);
8295: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_profile_option', p_profile_option);
8296: END IF;
8297:

Line 8294: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_document_type', p_document_type);

8290:
8291: IF g_debug_stmt THEN
8292: PO_DEBUG.debug_begin(p_log_head => g_log_head || l_api_name);
8293: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_document_id', p_document_id);
8294: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_document_type', p_document_type);
8295: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_profile_option', p_profile_option);
8296: END IF;
8297:
8298: IF p_document_type = 'RELEASE' THEN

Line 8295: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_profile_option', p_profile_option);

8291: IF g_debug_stmt THEN
8292: PO_DEBUG.debug_begin(p_log_head => g_log_head || l_api_name);
8293: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_document_id', p_document_id);
8294: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_document_type', p_document_type);
8295: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_profile_option', p_profile_option);
8296: END IF;
8297:
8298: IF p_document_type = 'RELEASE' THEN
8299: SELECT wf_item_type, wf_item_key

Line 8317: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'x_item_type', x_item_type);

8313:
8314: END IF;
8315:
8316: IF g_debug_stmt THEN
8317: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'x_item_type', x_item_type);
8318: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'x_item_key', x_item_key);
8319: END IF;
8320:
8321: l_progress := '003';

Line 8318: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'x_item_key', x_item_key);

8314: END IF;
8315:
8316: IF g_debug_stmt THEN
8317: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'x_item_type', x_item_type);
8318: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'x_item_key', x_item_key);
8319: END IF;
8320:
8321: l_progress := '003';
8322: IF x_item_type IS NOT NULL AND

Line 8345: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'l_preparer_user_id', l_preparer_user_id);

8341: itemkey => x_item_key,
8342: aname => 'APPLICATION_ID');
8343:
8344: IF g_debug_stmt THEN
8345: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'l_preparer_user_id', l_preparer_user_id);
8346: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'l_preparer_resp_id', l_preparer_resp_id);
8347: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'l_preparer_resp_appl_id', l_preparer_resp_appl_id);
8348: END IF;
8349:

Line 8346: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'l_preparer_resp_id', l_preparer_resp_id);

8342: aname => 'APPLICATION_ID');
8343:
8344: IF g_debug_stmt THEN
8345: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'l_preparer_user_id', l_preparer_user_id);
8346: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'l_preparer_resp_id', l_preparer_resp_id);
8347: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'l_preparer_resp_appl_id', l_preparer_resp_appl_id);
8348: END IF;
8349:
8350: l_progress := '007';

Line 8347: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'l_preparer_resp_appl_id', l_preparer_resp_appl_id);

8343:
8344: IF g_debug_stmt THEN
8345: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'l_preparer_user_id', l_preparer_user_id);
8346: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'l_preparer_resp_id', l_preparer_resp_id);
8347: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'l_preparer_resp_appl_id', l_preparer_resp_appl_id);
8348: END IF;
8349:
8350: l_progress := '007';
8351:

Line 8378: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'l_profile_value', l_profile_value);

8374: l_progress := '013';
8375: END IF;
8376:
8377: IF g_debug_stmt THEN
8378: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'l_profile_value', l_profile_value);
8379: END IF;
8380:
8381: RETURN l_profile_value;
8382:

Line 8386: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'IN Exception sqlcode', SQLCODE);

8382:
8383: EXCEPTION
8384: WHEN OTHERS THEN
8385: IF g_debug_stmt THEN
8386: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'IN Exception sqlcode', SQLCODE);
8387: END IF;
8388:
8389: FND_PROFILE.GET(p_profile_option, l_profile_value);
8390:

Line 8392: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'l_profile_value', l_profile_value);

8388:
8389: FND_PROFILE.GET(p_profile_option, l_profile_value);
8390:
8391: IF g_debug_stmt THEN
8392: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'l_profile_value', l_profile_value);
8393: PO_DEBUG.debug_end(g_log_head || l_api_name);
8394: END IF;
8395:
8396: RETURN l_profile_value;

Line 8393: PO_DEBUG.debug_end(g_log_head || l_api_name);

8389: FND_PROFILE.GET(p_profile_option, l_profile_value);
8390:
8391: IF g_debug_stmt THEN
8392: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'l_profile_value', l_profile_value);
8393: PO_DEBUG.debug_end(g_log_head || l_api_name);
8394: END IF;
8395:
8396: RETURN l_profile_value;
8397: