eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_WEB_EXPENSE_WF dependencies on WF_NOTIFICATION

Line 8: -- copied from WF_NOTIFICATION package

4:
5: --
6: -- Private Variables
7: --
8: -- copied from WF_NOTIFICATION package
9: -- /fnddev/fnd/11.5/patch/115/sql/wfntfb.pls
10: --
11:
12: table_width varchar2(6) := '"100%"';

Line 989: WF_NOTIFICATION.WriteToClob(document, l_table_header);

985: end if;
986:
987: l_table_header := l_table_header || tr_end;
988:
989: WF_NOTIFICATION.WriteToClob(document, l_table_header);
990:
991: EXCEPTION
992: WHEN OTHERS THEN
993: IF (SQLCODE <> -20001) THEN

Line 1131: WF_NOTIFICATION.WriteToClob(document, l_table_row);

1127: end if;
1128:
1129: l_table_row := l_table_row || tr_end;
1130:
1131: WF_NOTIFICATION.WriteToClob(document, l_table_row);
1132: end if;
1133:
1134: END LOOP; /* ExpenseReportLinesCursor */
1135:

Line 1144: WF_NOTIFICATION.WriteToClob(document, l_table_row);

1140: end if;
1141:
1142: l_table_row := table_end || indent_end;
1143:
1144: WF_NOTIFICATION.WriteToClob(document, l_table_row);
1145:
1146: EXCEPTION
1147: WHEN OTHERS THEN
1148: IF (SQLCODE <> -20001) THEN

Line 9452: WF_NOTIFICATION.NewClob(l_temp_clob,document);

9448: BEGIN
9449:
9450: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'start GenerateExpLines');
9451:
9452: WF_NOTIFICATION.NewClob(l_temp_clob,document);
9453: GenerateExpClobLines(document_id,
9454: display_type,
9455: l_temp_clob,
9456: document_type);

Line 9596: p_adjustment_line := p_adjustment_line || td_text || nvl(WF_NOTIFICATION.SubstituteSpecialChars(adjustment_rec.justification), '&' || 'nbsp;') || td_end;

9592: p_adjustment_line := p_adjustment_line || td_number || to_char(adjustment_rec.amount, FND_CURRENCY.Get_Format_Mask(p_currency,22)) || td_end;
9593: -- 'Credit Card Expense'
9594: p_adjustment_line := p_adjustment_line || td_text || NVL(adjustment_rec.credit_card_expense_disp, '&' || 'nbsp;') || td_end;
9595: -- 'Justification'
9596: p_adjustment_line := p_adjustment_line || td_text || nvl(WF_NOTIFICATION.SubstituteSpecialChars(adjustment_rec.justification), '&' || 'nbsp;') || td_end;
9597: -- 'Instructions'
9598: p_adjustment_line := p_adjustment_line || td_text;
9599: if (adjustment_rec.adjustment_reason_code_disp is not null) then
9600: p_adjustment_line := p_adjustment_line || WF_NOTIFICATION.SubstituteSpecialChars(adjustment_rec.adjustment_reason_code_disp) ||'
';

Line 9600: p_adjustment_line := p_adjustment_line || WF_NOTIFICATION.SubstituteSpecialChars(adjustment_rec.adjustment_reason_code_disp) ||'
';

9596: p_adjustment_line := p_adjustment_line || td_text || nvl(WF_NOTIFICATION.SubstituteSpecialChars(adjustment_rec.justification), '&' || 'nbsp;') || td_end;
9597: -- 'Instructions'
9598: p_adjustment_line := p_adjustment_line || td_text;
9599: if (adjustment_rec.adjustment_reason_code_disp is not null) then
9600: p_adjustment_line := p_adjustment_line || WF_NOTIFICATION.SubstituteSpecialChars(adjustment_rec.adjustment_reason_code_disp) ||'
';
9601: else
9602: p_adjustment_line := p_adjustment_line || '&'||'nbsp;';
9603: end if;
9604: if (adjustment_rec.adjustment_reason_description is not null) then

Line 9605: p_adjustment_line := p_adjustment_line || WF_NOTIFICATION.SubstituteSpecialChars(adjustment_rec.adjustment_reason_description) ||'
';

9601: else
9602: p_adjustment_line := p_adjustment_line || '&'||'nbsp;';
9603: end if;
9604: if (adjustment_rec.adjustment_reason_description is not null) then
9605: p_adjustment_line := p_adjustment_line || WF_NOTIFICATION.SubstituteSpecialChars(adjustment_rec.adjustment_reason_description) ||'
';
9606: else
9607: p_adjustment_line := p_adjustment_line || '&'||'nbsp;';
9608: end if;
9609: if (adjustment_rec.adjustment_reason is not null) then

Line 9610: p_adjustment_line := p_adjustment_line || WF_NOTIFICATION.SubstituteSpecialChars(adjustment_rec.adjustment_reason);

9606: else
9607: p_adjustment_line := p_adjustment_line || '&'||'nbsp;';
9608: end if;
9609: if (adjustment_rec.adjustment_reason is not null) then
9610: p_adjustment_line := p_adjustment_line || WF_NOTIFICATION.SubstituteSpecialChars(adjustment_rec.adjustment_reason);
9611: else
9612: p_adjustment_line := p_adjustment_line || '&'||'nbsp;';
9613: end if;
9614: p_adjustment_line := p_adjustment_line || td_end;

Line 9619: l_adjustment_line := adjustment_rec.expense_type_disp || ' ' || adjustment_rec.amount || ' ' || WF_NOTIFICATION.SubstituteSpecialChars(adjustment_rec.adjustment_reason);

9615: p_adjustment_line := p_adjustment_line || tr_end;
9616: END IF;
9617: ELSIF p_adjustment_type = 'AUDIT' THEN
9618: IF (p_display_type = 'text/plain') THEN
9619: l_adjustment_line := adjustment_rec.expense_type_disp || ' ' || adjustment_rec.amount || ' ' || WF_NOTIFICATION.SubstituteSpecialChars(adjustment_rec.adjustment_reason);
9620: p_adjustment_line := p_adjustment_line || '
9621: ' || l_adjustment_line;
9622: ELSE -- HTML type
9623: p_adjustment_line := p_adjustment_line || tr_start;

Line 9632: p_adjustment_line := p_adjustment_line || td_text || nvl(WF_NOTIFICATION.SubstituteSpecialChars(adjustment_rec.justification), '&' || 'nbsp;') || td_end;

9628: -- 'Amount'
9629: p_adjustment_line := p_adjustment_line || td_number ||
9630: NVL(to_char(adjustment_rec.amount, FND_CURRENCY.Get_Format_Mask(p_currency,22)), '&' || 'nbsp;') || td_end;
9631: -- 'Justification'
9632: p_adjustment_line := p_adjustment_line || td_text || nvl(WF_NOTIFICATION.SubstituteSpecialChars(adjustment_rec.justification), '&' || 'nbsp;') || td_end;
9633: -- 'Instructions'
9634: p_adjustment_line := p_adjustment_line || td_text;
9635: if (adjustment_rec.adjustment_reason_code_disp is not null) then
9636: p_adjustment_line := p_adjustment_line || WF_NOTIFICATION.SubstituteSpecialChars(adjustment_rec.adjustment_reason_code_disp) ||'
';

Line 9636: p_adjustment_line := p_adjustment_line || WF_NOTIFICATION.SubstituteSpecialChars(adjustment_rec.adjustment_reason_code_disp) ||'
';

9632: p_adjustment_line := p_adjustment_line || td_text || nvl(WF_NOTIFICATION.SubstituteSpecialChars(adjustment_rec.justification), '&' || 'nbsp;') || td_end;
9633: -- 'Instructions'
9634: p_adjustment_line := p_adjustment_line || td_text;
9635: if (adjustment_rec.adjustment_reason_code_disp is not null) then
9636: p_adjustment_line := p_adjustment_line || WF_NOTIFICATION.SubstituteSpecialChars(adjustment_rec.adjustment_reason_code_disp) ||'
';
9637: else
9638: p_adjustment_line := p_adjustment_line || '&'||'nbsp;';
9639: end if;
9640: if (adjustment_rec.adjustment_reason_description is not null) then

Line 9641: p_adjustment_line := p_adjustment_line || WF_NOTIFICATION.SubstituteSpecialChars(adjustment_rec.adjustment_reason_description) ||'
';

9637: else
9638: p_adjustment_line := p_adjustment_line || '&'||'nbsp;';
9639: end if;
9640: if (adjustment_rec.adjustment_reason_description is not null) then
9641: p_adjustment_line := p_adjustment_line || WF_NOTIFICATION.SubstituteSpecialChars(adjustment_rec.adjustment_reason_description) ||'
';
9642: else
9643: p_adjustment_line := p_adjustment_line || '&'||'nbsp;';
9644: end if;
9645: if (adjustment_rec.adjustment_reason is not null) then

Line 9646: p_adjustment_line := p_adjustment_line || WF_NOTIFICATION.SubstituteSpecialChars(adjustment_rec.adjustment_reason);

9642: else
9643: p_adjustment_line := p_adjustment_line || '&'||'nbsp;';
9644: end if;
9645: if (adjustment_rec.adjustment_reason is not null) then
9646: p_adjustment_line := p_adjustment_line || WF_NOTIFICATION.SubstituteSpecialChars(adjustment_rec.adjustment_reason);
9647: else
9648: p_adjustment_line := p_adjustment_line || '&'||'nbsp;';
9649: end if;
9650: p_adjustment_line := p_adjustment_line || td_end;

Line 9655: l_adjustment_line := adjustment_rec.expense_type_disp || ' ' || adjustment_rec.amount || ' ' || WF_NOTIFICATION.SubstituteSpecialChars(adjustment_rec.adjustment_reason);

9651: p_adjustment_line := p_adjustment_line || tr_end;
9652: END IF;
9653: ELSE
9654: IF (p_display_type = 'text/plain') THEN
9655: l_adjustment_line := adjustment_rec.expense_type_disp || ' ' || adjustment_rec.amount || ' ' || WF_NOTIFICATION.SubstituteSpecialChars(adjustment_rec.adjustment_reason);
9656: p_adjustment_line := p_adjustment_line || '
9657: ' || l_adjustment_line;
9658: ELSE -- HTML type
9659: p_adjustment_line := p_adjustment_line || tr_start;

Line 9670: p_adjustment_line := p_adjustment_line || td_text || nvl(WF_NOTIFICATION.SubstituteSpecialChars(adjustment_rec.justification), '&' || 'nbsp;') || td_end;

9666: NVL(to_char(adjustment_rec.amount, FND_CURRENCY.Get_Format_Mask(p_currency,22)), '&' || 'nbsp;') || td_end;
9667: -- 'Itemized Expense'
9668: p_adjustment_line := p_adjustment_line || td_text || NVL(adjustment_rec.itemized_expense_disp, '&' || 'nbsp;') || td_end;
9669: -- 'Justification'
9670: p_adjustment_line := p_adjustment_line || td_text || nvl(WF_NOTIFICATION.SubstituteSpecialChars(adjustment_rec.justification), '&' || 'nbsp;') || td_end;
9671: -- 'Instructions'
9672: p_adjustment_line := p_adjustment_line || td_text;
9673: if (adjustment_rec.adjustment_reason_code_disp is not null) then
9674: p_adjustment_line := p_adjustment_line || WF_NOTIFICATION.SubstituteSpecialChars(adjustment_rec.adjustment_reason_code_disp) ||'
';

Line 9674: p_adjustment_line := p_adjustment_line || WF_NOTIFICATION.SubstituteSpecialChars(adjustment_rec.adjustment_reason_code_disp) ||'
';

9670: p_adjustment_line := p_adjustment_line || td_text || nvl(WF_NOTIFICATION.SubstituteSpecialChars(adjustment_rec.justification), '&' || 'nbsp;') || td_end;
9671: -- 'Instructions'
9672: p_adjustment_line := p_adjustment_line || td_text;
9673: if (adjustment_rec.adjustment_reason_code_disp is not null) then
9674: p_adjustment_line := p_adjustment_line || WF_NOTIFICATION.SubstituteSpecialChars(adjustment_rec.adjustment_reason_code_disp) ||'
';
9675: else
9676: p_adjustment_line := p_adjustment_line || '&'||'nbsp;';
9677: end if;
9678: if (adjustment_rec.adjustment_reason_description is not null) then

Line 9679: p_adjustment_line := p_adjustment_line || WF_NOTIFICATION.SubstituteSpecialChars(adjustment_rec.adjustment_reason_description) ||'
';

9675: else
9676: p_adjustment_line := p_adjustment_line || '&'||'nbsp;';
9677: end if;
9678: if (adjustment_rec.adjustment_reason_description is not null) then
9679: p_adjustment_line := p_adjustment_line || WF_NOTIFICATION.SubstituteSpecialChars(adjustment_rec.adjustment_reason_description) ||'
';
9680: else
9681: p_adjustment_line := p_adjustment_line || '&'||'nbsp;';
9682: end if;
9683: if (adjustment_rec.adjustment_reason is not null) then

Line 9684: p_adjustment_line := p_adjustment_line || WF_NOTIFICATION.SubstituteSpecialChars(adjustment_rec.adjustment_reason);

9680: else
9681: p_adjustment_line := p_adjustment_line || '&'||'nbsp;';
9682: end if;
9683: if (adjustment_rec.adjustment_reason is not null) then
9684: p_adjustment_line := p_adjustment_line || WF_NOTIFICATION.SubstituteSpecialChars(adjustment_rec.adjustment_reason);
9685: else
9686: p_adjustment_line := p_adjustment_line || '&'||'nbsp;';
9687: end if;
9688: p_adjustment_line := p_adjustment_line || td_end;

Line 9713: WF_NOTIFICATION.NewClob(l_temp_clob,document);

9709: l_message VARCHAR2(2000);
9710: l_temp_clob CLOB;
9711: l_colon NUMBER;--namrata
9712: BEGIN
9713: WF_NOTIFICATION.NewClob(l_temp_clob,document);
9714:
9715: GenerateAdjustmentInfoClob(document_id,
9716: display_type,
9717: l_temp_clob,

Line 9964: WF_NOTIFICATION.WriteToClob(document,l_document);

9960: l_currency,
9961: l_document);--namrata
9962:
9963: IF lengthb(l_document)>=l_document_max THEN
9964: WF_NOTIFICATION.WriteToClob(document,l_document);
9965: l_document:='';--namrata
9966: END IF;
9967:
9968:

Line 10008: WF_NOTIFICATION.WriteToClob(document,l_document);

10004: */
10005: END IF;
10006:
10007: IF l_document is not null THEN
10008: WF_NOTIFICATION.WriteToClob(document,l_document);
10009: END IF;
10010:
10011: document_type := display_type;
10012:

Line 10352: l_message_name wf_notifications.message_name%type;

10348: l_oldApproversOut ame_util.approversTable2;
10349: -- Bug: 7463317
10350: l_approvers ame_util.approversTable2;
10351: l_approvalProcessCompleteYN varchar2(20) := ame_util.booleanFalse;
10352: l_message_name wf_notifications.message_name%type;
10353: l_temp_item_key wf_items.item_key%TYPE := p_item_key;
10354: l_n_org_id Number;
10355: l_temp_entered_by NUMBER;
10356: l_temp_user_name VARCHAR2(200);

Line 10412: from wf_notifications

10408: l_notificationID := wf_engine.context_nid;
10409:
10410: select message_name
10411: into l_message_name
10412: from wf_notifications
10413: where notification_id = l_notificationID;
10414:
10415: if (l_message_name = 'OIE_AME_EXPENSE_REPORT_APPRVL' OR
10416: l_message_name = 'OIE_REQ_EXPENSE_REPORT_APPRVL') then

Line 10430: l_approverResponse := WF_NOTIFICATION.GetAttrText(l_notificationID,'RESULT');

10426: l_approver_name := WF_ENGINE.GetItemAttrText(p_item_type,
10427: p_item_key,
10428: 'APPROVER_NAME');
10429: l_forwarder.name := l_approver_name;
10430: l_approverResponse := WF_NOTIFICATION.GetAttrText(l_notificationID,'RESULT');
10431:
10432: IF (l_approverResponse = 'APPROVED') THEN
10433: l_approvalStatusIn := AME_UTIL.approvedStatus;
10434: ELSIF (l_approverResponse = 'REJECTED') THEN

Line 10522: FROM wf_notifications

10518: l_debug_info := 'Get User info from notif';
10519: ---------------------------------------------------------------------
10520: BEGIN
10521: SELECT NVL(MORE_INFO_ROLE, RECIPIENT_ROLE) INTO l_temp_user_name
10522: FROM wf_notifications
10523: WHERE notification_id = l_notificationID;
10524:
10525: SELECT user_id INTO l_temp_entered_by FROM fnd_user WHERE user_name = l_temp_user_name;
10526: l_entered_by := l_temp_entered_by;

Line 10833: l_TransferNotificationID := WF_NOTIFICATION.SEND(

10829:
10830: -----------------------------------------
10831: l_debug_info := 'send notification Notify Preparer About Approval Request Transfer';
10832: -----------------------------------------
10833: l_TransferNotificationID := WF_NOTIFICATION.SEND(
10834: role => l_preparer_name,
10835: msg_type => 'APEXP',
10836: msg_name => 'OIE_PREPARER_TRANSFER',
10837: due_date => null,

Line 10847: WF_NOTIFICATION.SetAttrText(l_TransferNotificationID,

10843: if (l_TransferNotificationID is not null) then
10844: -----------------------------------------
10845: l_debug_info := 'set the notification attributes';
10846: -----------------------------------------
10847: WF_NOTIFICATION.SetAttrText(l_TransferNotificationID,
10848: 'DOCUMENT_NUMBER',
10849: WF_ENGINE.GetItemAttrText(p_item_type,
10850: p_item_key,
10851: 'DOCUMENT_NUMBER'));

Line 10853: WF_NOTIFICATION.SetAttrText(l_TransferNotificationID,

10849: WF_ENGINE.GetItemAttrText(p_item_type,
10850: p_item_key,
10851: 'DOCUMENT_NUMBER'));
10852:
10853: WF_NOTIFICATION.SetAttrText(l_TransferNotificationID,
10854: '#HDR_DISPLAY_TOTAL',
10855: WF_ENGINE.GetItemAttrText(p_item_type,
10856: p_item_key,
10857: 'DISPLAY_TOTAL'));

Line 10858: WF_NOTIFICATION.SetAttrText(l_TransferNotificationID,

10854: '#HDR_DISPLAY_TOTAL',
10855: WF_ENGINE.GetItemAttrText(p_item_type,
10856: p_item_key,
10857: 'DISPLAY_TOTAL'));
10858: WF_NOTIFICATION.SetAttrText(l_TransferNotificationID,
10859: '#FROM_ROLE',
10860: WF_ENGINE.GetItemAttrText(p_item_type,
10861: p_item_key,
10862: 'APPROVER_DISPLAY_NAME'));

Line 10863: WF_NOTIFICATION.SetAttrText(l_TransferNotificationID,

10859: '#FROM_ROLE',
10860: WF_ENGINE.GetItemAttrText(p_item_type,
10861: p_item_key,
10862: 'APPROVER_DISPLAY_NAME'));
10863: WF_NOTIFICATION.SetAttrText(l_TransferNotificationID,
10864: '#HDR_DOC_COST_CENTER',
10865: WF_ENGINE.GetItemAttrText(p_item_type,
10866: p_item_key,
10867: 'DOC_COST_CENTER'));

Line 10868: WF_NOTIFICATION.SetAttrText(l_TransferNotificationID,

10864: '#HDR_DOC_COST_CENTER',
10865: WF_ENGINE.GetItemAttrText(p_item_type,
10866: p_item_key,
10867: 'DOC_COST_CENTER'));
10868: WF_NOTIFICATION.SetAttrText(l_TransferNotificationID,
10869: '#HDR_EMPLOYEE_DISPLAY_NAME',
10870: WF_ENGINE.GetItemAttrText(p_item_type,
10871: p_item_key,
10872: 'EMPLOYEE_DISPLAY_NAME'));

Line 10873: WF_NOTIFICATION.SetAttrText(l_TransferNotificationID,

10869: '#HDR_EMPLOYEE_DISPLAY_NAME',
10870: WF_ENGINE.GetItemAttrText(p_item_type,
10871: p_item_key,
10872: 'EMPLOYEE_DISPLAY_NAME'));
10873: WF_NOTIFICATION.SetAttrText(l_TransferNotificationID,
10874: '#HDR_PURPOSE',
10875: WF_ENGINE.GetItemAttrText(p_item_type,
10876: p_item_key,
10877: 'PURPOSE'));

Line 10878: WF_NOTIFICATION.SetAttrText(l_TransferNotificationID,

10874: '#HDR_PURPOSE',
10875: WF_ENGINE.GetItemAttrText(p_item_type,
10876: p_item_key,
10877: 'PURPOSE'));
10878: WF_NOTIFICATION.SetAttrText(l_TransferNotificationID,
10879: 'APPROVER_DISPLAY_NAME',
10880: WF_ENGINE.GetItemAttrText(p_item_type,
10881: p_item_key,
10882: 'APPROVER_DISPLAY_NAME'));

Line 10883: WF_NOTIFICATION.SetAttrNumber(l_TransferNotificationID,

10879: 'APPROVER_DISPLAY_NAME',
10880: WF_ENGINE.GetItemAttrText(p_item_type,
10881: p_item_key,
10882: 'APPROVER_DISPLAY_NAME'));
10883: WF_NOTIFICATION.SetAttrNumber(l_TransferNotificationID,
10884: 'EXPENSE_REPORT_ID',
10885: WF_ENGINE.GetItemAttrNumber(p_item_type,
10886: p_item_key,
10887: 'EXPENSE_REPORT_ID'));

Line 10888: WF_NOTIFICATION.SetAttrText(l_TransferNotificationID,

10884: 'EXPENSE_REPORT_ID',
10885: WF_ENGINE.GetItemAttrNumber(p_item_type,
10886: p_item_key,
10887: 'EXPENSE_REPORT_ID'));
10888: WF_NOTIFICATION.SetAttrText(l_TransferNotificationID,
10889: 'OIE_APEXP_BODY',
10890: WF_ENGINE.GetItemAttrText(p_item_type,
10891: p_item_key,
10892: 'OIE_APEXP_BODY'));

Line 10893: WF_NOTIFICATION.SetAttrText(l_TransferNotificationID,

10889: 'OIE_APEXP_BODY',
10890: WF_ENGINE.GetItemAttrText(p_item_type,
10891: p_item_key,
10892: 'OIE_APEXP_BODY'));
10893: WF_NOTIFICATION.SetAttrText(l_TransferNotificationID,
10894: 'TRANSFER_APPROVER_DISPLAY_NAME',
10895: WF_ENGINE.GetItemAttrText(p_item_type,
10896: p_item_key,
10897: 'TRANSFER_APPROVER_DISPLAY_NAME'));

Line 10899: wf_notification.denormalize_notification(l_TransferNotificationID);

10895: WF_ENGINE.GetItemAttrText(p_item_type,
10896: p_item_key,
10897: 'TRANSFER_APPROVER_DISPLAY_NAME'));
10898:
10899: wf_notification.denormalize_notification(l_TransferNotificationID);
10900: end if;
10901:
10902: end if;
10903:

Line 11019: l_WFAdminNote := WF_NOTIFICATION.GetAttrText(l_notificationID,

11015:
11016: -----------------------------------------
11017: l_debug_info := 'Get WF Admin Note';
11018: -----------------------------------------
11019: l_WFAdminNote := WF_NOTIFICATION.GetAttrText(l_notificationID,
11020: 'WF_ADMIN_NOTE');
11021:
11022: /* Bug 2798344: The following code does got fire to raise a sql
11023: exception. However, it appears to be a bug than a desired feature.

Line 11649: l_payable_admin wf_notifications.recipient_role%TYPE;

11645: l_doc_cctr VARCHAR2(2000);
11646: l_preparer_name VARCHAR2(2000);
11647: l_employee_name VARCHAR2(2000);
11648: l_purpose VARCHAR2(2400);
11649: l_payable_admin wf_notifications.recipient_role%TYPE;
11650: l_currency VARCHAR2(50);
11651: l_total VARCHAR2(200);
11652: l_payment_due VARCHAR2(100);
11653: l_debug_info VARCHAR2(200);

Line 12233: WF_NOTIFICATION.WriteToClob(document,fnd_message.get);

12229: IF (l_payment = 'BOTH' and l_num_both_personal_lines > 0) THEN
12230: NULL;
12231: ELSE
12232: FND_MESSAGE.SET_NAME('SQLAP','AP_WEB_EXP_REPORT_SHORTPAID');
12233: WF_NOTIFICATION.WriteToClob(document,fnd_message.get);
12234: document_type := display_type;
12235: return;
12236: END IF;
12237: --Bug 2944363 End here.

Line 12342: WF_NOTIFICATION.WriteToClob(document,l_document);

12338: loop
12339:
12340: IF lengthb(l_document) >= l_document_max THEN
12341: -- Appends l_document to end of document (CLOB object)
12342: WF_NOTIFICATION.WriteToClob(document,l_document);
12343: l_document := '';
12344: --l_show_message := 'Y';
12345: --exit;
12346: END IF;

Line 12470: WF_NOTIFICATION.WriteToClob(document,l_document);

12466: EXIT WHEN XpenseLinesCursor%NOTFOUND;
12467:
12468: IF lengthb(l_document) >= l_document_max THEN
12469: -- Appends l_document to end of document (CLOB object)
12470: WF_NOTIFICATION.WriteToClob(document,l_document);
12471: l_document := '';
12472: --l_show_message := 'Y';
12473: --exit;
12474: END IF;

Line 12560: l_document := l_document || td_text || WF_NOTIFICATION.SubstituteSpecialChars(l_merchant_name) || td_end;

12556: -- display Expense Type
12557: l_document := l_document || td_text || l_expense_type || td_end;
12558: -- display Merchant Name
12559: if ((l_is_cc_table) or (NOT l_is_cc_table and l_co_merchant_count > 0)) then
12560: l_document := l_document || td_text || WF_NOTIFICATION.SubstituteSpecialChars(l_merchant_name) || td_end;
12561: end if;
12562:
12563: if (l_employee_project_enabled = 'Y') then
12564: -- display Project/Task only when Projects enabled

Line 12576: l_document := l_document || td_text || nvl(WF_NOTIFICATION.SubstituteSpecialChars(l_justification), '&' || 'nbsp;') || td_end;

12572: -- display Amount
12573: l_document := l_document || td_number || LPAD(to_char(l_total_amt, FND_CURRENCY.Get_Format_Mask(l_currency,22)),14) || td_end;
12574:
12575: -- display Justification
12576: l_document := l_document || td_text || nvl(WF_NOTIFICATION.SubstituteSpecialChars(l_justification), '&' || 'nbsp;') || td_end;
12577:
12578: if (l_line_accounting_enabled = 'Y') then
12579: l_document := l_document || td_text || nvl(l_flex_concatenated, '&' || 'nbsp;') || td_end;
12580: end if;

Line 12588: l_document := l_document || td_text || WF_NOTIFICATION.SubstituteSpecialChars(l_merchant_name) || td_end;

12584: l_document := l_document || td_text || '&' || 'nbsp;' || td_end;
12585:
12586: -- display Merchant Name
12587: if ((l_is_cc_table) or (NOT l_is_cc_table and l_co_merchant_count > 0)) then
12588: l_document := l_document || td_text || WF_NOTIFICATION.SubstituteSpecialChars(l_merchant_name) || td_end;
12589: end if;
12590:
12591: if (l_employee_project_enabled = 'Y') then
12592: -- display Project/Task only when Projects enabled

Line 12783: WF_NOTIFICATION.WriteToClob(document,l_document);

12779: EXIT WHEN PersonalLinesCursor%NOTFOUND;
12780:
12781: IF lengthb(l_document) >= l_document_max THEN
12782: -- Appends l_document to end of document (CLOB object)
12783: WF_NOTIFICATION.WriteToClob(document,l_document);
12784: l_document := '';
12785: --l_show_message := 'Y';
12786: --exit;
12787: END IF;

Line 12801: l_document := l_document || td_text || WF_NOTIFICATION.SubstituteSpecialChars(l_merchant_name) || td_end;

12797: l_document := l_document || td_text || l_start_date || td_end;
12798:
12799: -- display Merchant
12800: --Bug 2942773: Add Merchant name value to personal expense table.
12801: l_document := l_document || td_text || WF_NOTIFICATION.SubstituteSpecialChars(l_merchant_name) || td_end;
12802: -- display Amount
12803: l_document := l_document || td_number || LPAD(to_char(l_total_amt, FND_CURRENCY.Get_Format_Mask(l_currency,22)),14) || td_end;
12804: l_document := l_document || tr_end;
12805:

Line 12890: WF_NOTIFICATION.WriteToClob(document,l_document);

12886: l_cc_merchant_name;
12887: EXIT WHEN BothPayPersonalLinesCursor%NOTFOUND;
12888: IF lengthb(l_document) >= l_document_max THEN
12889: -- Appends l_document to end of document (CLOB object)
12890: WF_NOTIFICATION.WriteToClob(document,l_document);
12891: l_document := '';
12892: --l_show_message := 'Y';
12893: --exit;
12894: END IF;

Line 12901: l_document := l_document || td_text || WF_NOTIFICATION.SubstituteSpecialChars(l_cc_merchant_name) || td_end;

12897: l_document := l_document || tr_start;
12898: -- display Date
12899: l_document := l_document || td_text || l_cc_trxn_date || td_end;
12900: -- display Merchant
12901: l_document := l_document || td_text || WF_NOTIFICATION.SubstituteSpecialChars(l_cc_merchant_name) || td_end;
12902: -- display Amount
12903: l_document := l_document || td_number || LPAD(to_char(l_cc_expensed_amt, FND_CURRENCY.Get_Format_Mask(l_cc_curr_code,22)),14) || td_end;
12904: l_document := l_document || tr_end;
12905:

Line 12952: WF_NOTIFICATION.WriteToClob(document,l_document);

12948: /* Bug 3561386 : Should add l_document to the clob only if it is
12949: * not null.
12950: */
12951: IF l_document is not null then
12952: WF_NOTIFICATION.WriteToClob(document,l_document);
12953: END IF;
12954:
12955: document_type := display_type;
12956:

Line 15326: FROM wf_notifications

15322: IF ( l_ame_enabled <> 'Y' ) THEN
15323:
15324: BEGIN
15325: SELECT recipient_role INTO l_user_name
15326: FROM wf_notifications
15327: WHERE message_type = 'APEXP'
15328: AND message_name = 'OIE_REQ_EXPENSE_REPORT_APPRVL'
15329: AND ( item_key = p_item_key
15330: OR p_item_key = SubStr(context,7,length(p_item_key)) )

Line 15366: FROM wf_notifications

15362: -- l_entered_by);
15363:
15364: BEGIN
15365: SELECT recipient_role INTO l_user_name
15366: FROM wf_notifications
15367: WHERE message_type = 'APEXP'
15368: AND message_name = 'OIE_REQUEST_EMPLOYEE_APPROVAL'
15369: AND ( item_key = p_item_key
15370: OR p_item_key = SubStr(context,7,length(p_item_key)) )

Line 16032: l_user_name wf_notifications.recipient_role%type;

16028: l_item_type wf_items.item_type%type;
16029: l_item_key wf_items.item_key%type;
16030: l_temp_item_key wf_items.item_key%type;
16031: l_access_granted varchar2(1) := 'N';
16032: l_user_name wf_notifications.recipient_role%type;
16033:
16034: BEGIN
16035:
16036: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'start CheckAccess');

Line 16041: from wf_notifications

16037:
16038: -- get the item type for the notif
16039: select message_type, item_key
16040: into l_item_type, l_temp_item_key
16041: from wf_notifications
16042: where notification_id = p_ntf_id
16043: and rownum = 1;
16044:
16045: -- check the following:

Line 16128: from wf_notifications wfn ,

16124: /*
16125: -- 2. User has access to the NtfId
16126: select 'Y'
16127: into l_access_granted
16128: from wf_notifications wfn ,
16129: WF_USER_ROLES wur
16130: where wur.user_name = p_user_name
16131: and wfn.notification_id = p_ntf_id
16132: and ( wfn.recipient_role = wur.role_name

Line 16194: l_end_date wf_notifications.end_date%TYPE;

16190: l_employee_id NUMBER;
16191: l_continue BOOLEAN := TRUE;
16192: l_wf_active BOOLEAN := FALSE;
16193: l_wf_exist BOOLEAN := FALSE;
16194: l_end_date wf_notifications.end_date%TYPE;
16195: l_approver_exist varchar2(1) := 'N'; -- Bug 15928430
16196:
16197: BEGIN
16198:

Line 16251: from wf_notifications

16247: l_child_item_key := p_item_key || '-' || to_char(i);
16248: begin
16249: select end_date
16250: into l_end_date
16251: from wf_notifications
16252: where message_type = 'APEXP'
16253: and message_name = 'OIE_AME_EXPENSE_REPORT_APPRVL'
16254: and item_key = l_child_item_key;
16255: if l_end_date is NULL then

Line 17242: l_context wf_notifications.context%type;

17238: RETURN l_ExpAccountsUpdated;
17239: END IsExpAccountsUpdated;
17240:
17241: FUNCTION getItemKey(p_notification_id IN NUMBER) RETURN VARCHAR2 IS
17242: l_context wf_notifications.context%type;
17243: l_temp_context wf_notifications.context%type;
17244: l_item_key wf_notifications.context%type;
17245: l_debug_info varchar2(200);
17246: BEGIN

Line 17243: l_temp_context wf_notifications.context%type;

17239: END IsExpAccountsUpdated;
17240:
17241: FUNCTION getItemKey(p_notification_id IN NUMBER) RETURN VARCHAR2 IS
17242: l_context wf_notifications.context%type;
17243: l_temp_context wf_notifications.context%type;
17244: l_item_key wf_notifications.context%type;
17245: l_debug_info varchar2(200);
17246: BEGIN
17247: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'start getItemKey');

Line 17244: l_item_key wf_notifications.context%type;

17240:
17241: FUNCTION getItemKey(p_notification_id IN NUMBER) RETURN VARCHAR2 IS
17242: l_context wf_notifications.context%type;
17243: l_temp_context wf_notifications.context%type;
17244: l_item_key wf_notifications.context%type;
17245: l_debug_info varchar2(200);
17246: BEGIN
17247: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'start getItemKey');
17248:

Line 17250: from wf_notifications

17246: BEGIN
17247: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'start getItemKey');
17248:
17249: select context into l_context
17250: from wf_notifications
17251: where notification_id = p_notification_id;
17252:
17253: --l_context would have something like 'APEXP:22591-2:579934'
17254: