DBA Data[Home] [Help]

APPS.ARP_CMREQ_WF dependencies on FND_MESSAGE

Line 474: fnd_message.set_name('AR', 'ARW_INV_MSG10');

470: l_tax_disclaimer := NULL;
471:
472: if l_line_credit_flag = 'Y'
473: then
474: fnd_message.set_name('AR', 'ARW_INV_MSG10');
475: l_tax_disclaimer := fnd_message.get;
476: end if;
477:
478: WF_ENGINE.SetItemAttrText(p_item_type,

Line 475: l_tax_disclaimer := fnd_message.get;

471:
472: if l_line_credit_flag = 'Y'
473: then
474: fnd_message.set_name('AR', 'ARW_INV_MSG10');
475: l_tax_disclaimer := fnd_message.get;
476: end if;
477:
478: WF_ENGINE.SetItemAttrText(p_item_type,
479: p_item_key,

Line 1195: fnd_message.set_name('AR', 'ARW_NEED_RULE');

1191: if l_invoicing_rule_id is not NULL then
1192:
1193: if nvl(l_credit_accounting_rule,'*') not in ('LIFO','PRORATE','UNIT') then
1194:
1195: fnd_message.set_name('AR', 'ARW_NEED_RULE');
1196: l_need_rule_mesg := fnd_message.get;
1197:
1198: WF_ENGINE.SetItemAttrText(p_item_type,
1199: p_item_key,

Line 1196: l_need_rule_mesg := fnd_message.get;

1192:
1193: if nvl(l_credit_accounting_rule,'*') not in ('LIFO','PRORATE','UNIT') then
1194:
1195: fnd_message.set_name('AR', 'ARW_NEED_RULE');
1196: l_need_rule_mesg := fnd_message.get;
1197:
1198: WF_ENGINE.SetItemAttrText(p_item_type,
1199: p_item_key,
1200: 'INVALID_RULE_MESG',

Line 3283: fnd_message.set_name('AR', 'AR_WF_SUBMISSION');

3279: when others then
3280: l_reason_meaning := l_reason_code;
3281: end;
3282:
3283: fnd_message.set_name('AR', 'AR_WF_SUBMISSION');
3284: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
3285: fnd_message.set_token('REQUESTOR', l_requestor_user_name);
3286: fnd_message.set_token('AMOUNT', to_char(l_total_credit_to_invoice));
3287: fnd_message.set_token('REASON', l_reason_meaning);

Line 3284: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));

3280: l_reason_meaning := l_reason_code;
3281: end;
3282:
3283: fnd_message.set_name('AR', 'AR_WF_SUBMISSION');
3284: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
3285: fnd_message.set_token('REQUESTOR', l_requestor_user_name);
3286: fnd_message.set_token('AMOUNT', to_char(l_total_credit_to_invoice));
3287: fnd_message.set_token('REASON', l_reason_meaning);
3288:

Line 3285: fnd_message.set_token('REQUESTOR', l_requestor_user_name);

3281: end;
3282:
3283: fnd_message.set_name('AR', 'AR_WF_SUBMISSION');
3284: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
3285: fnd_message.set_token('REQUESTOR', l_requestor_user_name);
3286: fnd_message.set_token('AMOUNT', to_char(l_total_credit_to_invoice));
3287: fnd_message.set_token('REASON', l_reason_meaning);
3288:
3289: l_note_text := fnd_message.get;

Line 3286: fnd_message.set_token('AMOUNT', to_char(l_total_credit_to_invoice));

3282:
3283: fnd_message.set_name('AR', 'AR_WF_SUBMISSION');
3284: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
3285: fnd_message.set_token('REQUESTOR', l_requestor_user_name);
3286: fnd_message.set_token('AMOUNT', to_char(l_total_credit_to_invoice));
3287: fnd_message.set_token('REASON', l_reason_meaning);
3288:
3289: l_note_text := fnd_message.get;
3290: l_note_text1 := l_note_text;

Line 3287: fnd_message.set_token('REASON', l_reason_meaning);

3283: fnd_message.set_name('AR', 'AR_WF_SUBMISSION');
3284: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
3285: fnd_message.set_token('REQUESTOR', l_requestor_user_name);
3286: fnd_message.set_token('AMOUNT', to_char(l_total_credit_to_invoice));
3287: fnd_message.set_token('REASON', l_reason_meaning);
3288:
3289: l_note_text := fnd_message.get;
3290: l_note_text1 := l_note_text;
3291: if l_comments is not NULL then

Line 3289: l_note_text := fnd_message.get;

3285: fnd_message.set_token('REQUESTOR', l_requestor_user_name);
3286: fnd_message.set_token('AMOUNT', to_char(l_total_credit_to_invoice));
3287: fnd_message.set_token('REASON', l_reason_meaning);
3288:
3289: l_note_text := fnd_message.get;
3290: l_note_text1 := l_note_text;
3291: if l_comments is not NULL then
3292: select meaning into l_comment_type
3293: from ar_lookups

Line 3404: fnd_message.set_name('AR', 'AR_WF_APPROVAL_REMINDER');

3400: 'APPROVER_DISPLAY_NAME');
3401:
3402: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /*5119049*/
3403:
3404: fnd_message.set_name('AR', 'AR_WF_APPROVAL_REMINDER');
3405: fnd_message.set_token('APPROVER', l_approver_display_name);
3406: -- bug fix 1122477
3407:
3408: l_note_text := fnd_message.get;

Line 3405: fnd_message.set_token('APPROVER', l_approver_display_name);

3401:
3402: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /*5119049*/
3403:
3404: fnd_message.set_name('AR', 'AR_WF_APPROVAL_REMINDER');
3405: fnd_message.set_token('APPROVER', l_approver_display_name);
3406: -- bug fix 1122477
3407:
3408: l_note_text := fnd_message.get;
3409:

Line 3408: l_note_text := fnd_message.get;

3404: fnd_message.set_name('AR', 'AR_WF_APPROVAL_REMINDER');
3405: fnd_message.set_token('APPROVER', l_approver_display_name);
3406: -- bug fix 1122477
3407:
3408: l_note_text := fnd_message.get;
3409:
3410: IF l_notes is NOT NULL then
3411: l_note_text := SUBSTRB(l_note_text || ' "' || l_notes || '"',1,2000) ; /*5119049*/
3412: END IF;

Line 3509: fnd_message.set_name('AR', 'AR_WF_APPROVAL_ESCALATION');

3505: 'MANAGER_USER_NAME');
3506:
3507: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /*5119049*/
3508:
3509: fnd_message.set_name('AR', 'AR_WF_APPROVAL_ESCALATION');
3510: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
3511: fnd_message.set_token('APPROVER', l_manager_user_name);
3512:
3513: l_note_text := fnd_message.get;

Line 3510: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));

3506:
3507: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /*5119049*/
3508:
3509: fnd_message.set_name('AR', 'AR_WF_APPROVAL_ESCALATION');
3510: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
3511: fnd_message.set_token('APPROVER', l_manager_user_name);
3512:
3513: l_note_text := fnd_message.get;
3514:

Line 3511: fnd_message.set_token('APPROVER', l_manager_user_name);

3507: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /*5119049*/
3508:
3509: fnd_message.set_name('AR', 'AR_WF_APPROVAL_ESCALATION');
3510: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
3511: fnd_message.set_token('APPROVER', l_manager_user_name);
3512:
3513: l_note_text := fnd_message.get;
3514:
3515: IF l_notes is NOT NULL then

Line 3513: l_note_text := fnd_message.get;

3509: fnd_message.set_name('AR', 'AR_WF_APPROVAL_ESCALATION');
3510: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
3511: fnd_message.set_token('APPROVER', l_manager_user_name);
3512:
3513: l_note_text := fnd_message.get;
3514:
3515: IF l_notes is NOT NULL then
3516: l_note_text := SUBSTRB(l_note_text || ' "' || l_notes || '"',1,2000) ; /*5119049*/
3517: END IF;

Line 3611: fnd_message.set_name('AR', 'AR_WF_REQUEST_MANUAL');

3607: SELECT display_name INTO l_role_display_name
3608: FROM wf_roles
3609: WHERE name = l_receivable_role;
3610:
3611: fnd_message.set_name('AR', 'AR_WF_REQUEST_MANUAL');
3612: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
3613: fnd_message.set_token('RECEIVABLE_ROLE',l_role_display_name);
3614:
3615: l_note_text := fnd_message.get;

Line 3612: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));

3608: FROM wf_roles
3609: WHERE name = l_receivable_role;
3610:
3611: fnd_message.set_name('AR', 'AR_WF_REQUEST_MANUAL');
3612: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
3613: fnd_message.set_token('RECEIVABLE_ROLE',l_role_display_name);
3614:
3615: l_note_text := fnd_message.get;
3616:

Line 3613: fnd_message.set_token('RECEIVABLE_ROLE',l_role_display_name);

3609: WHERE name = l_receivable_role;
3610:
3611: fnd_message.set_name('AR', 'AR_WF_REQUEST_MANUAL');
3612: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
3613: fnd_message.set_token('RECEIVABLE_ROLE',l_role_display_name);
3614:
3615: l_note_text := fnd_message.get;
3616:
3617: IF l_notes is NOT NULL then

Line 3615: l_note_text := fnd_message.get;

3611: fnd_message.set_name('AR', 'AR_WF_REQUEST_MANUAL');
3612: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
3613: fnd_message.set_token('RECEIVABLE_ROLE',l_role_display_name);
3614:
3615: l_note_text := fnd_message.get;
3616:
3617: IF l_notes is NOT NULL then
3618: l_note_text := SUBSTRB(l_note_text || ' "' || l_notes || '"',1,2000) ; /*5119049*/
3619: END IF;

Line 3729: fnd_message.set_name('AR', 'AR_WF_COMPLETED_MANUAL');

3725: WHERE name = l_receivable_role;
3726:
3727:
3728:
3729: fnd_message.set_name('AR', 'AR_WF_COMPLETED_MANUAL');
3730: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
3731: fnd_message.set_token('APPROVER',l_role_display_name);
3732:
3733: l_note_text := fnd_message.get;

Line 3730: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));

3726:
3727:
3728:
3729: fnd_message.set_name('AR', 'AR_WF_COMPLETED_MANUAL');
3730: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
3731: fnd_message.set_token('APPROVER',l_role_display_name);
3732:
3733: l_note_text := fnd_message.get;
3734:

Line 3731: fnd_message.set_token('APPROVER',l_role_display_name);

3727:
3728:
3729: fnd_message.set_name('AR', 'AR_WF_COMPLETED_MANUAL');
3730: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
3731: fnd_message.set_token('APPROVER',l_role_display_name);
3732:
3733: l_note_text := fnd_message.get;
3734:
3735: IF l_notes is NOT NULL then

Line 3733: l_note_text := fnd_message.get;

3729: fnd_message.set_name('AR', 'AR_WF_COMPLETED_MANUAL');
3730: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
3731: fnd_message.set_token('APPROVER',l_role_display_name);
3732:
3733: l_note_text := fnd_message.get;
3734:
3735: IF l_notes is NOT NULL then
3736: l_note_text := SUBSTRB(l_note_text || ' "' || l_notes || '"',1,2000) ; /*5119049*/
3737: END IF;

Line 3836: fnd_message.set_name('AR', 'AR_WF_REQUEST_APPROVAL');

3832: 'APPROVER_DISPLAY_NAME');
3833:
3834: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /*5119049*/
3835:
3836: fnd_message.set_name('AR', 'AR_WF_REQUEST_APPROVAL');
3837: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
3838: fnd_message.set_token('APPROVER', l_approver_display_name);
3839: -- bug fix 1122477
3840:

Line 3837: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));

3833:
3834: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /*5119049*/
3835:
3836: fnd_message.set_name('AR', 'AR_WF_REQUEST_APPROVAL');
3837: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
3838: fnd_message.set_token('APPROVER', l_approver_display_name);
3839: -- bug fix 1122477
3840:
3841: l_note_text := fnd_message.get;

Line 3838: fnd_message.set_token('APPROVER', l_approver_display_name);

3834: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /*5119049*/
3835:
3836: fnd_message.set_name('AR', 'AR_WF_REQUEST_APPROVAL');
3837: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
3838: fnd_message.set_token('APPROVER', l_approver_display_name);
3839: -- bug fix 1122477
3840:
3841: l_note_text := fnd_message.get;
3842:

Line 3841: l_note_text := fnd_message.get;

3837: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
3838: fnd_message.set_token('APPROVER', l_approver_display_name);
3839: -- bug fix 1122477
3840:
3841: l_note_text := fnd_message.get;
3842:
3843: IF l_notes is NOT NULL then
3844: l_note_text := SUBSTRB(l_note_text || ' "' || l_notes || '"',1,2000) ; /*5119049*/
3845: END IF;

Line 3934: fnd_message.set_name('AR', 'AR_WF_APPROVED_RESPONSE');

3930: 'APPROVER_DISPLAY_NAME');
3931:
3932: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /*5119049*/
3933:
3934: fnd_message.set_name('AR', 'AR_WF_APPROVED_RESPONSE');
3935: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
3936: fnd_message.set_token('APPROVER', l_approver_display_name);
3937: -- bug fix 1122477
3938:

Line 3935: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));

3931:
3932: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /*5119049*/
3933:
3934: fnd_message.set_name('AR', 'AR_WF_APPROVED_RESPONSE');
3935: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
3936: fnd_message.set_token('APPROVER', l_approver_display_name);
3937: -- bug fix 1122477
3938:
3939: l_note_text := fnd_message.get;

Line 3936: fnd_message.set_token('APPROVER', l_approver_display_name);

3932: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /*5119049*/
3933:
3934: fnd_message.set_name('AR', 'AR_WF_APPROVED_RESPONSE');
3935: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
3936: fnd_message.set_token('APPROVER', l_approver_display_name);
3937: -- bug fix 1122477
3938:
3939: l_note_text := fnd_message.get;
3940:

