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 117: g_debug_stmt CONSTANT BOOLEAN := PO_DEBUG.is_debug_stmt_on;

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

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

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

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

2278:
2279: BEGIN
2280: l_progress := '000';
2281: IF g_debug_stmt THEN
2282: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);
2283: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
2284: p_token => l_progress,
2285: p_message => 'Communication method '||p_mode);
2286: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

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

2279: BEGIN
2280: l_progress := '000';
2281: IF g_debug_stmt THEN
2282: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);
2283: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
2284: p_token => l_progress,
2285: p_message => 'Communication method '||p_mode);
2286: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
2287: p_token => l_progress,

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

2282: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);
2283: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
2284: p_token => l_progress,
2285: p_message => 'Communication method '||p_mode);
2286: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
2287: p_token => l_progress,
2288: p_message => 'Document Type '||p_document_type);
2289: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
2290: p_token => l_progress,

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

2285: p_message => 'Communication method '||p_mode);
2286: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
2287: p_token => l_progress,
2288: p_message => 'Document Type '||p_document_type);
2289: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
2290: p_token => l_progress,
2291: p_message => 'Authorization Status '||p_authorization_status);
2292: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
2293: p_token => l_progress,

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

2288: p_message => 'Document Type '||p_document_type);
2289: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
2290: p_token => l_progress,
2291: p_message => 'Authorization Status '||p_authorization_status);
2292: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
2293: p_token => l_progress,
2294: p_message => 'Document Id '||p_document_id);
2295: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
2296: p_token => l_progress,

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

2291: p_message => 'Authorization Status '||p_authorization_status);
2292: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
2293: p_token => l_progress,
2294: p_message => 'Document Id '||p_document_id);
2295: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
2296: p_token => l_progress,
2297: p_message => 'With Terms '||p_with_terms);
2298: END IF;
2299:

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

2327: where ph.po_header_id = pr.po_header_id and pr.po_release_id = p_document_id and
2328: ph.vendor_site_id = pvs.vendor_site_id ;
2329: end if;
2330: IF g_debug_stmt THEN
2331: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
2332: p_token => l_progress,
2333: p_message => 'Supplier Language: '||l_supp_lang);
2334: END IF;
2335: exception

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

2334: END IF;
2335: exception
2336: when others then l_supp_lang := NULL;
2337: IF g_debug_stmt THEN
2338: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
2339: p_token => l_progress,
2340: p_message => 'Supplier Language not found');
2341: END IF;
2342: end;

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

2363:
2364: if l_conterm_exists_flag = 'Y' then
2365: l_progress := '030';
2366: IF g_debug_stmt THEN
2367: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
2368: p_token => l_progress,
2369: p_message => 'Checking for latest PDF with terms in Contracts Repository');
2370: END IF;
2371:

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

2392:
2393: else
2394: l_progress := '031';
2395: IF g_debug_stmt THEN
2396: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
2397: p_token => l_progress,
2398: p_message => 'Checking for latest PDF without terms in suppliers language in PO Repository');
2399: END IF;
2400:

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

2423: end if;
2424:
2425: l_progress := '040';
2426: IF g_debug_stmt THEN
2427: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
2428: p_token => l_progress,
2429: p_message => 'Checking for latest PDF without terms in buyers language in PO Repository');
2430: END IF;
2431:

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

2450:
2451: else
2452: l_progress := '050';
2453: IF g_debug_stmt THEN
2454: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
2455: p_token => l_progress,
2456: p_message => 'Checking for latest PDF without terms in suppliers language in PO Repository');
2457: END IF;
2458:

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

2494: Exception
2495: When others then
2496: l_progress := '070';
2497: IF g_debug_unexp THEN
2498: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,
2499: p_progress => l_progress);
2500: END IF;
2501: raise;
2502: End;

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

2504: -- Instead it would return null, so raise exception explicitly
2505: IF l_revision_num IS NULL THEN
2506: l_progress := '080';
2507: IF g_debug_unexp THEN
2508: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,
2509: p_progress => l_progress);
2510: END IF;
2511: raise no_data_found;
2512: END IF;

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

2521: end if; -- if (p_authorization_status = 'APPROVED' or p_authorization_status = 'PRE-APPROVED')
2522:
2523: l_progress := '090';
2524: IF g_debug_stmt THEN
2525: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
2526: p_token => l_progress,
2527: p_message => 'Decide on which PDFs to generate and store');
2528: END IF;
2529:

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

