511: l_tax_disclaimer := NULL;
512:
513: if l_line_credit_flag = 'Y'
514: then
515: fnd_message.set_name('AR', 'ARW_INV_MSG10');
516: l_tax_disclaimer := fnd_message.get;
517: end if;
518:
519: WF_ENGINE.SetItemAttrText(p_item_type,
512:
513: if l_line_credit_flag = 'Y'
514: then
515: fnd_message.set_name('AR', 'ARW_INV_MSG10');
516: l_tax_disclaimer := fnd_message.get;
517: end if;
518:
519: WF_ENGINE.SetItemAttrText(p_item_type,
520: p_item_key,
1232: if l_invoicing_rule_id is not NULL then
1233:
1234: if nvl(l_credit_accounting_rule,'*') not in ('LIFO','PRORATE','UNIT') then
1235:
1236: fnd_message.set_name('AR', 'ARW_NEED_RULE');
1237: l_need_rule_mesg := fnd_message.get;
1238:
1239: WF_ENGINE.SetItemAttrText(p_item_type,
1240: p_item_key,
1233:
1234: if nvl(l_credit_accounting_rule,'*') not in ('LIFO','PRORATE','UNIT') then
1235:
1236: fnd_message.set_name('AR', 'ARW_NEED_RULE');
1237: l_need_rule_mesg := fnd_message.get;
1238:
1239: WF_ENGINE.SetItemAttrText(p_item_type,
1240: p_item_key,
1241: 'INVALID_RULE_MESG',
3386: when others then
3387: l_reason_meaning := l_reason_code;
3388: end;
3389:
3390: fnd_message.set_name('AR', 'AR_WF_SUBMISSION');
3391: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
3392: fnd_message.set_token('REQUESTOR', l_requestor_user_name);
3393: fnd_message.set_token('AMOUNT', to_char(l_total_credit_to_invoice));
3394: fnd_message.set_token('REASON', l_reason_meaning);
3387: l_reason_meaning := l_reason_code;
3388: end;
3389:
3390: fnd_message.set_name('AR', 'AR_WF_SUBMISSION');
3391: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
3392: fnd_message.set_token('REQUESTOR', l_requestor_user_name);
3393: fnd_message.set_token('AMOUNT', to_char(l_total_credit_to_invoice));
3394: fnd_message.set_token('REASON', l_reason_meaning);
3395:
3388: end;
3389:
3390: fnd_message.set_name('AR', 'AR_WF_SUBMISSION');
3391: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
3392: fnd_message.set_token('REQUESTOR', l_requestor_user_name);
3393: fnd_message.set_token('AMOUNT', to_char(l_total_credit_to_invoice));
3394: fnd_message.set_token('REASON', l_reason_meaning);
3395:
3396: l_note_text := fnd_message.get;
3389:
3390: fnd_message.set_name('AR', 'AR_WF_SUBMISSION');
3391: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
3392: fnd_message.set_token('REQUESTOR', l_requestor_user_name);
3393: fnd_message.set_token('AMOUNT', to_char(l_total_credit_to_invoice));
3394: fnd_message.set_token('REASON', l_reason_meaning);
3395:
3396: l_note_text := fnd_message.get;
3397: l_note_text1 := l_note_text;
3390: fnd_message.set_name('AR', 'AR_WF_SUBMISSION');
3391: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
3392: fnd_message.set_token('REQUESTOR', l_requestor_user_name);
3393: fnd_message.set_token('AMOUNT', to_char(l_total_credit_to_invoice));
3394: fnd_message.set_token('REASON', l_reason_meaning);
3395:
3396: l_note_text := fnd_message.get;
3397: l_note_text1 := l_note_text;
3398: if l_comments is not NULL then
3392: fnd_message.set_token('REQUESTOR', l_requestor_user_name);
3393: fnd_message.set_token('AMOUNT', to_char(l_total_credit_to_invoice));
3394: fnd_message.set_token('REASON', l_reason_meaning);
3395:
3396: l_note_text := fnd_message.get;
3397: l_note_text1 := l_note_text;
3398: if l_comments is not NULL then
3399: select meaning into l_comment_type
3400: from ar_lookups
3507: 'APPROVER_DISPLAY_NAME');
3508:
3509: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /*5119049*/
3510:
3511: fnd_message.set_name('AR', 'AR_WF_APPROVAL_REMINDER');
3512: fnd_message.set_token('APPROVER', l_approver_display_name);
3513: -- bug fix 1122477
3514:
3515: l_note_text := fnd_message.get;
3508:
3509: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /*5119049*/
3510:
3511: fnd_message.set_name('AR', 'AR_WF_APPROVAL_REMINDER');
3512: fnd_message.set_token('APPROVER', l_approver_display_name);
3513: -- bug fix 1122477
3514:
3515: l_note_text := fnd_message.get;
3516:
3511: fnd_message.set_name('AR', 'AR_WF_APPROVAL_REMINDER');
3512: fnd_message.set_token('APPROVER', l_approver_display_name);
3513: -- bug fix 1122477
3514:
3515: l_note_text := fnd_message.get;
3516:
3517: IF l_notes is NOT NULL then
3518: l_note_text := SUBSTRB(l_note_text || ' "' || l_notes || '"',1,2000) ; /*5119049*/
3519: END IF;
3612: 'MANAGER_USER_NAME');
3613:
3614: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /*5119049*/
3615:
3616: fnd_message.set_name('AR', 'AR_WF_APPROVAL_ESCALATION');
3617: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
3618: fnd_message.set_token('APPROVER', l_manager_user_name);
3619:
3620: l_note_text := fnd_message.get;
3613:
3614: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /*5119049*/
3615:
3616: fnd_message.set_name('AR', 'AR_WF_APPROVAL_ESCALATION');
3617: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
3618: fnd_message.set_token('APPROVER', l_manager_user_name);
3619:
3620: l_note_text := fnd_message.get;
3621:
3614: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /*5119049*/
3615:
3616: fnd_message.set_name('AR', 'AR_WF_APPROVAL_ESCALATION');
3617: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
3618: fnd_message.set_token('APPROVER', l_manager_user_name);
3619:
3620: l_note_text := fnd_message.get;
3621:
3622: IF l_notes is NOT NULL then
3616: fnd_message.set_name('AR', 'AR_WF_APPROVAL_ESCALATION');
3617: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
3618: fnd_message.set_token('APPROVER', l_manager_user_name);
3619:
3620: l_note_text := fnd_message.get;
3621:
3622: IF l_notes is NOT NULL then
3623: l_note_text := SUBSTRB(l_note_text || ' "' || l_notes || '"',1,2000) ; /*5119049*/
3624: END IF;
3714: SELECT display_name INTO l_role_display_name
3715: FROM wf_roles
3716: WHERE name = l_receivable_role;
3717:
3718: fnd_message.set_name('AR', 'AR_WF_REQUEST_MANUAL');
3719: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
3720: fnd_message.set_token('RECEIVABLE_ROLE',l_role_display_name);
3721:
3722: l_note_text := fnd_message.get;
3715: FROM wf_roles
3716: WHERE name = l_receivable_role;
3717:
3718: fnd_message.set_name('AR', 'AR_WF_REQUEST_MANUAL');
3719: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
3720: fnd_message.set_token('RECEIVABLE_ROLE',l_role_display_name);
3721:
3722: l_note_text := fnd_message.get;
3723:
3716: WHERE name = l_receivable_role;
3717:
3718: fnd_message.set_name('AR', 'AR_WF_REQUEST_MANUAL');
3719: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
3720: fnd_message.set_token('RECEIVABLE_ROLE',l_role_display_name);
3721:
3722: l_note_text := fnd_message.get;
3723:
3724: IF l_notes is NOT NULL then
3718: fnd_message.set_name('AR', 'AR_WF_REQUEST_MANUAL');
3719: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
3720: fnd_message.set_token('RECEIVABLE_ROLE',l_role_display_name);
3721:
3722: l_note_text := fnd_message.get;
3723:
3724: IF l_notes is NOT NULL then
3725: l_note_text := SUBSTRB(l_note_text || ' "' || l_notes || '"',1,2000) ; /*5119049*/
3726: END IF;
3832: WHERE name = l_receivable_role;
3833:
3834:
3835:
3836: fnd_message.set_name('AR', 'AR_WF_COMPLETED_MANUAL');
3837: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
3838: fnd_message.set_token('APPROVER',l_role_display_name);
3839:
3840: l_note_text := fnd_message.get;
3833:
3834:
3835:
3836: fnd_message.set_name('AR', 'AR_WF_COMPLETED_MANUAL');
3837: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
3838: fnd_message.set_token('APPROVER',l_role_display_name);
3839:
3840: l_note_text := fnd_message.get;
3841:
3834:
3835:
3836: fnd_message.set_name('AR', 'AR_WF_COMPLETED_MANUAL');
3837: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
3838: fnd_message.set_token('APPROVER',l_role_display_name);
3839:
3840: l_note_text := fnd_message.get;
3841:
3842: IF l_notes is NOT NULL then
3836: fnd_message.set_name('AR', 'AR_WF_COMPLETED_MANUAL');
3837: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
3838: fnd_message.set_token('APPROVER',l_role_display_name);
3839:
3840: l_note_text := fnd_message.get;
3841:
3842: IF l_notes is NOT NULL then
3843: l_note_text := SUBSTRB(l_note_text || ' "' || l_notes || '"',1,2000) ; /*5119049*/
3844: END IF;
3939: 'APPROVER_DISPLAY_NAME');
3940:
3941: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /*5119049*/
3942:
3943: fnd_message.set_name('AR', 'AR_WF_REQUEST_APPROVAL');
3944: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
3945: fnd_message.set_token('APPROVER', l_approver_display_name);
3946: -- bug fix 1122477
3947:
3940:
3941: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /*5119049*/
3942:
3943: fnd_message.set_name('AR', 'AR_WF_REQUEST_APPROVAL');
3944: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
3945: fnd_message.set_token('APPROVER', l_approver_display_name);
3946: -- bug fix 1122477
3947:
3948: l_note_text := fnd_message.get;
3941: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /*5119049*/
3942:
3943: fnd_message.set_name('AR', 'AR_WF_REQUEST_APPROVAL');
3944: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
3945: fnd_message.set_token('APPROVER', l_approver_display_name);
3946: -- bug fix 1122477
3947:
3948: l_note_text := fnd_message.get;
3949:
3944: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
3945: fnd_message.set_token('APPROVER', l_approver_display_name);
3946: -- bug fix 1122477
3947:
3948: l_note_text := fnd_message.get;
3949:
3950: IF l_notes is NOT NULL then
3951: l_note_text := SUBSTRB(l_note_text || ' "' || l_notes || '"',1,2000) ; /*5119049*/
3952: END IF;
4037: 'APPROVER_DISPLAY_NAME');
4038:
4039: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /*5119049*/
4040:
4041: fnd_message.set_name('AR', 'AR_WF_APPROVED_RESPONSE');
4042: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
4043: fnd_message.set_token('APPROVER', l_approver_display_name);
4044: -- bug fix 1122477
4045:
4038:
4039: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /*5119049*/
4040:
4041: fnd_message.set_name('AR', 'AR_WF_APPROVED_RESPONSE');
4042: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
4043: fnd_message.set_token('APPROVER', l_approver_display_name);
4044: -- bug fix 1122477
4045:
4046: l_note_text := fnd_message.get;
4039: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /*5119049*/
4040:
4041: fnd_message.set_name('AR', 'AR_WF_APPROVED_RESPONSE');
4042: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
4043: fnd_message.set_token('APPROVER', l_approver_display_name);
4044: -- bug fix 1122477
4045:
4046: l_note_text := fnd_message.get;
4047:
4042: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
4043: fnd_message.set_token('APPROVER', l_approver_display_name);
4044: -- bug fix 1122477
4045:
4046: l_note_text := fnd_message.get;
4047:
4048: IF l_notes is NOT NULL then
4049: l_note_text := SUBSTRB(l_note_text || ' "' || l_notes || '"',1,2000) ; /*5119049*/
4050: END IF;
4150: 'APPROVER_DISPLAY_NAME');
4151: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /*5119049*/
4152:
4153:
4154: fnd_message.set_name('AR', 'AR_WF_REJECTED_RESPONSE');
4155: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
4156: fnd_message.set_token('APPROVER', l_approver_display_name);
4157: -- bug fix 1122477
4158:
4151: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /*5119049*/
4152:
4153:
4154: fnd_message.set_name('AR', 'AR_WF_REJECTED_RESPONSE');
4155: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
4156: fnd_message.set_token('APPROVER', l_approver_display_name);
4157: -- bug fix 1122477
4158:
4159: l_note_text := fnd_message.get;
4152:
4153:
4154: fnd_message.set_name('AR', 'AR_WF_REJECTED_RESPONSE');
4155: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
4156: fnd_message.set_token('APPROVER', l_approver_display_name);
4157: -- bug fix 1122477
4158:
4159: l_note_text := fnd_message.get;
4160:
4155: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
4156: fnd_message.set_token('APPROVER', l_approver_display_name);
4157: -- bug fix 1122477
4158:
4159: l_note_text := fnd_message.get;
4160:
4161: IF l_notes is NOT NULL then
4162: l_note_text := SUBSTRB(l_note_text || ' "' || l_notes || '"',1,2000) ; /*5119049*/
4163: END IF;
4262:
4263: /* Get trx number for CM and the insert into note text */
4264:
4265:
4266: fnd_message.set_name('AR', 'AR_WF_COMPLETED_SUCCESSFUL');
4267: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
4268: fnd_message.set_token('TRXNUMBER', l_credit_memo_number);
4269:
4270: l_note_text := fnd_message.get;
4263: /* Get trx number for CM and the insert into note text */
4264:
4265:
4266: fnd_message.set_name('AR', 'AR_WF_COMPLETED_SUCCESSFUL');
4267: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
4268: fnd_message.set_token('TRXNUMBER', l_credit_memo_number);
4269:
4270: l_note_text := fnd_message.get;
4271:
4264:
4265:
4266: fnd_message.set_name('AR', 'AR_WF_COMPLETED_SUCCESSFUL');
4267: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
4268: fnd_message.set_token('TRXNUMBER', l_credit_memo_number);
4269:
4270: l_note_text := fnd_message.get;
4271:
4272: IF l_notes is NOT NULL then
4266: fnd_message.set_name('AR', 'AR_WF_COMPLETED_SUCCESSFUL');
4267: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
4268: fnd_message.set_token('TRXNUMBER', l_credit_memo_number);
4269:
4270: l_note_text := fnd_message.get;
4271:
4272: IF l_notes is NOT NULL then
4273: l_note_text := SUBSTRB(l_note_text || ' "' || l_notes || '"',1,2000) ; /*5119049*/
4274: END IF;
4590: l_cm_creation_error := NULL;
4591:
4592: IF l_batch_source_name IS NULL THEN
4593:
4594: fnd_message.set_name('AR', 'AR_WF_NO_BATCH');
4595: l_cm_creation_error := fnd_message.get;
4596:
4597: WF_ENGINE.SetItemAttrText(p_item_type,
4598: p_item_key,
4591:
4592: IF l_batch_source_name IS NULL THEN
4593:
4594: fnd_message.set_name('AR', 'AR_WF_NO_BATCH');
4595: l_cm_creation_error := fnd_message.get;
4596:
4597: WF_ENGINE.SetItemAttrText(p_item_type,
4598: p_item_key,
4599: 'CM_CREATION_ERROR',