Line 3939: l_note_text := fnd_message.get;

3935: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
3936: fnd_message.set_token('APPROVER', l_approver_display_name);
3937: -- bug fix 1122477
3938:
3939: l_note_text := fnd_message.get;
3940:
3941: IF l_notes is NOT NULL then
3942: l_note_text := SUBSTRB(l_note_text || ' "' || l_notes || '"',1,2000) ; /*5119049*/
3943: END IF;

Line 4047: fnd_message.set_name('AR', 'AR_WF_REJECTED_RESPONSE');

4043: 'APPROVER_DISPLAY_NAME');
4044: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /*5119049*/
4045:
4046:
4047: fnd_message.set_name('AR', 'AR_WF_REJECTED_RESPONSE');
4048: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
4049: fnd_message.set_token('APPROVER', l_approver_display_name);
4050: -- bug fix 1122477
4051:

Line 4048: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));

4044: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /*5119049*/
4045:
4046:
4047: fnd_message.set_name('AR', 'AR_WF_REJECTED_RESPONSE');
4048: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
4049: fnd_message.set_token('APPROVER', l_approver_display_name);
4050: -- bug fix 1122477
4051:
4052: l_note_text := fnd_message.get;

Line 4049: fnd_message.set_token('APPROVER', l_approver_display_name);

4045:
4046:
4047: fnd_message.set_name('AR', 'AR_WF_REJECTED_RESPONSE');
4048: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
4049: fnd_message.set_token('APPROVER', l_approver_display_name);
4050: -- bug fix 1122477
4051:
4052: l_note_text := fnd_message.get;
4053:

Line 4052: l_note_text := fnd_message.get;

4048: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
4049: fnd_message.set_token('APPROVER', l_approver_display_name);
4050: -- bug fix 1122477
4051:
4052: l_note_text := fnd_message.get;
4053:
4054: IF l_notes is NOT NULL then
4055: l_note_text := SUBSTRB(l_note_text || ' "' || l_notes || '"',1,2000) ; /*5119049*/
4056: END IF;

Line 4159: fnd_message.set_name('AR', 'AR_WF_COMPLETED_SUCCESSFUL');

4155:
4156: /* Get trx number for CM and the insert into note text */
4157:
4158:
4159: fnd_message.set_name('AR', 'AR_WF_COMPLETED_SUCCESSFUL');
4160: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
4161: fnd_message.set_token('TRXNUMBER', l_credit_memo_number);
4162:
4163: l_note_text := fnd_message.get;

Line 4160: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));

4156: /* Get trx number for CM and the insert into note text */
4157:
4158:
4159: fnd_message.set_name('AR', 'AR_WF_COMPLETED_SUCCESSFUL');
4160: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
4161: fnd_message.set_token('TRXNUMBER', l_credit_memo_number);
4162:
4163: l_note_text := fnd_message.get;
4164:

Line 4161: fnd_message.set_token('TRXNUMBER', l_credit_memo_number);

4157:
4158:
4159: fnd_message.set_name('AR', 'AR_WF_COMPLETED_SUCCESSFUL');
4160: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
4161: fnd_message.set_token('TRXNUMBER', l_credit_memo_number);
4162:
4163: l_note_text := fnd_message.get;
4164:
4165: IF l_notes is NOT NULL then

Line 4163: l_note_text := fnd_message.get;

4159: fnd_message.set_name('AR', 'AR_WF_COMPLETED_SUCCESSFUL');
4160: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
4161: fnd_message.set_token('TRXNUMBER', l_credit_memo_number);
4162:
4163: l_note_text := fnd_message.get;
4164:
4165: IF l_notes is NOT NULL then
4166: l_note_text := SUBSTRB(l_note_text || ' "' || l_notes || '"',1,2000) ; /*5119049*/
4167: END IF;

Line 4472: fnd_message.set_name('AR', 'AR_WF_NO_BATCH');

4468: l_cm_creation_error := NULL;
4469:
4470: IF l_batch_source_name IS NULL THEN
4471:
4472: fnd_message.set_name('AR', 'AR_WF_NO_BATCH');
4473: l_cm_creation_error := fnd_message.get;
4474:
4475: WF_ENGINE.SetItemAttrText(p_item_type,
4476: p_item_key,

Line 4473: l_cm_creation_error := fnd_message.get;

4469:
4470: IF l_batch_source_name IS NULL THEN
4471:
4472: fnd_message.set_name('AR', 'AR_WF_NO_BATCH');
4473: l_cm_creation_error := fnd_message.get;
4474:
4475: WF_ENGINE.SetItemAttrText(p_item_type,
4476: p_item_key,
4477: 'CM_CREATION_ERROR',