DBA Data[Home] [Help]

APPS.PO_CLOSEOUT_PVT dependencies on FND_MESSAGE

Line 2291: l_messages := l_messages || ' '|| fnd_message.get_string('PO','PO_CLSOUT_ELIGIBLE_NOTIF_BODY') ||

2287: IF(l_doc_num_tbl.Count > 0) THEN
2288:
2289: --dbms_lob.createtemporary(l_document, true);
2290: --dbms_lob.open(l_document, dbms_lob.lob_readwrite);
2291: l_messages := l_messages || ' '|| fnd_message.get_string('PO','PO_CLSOUT_ELIGIBLE_NOTIF_BODY') ||
2292: '';
2293:
2294: l_messages := l_messages ||'';
2295: l_messages := l_messages ||'';

Line 2295: l_messages := l_messages ||'
';

2291: l_messages := l_messages || '

' || fnd_message.get_string('PO','PO_MUB_MSG_DOC_NUM') || '
' || fnd_message.get_string('PO','PO_MUB_MSG_DOC_NUM') || '
'|| fnd_message.get_string('PO','PO_CLSOUT_ELIGIBLE_NOTIF_BODY') ||
2292: '
';
2293:
2294: l_messages := l_messages ||'';
2295: l_messages := l_messages ||'';
2296: l_messages := l_messages ||'';
2297: l_messages := l_messages ||'';
2298: l_messages := l_messages ||'';
2299: l_messages := l_messages ||'';

Line 2296: l_messages := l_messages ||'
';

2292: '

' || fnd_message.get_string('PO','PO_MUB_MSG_DOC_NUM') || '' || fnd_message.get_string('PO','PO_WF_NOTIF_DESCRIPTION') || '' || fnd_message.get_string('PO','PO_MUB_MSG_DOC_TYPE') || '' || fnd_message.get_string('PO','PO_SOURCING_STATUS') || '' || fnd_message.get_string('PO','PO_ALL_SUPPLIER') || ' ' || fnd_message.get_string('PO','PO_WF_NOTIF_DESCRIPTION') || '
';
2293:
2294: l_messages := l_messages ||'';
2295: l_messages := l_messages ||'';
2296: l_messages := l_messages ||'';
2297: l_messages := l_messages ||'';
2298: l_messages := l_messages ||'';
2299: l_messages := l_messages ||'';
2300: l_messages := l_messages ||'';

Line 2297: l_messages := l_messages ||'
';

2293:
2294: l_messages := l_messages ||'

' || fnd_message.get_string('PO','PO_MUB_MSG_DOC_NUM') || ' ' || fnd_message.get_string('PO','PO_WF_NOTIF_DESCRIPTION') || '' || fnd_message.get_string('PO','PO_MUB_MSG_DOC_TYPE') || '' || fnd_message.get_string('PO','PO_SOURCING_STATUS') || '' || fnd_message.get_string('PO','PO_ALL_SUPPLIER') || '' || fnd_message.get_string('PO','PO_WF_NOTIF_AMOUNT') || ' ' || fnd_message.get_string('PO','PO_MUB_MSG_DOC_TYPE') || '
';
2295: l_messages := l_messages ||'';
2296: l_messages := l_messages ||'';
2297: l_messages := l_messages ||'';
2298: l_messages := l_messages ||'';
2299: l_messages := l_messages ||'';
2300: l_messages := l_messages ||'';
2301: l_messages := l_messages ||'';

Line 2298: l_messages := l_messages ||'
';

2294: l_messages := l_messages ||'

' || fnd_message.get_string('PO','PO_MUB_MSG_DOC_NUM') || '' || fnd_message.get_string('PO','PO_WF_NOTIF_DESCRIPTION') || ' ' || fnd_message.get_string('PO','PO_MUB_MSG_DOC_TYPE') || '' || fnd_message.get_string('PO','PO_SOURCING_STATUS') || '' || fnd_message.get_string('PO','PO_ALL_SUPPLIER') || '' || fnd_message.get_string('PO','PO_WF_NOTIF_AMOUNT') || '' || fnd_message.get_string('PO','PO_CURRENCY_CODE') || '
' || fnd_message.get_string('PO','PO_SOURCING_STATUS') || '
';
2295: l_messages := l_messages ||'';
2296: l_messages := l_messages ||'';
2297: l_messages := l_messages ||'';
2298: l_messages := l_messages ||'';
2299: l_messages := l_messages ||'';
2300: l_messages := l_messages ||'';
2301: l_messages := l_messages ||'';
2302: l_progress := 20;

Line 2299: l_messages := l_messages ||'
';

2295: l_messages := l_messages ||'

';
2296: l_messages := l_messages ||'';
2297: l_messages := l_messages ||'';
2298: l_messages := l_messages ||'';
2299: l_messages := l_messages ||'';
2300: l_messages := l_messages ||'';
2301: l_messages := l_messages ||'';
2302: l_progress := 20;
2303: --DBMS_LOB.writeappend(l_document,Length(l_messages),l_messages);

Line 2300: l_messages := l_messages ||'
';

2296: l_messages := l_messages ||'

';
2297: l_messages := l_messages ||'';
2298: l_messages := l_messages ||'';
2299: l_messages := l_messages ||'';
2300: l_messages := l_messages ||'';
2301: l_messages := l_messages ||'';
2302: l_progress := 20;
2303: --DBMS_LOB.writeappend(l_document,Length(l_messages),l_messages);
2304: FOR i IN l_doc_num_tbl.FIRST .. l_doc_num_tbl.LAST

Line 2301: l_messages := l_messages ||'
';

2297: l_messages := l_messages ||'

';
2298: l_messages := l_messages ||'';
2299: l_messages := l_messages ||'';
2300: l_messages := l_messages ||'';
2301: l_messages := l_messages ||'';
2302: l_progress := 20;
2303: --DBMS_LOB.writeappend(l_document,Length(l_messages),l_messages);
2304: FOR i IN l_doc_num_tbl.FIRST .. l_doc_num_tbl.LAST
2305: LOOP

Line 2329: avalue => fnd_message.get_string('PO','PO_CLSOUT_ELIGIBLE_NOTIF_SUB') || ' <' || po_moac_utils_pvt.GET_OU_NAME(po_moac_utils_pvt.GET_CURRENT_ORG_ID) || '>');

2325: );
2326:
2327: wf_notification.Setattrtext(nid => l_notification_id,
2328: aname =>'MESSAGE_SUBJECT',
2329: avalue => fnd_message.get_string('PO','PO_CLSOUT_ELIGIBLE_NOTIF_SUB') || ' <' || po_moac_utils_pvt.GET_OU_NAME(po_moac_utils_pvt.GET_CURRENT_ORG_ID) || '>');
2330:
2331: wf_notification.Setattrtext(nid => l_notification_id,
2332: aname => 'CONTRACT_ADMIN_PAGE',
2333: avalue => 'JSP:/OA_HTML/OA.jsp?OAFunc=PO_MULTI_MOD'||'&'||

Line 2425: l_msgbody := l_msgbody || l_messages || '
' || fnd_message.get_string('PO','PO_MUB_MSG_DOC_NUM') || '' || fnd_message.get_string('PO','PO_WF_NOTIF_DESCRIPTION') || '' || fnd_message.get_string('PO','PO_MUB_MSG_DOC_TYPE') || ' ' || fnd_message.get_string('PO','PO_SOURCING_STATUS') || '' || fnd_message.get_string('PO','PO_ALL_SUPPLIER') || '' || fnd_message.get_string('PO','PO_WF_NOTIF_AMOUNT') || '' || fnd_message.get_string('PO','PO_CURRENCY_CODE') || '
' || fnd_message.get_string('PO','PO_ALL_SUPPLIER') || '
' || fnd_message.get_string('PO','PO_MUB_MSG_DOC_NUM') || '' || fnd_message.get_string('PO','PO_WF_NOTIF_DESCRIPTION') || '' || fnd_message.get_string('PO','PO_MUB_MSG_DOC_TYPE') || '' || fnd_message.get_string('PO','PO_SOURCING_STATUS') || ' ' || fnd_message.get_string('PO','PO_ALL_SUPPLIER') || '' || fnd_message.get_string('PO','PO_WF_NOTIF_AMOUNT') || '' || fnd_message.get_string('PO','PO_CURRENCY_CODE') || '
' || fnd_message.get_string('PO','PO_WF_NOTIF_AMOUNT') || ' ' || fnd_message.get_string('PO','PO_WF_NOTIF_DESCRIPTION') || '' || fnd_message.get_string('PO','PO_MUB_MSG_DOC_TYPE') || '' || fnd_message.get_string('PO','PO_SOURCING_STATUS') || '' || fnd_message.get_string('PO','PO_ALL_SUPPLIER') || ' ' || fnd_message.get_string('PO','PO_WF_NOTIF_AMOUNT') || '' || fnd_message.get_string('PO','PO_CURRENCY_CODE') || '
' || fnd_message.get_string('PO','PO_CURRENCY_CODE') || '
' || fnd_message.get_string('PO','PO_MUB_MSG_DOC_TYPE') || '' || fnd_message.get_string('PO','PO_SOURCING_STATUS') || '' || fnd_message.get_string('PO','PO_ALL_SUPPLIER') || '' || fnd_message.get_string('PO','PO_WF_NOTIF_AMOUNT') || ' ' || fnd_message.get_string('PO','PO_CURRENCY_CODE') || '
'||fnd_message.get_string('PO','PO_CLSOUT_NOTIF_CHOOSE_ACTION')||'
';

2421: table.gridtable th{ border-width: 1px; padding: 8px; border-style: solid; border-color: #666666; background-color: #dedede;}
2422: table.gridtable td{ border-width: 1px; padding: 8px; border-style: solid; border-color: #666666; background-color: #ffffff;}
2423: .OraCopyright{ display: none; } .OraLegal{ display: none; } .OraPrivacy{ display: none; } tr:hover td.OraTableCellText{ background-color: wheat; }
2424: ';
2425: l_msgbody := l_msgbody || l_messages || '
'||fnd_message.get_string('PO','PO_CLSOUT_NOTIF_CHOOSE_ACTION')||'
';
2426:
2427: WF_NOTIFICATION.WriteToClob(document, l_msgbody);
2428:
2429: l_progress := 4;

Line 2996: fnd_message.set_name('PO','PO_CLSOUT_TASK_ACT_ERR_BODY');

2992:
2993:
2994: IF ( l_message_type = 'CLSOUT_TASK_ACT_ERR') THEN
2995:
2996: fnd_message.set_name('PO','PO_CLSOUT_TASK_ACT_ERR_BODY');
2997:
2998: ELSIF (l_message_type = 'CLSOUT_PDF_GEN_ERR') THEN
2999:
3000: fnd_message.set_name('PO','PO_CLSOUT_PDF_GEN_ERR_BODY');

Line 3000: fnd_message.set_name('PO','PO_CLSOUT_PDF_GEN_ERR_BODY');

2996: fnd_message.set_name('PO','PO_CLSOUT_TASK_ACT_ERR_BODY');
2997:
2998: ELSIF (l_message_type = 'CLSOUT_PDF_GEN_ERR') THEN
2999:
3000: fnd_message.set_name('PO','PO_CLSOUT_PDF_GEN_ERR_BODY');
3001: fnd_message.set_token('PDF_TYPE',l_pdf_type);
3002:
3003: END IF;
3004:

Line 3001: fnd_message.set_token('PDF_TYPE',l_pdf_type);

2997:
2998: ELSIF (l_message_type = 'CLSOUT_PDF_GEN_ERR') THEN
2999:
3000: fnd_message.set_name('PO','PO_CLSOUT_PDF_GEN_ERR_BODY');
3001: fnd_message.set_token('PDF_TYPE',l_pdf_type);
3002:
3003: END IF;
3004:
3005: fnd_message.set_token('DOC_SUB_TYPE',l_doc_sub_type);

Line 3005: fnd_message.set_token('DOC_SUB_TYPE',l_doc_sub_type);

3001: fnd_message.set_token('PDF_TYPE',l_pdf_type);
3002:
3003: END IF;
3004:
3005: fnd_message.set_token('DOC_SUB_TYPE',l_doc_sub_type);
3006: fnd_message.set_token('CLM_DOCUMENT_NUMBER',l_clm_document_number);
3007:
3008: l_msgbody := fnd_message.get;
3009:

Line 3006: fnd_message.set_token('CLM_DOCUMENT_NUMBER',l_clm_document_number);

3002:
3003: END IF;
3004:
3005: fnd_message.set_token('DOC_SUB_TYPE',l_doc_sub_type);
3006: fnd_message.set_token('CLM_DOCUMENT_NUMBER',l_clm_document_number);
3007:
3008: l_msgbody := fnd_message.get;
3009:
3010: WF_NOTIFICATION.WriteToClob(document, l_msgbody);

Line 3008: l_msgbody := fnd_message.get;

3004:
3005: fnd_message.set_token('DOC_SUB_TYPE',l_doc_sub_type);
3006: fnd_message.set_token('CLM_DOCUMENT_NUMBER',l_clm_document_number);
3007:
3008: l_msgbody := fnd_message.get;
3009:
3010: WF_NOTIFICATION.WriteToClob(document, l_msgbody);
3011:
3012: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'PO_CLOSEOUT_PVT.get_clsout_err_msg_body: 03');

Line 3089: l_msgbody := l_msgbody || l_messages || '
'||fnd_message.get_string('PO','PO_CONTROL_CHOOSE_ACTION')||'
';

3085:
3086: l_msgbody := '
3087: ';
3088: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'PO_CLOSEOUT_PVT.get_val_notfn_body: 07');
3089: l_msgbody := l_msgbody || l_messages || '
'||fnd_message.get_string('PO','PO_CONTROL_CHOOSE_ACTION')||'
';
3090:
3091: WF_NOTIFICATION.WriteToClob(document, l_msgbody);
3092:
3093: l_progress := 4;

Line 3183: fnd_message.set_name('PO','PO_CLSOUT_VALIDATION_ERR_SUB');

3179: l_progress := 30;
3180:
3181: IF (l_result_type = c_result_type_FAILURE) THEN
3182: resultout := wf_engine.eng_completed || ':' || 'ERROR' ;
3183: fnd_message.set_name('PO','PO_CLSOUT_VALIDATION_ERR_SUB');
3184: fnd_message.set_token('DOC_SUB_TYPE',l_doc_sub_type);
3185: fnd_message.set_token('CLM_DOCUMENT_NUMBER',l_clm_document_number);
3186:
3187: l_message_subject := fnd_message.get;

Line 3184: fnd_message.set_token('DOC_SUB_TYPE',l_doc_sub_type);

3180:
3181: IF (l_result_type = c_result_type_FAILURE) THEN
3182: resultout := wf_engine.eng_completed || ':' || 'ERROR' ;
3183: fnd_message.set_name('PO','PO_CLSOUT_VALIDATION_ERR_SUB');
3184: fnd_message.set_token('DOC_SUB_TYPE',l_doc_sub_type);
3185: fnd_message.set_token('CLM_DOCUMENT_NUMBER',l_clm_document_number);
3186:
3187: l_message_subject := fnd_message.get;
3188:

Line 3185: fnd_message.set_token('CLM_DOCUMENT_NUMBER',l_clm_document_number);

3181: IF (l_result_type = c_result_type_FAILURE) THEN
3182: resultout := wf_engine.eng_completed || ':' || 'ERROR' ;
3183: fnd_message.set_name('PO','PO_CLSOUT_VALIDATION_ERR_SUB');
3184: fnd_message.set_token('DOC_SUB_TYPE',l_doc_sub_type);
3185: fnd_message.set_token('CLM_DOCUMENT_NUMBER',l_clm_document_number);
3186:
3187: l_message_subject := fnd_message.get;
3188:
3189: fnd_message.set_name('PO','PO_CLSOUT_VALIDATION_ERR_BODY');

Line 3187: l_message_subject := fnd_message.get;

3183: fnd_message.set_name('PO','PO_CLSOUT_VALIDATION_ERR_SUB');
3184: fnd_message.set_token('DOC_SUB_TYPE',l_doc_sub_type);
3185: fnd_message.set_token('CLM_DOCUMENT_NUMBER',l_clm_document_number);
3186:
3187: l_message_subject := fnd_message.get;
3188:
3189: fnd_message.set_name('PO','PO_CLSOUT_VALIDATION_ERR_BODY');
3190: fnd_message.set_token('DOC_SUB_TYPE',l_doc_sub_type);
3191: fnd_message.set_token('CLM_DOCUMENT_NUMBER',l_clm_document_number);

Line 3189: fnd_message.set_name('PO','PO_CLSOUT_VALIDATION_ERR_BODY');

3185: fnd_message.set_token('CLM_DOCUMENT_NUMBER',l_clm_document_number);
3186:
3187: l_message_subject := fnd_message.get;
3188:
3189: fnd_message.set_name('PO','PO_CLSOUT_VALIDATION_ERR_BODY');
3190: fnd_message.set_token('DOC_SUB_TYPE',l_doc_sub_type);
3191: fnd_message.set_token('CLM_DOCUMENT_NUMBER',l_clm_document_number);
3192:
3193: l_messages := l_messages || '

'||fnd_message.get||

Line 3190: fnd_message.set_token('DOC_SUB_TYPE',l_doc_sub_type);

3186:
3187: l_message_subject := fnd_message.get;
3188:
3189: fnd_message.set_name('PO','PO_CLSOUT_VALIDATION_ERR_BODY');
3190: fnd_message.set_token('DOC_SUB_TYPE',l_doc_sub_type);
3191: fnd_message.set_token('CLM_DOCUMENT_NUMBER',l_clm_document_number);
3192:
3193: l_messages := l_messages || '

'||fnd_message.get||
3194: '
    ';

    Line 3191: fnd_message.set_token('CLM_DOCUMENT_NUMBER',l_clm_document_number);

    3187: l_message_subject := fnd_message.get;
    3188:
    3189: fnd_message.set_name('PO','PO_CLSOUT_VALIDATION_ERR_BODY');
    3190: fnd_message.set_token('DOC_SUB_TYPE',l_doc_sub_type);
    3191: fnd_message.set_token('CLM_DOCUMENT_NUMBER',l_clm_document_number);
    3192:
    3193: l_messages := l_messages || '

'||fnd_message.get||
3194: '
    ';
    3195:

    Line 3193: l_messages := l_messages || '
'||fnd_message.get||

3189: fnd_message.set_name('PO','PO_CLSOUT_VALIDATION_ERR_BODY');
3190: fnd_message.set_token('DOC_SUB_TYPE',l_doc_sub_type);
3191: fnd_message.set_token('CLM_DOCUMENT_NUMBER',l_clm_document_number);
3192:
3193: l_messages := l_messages || '

'||fnd_message.get||
3194: '
    ';
    3195:
    3196: ELSIF (l_result_type = c_result_type_WARNING) THEN
    3197: resultout := wf_engine.eng_completed || ':' || 'WARNING' ;

    Line 3198: fnd_message.set_name('PO','PO_CLSOUT_VAL_WARNING_SUB');

    3194: '

    ';
    3195:
    3196: ELSIF (l_result_type = c_result_type_WARNING) THEN
    3197: resultout := wf_engine.eng_completed || ':' || 'WARNING' ;
    3198: fnd_message.set_name('PO','PO_CLSOUT_VAL_WARNING_SUB');
    3199: fnd_message.set_token('DOC_SUB_TYPE',l_doc_sub_type);
    3200: fnd_message.set_token('CLM_DOCUMENT_NUMBER',l_clm_document_number);
    3201:
    3202: l_message_subject := fnd_message.get;

    Line 3199: fnd_message.set_token('DOC_SUB_TYPE',l_doc_sub_type);

    3195:
    3196: ELSIF (l_result_type = c_result_type_WARNING) THEN
    3197: resultout := wf_engine.eng_completed || ':' || 'WARNING' ;
    3198: fnd_message.set_name('PO','PO_CLSOUT_VAL_WARNING_SUB');
    3199: fnd_message.set_token('DOC_SUB_TYPE',l_doc_sub_type);
    3200: fnd_message.set_token('CLM_DOCUMENT_NUMBER',l_clm_document_number);
    3201:
    3202: l_message_subject := fnd_message.get;
    3203:

    Line 3200: fnd_message.set_token('CLM_DOCUMENT_NUMBER',l_clm_document_number);

    3196: ELSIF (l_result_type = c_result_type_WARNING) THEN
    3197: resultout := wf_engine.eng_completed || ':' || 'WARNING' ;
    3198: fnd_message.set_name('PO','PO_CLSOUT_VAL_WARNING_SUB');
    3199: fnd_message.set_token('DOC_SUB_TYPE',l_doc_sub_type);
    3200: fnd_message.set_token('CLM_DOCUMENT_NUMBER',l_clm_document_number);
    3201:
    3202: l_message_subject := fnd_message.get;
    3203:
    3204: fnd_message.set_name('PO','PO_CLSOUT_VAL_WARNING_BODY');

    Line 3202: l_message_subject := fnd_message.get;

    3198: fnd_message.set_name('PO','PO_CLSOUT_VAL_WARNING_SUB');
    3199: fnd_message.set_token('DOC_SUB_TYPE',l_doc_sub_type);
    3200: fnd_message.set_token('CLM_DOCUMENT_NUMBER',l_clm_document_number);
    3201:
    3202: l_message_subject := fnd_message.get;
    3203:
    3204: fnd_message.set_name('PO','PO_CLSOUT_VAL_WARNING_BODY');
    3205: fnd_message.set_token('DOC_SUB_TYPE',l_doc_sub_type);
    3206: fnd_message.set_token('CLM_DOCUMENT_NUMBER',l_clm_document_number);

    Line 3204: fnd_message.set_name('PO','PO_CLSOUT_VAL_WARNING_BODY');

    3200: fnd_message.set_token('CLM_DOCUMENT_NUMBER',l_clm_document_number);
    3201:
    3202: l_message_subject := fnd_message.get;
    3203:
    3204: fnd_message.set_name('PO','PO_CLSOUT_VAL_WARNING_BODY');
    3205: fnd_message.set_token('DOC_SUB_TYPE',l_doc_sub_type);
    3206: fnd_message.set_token('CLM_DOCUMENT_NUMBER',l_clm_document_number);
    3207:
    3208: l_messages := l_messages || '

'||fnd_message.get||

Line 3205: fnd_message.set_token('DOC_SUB_TYPE',l_doc_sub_type);

3201:
3202: l_message_subject := fnd_message.get;
3203:
3204: fnd_message.set_name('PO','PO_CLSOUT_VAL_WARNING_BODY');
3205: fnd_message.set_token('DOC_SUB_TYPE',l_doc_sub_type);
3206: fnd_message.set_token('CLM_DOCUMENT_NUMBER',l_clm_document_number);
3207:
3208: l_messages := l_messages || '

'||fnd_message.get||
3209: '
    ';

    Line 3206: fnd_message.set_token('CLM_DOCUMENT_NUMBER',l_clm_document_number);

    3202: l_message_subject := fnd_message.get;
    3203:
    3204: fnd_message.set_name('PO','PO_CLSOUT_VAL_WARNING_BODY');
    3205: fnd_message.set_token('DOC_SUB_TYPE',l_doc_sub_type);
    3206: fnd_message.set_token('CLM_DOCUMENT_NUMBER',l_clm_document_number);
    3207:
    3208: l_messages := l_messages || '

'||fnd_message.get||
3209: '
    ';
    3210:

    Line 3208: l_messages := l_messages || '
'||fnd_message.get||

3204: fnd_message.set_name('PO','PO_CLSOUT_VAL_WARNING_BODY');
3205: fnd_message.set_token('DOC_SUB_TYPE',l_doc_sub_type);
3206: fnd_message.set_token('CLM_DOCUMENT_NUMBER',l_clm_document_number);
3207:
3208: l_messages := l_messages || '

'||fnd_message.get||
3209: '
    ';
    3210:
    3211: ELSIF (l_result_type = c_result_type_SUCCESS) THEN
    3212:

    Line 3227: l_msg := fnd_message.get_string('PO', l_results.MESSAGE_NAME(i));

    3223: avalue => l_message_subject);
    3224:
    3225: FOR i IN l_results.MESSAGE_NAME.FIRST .. l_results.MESSAGE_NAME.LAST
    3226: LOOP
    3227: l_msg := fnd_message.get_string('PO', l_results.MESSAGE_NAME(i));
    3228: l_messages := l_messages || '

  1. ' || l_msg || '
  2. ';
    3229: END LOOP;
    3230:
    3231: wf_engine.setitemattrtext(itemtype => itemtype,

    Line 3794:

    3790:
    3791: get_user_name(l_buyer_id, l_buyer_name,l_buyer_dsp_name);
    3792:
    3793: l_msgbody := '
    3794:

    '||fnd_message.get_string('PO', 'PO_WF_SIGN_NOTIF_DOCTYPE')||' :

    3795:
    3796:
    3797:
    3798: ';

    Line 3796:

    3792:
    3793: l_msgbody := '
    3794:

    '||fnd_message.get_string('PO', 'PO_WF_SIGN_NOTIF_DOCTYPE')||' : ' || l_doc_type_disp || ' '||fnd_message.get_string('PO', 'PO_WF_SIGN_NOTIF_PO_NUMBER') ||': ' ||l_clm_document_number||','|| l_revision_num || '
    '||fnd_message.get_string('PO', 'PO_WF_SIGN_NOTIF_SUPPLIER')||' : '||fnd_message.get_string('PO', 'PO_WF_SIGN_NOTIF_PO_NUMBER') ||':

    3795:
    3796:
    3797:
    3798: ';
    3799:
    3800: l_msgbody := l_msgbody || '';

    3794:

    '||fnd_message.get_string('PO', 'PO_WF_SIGN_NOTIF_DOCTYPE')||' : ' || l_doc_type_disp || ' '||fnd_message.get_string('PO', 'PO_WF_SIGN_NOTIF_PO_NUMBER') ||': ' ||l_clm_document_number||','|| l_revision_num || '
    '||fnd_message.get_string('PO', 'PO_WF_SIGN_NOTIF_SUPPLIER')||' : ' || l_vendor_name || '

    Line 3798:
    '||fnd_message.get_string('PO', 'PO_WF_SIGN_NOTIF_SUPPLIER')||' :

    3795:
    3796:
    3797:
    3798: ';
    3799:
    3800: l_msgbody := l_msgbody || '
    3802: ';

    Line 3801: '||fnd_message.get_string('PO', 'PO_WF_SIGN_NOTIF_BUYER') ||':

    3797:


    3798: ';
    3799:
    3800: l_msgbody := l_msgbody || '
    3802: ';
    3803:
    3804: l_msgbody := l_msgbody || '
    3805:

    Line 3805:

    3801: '||fnd_message.get_string('PO', 'PO_WF_SIGN_NOTIF_BUYER') ||':
    3802:

    ';
    3803:
    3804: l_msgbody := l_msgbody || '
    3805:
    3806:
    '||fnd_message.get_string('PO', 'PO_WF_SIGN_NOTIF_DOCTYPE')||' : ' || l_doc_type_disp || ' '||fnd_message.get_string('PO', 'PO_WF_SIGN_NOTIF_PO_NUMBER') ||': ' ||l_clm_document_number||','|| l_revision_num || '
    '||fnd_message.get_string('PO', 'PO_WF_SIGN_NOTIF_SUPPLIER')||' : ' || l_vendor_name || '
    3801: '||fnd_message.get_string('PO', 'PO_WF_SIGN_NOTIF_BUYER') ||':
    ' || l_buyer_dsp_name || '
    ' ||l_clm_document_number||','|| l_revision_num || '
    '||fnd_message.get_string('PO', 'PO_WF_SIGN_NOTIF_SUPPLIER')||' : ' || l_vendor_name || '
    3801: '||fnd_message.get_string('PO', 'PO_WF_SIGN_NOTIF_BUYER') ||':
    ' || l_buyer_dsp_name || '
    '||fnd_message.get_string('PO', 'PO_WF_SIGN_NOTIF_DESC')||' : '||fnd_message.get_string('PO', 'PO_WF_SIGN_NOTIF_DESC')||' : ' || l_buyer_dsp_name || '
    '||fnd_message.get_string('PO', 'PO_WF_SIGN_NOTIF_DESC')||' :' || l_comments || '
    ';
    3807:
    3808: l_msgbody := l_msgbody || '';
    3809:

    Line 4383: fnd_message.set_name('PO','PO_CLSOUT_TASK_ACT_ERR_SUB');

    4379:
    4380:
    4381: IF ( l_message_type = 'CLSOUT_TASK_ACT_ERR') THEN
    4382:
    4383: fnd_message.set_name('PO','PO_CLSOUT_TASK_ACT_ERR_SUB');
    4384: fnd_message.set_token('DOC_SUB_TYPE',l_doc_sub_type);
    4385: fnd_message.set_token('CLM_DOCUMENT_NUMBER',l_clm_document_number);
    4386:
    4387: l_message_subject := fnd_message.get;

    Line 4384: fnd_message.set_token('DOC_SUB_TYPE',l_doc_sub_type);

    4380:
    4381: IF ( l_message_type = 'CLSOUT_TASK_ACT_ERR') THEN
    4382:
    4383: fnd_message.set_name('PO','PO_CLSOUT_TASK_ACT_ERR_SUB');
    4384: fnd_message.set_token('DOC_SUB_TYPE',l_doc_sub_type);
    4385: fnd_message.set_token('CLM_DOCUMENT_NUMBER',l_clm_document_number);
    4386:
    4387: l_message_subject := fnd_message.get;
    4388:

    Line 4385: fnd_message.set_token('CLM_DOCUMENT_NUMBER',l_clm_document_number);

    4381: IF ( l_message_type = 'CLSOUT_TASK_ACT_ERR') THEN
    4382:
    4383: fnd_message.set_name('PO','PO_CLSOUT_TASK_ACT_ERR_SUB');
    4384: fnd_message.set_token('DOC_SUB_TYPE',l_doc_sub_type);
    4385: fnd_message.set_token('CLM_DOCUMENT_NUMBER',l_clm_document_number);
    4386:
    4387: l_message_subject := fnd_message.get;
    4388:
    4389: wf_engine.setitemattrtext(itemtype => itemtype,

    Line 4387: l_message_subject := fnd_message.get;

    4383: fnd_message.set_name('PO','PO_CLSOUT_TASK_ACT_ERR_SUB');
    4384: fnd_message.set_token('DOC_SUB_TYPE',l_doc_sub_type);
    4385: fnd_message.set_token('CLM_DOCUMENT_NUMBER',l_clm_document_number);
    4386:
    4387: l_message_subject := fnd_message.get;
    4388:
    4389: wf_engine.setitemattrtext(itemtype => itemtype,
    4390: itemkey => itemkey,
    4391: aname => 'MESSAGE_BODY',

    Line 4396: fnd_message.set_name('PO','PO_CLSOUT_PDF_GEN_ERR_SUB');

    4392: avalue => 'PLSQLCLOB:PO_CLOSEOUT_PVT.get_clsout_err_msg_body/'|| l_message_type ||':'||itemtype||':'||itemkey);
    4393:
    4394: ELSIF ( l_message_type = 'CLSOUT_PDF_GEN_ERR') THEN
    4395:
    4396: fnd_message.set_name('PO','PO_CLSOUT_PDF_GEN_ERR_SUB');
    4397: fnd_message.set_token('DOC_SUB_TYPE',l_doc_sub_type);
    4398: fnd_message.set_token('CLM_DOCUMENT_NUMBER',l_clm_document_number);
    4399: fnd_message.set_token('PDF_GENERATION_TYPE',l_pdf_type);
    4400:

    Line 4397: fnd_message.set_token('DOC_SUB_TYPE',l_doc_sub_type);

    4393:
    4394: ELSIF ( l_message_type = 'CLSOUT_PDF_GEN_ERR') THEN
    4395:
    4396: fnd_message.set_name('PO','PO_CLSOUT_PDF_GEN_ERR_SUB');
    4397: fnd_message.set_token('DOC_SUB_TYPE',l_doc_sub_type);
    4398: fnd_message.set_token('CLM_DOCUMENT_NUMBER',l_clm_document_number);
    4399: fnd_message.set_token('PDF_GENERATION_TYPE',l_pdf_type);
    4400:
    4401: l_message_subject := fnd_message.get;

    Line 4398: fnd_message.set_token('CLM_DOCUMENT_NUMBER',l_clm_document_number);

    4394: ELSIF ( l_message_type = 'CLSOUT_PDF_GEN_ERR') THEN
    4395:
    4396: fnd_message.set_name('PO','PO_CLSOUT_PDF_GEN_ERR_SUB');
    4397: fnd_message.set_token('DOC_SUB_TYPE',l_doc_sub_type);
    4398: fnd_message.set_token('CLM_DOCUMENT_NUMBER',l_clm_document_number);
    4399: fnd_message.set_token('PDF_GENERATION_TYPE',l_pdf_type);
    4400:
    4401: l_message_subject := fnd_message.get;
    4402:

    Line 4399: fnd_message.set_token('PDF_GENERATION_TYPE',l_pdf_type);

    4395:
    4396: fnd_message.set_name('PO','PO_CLSOUT_PDF_GEN_ERR_SUB');
    4397: fnd_message.set_token('DOC_SUB_TYPE',l_doc_sub_type);
    4398: fnd_message.set_token('CLM_DOCUMENT_NUMBER',l_clm_document_number);
    4399: fnd_message.set_token('PDF_GENERATION_TYPE',l_pdf_type);
    4400:
    4401: l_message_subject := fnd_message.get;
    4402:
    4403: wf_engine.setitemattrtext(itemtype => itemtype,

    Line 4401: l_message_subject := fnd_message.get;

    4397: fnd_message.set_token('DOC_SUB_TYPE',l_doc_sub_type);
    4398: fnd_message.set_token('CLM_DOCUMENT_NUMBER',l_clm_document_number);
    4399: fnd_message.set_token('PDF_GENERATION_TYPE',l_pdf_type);
    4400:
    4401: l_message_subject := fnd_message.get;
    4402:
    4403: wf_engine.setitemattrtext(itemtype => itemtype,
    4404: itemkey => itemkey,
    4405: aname => 'MESSAGE_BODY',

    Line 4410: fnd_message.set_name('PO','PO_CLSOUT_CHECKLIST_SIGN_SUB');

    4406: avalue => 'PLSQLCLOB:PO_CLOSEOUT_PVT.get_clsout_err_msg_body/'|| l_message_type ||':'||itemtype||':'||itemkey);
    4407:
    4408: ELSIF ( l_message_type = 'CLSOUT_CHECKLIST_SIGN') THEN
    4409:
    4410: fnd_message.set_name('PO','PO_CLSOUT_CHECKLIST_SIGN_SUB');
    4411: fnd_message.set_token('DOC_SUB_TYPE',l_doc_sub_type);
    4412: fnd_message.set_token('CLM_DOCUMENT_NUMBER',l_clm_document_number);
    4413:
    4414: l_message_subject := fnd_message.get;

    Line 4411: fnd_message.set_token('DOC_SUB_TYPE',l_doc_sub_type);

    4407:
    4408: ELSIF ( l_message_type = 'CLSOUT_CHECKLIST_SIGN') THEN
    4409:
    4410: fnd_message.set_name('PO','PO_CLSOUT_CHECKLIST_SIGN_SUB');
    4411: fnd_message.set_token('DOC_SUB_TYPE',l_doc_sub_type);
    4412: fnd_message.set_token('CLM_DOCUMENT_NUMBER',l_clm_document_number);
    4413:
    4414: l_message_subject := fnd_message.get;
    4415:

    Line 4412: fnd_message.set_token('CLM_DOCUMENT_NUMBER',l_clm_document_number);

    4408: ELSIF ( l_message_type = 'CLSOUT_CHECKLIST_SIGN') THEN
    4409:
    4410: fnd_message.set_name('PO','PO_CLSOUT_CHECKLIST_SIGN_SUB');
    4411: fnd_message.set_token('DOC_SUB_TYPE',l_doc_sub_type);
    4412: fnd_message.set_token('CLM_DOCUMENT_NUMBER',l_clm_document_number);
    4413:
    4414: l_message_subject := fnd_message.get;
    4415:
    4416: ELSIF ( l_message_type = 'CLSOUT_CCS_SELF_SIGN') THEN

    Line 4414: l_message_subject := fnd_message.get;

    4410: fnd_message.set_name('PO','PO_CLSOUT_CHECKLIST_SIGN_SUB');
    4411: fnd_message.set_token('DOC_SUB_TYPE',l_doc_sub_type);
    4412: fnd_message.set_token('CLM_DOCUMENT_NUMBER',l_clm_document_number);
    4413:
    4414: l_message_subject := fnd_message.get;
    4415:
    4416: ELSIF ( l_message_type = 'CLSOUT_CCS_SELF_SIGN') THEN
    4417:
    4418: fnd_message.set_name('PO','PO_CLSOUT_CCS_SELF_SIGN_SUB');

    Line 4418: fnd_message.set_name('PO','PO_CLSOUT_CCS_SELF_SIGN_SUB');

    4414: l_message_subject := fnd_message.get;
    4415:
    4416: ELSIF ( l_message_type = 'CLSOUT_CCS_SELF_SIGN') THEN
    4417:
    4418: fnd_message.set_name('PO','PO_CLSOUT_CCS_SELF_SIGN_SUB');
    4419: fnd_message.set_token('DOC_SUB_TYPE',l_doc_sub_type);
    4420: fnd_message.set_token('CLM_DOCUMENT_NUMBER',l_clm_document_number);
    4421:
    4422: l_message_subject := fnd_message.get;

    Line 4419: fnd_message.set_token('DOC_SUB_TYPE',l_doc_sub_type);

    4415:
    4416: ELSIF ( l_message_type = 'CLSOUT_CCS_SELF_SIGN') THEN
    4417:
    4418: fnd_message.set_name('PO','PO_CLSOUT_CCS_SELF_SIGN_SUB');
    4419: fnd_message.set_token('DOC_SUB_TYPE',l_doc_sub_type);
    4420: fnd_message.set_token('CLM_DOCUMENT_NUMBER',l_clm_document_number);
    4421:
    4422: l_message_subject := fnd_message.get;
    4423:

    Line 4420: fnd_message.set_token('CLM_DOCUMENT_NUMBER',l_clm_document_number);

    4416: ELSIF ( l_message_type = 'CLSOUT_CCS_SELF_SIGN') THEN
    4417:
    4418: fnd_message.set_name('PO','PO_CLSOUT_CCS_SELF_SIGN_SUB');
    4419: fnd_message.set_token('DOC_SUB_TYPE',l_doc_sub_type);
    4420: fnd_message.set_token('CLM_DOCUMENT_NUMBER',l_clm_document_number);
    4421:
    4422: l_message_subject := fnd_message.get;
    4423:
    4424: ELSIF ( l_message_type = 'CLSOUT_CCS_ACK_SIGN') THEN

    Line 4422: l_message_subject := fnd_message.get;

    4418: fnd_message.set_name('PO','PO_CLSOUT_CCS_SELF_SIGN_SUB');
    4419: fnd_message.set_token('DOC_SUB_TYPE',l_doc_sub_type);
    4420: fnd_message.set_token('CLM_DOCUMENT_NUMBER',l_clm_document_number);
    4421:
    4422: l_message_subject := fnd_message.get;
    4423:
    4424: ELSIF ( l_message_type = 'CLSOUT_CCS_ACK_SIGN') THEN
    4425:
    4426: fnd_message.set_name('PO','PO_CLSOUT_CCS_ACK_SIGN_SUB');

    Line 4426: fnd_message.set_name('PO','PO_CLSOUT_CCS_ACK_SIGN_SUB');

    4422: l_message_subject := fnd_message.get;
    4423:
    4424: ELSIF ( l_message_type = 'CLSOUT_CCS_ACK_SIGN') THEN
    4425:
    4426: fnd_message.set_name('PO','PO_CLSOUT_CCS_ACK_SIGN_SUB');
    4427: fnd_message.set_token('DOC_SUB_TYPE',l_doc_sub_type);
    4428: fnd_message.set_token('CLM_DOCUMENT_NUMBER',l_clm_document_number);
    4429:
    4430: l_message_subject := fnd_message.get;

    Line 4427: fnd_message.set_token('DOC_SUB_TYPE',l_doc_sub_type);

    4423:
    4424: ELSIF ( l_message_type = 'CLSOUT_CCS_ACK_SIGN') THEN
    4425:
    4426: fnd_message.set_name('PO','PO_CLSOUT_CCS_ACK_SIGN_SUB');
    4427: fnd_message.set_token('DOC_SUB_TYPE',l_doc_sub_type);
    4428: fnd_message.set_token('CLM_DOCUMENT_NUMBER',l_clm_document_number);
    4429:
    4430: l_message_subject := fnd_message.get;
    4431:

    Line 4428: fnd_message.set_token('CLM_DOCUMENT_NUMBER',l_clm_document_number);

    4424: ELSIF ( l_message_type = 'CLSOUT_CCS_ACK_SIGN') THEN
    4425:
    4426: fnd_message.set_name('PO','PO_CLSOUT_CCS_ACK_SIGN_SUB');
    4427: fnd_message.set_token('DOC_SUB_TYPE',l_doc_sub_type);
    4428: fnd_message.set_token('CLM_DOCUMENT_NUMBER',l_clm_document_number);
    4429:
    4430: l_message_subject := fnd_message.get;
    4431:
    4432: END IF;

    Line 4430: l_message_subject := fnd_message.get;

    4426: fnd_message.set_name('PO','PO_CLSOUT_CCS_ACK_SIGN_SUB');
    4427: fnd_message.set_token('DOC_SUB_TYPE',l_doc_sub_type);
    4428: fnd_message.set_token('CLM_DOCUMENT_NUMBER',l_clm_document_number);
    4429:
    4430: l_message_subject := fnd_message.get;
    4431:
    4432: END IF;
    4433:
    4434: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'l_message_subject'||l_message_subject);