APPS.PO_CLOSEOUT_PVT dependencies on WF_ENGINE

Line 2738: l_document_id := wf_engine.GetItemAttrNumber

2734:
2735: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'itemkey ' || itemkey);
2736: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'itemtype ' || itemtype);
2737:
2738: l_document_id := wf_engine.GetItemAttrNumber
2739: (itemtype => itemtype,
2740: itemkey => itemkey,
2741: aname => 'DOCUMENT_ID');
2742: l_closeout_dtate := wf_engine.GetItemAttrDate

Line 2742: l_closeout_dtate := wf_engine.GetItemAttrDate

2738: l_document_id := wf_engine.GetItemAttrNumber
2739: (itemtype => itemtype,
2740: itemkey => itemkey,
2741: aname => 'DOCUMENT_ID');
2742: l_closeout_dtate := wf_engine.GetItemAttrDate
2743: (itemtype => itemtype,
2744: itemkey => itemkey,
2745: aname => 'CLOSEOUT_DATE');
2746:

Line 2751: l_closeout_status := wf_engine.GetActivityAttrText

2747: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'l_document_id ' || l_document_id);
2748: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'l_closeout_dtate ' || l_closeout_dtate);
2749:
2750: l_progress := 10;
2751: l_closeout_status := wf_engine.GetActivityAttrText
2752: (itemtype => itemtype,
2753: itemkey => itemkey,
2754: actid => actid,
2755: aname => 'CLOSEOUT_STATUS');

Line 2767: l_aco_signed_date := wf_engine.GetItemAttrDate

2763: l_progress := 11;
2764:
2765: IF (l_closeout_status = 'ADMIN_COMPLETE') THEN
2766:
2767: l_aco_signed_date := wf_engine.GetItemAttrDate
2768: (itemtype => itemtype,
2769: itemkey => itemkey,
2770: aname => 'ACO_SIGNED_DATE');
2771: l_aco_singer_name := wf_engine.GetItemAttrText

Line 2771: l_aco_singer_name := wf_engine.GetItemAttrText

2767: l_aco_signed_date := wf_engine.GetItemAttrDate
2768: (itemtype => itemtype,
2769: itemkey => itemkey,
2770: aname => 'ACO_SIGNED_DATE');
2771: l_aco_singer_name := wf_engine.GetItemAttrText
2772: (itemtype => itemtype,
2773: itemkey => itemkey,
2774: aname => 'ACO_SIGNER_NAME');
2775:

Line 2776: l_aco_remarks := wf_engine.GetItemAttrText

2772: (itemtype => itemtype,
2773: itemkey => itemkey,
2774: aname => 'ACO_SIGNER_NAME');
2775:
2776: l_aco_remarks := wf_engine.GetItemAttrText
2777: (itemtype => itemtype,
2778: itemkey => itemkey,
2779: aname => 'ACO_REMARKS');
2780:

Line 2793: l_pco_signed_date := wf_engine.GetItemAttrDate

2789: l_progress := 13;
2790:
2791: ELSIF (l_closeout_status = 'CLOSED_OUT') THEN
2792:
2793: l_pco_signed_date := wf_engine.GetItemAttrDate
2794: (itemtype => itemtype,
2795: itemkey => itemkey,
2796: aname => 'PCO_SIGNED_DATE');
2797: l_pco_singer_name := wf_engine.GetItemAttrText

Line 2797: l_pco_singer_name := wf_engine.GetItemAttrText

2793: l_pco_signed_date := wf_engine.GetItemAttrDate
2794: (itemtype => itemtype,
2795: itemkey => itemkey,
2796: aname => 'PCO_SIGNED_DATE');
2797: l_pco_singer_name := wf_engine.GetItemAttrText
2798: (itemtype => itemtype,
2799: itemkey => itemkey,
2800: aname => 'PCO_SIGNER_NAME');
2801:

Line 2802: l_pco_remarks := wf_engine.GetItemAttrText

2798: (itemtype => itemtype,
2799: itemkey => itemkey,
2800: aname => 'PCO_SIGNER_NAME');
2801:
2802: l_pco_remarks := wf_engine.GetItemAttrText
2803: (itemtype => itemtype,
2804: itemkey => itemkey,
2805: aname => 'PCO_REMARKS');
2806:

Line 2911: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED' ;

2907:
2908: l_progress := 50;
2909: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'insert query count ' || SQL%ROWCOUNT);
2910:
2911: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED' ;
2912:
2913: IF (PO_LOG.d_proc) THEN PO_LOG.proc_end(d_module); END IF;
2914:
2915: EXCEPTION

Line 2985: l_clm_document_number := wf_engine.GetItemAttrText (itemtype => l_itemtype, itemkey => l_itemkey, aname => 'CLM_DOCUMENT_NUMBER');

2981: l_message_type := substr(message_type, 1, l_firstcolon - 1);
2982: l_itemtype := substr(message_type, l_firstcolon + 1, l_secondcolon - l_firstcolon - 1);
2983: l_itemkey := substr(message_type, l_secondcolon+1,length(message_type) - l_secondcolon);
2984:
2985: l_clm_document_number := wf_engine.GetItemAttrText (itemtype => l_itemtype, itemkey => l_itemkey, aname => 'CLM_DOCUMENT_NUMBER');
2986: l_doc_sub_type := wf_engine.GetItemAttrText (itemtype => l_itemtype, itemkey => l_itemkey, aname => 'DOCUMENT_TYPE_DISP');
2987: l_pdf_type := wf_engine.GetItemAttrText (itemtype => l_itemtype, itemkey => l_itemkey, aname => 'PDF_TYPE');
2988:
2989: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'l_message_type ' || l_message_type);

Line 2986: l_doc_sub_type := wf_engine.GetItemAttrText (itemtype => l_itemtype, itemkey => l_itemkey, aname => 'DOCUMENT_TYPE_DISP');

2982: l_itemtype := substr(message_type, l_firstcolon + 1, l_secondcolon - l_firstcolon - 1);
2983: l_itemkey := substr(message_type, l_secondcolon+1,length(message_type) - l_secondcolon);
2984:
2985: l_clm_document_number := wf_engine.GetItemAttrText (itemtype => l_itemtype, itemkey => l_itemkey, aname => 'CLM_DOCUMENT_NUMBER');
2986: l_doc_sub_type := wf_engine.GetItemAttrText (itemtype => l_itemtype, itemkey => l_itemkey, aname => 'DOCUMENT_TYPE_DISP');
2987: l_pdf_type := wf_engine.GetItemAttrText (itemtype => l_itemtype, itemkey => l_itemkey, aname => 'PDF_TYPE');
2988:
2989: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'l_message_type ' || l_message_type);
2990: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'l_clm_document_number ' || l_clm_document_number);

Line 2987: l_pdf_type := wf_engine.GetItemAttrText (itemtype => l_itemtype, itemkey => l_itemkey, aname => 'PDF_TYPE');

2983: l_itemkey := substr(message_type, l_secondcolon+1,length(message_type) - l_secondcolon);
2984:
2985: l_clm_document_number := wf_engine.GetItemAttrText (itemtype => l_itemtype, itemkey => l_itemkey, aname => 'CLM_DOCUMENT_NUMBER');
2986: l_doc_sub_type := wf_engine.GetItemAttrText (itemtype => l_itemtype, itemkey => l_itemkey, aname => 'DOCUMENT_TYPE_DISP');
2987: l_pdf_type := wf_engine.GetItemAttrText (itemtype => l_itemtype, itemkey => l_itemkey, aname => 'PDF_TYPE');
2988:
2989: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'l_message_type ' || l_message_type);
2990: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'l_clm_document_number ' || l_clm_document_number);
2991: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'l_doc_sub_type ' || l_doc_sub_type);

Line 3162: l_document_id := wf_engine.GetItemAttrNumber

3158:
3159: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'itemkey ' || itemkey);
3160: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'itemtype ' || itemtype);
3161:
3162: l_document_id := wf_engine.GetItemAttrNumber
3163: (itemtype => itemtype,
3164: itemkey => itemkey,
3165: aname => 'DOCUMENT_ID');
3166: l_clm_document_number := wf_engine.GetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'CLM_DOCUMENT_NUMBER');

Line 3166: l_clm_document_number := wf_engine.GetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'CLM_DOCUMENT_NUMBER');

3162: l_document_id := wf_engine.GetItemAttrNumber
3163: (itemtype => itemtype,
3164: itemkey => itemkey,
3165: aname => 'DOCUMENT_ID');
3166: l_clm_document_number := wf_engine.GetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'CLM_DOCUMENT_NUMBER');
3167: l_doc_sub_type := wf_engine.GetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_TYPE_DISP');
3168:
3169: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'l_document_id ' || l_document_id);
3170:

Line 3167: l_doc_sub_type := wf_engine.GetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_TYPE_DISP');

3163: (itemtype => itemtype,
3164: itemkey => itemkey,
3165: aname => 'DOCUMENT_ID');
3166: l_clm_document_number := wf_engine.GetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'CLM_DOCUMENT_NUMBER');
3167: l_doc_sub_type := wf_engine.GetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_TYPE_DISP');
3168:
3169: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'l_document_id ' || l_document_id);
3170:
3171: l_progress := 10;

Line 3182: resultout := wf_engine.eng_completed || ':' || 'ERROR' ;

3178: , x_results => l_results);
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:

Line 3197: resultout := wf_engine.eng_completed || ':' || 'WARNING' ;

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' ;
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:


Line 3214: resultout := wf_engine.eng_completed || ':' || 'SUCCESS' ;


3210:
3211: ELSIF (l_result_type = c_result_type_SUCCESS) THEN
3212:
3213: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'l_result_type ' || l_result_type);
3214: resultout := wf_engine.eng_completed || ':' || 'SUCCESS' ;
3215: RETURN;
3216: END IF;
3217:
3218: -- PO_CLOSEOUT_PVT.Log( d_module, d_position, 'l_message_subject'||l_message_subject);


Line 3220: wf_engine.setitemattrtext(itemtype => itemtype,


3216: END IF;
3217:
3218: -- PO_CLOSEOUT_PVT.Log( d_module, d_position, 'l_message_subject'||l_message_subject);
3219:
3220: wf_engine.setitemattrtext(itemtype => itemtype,
3221: itemkey => itemkey,
3222: aname => 'MESSAGE_SUBJECT',
3223: avalue => l_message_subject);
3224:


Line 3231: wf_engine.setitemattrtext(itemtype => itemtype,


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

1. ' || l_msg || '
';
3229: END LOOP;
3230:
3231: wf_engine.setitemattrtext(itemtype => itemtype,
3232: itemkey => itemkey,
3233: aname => 'MESSAGE_BODY',
3234: avalue => 'PLSQLCLOB:PO_CLOSEOUT_PVT.get_val_notfn_body/'|| l_messages ||'#'||itemtype||'#'||itemkey);
3235:


Line 3247: resultout := wf_engine.eng_completed || ':' || 'ERROR' ;


3243: WHEN OTHERS THEN
3244:
3245: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'PO_CLOSEOUT_PVT.Validate_Document : when others exception at '
3246: || l_progress || ';' || SQLERRM );
3247: resultout := wf_engine.eng_completed || ':' || 'ERROR' ;
3248:
3249: RAISE;
3250: END Validate_Document;
3251:


Line 3306: l_document_id := wf_engine.GetItemAttrNumber


3302:
3303: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'itemkey ' || itemkey);
3304: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'itemtype ' || itemtype);
3305:
3306: l_document_id := wf_engine.GetItemAttrNumber
3307: (itemtype => itemtype,
3308: itemkey => itemkey,
3309: aname => 'DOCUMENT_ID');
3310:


Line 3351: resultout := wf_engine.eng_completed || ':' || 'COMPLETED' ;


3347: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'l_doc_num: '||l_doc_num);
3348:
3349:
3350: IF (l_return_status = fnd_api.g_ret_sts_success AND l_task_status = 'COMPLETED') THEN
3351: resultout := wf_engine.eng_completed || ':' || 'COMPLETED' ;
3352: --When a document is reopened and If the tasks are already completed, workflow will directly initiates the signing process
3353: update PO_CLOSEOUT_DETAILS
3354: set incloseout = 'W'
3355: where reference_doc_id = l_document_id


Line 3358: resultout := wf_engine.eng_completed || ':' || 'ACTIVATED' ;


3354: set incloseout = 'W'
3355: where reference_doc_id = l_document_id
3356: and closeout_doc_type = PO_CLOSEOUT_PVT.g_CLOSEOUT_TYPE_INDIVIDUAL;
3357: ELSIF (l_return_status = fnd_api.g_ret_sts_success AND l_task_status = 'INITIATED') THEN
3358: resultout := wf_engine.eng_completed || ':' || 'ACTIVATED' ;
3359: ELSIF (l_return_status = fnd_api.g_ret_sts_error OR l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
3360: resultout := wf_engine.eng_completed || ':' || 'ERROR' ;
3361: END IF;
3362:


Line 3360: resultout := wf_engine.eng_completed || ':' || 'ERROR' ;


3356: and closeout_doc_type = PO_CLOSEOUT_PVT.g_CLOSEOUT_TYPE_INDIVIDUAL;
3357: ELSIF (l_return_status = fnd_api.g_ret_sts_success AND l_task_status = 'INITIATED') THEN
3358: resultout := wf_engine.eng_completed || ':' || 'ACTIVATED' ;
3359: ELSIF (l_return_status = fnd_api.g_ret_sts_error OR l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
3360: resultout := wf_engine.eng_completed || ':' || 'ERROR' ;
3361: END IF;
3362:
3363: IF (PO_LOG.d_proc) THEN PO_LOG.proc_end(d_module); END IF;
3364:


Line 3371: resultout := wf_engine.eng_completed || ':' || 'ERROR' ;


3367:
3368: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'PO_CLOSEOUT_PVT.Activate_tasks_list : when others exception at '
3369: || l_progress || ';' || SQLERRM );
3370:
3371: resultout := wf_engine.eng_completed || ':' || 'ERROR' ;
3372: RAISE;
3373:
3374: END Activate_tasks_list;
3375:


Line 3427: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED' ;


3423:
3424: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'itemkey ' || itemkey);
3425: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'itemtype ' || itemtype);
3426:
3427: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED' ;
3428:
3429: IF (PO_LOG.d_proc) THEN PO_LOG.proc_end(d_module); END IF;
3430:
3431: EXCEPTION


Line 3438: resultout := wf_engine.eng_completed || ':' || 'ACTIVATED' ;


3434: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'PO_CLOSEOUT_PVT.Set_Doc_TO_Prev_State : when others exception at '
3435: || l_progress || ';' || SQLERRM );
3436: resultout := c_result_type_FAILURE;
3437:
3438: resultout := wf_engine.eng_completed || ':' || 'ACTIVATED' ;
3439:
3440:
3441: RAISE;
3442: END Set_Doc_TO_Prev_State ;


Line 3495: l_document_id := wf_engine.GetItemAttrNumber


3491: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'itemtype ' || itemtype);
3492:
3493:
3494:
3495: l_document_id := wf_engine.GetItemAttrNumber
3496: (itemtype => itemtype,
3497: itemkey => itemkey,
3498: aname => 'DOCUMENT_ID');
3499:


Line 3516: resultout := wf_engine.eng_completed || ':' || l_is_physical_complete;


3512: EXCEPTION WHEN No_Data_Found THEN
3513: l_is_physical_complete := 'N';
3514: END;
3515:
3516: resultout := wf_engine.eng_completed || ':' || l_is_physical_complete;
3517:
3518: IF (PO_LOG.d_proc) THEN PO_LOG.proc_end(d_module); END IF;
3519:
3520: EXCEPTION


Line 3525: resultout := wf_engine.eng_completed || ':' || 'N';


3521: WHEN OTHERS THEN
3522:
3523: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'PO_CLOSEOUT_PVT.IS_STATUS_PHYSICAL_COMPLETE : when others exception at '
3524: || l_progress || ';' || SQLERRM );
3525: resultout := wf_engine.eng_completed || ':' || 'N';
3526: RAISE;
3527:
3528: END IS_STATUS_PHYSICAL_COMPLETE;
3529:


Line 3625: l_administrator_id := wf_engine.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'ADMINISTRATOR_ID');


3621:
3622: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'itemkey ' || itemkey);
3623: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'itemtype ' || itemtype);
3624:
3625: l_administrator_id := wf_engine.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'ADMINISTRATOR_ID');
3626: get_user_name(l_administrator_id, l_name, l_disp);
3627:
3628: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'l_name ' || l_name);
3629: IF (PO_LOG.d_proc) THEN PO_LOG.proc_end(d_module); END IF;


Line 3682: l_signer_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype, itemkey => p_itemkey, aname => 'CHECK_LIST_SIGNER_ID');


3678: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'p_itemkey ' || p_itemkey);
3679: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'p_signer_type ' || p_signer_type);
3680:
3681: IF ( p_signer_type = 'CHECKLIST') THEN
3682: l_signer_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype, itemkey => p_itemkey, aname => 'CHECK_LIST_SIGNER_ID');
3683: ELSIF ( p_signer_type = 'ADMIN_OFFICER') THEN
3684: l_signer_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype, itemkey => p_itemkey, aname => 'ADMIN_OFFICE_SIGNER_ID');
3685: ELSIF ( p_signer_type = 'CONTRACTING_OFFICER') THEN
3686: l_signer_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype, itemkey => p_itemkey, aname => 'CONTRACTING_OFFICE_SIGNER_ID');


Line 3684: l_signer_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype, itemkey => p_itemkey, aname => 'ADMIN_OFFICE_SIGNER_ID');


3680:
3681: IF ( p_signer_type = 'CHECKLIST') THEN
3682: l_signer_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype, itemkey => p_itemkey, aname => 'CHECK_LIST_SIGNER_ID');
3683: ELSIF ( p_signer_type = 'ADMIN_OFFICER') THEN
3684: l_signer_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype, itemkey => p_itemkey, aname => 'ADMIN_OFFICE_SIGNER_ID');
3685: ELSIF ( p_signer_type = 'CONTRACTING_OFFICER') THEN
3686: l_signer_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype, itemkey => p_itemkey, aname => 'CONTRACTING_OFFICE_SIGNER_ID');
3687: END IF;
3688:


Line 3686: l_signer_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype, itemkey => p_itemkey, aname => 'CONTRACTING_OFFICE_SIGNER_ID');


3682: l_signer_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype, itemkey => p_itemkey, aname => 'CHECK_LIST_SIGNER_ID');
3683: ELSIF ( p_signer_type = 'ADMIN_OFFICER') THEN
3684: l_signer_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype, itemkey => p_itemkey, aname => 'ADMIN_OFFICE_SIGNER_ID');
3685: ELSIF ( p_signer_type = 'CONTRACTING_OFFICER') THEN
3686: l_signer_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype, itemkey => p_itemkey, aname => 'CONTRACTING_OFFICE_SIGNER_ID');
3687: END IF;
3688:
3689: get_user_name(l_signer_id, l_name, l_disp_name);
3690:


Line 3949: wf_engine.createprocess (itemtype => l_itemtype,


3945: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'l_clm_closeout_status ' || l_clm_closeout_status);
3946: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'l_itemkey ' || l_itemkey);
3947:
3948: -- create workflow process
3949: wf_engine.createprocess (itemtype => l_itemtype,
3950: itemkey => l_itemkey,
3951: process => l_process);
3952:
3953: wf_engine.setitemattrtext(itemtype => l_itemtype,


Line 3953: wf_engine.setitemattrtext(itemtype => l_itemtype,


3949: wf_engine.createprocess (itemtype => l_itemtype,
3950: itemkey => l_itemkey,
3951: process => l_process);
3952:
3953: wf_engine.setitemattrtext(itemtype => l_itemtype,
3954: itemkey => l_itemkey,
3955: aname => 'DOCUMENT_ID',
3956: avalue => l_document_id);
3957:


Line 3958: wf_engine.setitemattrtext(itemtype => l_itemtype,


3954: itemkey => l_itemkey,
3955: aname => 'DOCUMENT_ID',
3956: avalue => l_document_id);
3957:
3958: wf_engine.setitemattrtext(itemtype => l_itemtype,
3959: itemkey => l_itemkey,
3960: aname => 'IS_CHECK_LIST_REQUIRED',
3961: avalue => l_chklist_req);
3962:


Line 3963: wf_engine.setitemattrtext(itemtype => l_itemtype,


3959: itemkey => l_itemkey,
3960: aname => 'IS_CHECK_LIST_REQUIRED',
3961: avalue => l_chklist_req);
3962:
3963: wf_engine.setitemattrtext(itemtype => l_itemtype,
3964: itemkey => l_itemkey,
3965: aname => 'IS_CCS_REQUIRED',
3966: avalue => l_ccs_req);
3967:


Line 3968: wf_engine.setitemattrtext(itemtype => l_itemtype,


3964: itemkey => l_itemkey,
3965: aname => 'IS_CCS_REQUIRED',
3966: avalue => l_ccs_req);
3967:
3968: wf_engine.setitemattrtext(itemtype => l_itemtype,
3969: itemkey => l_itemkey,
3970: aname => 'IS_CHECK_LIST_SIGN_REQUIRED',
3971: avalue => l_chklist_sign_req);
3972:


Line 3973: wf_engine.setitemattrtext(itemtype => l_itemtype,


3969: itemkey => l_itemkey,
3970: aname => 'IS_CHECK_LIST_SIGN_REQUIRED',
3971: avalue => l_chklist_sign_req);
3972:
3973: wf_engine.setitemattrtext(itemtype => l_itemtype,
3974: itemkey => l_itemkey,
3975: aname => 'IS_CCS_SIGN_REQUIRED',
3976: avalue => l_ccs_sign_req);
3977:


Line 3978: wf_engine.setitemattrtext(itemtype => l_itemtype,


3974: itemkey => l_itemkey,
3975: aname => 'IS_CCS_SIGN_REQUIRED',
3976: avalue => l_ccs_sign_req);
3977:
3978: wf_engine.setitemattrtext(itemtype => l_itemtype,
3979: itemkey => l_itemkey,
3980: aname => 'ACO_SIGNATURE_TYPE',
3981: avalue => l_aco_sign_type);
3982:


Line 3983: wf_engine.setitemattrtext(itemtype => l_itemtype,


3979: itemkey => l_itemkey,
3980: aname => 'ACO_SIGNATURE_TYPE',
3981: avalue => l_aco_sign_type);
3982:
3983: wf_engine.setitemattrtext(itemtype => l_itemtype,
3984: itemkey => l_itemkey,
3985: aname => 'PCO_SIGNATURE_TYPE',
3986: avalue => l_pco_sign_type);
3987:


Line 3988: wf_engine.setitemattrtext(itemtype => l_itemtype,


3984: itemkey => l_itemkey,
3985: aname => 'PCO_SIGNATURE_TYPE',
3986: avalue => l_pco_sign_type);
3987:
3988: wf_engine.setitemattrtext(itemtype => l_itemtype,
3989: itemkey => l_itemkey,
3990: aname => 'CHECK_LIST_SIGNER_ID',
3991: avalue => l_chklist_signer);
3992:


Line 3993: wf_engine.setitemattrtext(itemtype => l_itemtype,


3989: itemkey => l_itemkey,
3990: aname => 'CHECK_LIST_SIGNER_ID',
3991: avalue => l_chklist_signer);
3992:
3993: wf_engine.setitemattrtext(itemtype => l_itemtype,
3994: itemkey => l_itemkey,
3995: aname => 'ADMIN_OFFICE_SIGNER_ID',
3996: avalue => l_admin_signer);
3997:


Line 3998: wf_engine.setitemattrtext(itemtype => l_itemtype,


3994: itemkey => l_itemkey,
3995: aname => 'ADMIN_OFFICE_SIGNER_ID',
3996: avalue => l_admin_signer);
3997:
3998: wf_engine.setitemattrtext(itemtype => l_itemtype,
3999: itemkey => l_itemkey,
4000: aname => 'CONTRACTING_OFFICE_SIGNER_ID',
4001: avalue => l_cntr_signer);
4002:


Line 4003: wf_engine.setitemattrtext(itemtype => l_itemtype,


3999: itemkey => l_itemkey,
4000: aname => 'CONTRACTING_OFFICE_SIGNER_ID',
4001: avalue => l_cntr_signer);
4002:
4003: wf_engine.setitemattrtext(itemtype => l_itemtype,
4004: itemkey => l_itemkey,
4005: aname => 'ADMINISTRATOR_ID',
4006: avalue => l_admin_id);
4007:


Line 4009: wf_engine.setitemattrtext(itemtype => l_itemtype,


4005: aname => 'ADMINISTRATOR_ID',
4006: avalue => l_admin_id);
4007:
4008:
4009: wf_engine.setitemattrtext(itemtype => l_itemtype,
4010: itemkey => l_itemkey,
4011: aname => 'ADMINISTRATOR_NAME',
4012: avalue => get_administrator_user_name(l_itemtype, l_itemkey));
4013:


Line 4014: wf_engine.setitemattrtext(itemtype => l_itemtype,


4010: itemkey => l_itemkey,
4011: aname => 'ADMINISTRATOR_NAME',
4012: avalue => get_administrator_user_name(l_itemtype, l_itemkey));
4013:
4014: wf_engine.setitemattrtext(itemtype => l_itemtype,
4015: itemkey => l_itemkey,
4016: aname => 'CHECK_LIST_SIGNER',
4017: avalue => get_signer(l_itemtype, l_itemkey,'CHECKLIST'));
4018:


Line 4020: wf_engine.setitemattrtext(itemtype => l_itemtype,


4016: aname => 'CHECK_LIST_SIGNER',
4017: avalue => get_signer(l_itemtype, l_itemkey,'CHECKLIST'));
4018:
4019:
4020: wf_engine.setitemattrtext(itemtype => l_itemtype,
4021: itemkey => l_itemkey,
4022: aname => 'ADMIN_OFFICE_SIGNER',
4023: avalue => get_signer(l_itemtype, l_itemkey,'ADMIN_OFFICER'));
4024:


Line 4025: wf_engine.setitemattrtext(itemtype => l_itemtype,


4021: itemkey => l_itemkey,
4022: aname => 'ADMIN_OFFICE_SIGNER',
4023: avalue => get_signer(l_itemtype, l_itemkey,'ADMIN_OFFICER'));
4024:
4025: wf_engine.setitemattrtext(itemtype => l_itemtype,
4026: itemkey => l_itemkey,
4027: aname => 'CONTRACTING_OFFICE_SIGNER',
4028: avalue => get_signer(l_itemtype, l_itemkey, 'CONTRACTING_OFFICER'));
4029:


Line 4030: wf_engine.setitemattrtext(itemtype => l_itemtype,


4026: itemkey => l_itemkey,
4027: aname => 'CONTRACTING_OFFICE_SIGNER',
4028: avalue => get_signer(l_itemtype, l_itemkey, 'CONTRACTING_OFFICER'));
4029:
4030: wf_engine.setitemattrtext(itemtype => l_itemtype,
4031: itemkey => l_itemkey,
4032: aname => 'CLM_DOCUMENT_NUMBER',
4033: avalue => l_clm_document_number);
4034:


Line 4035: wf_engine.setitemattrtext(itemtype => l_itemtype,


4031: itemkey => l_itemkey,
4032: aname => 'CLM_DOCUMENT_NUMBER',
4033: avalue => l_clm_document_number);
4034:
4035: wf_engine.setitemattrtext(itemtype => l_itemtype,
4036: itemkey => l_itemkey,
4037: aname => 'DOCUMENT_TYPE_DISP',
4038: avalue => l_doc_type_disp);
4039:


Line 4041: wf_engine.setitemattrtext(itemtype => l_itemtype,


4037: aname => 'DOCUMENT_TYPE_DISP',
4038: avalue => l_doc_type_disp);
4039:
4040:
4041: wf_engine.setitemattrtext(itemtype => l_itemtype,
4042: itemkey => l_itemkey,
4043: aname => 'SIGNATURE_COMMENTS',
4044: avalue => l_comments);
4045:


Line 4046: wf_engine.setitemattrtext(itemtype => l_itemtype,


4042: itemkey => l_itemkey,
4043: aname => 'SIGNATURE_COMMENTS',
4044: avalue => l_comments);
4045:
4046: wf_engine.setitemattrtext(itemtype => l_itemtype,
4047: itemkey => l_itemkey,
4048: aname => 'ACO_REMARKS',
4049: avalue => l_aco_remarks);
4050:


Line 4051: wf_engine.setitemattrtext(itemtype => l_itemtype,


4047: itemkey => l_itemkey,
4048: aname => 'ACO_REMARKS',
4049: avalue => l_aco_remarks);
4050:
4051: wf_engine.setitemattrtext(itemtype => l_itemtype,
4052: itemkey => l_itemkey,
4053: aname => 'PCO_REMARKS',
4054: avalue => l_pco_remarks);
4055:


Line 4058: -- wf_engine.setitemattrtext(itemtype => l_itemtype,


4054: avalue => l_pco_remarks);
4055:
4056: -- Testing Hard coded
4057:
4058: -- wf_engine.setitemattrtext(itemtype => l_itemtype,
4059: -- itemkey => l_itemkey,
4060: -- aname => 'REVALIDATE_DOCUMENT',
4061: -- avalue => 'Y');
4062:


Line 4064: wf_engine.setitemattrtext(itemtype => l_itemtype,


4060: -- aname => 'REVALIDATE_DOCUMENT',
4061: -- avalue => 'Y');
4062:
4063:
4064: wf_engine.setitemattrtext(itemtype => l_itemtype,
4065: itemkey => l_itemkey,
4066: aname => 'PO_CLSOUT_SIGNATURE_BODY',
4067: avalue =>
4068: 'PLSQLCLOB:PO_CLOSEOUT_PVT.get_sign_notfn_body/'|| l_document_id ||':'||l_itemtype||':'||l_itemkey);


Line 4071: wf_engine.setitemattrtext(itemtype => l_itemtype,


4067: avalue =>
4068: 'PLSQLCLOB:PO_CLOSEOUT_PVT.get_sign_notfn_body/'|| l_document_id ||':'||l_itemtype||':'||l_itemkey);
4069:
4070:
4071: wf_engine.setitemattrtext(itemtype => l_itemtype,
4072: itemkey => l_itemkey,
4073: aname => 'PDF_CHECKLIST_ATTACHMENT',
4074: avalue =>
4075: 'PLSQLBLOB:PO_CLOSEOUT_PVT.get_closeout_pdf/'|| l_document_id ||':'||l_itemtype||':'||'CT');


Line 4078: wf_engine.setitemattrtext(itemtype => l_itemtype,


4074: avalue =>
4075: 'PLSQLBLOB:PO_CLOSEOUT_PVT.get_closeout_pdf/'|| l_document_id ||':'||l_itemtype||':'||'CT');
4076:
4077:
4078: wf_engine.setitemattrtext(itemtype => l_itemtype,
4079: itemkey => l_itemkey,
4080: aname => 'PDF_CCS_ATTACHMENT',
4081: avalue =>
4082: 'PLSQLBLOB:PO_CLOSEOUT_PVT.get_closeout_pdf/'|| l_document_id ||':'||l_itemtype||':'||'CCS');


Line 4084: wf_engine.setitemattrtext(itemtype => l_itemtype,


4080: aname => 'PDF_CCS_ATTACHMENT',
4081: avalue =>
4082: 'PLSQLBLOB:PO_CLOSEOUT_PVT.get_closeout_pdf/'|| l_document_id ||':'||l_itemtype||':'||'CCS');
4083:
4084: wf_engine.setitemattrtext(itemtype => l_itemtype,
4085: itemkey => l_itemkey,
4086: aname => 'VIEW_DOC_CLOSEOUT_URL',
4087: avalue => 'JSP:/OA_HTML/OA.jsp?OAFunc=MANAGE_CLOSEOUT'||'&'||
4088: 'documentHeaderId='||l_document_id||'&'||


Line 4099: WF_ENGINE.STARTPROCESS(ITEMTYPE => L_ITEMTYPE,


4095: );
4096:
4097: l_progress := 30 ;
4098:
4099: WF_ENGINE.STARTPROCESS(ITEMTYPE => L_ITEMTYPE,
4100: ITEMKEY => L_ITEMKEY );
4101:
4102: l_progress := 40;
4103:


Line 4126: wf_engine.setitemattrtext(itemtype => l_itemtype,


4122:
4123: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'Updated incloseout to W '||SQL%ROWCOUNT);
4124:
4125: -- Set the REVALIDATE_DOCUMENT to Y, as this is invoked from business event after all tasks has been completed and it needs revalidation.
4126: wf_engine.setitemattrtext(itemtype => l_itemtype,
4127: itemkey => l_itemkey,
4128: aname => 'REVALIDATE_DOCUMENT',
4129: avalue => 'Y');
4130:


Line 4220: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_ID');


4216: IF (PO_LOG.d_proc) THEN
4217: PO_LOG.proc_begin(d_module);
4218: END IF;
4219:
4220: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_ID');
4221: l_clm_document_number := wf_engine.GetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'CLM_DOCUMENT_NUMBER');
4222: l_pdf_generation_type := wf_engine.GetActivityAttrText (itemtype => itemtype, itemkey => itemkey, actid => actid, aname => 'PDF_GENERATION_TYPE');
4223:
4224: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'l_document_id: '||l_document_id);


Line 4221: l_clm_document_number := wf_engine.GetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'CLM_DOCUMENT_NUMBER');


4217: PO_LOG.proc_begin(d_module);
4218: END IF;
4219:
4220: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_ID');
4221: l_clm_document_number := wf_engine.GetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'CLM_DOCUMENT_NUMBER');
4222: l_pdf_generation_type := wf_engine.GetActivityAttrText (itemtype => itemtype, itemkey => itemkey, actid => actid, aname => 'PDF_GENERATION_TYPE');
4223:
4224: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'l_document_id: '||l_document_id);
4225: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'l_clm_document_number: '||l_clm_document_number);


Line 4222: l_pdf_generation_type := wf_engine.GetActivityAttrText (itemtype => itemtype, itemkey => itemkey, actid => actid, aname => 'PDF_GENERATION_TYPE');


4218: END IF;
4219:
4220: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_ID');
4221: l_clm_document_number := wf_engine.GetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'CLM_DOCUMENT_NUMBER');
4222: l_pdf_generation_type := wf_engine.GetActivityAttrText (itemtype => itemtype, itemkey => itemkey, actid => actid, aname => 'PDF_GENERATION_TYPE');
4223:
4224: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'l_document_id: '||l_document_id);
4225: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'l_clm_document_number: '||l_clm_document_number);
4226: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'l_pdf_generation_type: '||l_pdf_generation_type);


Line 4300: wf_engine.SetItemAttrNumber ( itemtype => itemtype,


4296: argument3 => l_clm_document_number);
4297:
4298: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'PO_CLOSEOUT_PVT.Generate_Closeout_PDF: : Request id is - '|| l_request_id);
4299:
4300: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
4301: itemkey => itemkey,
4302: aname => 'REQUEST_ID',
4303: avalue => l_request_id);
4304: wf_engine.SetItemAttrText ( itemtype => itemtype,


Line 4304: wf_engine.SetItemAttrText ( itemtype => itemtype,


4300: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
4301: itemkey => itemkey,
4302: aname => 'REQUEST_ID',
4303: avalue => l_request_id);
4304: wf_engine.SetItemAttrText ( itemtype => itemtype,
4305: itemkey => itemkey,
4306: aname => 'PDF_TYPE',
4307: avalue => l_pdf_generation_type);
4308:


Line 4310: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';


4306: aname => 'PDF_TYPE',
4307: avalue => l_pdf_generation_type);
4308:
4309:
4310: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
4311: IF (PO_LOG.d_proc) THEN PO_LOG.proc_end(d_module); END IF;
4312:
4313: EXCEPTION
4314: WHEN OTHERS THEN


Line 4316: resultout := wf_engine.eng_completed || ':' || '';


4312:
4313: EXCEPTION
4314: WHEN OTHERS THEN
4315: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'PO_CLOSEOUT_PVT.Generate_Closeout_PDF: Error: '||SQLERRM);
4316: resultout := wf_engine.eng_completed || ':' || '';
4317:
4318: END Generate_Closeout_PDF;
4319:
4320:


Line 4368: l_message_type := wf_engine.GetActivityAttrText (itemtype => itemtype, itemkey => itemkey, actid => actid, aname => 'MESSAGE_TYPE');


4364: IF (PO_LOG.d_proc) THEN
4365: PO_LOG.proc_begin(d_module);
4366: END IF;
4367:
4368: l_message_type := wf_engine.GetActivityAttrText (itemtype => itemtype, itemkey => itemkey, actid => actid, aname => 'MESSAGE_TYPE');
4369: l_clm_document_number := wf_engine.GetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'CLM_DOCUMENT_NUMBER');
4370: l_doc_sub_type := wf_engine.GetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_TYPE_DISP');
4371: l_pdf_type := wf_engine.GetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'PDF_TYPE');
4372: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_ID');


Line 4369: l_clm_document_number := wf_engine.GetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'CLM_DOCUMENT_NUMBER');


4365: PO_LOG.proc_begin(d_module);
4366: END IF;
4367:
4368: l_message_type := wf_engine.GetActivityAttrText (itemtype => itemtype, itemkey => itemkey, actid => actid, aname => 'MESSAGE_TYPE');
4369: l_clm_document_number := wf_engine.GetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'CLM_DOCUMENT_NUMBER');
4370: l_doc_sub_type := wf_engine.GetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_TYPE_DISP');
4371: l_pdf_type := wf_engine.GetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'PDF_TYPE');
4372: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_ID');
4373:


Line 4370: l_doc_sub_type := wf_engine.GetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_TYPE_DISP');


4366: END IF;
4367:
4368: l_message_type := wf_engine.GetActivityAttrText (itemtype => itemtype, itemkey => itemkey, actid => actid, aname => 'MESSAGE_TYPE');
4369: l_clm_document_number := wf_engine.GetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'CLM_DOCUMENT_NUMBER');
4370: l_doc_sub_type := wf_engine.GetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_TYPE_DISP');
4371: l_pdf_type := wf_engine.GetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'PDF_TYPE');
4372: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_ID');
4373:
4374: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'l_message_type'||l_message_type);


Line 4371: l_pdf_type := wf_engine.GetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'PDF_TYPE');


4367:
4368: l_message_type := wf_engine.GetActivityAttrText (itemtype => itemtype, itemkey => itemkey, actid => actid, aname => 'MESSAGE_TYPE');
4369: l_clm_document_number := wf_engine.GetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'CLM_DOCUMENT_NUMBER');
4370: l_doc_sub_type := wf_engine.GetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_TYPE_DISP');
4371: l_pdf_type := wf_engine.GetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'PDF_TYPE');
4372: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_ID');
4373:
4374: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'l_message_type'||l_message_type);
4375: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'l_clm_document_number'||l_clm_document_number);


Line 4372: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_ID');


4368: l_message_type := wf_engine.GetActivityAttrText (itemtype => itemtype, itemkey => itemkey, actid => actid, aname => 'MESSAGE_TYPE');
4369: l_clm_document_number := wf_engine.GetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'CLM_DOCUMENT_NUMBER');
4370: l_doc_sub_type := wf_engine.GetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_TYPE_DISP');
4371: l_pdf_type := wf_engine.GetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'PDF_TYPE');
4372: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_ID');
4373:
4374: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'l_message_type'||l_message_type);
4375: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'l_clm_document_number'||l_clm_document_number);
4376: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'l_doc_sub_type'||l_doc_sub_type);


Line 4389: wf_engine.setitemattrtext(itemtype => itemtype,


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',
4392: avalue => 'PLSQLCLOB:PO_CLOSEOUT_PVT.get_clsout_err_msg_body/'|| l_message_type ||':'||itemtype||':'||itemkey);
4393:


Line 4403: wf_engine.setitemattrtext(itemtype => itemtype,


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',
4406: avalue => 'PLSQLCLOB:PO_CLOSEOUT_PVT.get_clsout_err_msg_body/'|| l_message_type ||':'||itemtype||':'||itemkey);
4407:


Line 4436: wf_engine.setitemattrtext(itemtype => itemtype,


4432: END IF;
4433:
4434: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'l_message_subject'||l_message_subject);
4435:
4436: wf_engine.setitemattrtext(itemtype => itemtype,
4437: itemkey => itemkey,
4438: aname => 'MESSAGE_SUBJECT',
4439: avalue => l_message_subject);
4440:


Line 4442: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED' ;


4438: aname => 'MESSAGE_SUBJECT',
4439: avalue => l_message_subject);
4440:
4441:
4442: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED' ;
4443: PO_CLOSEOUT_PVT.Log(d_module, d_position, 'End ::: PO_CLOSEOUT_PVT.Set_Notification_Message ');
4444: END Set_Notification_Message;
4445:
4446:


Line 4681: l_document_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype, itemkey => p_itemkey, aname => 'DOCUMENT_ID');


4677: ELSIF ( p_funcmode = 'SET_CTX' ) THEN
4678:
4679: PO_CLOSEOUT_PVT.Log( d_module, d_position, ' inside SET_CTX');
4680:
4681: l_document_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype, itemkey => p_itemkey, aname => 'DOCUMENT_ID');
4682:
4683: SELECT ATTRIBUTE15
4684: INTO l_context_ids
4685: FROM po_closeout_details


Line 4803: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_ID');


4799: END IF;
4800:
4801: IF (funcmode = 'RUN') THEN
4802:
4803: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_ID');
4804:
4805: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'l_document_id ' || l_document_id);
4806:
4807: UPDATE po_closeout_details