2604: end if; -- if p_with_terms = 'Y'
2605:
2606: l_progress := '110';
2607: IF g_debug_stmt THEN
2608: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
2609: p_token => l_progress,
2610: p_message => 'Lanuch Communicate Requests');
2611: END IF;
2612:

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

2668:
2669: -- Now make cache documents
2670: l_progress := '160';
2671: IF g_debug_stmt THEN
2672: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
2673: p_token => l_progress,
2674: p_message => 'Generate Cache PDFs and store them in the repository');
2675: END IF;
2676:

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

2782: commit;
2783:
2784: l_progress := '230';
2785: IF g_debug_stmt THEN
2786: PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name);
2787: END IF;
2788:
2789: exception
2790: when others then

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

2788:
2789: exception
2790: when others then
2791: IF g_debug_unexp THEN
2792: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,
2793: p_progress => l_progress);
2794: END IF;
2795: raise;
2796: end Communicate;

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

2860:
2861: Begin
2862: l_progress := '000';
2863: IF g_debug_stmt THEN
2864: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);
2865: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
2866: p_token => l_progress,
2867: p_message => p_document_type||' '||p_document_id||' '||p_revision_number||' '||p_blob_type);
2868: END IF;

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

2861: Begin
2862: l_progress := '000';
2863: IF g_debug_stmt THEN
2864: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);
2865: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
2866: p_token => l_progress,
2867: p_message => p_document_type||' '||p_document_id||' '||p_revision_number||' '||p_blob_type);
2868: END IF;
2869:

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

2873: l_file_name := p_file_name;
2874: ELSIF p_blob_type = 'ZIP' THEN
2875: l_org_id := po_moac_utils_pvt.get_current_org_id; --
2876: IF g_debug_stmt THEN
2877: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
2878: p_token => l_progress,
2879: p_message => 'Calculated org_id = '||l_org_id);
2880: END IF;
2881: l_file_content_type := 'application/x-zip-compressed';

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

2924: End;
2925: END IF;
2926: l_progress := '040';
2927: IF g_debug_stmt THEN
2928: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
2929: p_token => l_progress,
2930: p_message => 'x_media_id = '||x_media_id);
2931: END IF;
2932:

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

3070: l_progress := '080';
3071: END IF;
3072:
3073: IF g_debug_stmt THEN
3074: PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name);
3075: END IF;
3076:
3077: Exception
3078: WHEN OTHERS THEN

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

3076:
3077: Exception
3078: WHEN OTHERS THEN
3079: IF g_debug_unexp THEN
3080: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,
3081: p_progress => l_progress);
3082: END IF;
3083: raise;
3084: end Store_Blob;

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

6420:
6421: l_progress := '000';
6422:
6423: IF g_debug_stmt THEN
6424: PO_DEBUG.debug_begin(p_log_head => g_log_head || l_api_name);
6425: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_document_id', p_document_id);
6426: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_document_type', p_document_type);
6427: END IF;
6428:

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

6421: l_progress := '000';
6422:
6423: IF g_debug_stmt THEN
6424: PO_DEBUG.debug_begin(p_log_head => g_log_head || l_api_name);
6425: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_document_id', p_document_id);
6426: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_document_type', p_document_type);
6427: END IF;
6428:
6429: BEGIN

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

6422:
6423: IF g_debug_stmt THEN
6424: PO_DEBUG.debug_begin(p_log_head => g_log_head || l_api_name);
6425: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_document_id', p_document_id);
6426: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_document_type', p_document_type);
6427: END IF;
6428:
6429: BEGIN
6430:

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

6437:
6438: l_progress := '020';
6439:
6440: IF g_debug_stmt THEN
6441: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'l_language_code', l_language_code);
6442: END IF;
6443:
6444: -- Query for getting the PO number i.e segment1.
6445: IF p_document_type in ('PO','PA') THEN

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

6464: l_file_name := p_document_type||p_terms||p_orgid||'_'||l_po_number||'_'||p_revision_num||'_'||l_language_code||p_extension;
6465:
6466: l_progress := '900';
6467: IF g_debug_stmt THEN
6468: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'l_file_name', l_file_name);
6469: PO_DEBUG.debug_end(g_log_head || l_api_name);
6470: END IF;
6471:
6472: RETURN l_file_name;

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

6465:
6466: l_progress := '900';
6467: IF g_debug_stmt THEN
6468: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'l_file_name', l_file_name);
6469: PO_DEBUG.debug_end(g_log_head || l_api_name);
6470: END IF;
6471:
6472: RETURN l_file_name;
6473:

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

7093: BEGIN
7094: l_progress := '000';
7095:
7096: IF g_debug_stmt THEN
7097: PO_DEBUG.debug_begin(p_log_head => g_log_head || l_api_name);
7098: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_document_id', p_document_id);
7099: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_document_type', p_document_type);
7100: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_profile_option', p_profile_option);
7101: END IF;

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

7094: l_progress := '000';
7095:
7096: IF g_debug_stmt THEN
7097: PO_DEBUG.debug_begin(p_log_head => g_log_head || l_api_name);
7098: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_document_id', p_document_id);
7099: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_document_type', p_document_type);
7100: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_profile_option', p_profile_option);
7101: END IF;
7102:

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

7095:
7096: IF g_debug_stmt THEN
7097: PO_DEBUG.debug_begin(p_log_head => g_log_head || l_api_name);
7098: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_document_id', p_document_id);
7099: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_document_type', p_document_type);
7100: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_profile_option', p_profile_option);
7101: END IF;
7102:
7103: IF p_document_type = 'RELEASE' THEN

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

7096: IF g_debug_stmt THEN
7097: PO_DEBUG.debug_begin(p_log_head => g_log_head || l_api_name);
7098: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_document_id', p_document_id);
7099: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_document_type', p_document_type);
7100: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_profile_option', p_profile_option);
7101: END IF;
7102:
7103: IF p_document_type = 'RELEASE' THEN
7104: SELECT wf_item_type, wf_item_key

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

7118:
7119: END IF;
7120:
7121: IF g_debug_stmt THEN
7122: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'x_item_type', x_item_type);
7123: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'x_item_key', x_item_key);
7124: END IF;
7125:
7126: l_progress := '003';

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

7119: END IF;
7120:
7121: IF g_debug_stmt THEN
7122: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'x_item_type', x_item_type);
7123: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'x_item_key', x_item_key);
7124: END IF;
7125:
7126: l_progress := '003';
7127: IF x_item_type IS NOT NULL AND

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

7146: itemkey => x_item_key,
7147: aname => 'APPLICATION_ID');
7148:
7149: IF g_debug_stmt THEN
7150: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'l_preparer_user_id', l_preparer_user_id);
7151: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'l_preparer_resp_id', l_preparer_resp_id);
7152: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'l_preparer_resp_appl_id', l_preparer_resp_appl_id);
7153: END IF;
7154:

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

7147: aname => 'APPLICATION_ID');
7148:
7149: IF g_debug_stmt THEN
7150: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'l_preparer_user_id', l_preparer_user_id);
7151: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'l_preparer_resp_id', l_preparer_resp_id);
7152: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'l_preparer_resp_appl_id', l_preparer_resp_appl_id);
7153: END IF;
7154:
7155: l_progress := '007';

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

7148:
7149: IF g_debug_stmt THEN
7150: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'l_preparer_user_id', l_preparer_user_id);
7151: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'l_preparer_resp_id', l_preparer_resp_id);
7152: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'l_preparer_resp_appl_id', l_preparer_resp_appl_id);
7153: END IF;
7154:
7155: l_progress := '007';
7156:

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

7179: l_progress := '013';
7180: END IF;
7181:
7182: IF g_debug_stmt THEN
7183: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'l_profile_value', l_profile_value);
7184: END IF;
7185:
7186: RETURN l_profile_value;
7187:

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

7187:
7188: EXCEPTION
7189: WHEN OTHERS THEN
7190: IF g_debug_stmt THEN
7191: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'IN Exception sqlcode', SQLCODE);
7192: END IF;
7193:
7194: FND_PROFILE.GET(p_profile_option,l_profile_value);
7195:

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

7193:
7194: FND_PROFILE.GET(p_profile_option,l_profile_value);
7195:
7196: IF g_debug_stmt THEN
7197: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'l_profile_value', l_profile_value);
7198: PO_DEBUG.debug_end(g_log_head || l_api_name);
7199: END IF;
7200:
7201: RETURN l_profile_value;

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

7194: FND_PROFILE.GET(p_profile_option,l_profile_value);
7195:
7196: IF g_debug_stmt THEN
7197: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'l_profile_value', l_profile_value);
7198: PO_DEBUG.debug_end(g_log_head || l_api_name);
7199: END IF;
7200:
7201: RETURN l_profile_value;
7202: