DBA Data[Home] [Help]

APPS.AR_AME_CMWF_API dependencies on FND_MESSAGE

Line 563: fnd_message.set_name('AR', 'AR_WF_APPROVAL_REASSIGNED');

559: itemtype => p_item_type,
560: itemkey => p_item_key,
561: aname => 'CUSTOMER_TRX_ID');
562:
563: fnd_message.set_name('AR', 'AR_WF_APPROVAL_REASSIGNED');
564: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
565: fnd_message.set_token('APPROVER', l_responder_display_name);
566:
567: l_note_text := fnd_message.get;

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

560: itemkey => p_item_key,
561: aname => 'CUSTOMER_TRX_ID');
562:
563: fnd_message.set_name('AR', 'AR_WF_APPROVAL_REASSIGNED');
564: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
565: fnd_message.set_token('APPROVER', l_responder_display_name);
566:
567: l_note_text := fnd_message.get;
568:

Line 565: fnd_message.set_token('APPROVER', l_responder_display_name);

561: aname => 'CUSTOMER_TRX_ID');
562:
563: fnd_message.set_name('AR', 'AR_WF_APPROVAL_REASSIGNED');
564: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
565: fnd_message.set_token('APPROVER', l_responder_display_name);
566:
567: l_note_text := fnd_message.get;
568:
569: InsertTrxNotes (

Line 567: l_note_text := fnd_message.get;

563: fnd_message.set_name('AR', 'AR_WF_APPROVAL_REASSIGNED');
564: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
565: fnd_message.set_token('APPROVER', l_responder_display_name);
566:
567: l_note_text := fnd_message.get;
568:
569: InsertTrxNotes (
570: x_customer_call_id => NULL,
571: x_customer_call_topic_id => NULL,

Line 735: Fnd_message.set_name(

731:
732: ame_api.getadminapprover(adminapproverout => l_admin_approver);
733:
734: IF l_next_approver.person_id = l_admin_approver.person_id THEN
735: Fnd_message.set_name(
736: application => 'AR',
737: name => 'AR_CMWF_AME_NO_APPROVER_MESG');
738: l_error_message := fnd_message.get;
739: app_exception.raise_exception;

Line 738: l_error_message := fnd_message.get;

734: IF l_next_approver.person_id = l_admin_approver.person_id THEN
735: Fnd_message.set_name(
736: application => 'AR',
737: name => 'AR_CMWF_AME_NO_APPROVER_MESG');
738: l_error_message := fnd_message.get;
739: app_exception.raise_exception;
740:
741: ELSE
742:

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

1364:
1365: l_tax_disclaimer := NULL;
1366:
1367: IF l_line_credit_flag = 'Y' THEN
1368: fnd_message.set_name('AR', 'ARW_INV_MSG10');
1369: l_tax_disclaimer := fnd_message.get;
1370: END IF;
1371:
1372: wf_engine.SetItemAttrText(p_item_type,

Line 1369: l_tax_disclaimer := fnd_message.get;

1365: l_tax_disclaimer := NULL;
1366:
1367: IF l_line_credit_flag = 'Y' THEN
1368: fnd_message.set_name('AR', 'ARW_INV_MSG10');
1369: l_tax_disclaimer := fnd_message.get;
1370: END IF;
1371:
1372: wf_engine.SetItemAttrText(p_item_type,
1373: p_item_key,

Line 2030: fnd_message.set_name(

2026: IF l_invoicing_rule_id is NOT NULL THEN
2027: IF nvl(l_credit_accounting_rule,'*')
2028: NOT IN ('LIFO','PRORATE','UNIT') THEN
2029:
2030: fnd_message.set_name(
2031: application => 'AR',
2032: name => 'ARW_NEED_RULE');
2033:
2034: l_need_rule_mesg := fnd_message.get;

Line 2034: l_need_rule_mesg := fnd_message.get;

2030: fnd_message.set_name(
2031: application => 'AR',
2032: name => 'ARW_NEED_RULE');
2033:
2034: l_need_rule_mesg := fnd_message.get;
2035:
2036: wf_engine.SetItemAttrText(
2037: itemtype => p_item_type,
2038: itemkey => p_item_key,

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

4083: when others then
4084: l_reason_meaning := l_reason_code;
4085: END;
4086:
4087: fnd_message.set_name('AR', 'AR_WF_SUBMISSION');
4088: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
4089: fnd_message.set_token('REQUESTOR', l_requestor_user_name);
4090: fnd_message.set_token('AMOUNT', to_char(l_total_credit_to_invoice));
4091: fnd_message.set_token('REASON', l_reason_meaning);

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

4084: l_reason_meaning := l_reason_code;
4085: END;
4086:
4087: fnd_message.set_name('AR', 'AR_WF_SUBMISSION');
4088: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
4089: fnd_message.set_token('REQUESTOR', l_requestor_user_name);
4090: fnd_message.set_token('AMOUNT', to_char(l_total_credit_to_invoice));
4091: fnd_message.set_token('REASON', l_reason_meaning);
4092:

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

4085: END;
4086:
4087: fnd_message.set_name('AR', 'AR_WF_SUBMISSION');
4088: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
4089: fnd_message.set_token('REQUESTOR', l_requestor_user_name);
4090: fnd_message.set_token('AMOUNT', to_char(l_total_credit_to_invoice));
4091: fnd_message.set_token('REASON', l_reason_meaning);
4092:
4093: l_note_text := fnd_message.get;

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

4086:
4087: fnd_message.set_name('AR', 'AR_WF_SUBMISSION');
4088: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
4089: fnd_message.set_token('REQUESTOR', l_requestor_user_name);
4090: fnd_message.set_token('AMOUNT', to_char(l_total_credit_to_invoice));
4091: fnd_message.set_token('REASON', l_reason_meaning);
4092:
4093: l_note_text := fnd_message.get;
4094: l_note_text1 := l_note_text;

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

4087: fnd_message.set_name('AR', 'AR_WF_SUBMISSION');
4088: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
4089: fnd_message.set_token('REQUESTOR', l_requestor_user_name);
4090: fnd_message.set_token('AMOUNT', to_char(l_total_credit_to_invoice));
4091: fnd_message.set_token('REASON', l_reason_meaning);
4092:
4093: l_note_text := fnd_message.get;
4094: l_note_text1 := l_note_text;
4095:

Line 4093: l_note_text := fnd_message.get;

4089: fnd_message.set_token('REQUESTOR', l_requestor_user_name);
4090: fnd_message.set_token('AMOUNT', to_char(l_total_credit_to_invoice));
4091: fnd_message.set_token('REASON', l_reason_meaning);
4092:
4093: l_note_text := fnd_message.get;
4094: l_note_text1 := l_note_text;
4095:
4096: IF l_comments is NOT NULL then
4097: select meaning into l_comment_type

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

4215: 'APPROVER_DISPLAY_NAME');
4216:
4217: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /*5119049*/
4218:
4219: fnd_message.set_name('AR', 'AR_WF_APPROVAL_REMINDER');
4220: fnd_message.set_token('APPROVER', l_approver_display_name);
4221: -- bug fix 1122477
4222:
4223: l_note_text := fnd_message.get;

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

4216:
4217: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /*5119049*/
4218:
4219: fnd_message.set_name('AR', 'AR_WF_APPROVAL_REMINDER');
4220: fnd_message.set_token('APPROVER', l_approver_display_name);
4221: -- bug fix 1122477
4222:
4223: l_note_text := fnd_message.get;
4224:

Line 4223: l_note_text := fnd_message.get;

4219: fnd_message.set_name('AR', 'AR_WF_APPROVAL_REMINDER');
4220: fnd_message.set_token('APPROVER', l_approver_display_name);
4221: -- bug fix 1122477
4222:
4223: l_note_text := fnd_message.get;
4224:
4225: IF l_notes is NOT NULL then
4226: l_note_text := SUBSTRB(l_note_text || ' "' || l_notes || '"',1,2000) ; /*5119049*/
4227: END IF;

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

4321: 'MANAGER_USER_NAME');
4322:
4323: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /*5119049*/
4324:
4325: fnd_message.set_name('AR', 'AR_WF_APPROVAL_ESCALATION');
4326: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
4327: fnd_message.set_token('APPROVER', l_manager_user_name);
4328:
4329: l_note_text := fnd_message.get;

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

4322:
4323: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /*5119049*/
4324:
4325: fnd_message.set_name('AR', 'AR_WF_APPROVAL_ESCALATION');
4326: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
4327: fnd_message.set_token('APPROVER', l_manager_user_name);
4328:
4329: l_note_text := fnd_message.get;
4330:

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

4323: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /*5119049*/
4324:
4325: fnd_message.set_name('AR', 'AR_WF_APPROVAL_ESCALATION');
4326: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
4327: fnd_message.set_token('APPROVER', l_manager_user_name);
4328:
4329: l_note_text := fnd_message.get;
4330:
4331:

Line 4329: l_note_text := fnd_message.get;

4325: fnd_message.set_name('AR', 'AR_WF_APPROVAL_ESCALATION');
4326: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
4327: fnd_message.set_token('APPROVER', l_manager_user_name);
4328:
4329: l_note_text := fnd_message.get;
4330:
4331:
4332: IF l_notes is NOT NULL then
4333: l_note_text := SUBSTRB(l_note_text || ' "' || l_notes || '"',1,2000) ; /*5119049*/

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

4429: SELECT display_name INTO l_role_display_name
4430: FROM wf_roles
4431: WHERE name = l_receivable_role;
4432:
4433: fnd_message.set_name('AR', 'AR_WF_REQUEST_MANUAL');
4434: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
4435: fnd_message.set_token('RECEIVABLE_ROLE',l_role_display_name);
4436:
4437: l_note_text := fnd_message.get;

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

4430: FROM wf_roles
4431: WHERE name = l_receivable_role;
4432:
4433: fnd_message.set_name('AR', 'AR_WF_REQUEST_MANUAL');
4434: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
4435: fnd_message.set_token('RECEIVABLE_ROLE',l_role_display_name);
4436:
4437: l_note_text := fnd_message.get;
4438:

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

4431: WHERE name = l_receivable_role;
4432:
4433: fnd_message.set_name('AR', 'AR_WF_REQUEST_MANUAL');
4434: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
4435: fnd_message.set_token('RECEIVABLE_ROLE',l_role_display_name);
4436:
4437: l_note_text := fnd_message.get;
4438:
4439: IF l_notes is NOT NULL then

Line 4437: l_note_text := fnd_message.get;

4433: fnd_message.set_name('AR', 'AR_WF_REQUEST_MANUAL');
4434: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
4435: fnd_message.set_token('RECEIVABLE_ROLE',l_role_display_name);
4436:
4437: l_note_text := fnd_message.get;
4438:
4439: IF l_notes is NOT NULL then
4440: l_note_text := SUBSTRB(l_note_text || ' "' || l_notes || '"',1,2000) ; /*5119049*/
4441: END IF;

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

4553: WHERE name = l_receivable_role;
4554:
4555:
4556:
4557: fnd_message.set_name('AR', 'AR_WF_COMPLETED_MANUAL');
4558: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
4559: fnd_message.set_token('APPROVER',l_role_display_name);
4560:
4561: l_note_text := fnd_message.get;

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

4554:
4555:
4556:
4557: fnd_message.set_name('AR', 'AR_WF_COMPLETED_MANUAL');
4558: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
4559: fnd_message.set_token('APPROVER',l_role_display_name);
4560:
4561: l_note_text := fnd_message.get;
4562:

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

4555:
4556:
4557: fnd_message.set_name('AR', 'AR_WF_COMPLETED_MANUAL');
4558: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
4559: fnd_message.set_token('APPROVER',l_role_display_name);
4560:
4561: l_note_text := fnd_message.get;
4562:
4563: IF l_notes is NOT NULL then

Line 4561: l_note_text := fnd_message.get;

4557: fnd_message.set_name('AR', 'AR_WF_COMPLETED_MANUAL');
4558: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
4559: fnd_message.set_token('APPROVER',l_role_display_name);
4560:
4561: l_note_text := fnd_message.get;
4562:
4563: IF l_notes is NOT NULL then
4564: l_note_text := SUBSTRB(l_note_text || ' "' || l_notes || '"',1,2000) ; /*5119049*/
4565: END IF;

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

4665: 'APPROVER_DISPLAY_NAME');
4666:
4667: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /*5119049*/
4668:
4669: fnd_message.set_name('AR', 'AR_WF_REQUEST_APPROVAL');
4670: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
4671: fnd_message.set_token('APPROVER', l_approver_display_name);
4672: -- bug fix 1122477
4673:

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

4666:
4667: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /*5119049*/
4668:
4669: fnd_message.set_name('AR', 'AR_WF_REQUEST_APPROVAL');
4670: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
4671: fnd_message.set_token('APPROVER', l_approver_display_name);
4672: -- bug fix 1122477
4673:
4674: l_note_text := fnd_message.get;

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

4667: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /*5119049*/
4668:
4669: fnd_message.set_name('AR', 'AR_WF_REQUEST_APPROVAL');
4670: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
4671: fnd_message.set_token('APPROVER', l_approver_display_name);
4672: -- bug fix 1122477
4673:
4674: l_note_text := fnd_message.get;
4675:

Line 4674: l_note_text := fnd_message.get;

4670: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
4671: fnd_message.set_token('APPROVER', l_approver_display_name);
4672: -- bug fix 1122477
4673:
4674: l_note_text := fnd_message.get;
4675:
4676: IF l_notes is NOT NULL then
4677: l_note_text := SUBSTRB(l_note_text || ' "' || l_notes || '"',1,2000) ; /*5119049*/
4678: END IF;

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

4784: 'APPROVER_DISPLAY_NAME');
4785: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /*5119049*/
4786:
4787:
4788: fnd_message.set_name('AR', 'AR_WF_APPROVED_RESPONSE');
4789: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
4790: fnd_message.set_token('APPROVER', l_approver_display_name);
4791: -- bug fix 1122477
4792:

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

4785: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /*5119049*/
4786:
4787:
4788: fnd_message.set_name('AR', 'AR_WF_APPROVED_RESPONSE');
4789: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
4790: fnd_message.set_token('APPROVER', l_approver_display_name);
4791: -- bug fix 1122477
4792:
4793: l_note_text := fnd_message.get;

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

4786:
4787:
4788: fnd_message.set_name('AR', 'AR_WF_APPROVED_RESPONSE');
4789: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
4790: fnd_message.set_token('APPROVER', l_approver_display_name);
4791: -- bug fix 1122477
4792:
4793: l_note_text := fnd_message.get;
4794:

Line 4793: l_note_text := fnd_message.get;

4789: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
4790: fnd_message.set_token('APPROVER', l_approver_display_name);
4791: -- bug fix 1122477
4792:
4793: l_note_text := fnd_message.get;
4794:
4795: IF l_notes is NOT NULL then
4796: l_note_text := SUBSTRB(l_note_text || ' "' || l_notes || '"',1,2000) ; /*5119049*/
4797: END IF;

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

4937: 'APPROVER_DISPLAY_NAME');
4938:
4939: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /*5119049*/
4940:
4941: fnd_message.set_name('AR', 'AR_WF_REJECTED_RESPONSE');
4942: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
4943: fnd_message.set_token('APPROVER', l_approver_display_name);
4944: -- bug fix 1122477
4945:

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

4938:
4939: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /*5119049*/
4940:
4941: fnd_message.set_name('AR', 'AR_WF_REJECTED_RESPONSE');
4942: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
4943: fnd_message.set_token('APPROVER', l_approver_display_name);
4944: -- bug fix 1122477
4945:
4946: l_note_text := fnd_message.get;

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

4939: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /*5119049*/
4940:
4941: fnd_message.set_name('AR', 'AR_WF_REJECTED_RESPONSE');
4942: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
4943: fnd_message.set_token('APPROVER', l_approver_display_name);
4944: -- bug fix 1122477
4945:
4946: l_note_text := fnd_message.get;
4947:

Line 4946: l_note_text := fnd_message.get;

4942: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
4943: fnd_message.set_token('APPROVER', l_approver_display_name);
4944: -- bug fix 1122477
4945:
4946: l_note_text := fnd_message.get;
4947:
4948: IF l_notes is NOT NULL then
4949: l_note_text := SUBSTRB(l_note_text || ' "' || l_notes || '"',1,2000) ; /*5119049*/
4950: END IF;

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

5083: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /*5119049*/
5084: /* Get trx number for CM and the insert into note text */
5085:
5086:
5087: fnd_message.set_name('AR', 'AR_WF_COMPLETED_SUCCESSFUL');
5088: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
5089: fnd_message.set_token('TRXNUMBER', l_credit_memo_number);
5090:
5091: l_note_text := fnd_message.get;

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

5084: /* Get trx number for CM and the insert into note text */
5085:
5086:
5087: fnd_message.set_name('AR', 'AR_WF_COMPLETED_SUCCESSFUL');
5088: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
5089: fnd_message.set_token('TRXNUMBER', l_credit_memo_number);
5090:
5091: l_note_text := fnd_message.get;
5092:

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

5085:
5086:
5087: fnd_message.set_name('AR', 'AR_WF_COMPLETED_SUCCESSFUL');
5088: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
5089: fnd_message.set_token('TRXNUMBER', l_credit_memo_number);
5090:
5091: l_note_text := fnd_message.get;
5092:
5093:

Line 5091: l_note_text := fnd_message.get;

5087: fnd_message.set_name('AR', 'AR_WF_COMPLETED_SUCCESSFUL');
5088: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
5089: fnd_message.set_token('TRXNUMBER', l_credit_memo_number);
5090:
5091: l_note_text := fnd_message.get;
5092:
5093:
5094: IF l_notes is NOT NULL then
5095: l_note_text := SUBSTRB(l_note_text || ' "' || l_notes || '"',1,2000) ; /*5119049*/

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

5447: in workflow definition
5448:
5449: IF l_batch_source_name IS NULL THEN
5450:
5451: fnd_message.set_name('AR', 'AR_WF_NO_BATCH');
5452: l_cm_creation_error := fnd_message.get;
5453:
5454: wf_engine.SetItemAttrText(p_item_type,
5455: p_item_key,

Line 5452: l_cm_creation_error := fnd_message.get;

5448:
5449: IF l_batch_source_name IS NULL THEN
5450:
5451: fnd_message.set_name('AR', 'AR_WF_NO_BATCH');
5452: l_cm_creation_error := fnd_message.get;
5453:
5454: wf_engine.SetItemAttrText(p_item_type,
5455: p_item_key,
5456: 'CM_CREATION_ERROR',