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.PON_AUCTION_PKG dependencies on FND_GLOBAL

Line 1050: owner => fnd_global.user_name);

1046:
1047: -- Bug 4295915: Set the workflow owner
1048: wf_engine.SetItemOwner(itemtype => x_itemtype,
1049: itemkey => x_itemkey,
1050: owner => fnd_global.user_name);
1051:
1052: wf_engine.StartProcess(itemtype => x_itemtype,
1053: itemkey => x_itemkey );
1054:

Line 1229: avalue => fnd_global.user_name);

1225:
1226: wf_engine.SetItemAttrText (itemtype => x_itemtype,
1227: itemkey => x_itemkey,
1228: aname => 'ORIGIN_USER_NAME',
1229: avalue => fnd_global.user_name);
1230:
1231: wf_engine.SetItemOwner(itemtype => x_itemtype,
1232: itemkey => x_itemkey,
1233: owner => fnd_global.user_name);

Line 1233: owner => fnd_global.user_name);

1229: avalue => fnd_global.user_name);
1230:
1231: wf_engine.SetItemOwner(itemtype => x_itemtype,
1232: itemkey => x_itemkey,
1233: owner => fnd_global.user_name);
1234:
1235:
1236: --
1237: -- Start the workflow

Line 1519: avalue => fnd_global.user_name);

1515:
1516: wf_engine.SetItemAttrText (itemtype => x_itemtype,
1517: itemkey => x_itemkey,
1518: aname => 'ORIGIN_USER_NAME',
1519: avalue => fnd_global.user_name);
1520:
1521:
1522: wf_engine.SetItemAttrNumber (itemtype => x_itemtype,
1523: itemkey => x_itemkey,

Line 1860: owner => fnd_global.user_name);

1856:
1857: -- Bug 4295915: Set the workflow owner
1858: wf_engine.SetItemOwner(itemtype => x_itemtype,
1859: itemkey => x_itemkey,
1860: owner => fnd_global.user_name);
1861:
1862: wf_engine.StartProcess(itemtype => x_itemtype,
1863: itemkey => x_itemkey );
1864:

Line 2019: owner => fnd_global.user_name);

2015:
2016: -- Bug 4295915: Set the workflow owner
2017: wf_engine.SetItemOwner(itemtype => x_itemtype,
2018: itemkey => x_itemkey,
2019: owner => fnd_global.user_name);
2020:
2021: --
2022: -- Start the workflow
2023: --

Line 2203: avalue => fnd_global.user_name);

2199:
2200: wf_engine.SetItemAttrText (itemtype => x_itemtype,
2201: itemkey => x_itemkey,
2202: aname => 'ORIGIN_USER_NAME',
2203: avalue => fnd_global.user_name);
2204:
2205: -- Item attribute value is going to be used as a parameter to View Quote page
2206: wf_engine.SetItemAttrNumber (itemtype => x_itemtype,
2207: itemkey => x_itemkey,

Line 2458: owner => fnd_global.user_name);

2454:
2455: -- Bug 4295915: Set the workflow owner
2456: wf_engine.SetItemOwner(itemtype => x_itemtype,
2457: itemkey => x_itemkey,
2458: owner => fnd_global.user_name);
2459:
2460: --
2461: -- Start the workflow
2462: --

Line 2558: avalue => fnd_global.user_name);

2554:
2555: wf_engine.SetItemAttrText (itemtype => x_itemtype,
2556: itemkey => x_itemkey,
2557: aname => 'ORIGIN_USER_NAME',
2558: avalue => fnd_global.user_name);
2559: x_progress := '026';
2560:
2561:
2562: wf_engine.SetItemAttrText (itemtype => x_itemtype,

Line 2599: owner => fnd_global.user_name);

2595:
2596: -- Bug 4295915: Set the workflow owner
2597: wf_engine.SetItemOwner(itemtype => x_itemtype,
2598: itemkey => x_itemkey,
2599: owner => fnd_global.user_name);
2600:
2601: --
2602: -- Start the workflow
2603: --

Line 2902: avalue => fnd_global.user_name);

2898:
2899: wf_engine.SetItemAttrText (itemtype => x_itemtype,
2900: itemkey => x_itemkey,
2901: aname => 'ORIGIN_USER_NAME',
2902: avalue => fnd_global.user_name);
2903:
2904: wf_engine.SetItemAttrText (itemtype => x_itemtype,
2905: itemkey => x_itemkey,
2906: aname => 'BID',

Line 3115: owner => fnd_global.user_name);

3111:
3112: -- Bug 4295915: Set the workflow owner
3113: wf_engine.SetItemOwner(itemtype => x_itemtype,
3114: itemkey => x_itemkey,
3115: owner => fnd_global.user_name);
3116:
3117: --
3118: -- Start the workflow
3119: --

Line 4139: owner => fnd_global.user_name);

4135:
4136: -- Bug 4295915: Set the workflow owner
4137: wf_engine.SetItemOwner(itemtype => x_itemtype,
4138: itemkey => x_itemkey,
4139: owner => fnd_global.user_name);
4140:
4141: wf_engine.StartProcess(itemtype => x_itemtype,
4142: itemkey => x_itemkey);
4143: end if;

Line 5611: html_out1 := replace(html_in,concat(fnd_global.local_chr(38),'quot;'),fnd_global.local_chr(34));

5607: html_out1 varchar2(4000);
5608: html_out2 varchar2(4000);
5609: html_out3 varchar2(4000);
5610: begin
5611: html_out1 := replace(html_in,concat(fnd_global.local_chr(38),'quot;'),fnd_global.local_chr(34));
5612: html_out2 := replace(html_out1,concat(fnd_global.local_chr(38),'lt;'),fnd_global.local_chr(60));
5613: html_out3 := replace(html_out2,concat(fnd_global.local_chr(38),'gt;'),fnd_global.local_chr(62));
5614: return(html_out3);
5615: end;

Line 5612: html_out2 := replace(html_out1,concat(fnd_global.local_chr(38),'lt;'),fnd_global.local_chr(60));

5608: html_out2 varchar2(4000);
5609: html_out3 varchar2(4000);
5610: begin
5611: html_out1 := replace(html_in,concat(fnd_global.local_chr(38),'quot;'),fnd_global.local_chr(34));
5612: html_out2 := replace(html_out1,concat(fnd_global.local_chr(38),'lt;'),fnd_global.local_chr(60));
5613: html_out3 := replace(html_out2,concat(fnd_global.local_chr(38),'gt;'),fnd_global.local_chr(62));
5614: return(html_out3);
5615: end;
5616:

Line 5613: html_out3 := replace(html_out2,concat(fnd_global.local_chr(38),'gt;'),fnd_global.local_chr(62));

5609: html_out3 varchar2(4000);
5610: begin
5611: html_out1 := replace(html_in,concat(fnd_global.local_chr(38),'quot;'),fnd_global.local_chr(34));
5612: html_out2 := replace(html_out1,concat(fnd_global.local_chr(38),'lt;'),fnd_global.local_chr(60));
5613: html_out3 := replace(html_out2,concat(fnd_global.local_chr(38),'gt;'),fnd_global.local_chr(62));
5614: return(html_out3);
5615: end;
5616:
5617:

Line 5844: /* FND_GLOBAL.LOCAL_CHR() for a performance bug (982909) */

5840: while POS < DATA_SIZE loop
5841: FLAG := SUBSTR(MSGDATA, POS, 1);
5842: POS := POS + 2;
5843: /* Note that we are intentionally using chr(0) rather than */
5844: /* FND_GLOBAL.LOCAL_CHR() for a performance bug (982909) */
5845: NEXTPOS := INSTR(MSGDATA, chr(0), POS);
5846: TOK_NAM := SUBSTR(MSGDATA, POS, NEXTPOS - POS);
5847: POS := NEXTPOS + 1;
5848: NEXTPOS := INSTR(MSGDATA, chr(0), POS);

Line 6389: g_original_lang_code := fnd_global.current_language;

6385: module => g_module_prefix || 'SET_SESSION_LANGUAGE',
6386: message => 'Entered procedure : p_language_code ' || p_language_code);
6387: END IF; --}
6388:
6389: g_original_lang_code := fnd_global.current_language;
6390:
6391: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6392: FND_LOG.string(log_level => FND_LOG.level_statement,
6393: module => g_module_prefix || 'SET_SESSION_LANGUAGE',

Line 7023: avalue => fnd_global.user_name);

7019:
7020: wf_engine.SetItemAttrText (itemtype => x_itemtype,
7021: itemkey => x_itemkey,
7022: aname => 'ORIGIN_USER_NAME',
7023: avalue => fnd_global.user_name);
7024:
7025: wf_engine.SetItemAttrText (itemtype => x_itemtype,
7026: itemkey => x_itemkey,
7027: aname => 'NOTE_TO_BIDDERS',

Line 7103: owner => fnd_global.user_name);

7099:
7100: -- Bug 4295915: Set the workflow owner
7101: wf_engine.SetItemOwner(itemtype => x_itemtype,
7102: itemkey => x_itemkey,
7103: owner => fnd_global.user_name);
7104:
7105: --
7106: -- Start the workflow
7107: --

Line 7548: x_neg_summary_url_supplier:=regexp_replace(x_neg_summary_url_supplier , 'language_code='||fnd_global.current_language, 'language_code='||x_language_code);

7544: ,p_notif_performer => 'SUPPLIER');
7545: --Bug 11898698
7546: --Modifying the language_code in the URL with that of the recipient
7547: --The profile "ICX_LANGUAGE" needs to be set for the recipient for this fix
7548: x_neg_summary_url_supplier:=regexp_replace(x_neg_summary_url_supplier , 'language_code='||fnd_global.current_language, 'language_code='||x_language_code);
7549:
7550: wf_engine.SetItemAttrText (itemtype => t_itemtype,
7551: itemkey => t_itemkey,
7552: aname => 'NEG_SUMMARY_URL',

Line 7662: avalue => fnd_global.user_name);

7658:
7659: wf_engine.SetItemAttrText (itemtype => t_itemtype,
7660: itemkey => t_itemkey,
7661: aname => 'ORIGIN_USER_NAME',
7662: avalue => fnd_global.user_name);
7663:
7664:
7665: -- Bug 3824928: Deleted unwanted lines here
7666:

Line 7856: owner => fnd_global.user_name);

7852:
7853: -- Bug 4295915: Set the workflow owner
7854: wf_engine.SetItemOwner(itemtype => t_itemtype,
7855: itemkey => t_itemkey,
7856: owner => fnd_global.user_name);
7857:
7858: wf_engine.StartProcess(itemtype => t_itemtype,
7859: itemkey => t_itemkey );
7860:

Line 8254: owner => fnd_global.user_name);

8250:
8251: -- Bug 4295915: Set the workflow owner
8252: wf_engine.SetItemOwner(itemtype => l_itemtype,
8253: itemkey => l_itemkey,
8254: owner => fnd_global.user_name);
8255:
8256: wf_engine.StartProcess ( ItemType => l_ItemType,
8257: ItemKey => l_ItemKey );
8258:

Line 8959: owner => fnd_global.user_name);

8955:
8956: -- Bug 4295915: Set the workflow owner
8957: wf_engine.SetItemOwner(itemtype => x_itemtype,
8958: itemkey => x_itemkey,
8959: owner => fnd_global.user_name);
8960:
8961: -- choli update for emd
8962: -- For members, store item key in pom_bidding_parties
8963: x_auction_header_id := wf_engine.GetItemAttrNumber(itemtype => p_itemtype,

Line 9527: owner => fnd_global.user_name);

9523:
9524: -- Bug 4295915: Set the workflow owner
9525: wf_engine.SetItemOwner(itemtype => x_itemtype,
9526: itemkey => x_itemkey,
9527: owner => fnd_global.user_name);
9528:
9529: wf_engine.StartProcess(itemtype => x_itemtype,
9530: itemkey => x_itemkey );
9531:

Line 9818: last_updated_by = FND_GLOBAL.USER_ID,

9814: auction_header_id = null,
9815: auction_display_number = null,
9816: auction_line_number = NULL,
9817: last_update_date = SYSDATE,
9818: last_updated_by = FND_GLOBAL.USER_ID,
9819: last_update_login = FND_GLOBAL.LOGIN_ID
9820: WHERE (REQUISITION_LINE_ID = l_requisition_line_id
9821: OR group_line_id=l_requisition_line_id
9822: OR clm_base_line_num=l_requisition_line_id)

Line 9819: last_update_login = FND_GLOBAL.LOGIN_ID

9815: auction_display_number = null,
9816: auction_line_number = NULL,
9817: last_update_date = SYSDATE,
9818: last_updated_by = FND_GLOBAL.USER_ID,
9819: last_update_login = FND_GLOBAL.LOGIN_ID
9820: WHERE (REQUISITION_LINE_ID = l_requisition_line_id
9821: OR group_line_id=l_requisition_line_id
9822: OR clm_base_line_num=l_requisition_line_id)
9823: and nvl(modified_by_agent_flag,'N') <> 'Y'

Line 10883: avalue => fnd_global.user_name);

10879:
10880: wf_engine.SetItemAttrText (itemtype => x_itemtype,
10881: itemkey => x_itemkey,
10882: aname => 'ORIGIN_USER_NAME',
10883: avalue => fnd_global.user_name);
10884:
10885: wf_engine.SetItemAttrText (itemtype => x_itemtype,
10886: itemkey => x_itemkey,
10887: aname => 'RECIPIENT_ROLE',

Line 10920: owner => fnd_global.user_name);

10916:
10917: -- Bug 4295915: Set the workflow owner
10918: wf_engine.SetItemOwner(itemtype => x_itemtype,
10919: itemkey => x_itemkey,
10920: owner => fnd_global.user_name);
10921:
10922: wf_engine.StartProcess(itemtype => x_itemtype,
10923: itemkey => x_itemkey );
10924:

Line 11314: owner => fnd_global.user_name);

11310:
11311: -- Bug 4295915: Set the workflow owner
11312: wf_engine.SetItemOwner(itemtype => x_itemtype,
11313: itemkey => x_itemkey,
11314: owner => fnd_global.user_name);
11315:
11316: l_progress := '100';
11317:
11318: wf_engine.StartProcess(itemtype => x_itemtype,

Line 11702: avalue => fnd_global.user_name);

11698:
11699: wf_engine.SetItemAttrText (itemtype => l_itemtype,
11700: itemkey => l_itemkey,
11701: aname => 'RECIPIENT_ROLE',
11702: avalue => fnd_global.user_name);
11703:
11704:
11705: wf_engine.SetItemAttrText (itemtype => l_itemtype,
11706: itemkey => l_itemkey,

Line 11748: owner => fnd_global.user_name);

11744:
11745: -- Bug 4295915: Set the workflow owner
11746: wf_engine.SetItemOwner(itemtype => l_itemtype,
11747: itemkey => l_itemkey,
11748: owner => fnd_global.user_name);
11749:
11750: l_progress := '100';
11751:
11752: wf_engine.StartProcess(itemtype => l_itemtype,

Line 12946: --avalue => fnd_global.user_name);--Bug: 13609915 :set FROM as creator of doc

12942:
12943: wf_engine.SetItemAttrText (itemtype => l_itemtype,
12944: itemkey => l_itemkey,
12945: aname => 'ORIGIN_USER_NAME',
12946: --avalue => fnd_global.user_name);--Bug: 13609915 :set FROM as creator of doc
12947: avalue => l_sender_user);
12948:
12949: -- Bug 4295915: Set the workflow owner
12950: wf_engine.SetItemOwner(itemtype => l_itemtype,

Line 12952: owner => fnd_global.user_name);

12948:
12949: -- Bug 4295915: Set the workflow owner
12950: wf_engine.SetItemOwner(itemtype => l_itemtype,
12951: itemkey => l_itemkey,
12952: owner => fnd_global.user_name);
12953:
12954: BEGIN
12955:
12956: wf_engine.SetItemAttrText (itemtype => l_itemtype,

Line 13960: avalue => fnd_global.user_name);

13956: -- origin user name
13957: wf_engine.SetItemAttrText( itemtype => x_item_type,
13958: itemkey => x_item_key,
13959: aname => 'ORIGIN_USER_NAME',
13960: avalue => fnd_global.user_name);
13961:
13962: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
13963: FND_LOG.string (log_level => FND_LOG.level_statement,
13964: module => g_module_prefix || '.notify_bidders_tech_complete',

Line 14956: NL VARCHAR2(1) := fnd_global.newline;

14952: document IN OUT NOCOPY CLOB,
14953: document_type IN OUT NOCOPY VARCHAR2)
14954: IS
14955:
14956: NL VARCHAR2(1) := fnd_global.newline;
14957: l_document VARCHAR2(32000) := '';
14958: l_disp_type VARCHAR2(20) := 'text/plain';
14959: l_item_type wf_items.item_type%TYPE;
14960: l_item_key wf_items.item_key%TYPE;

Line 15161: NL VARCHAR2(1) := fnd_global.newline;

15157: document IN OUT NOCOPY CLOB,
15158: document_type IN OUT NOCOPY VARCHAR2)
15159: IS
15160:
15161: NL VARCHAR2(1) := fnd_global.newline;
15162: l_document VARCHAR2(32000) := '';
15163: l_disp_type VARCHAR2(20) := 'text/plain';
15164: l_item_type wf_items.item_type%TYPE;
15165: l_item_key wf_items.item_key%TYPE;

Line 15324: NL VARCHAR2(1) := fnd_global.newline;

15320: document IN OUT NOCOPY CLOB,
15321: document_type IN OUT NOCOPY VARCHAR2)
15322: IS
15323:
15324: NL VARCHAR2(1) := fnd_global.newline;
15325: l_document VARCHAR2(32000) := '';
15326: l_disp_type VARCHAR2(20) := 'text/plain';
15327: l_item_type wf_items.item_type%TYPE;
15328: l_item_key wf_items.item_key%TYPE;

Line 15542: NL VARCHAR2(1) := fnd_global.newline;

15538: document IN OUT NOCOPY CLOB,
15539: document_type IN OUT NOCOPY VARCHAR2)
15540: IS
15541:
15542: NL VARCHAR2(1) := fnd_global.newline;
15543: l_document VARCHAR2(32000) := '';
15544: l_disp_type VARCHAR2(20) := 'text/plain';
15545: l_item_type wf_items.item_type%TYPE;
15546: l_item_key wf_items.item_key%TYPE;

Line 15751: NL VARCHAR2(1) := fnd_global.newline;

15747: document IN OUT NOCOPY CLOB,
15748: document_type IN OUT NOCOPY VARCHAR2)
15749: IS
15750:
15751: NL VARCHAR2(1) := fnd_global.newline;
15752: l_document VARCHAR2(32000) := '';
15753: l_disp_type VARCHAR2(20) := 'text/plain';
15754: l_item_type wf_items.item_type%TYPE;
15755: l_item_key wf_items.item_key%TYPE;

Line 15982: NL VARCHAR2(1) := fnd_global.newline;

15978: document IN OUT NOCOPY CLOB,
15979: document_type IN OUT NOCOPY VARCHAR2)
15980: IS
15981:
15982: NL VARCHAR2(1) := fnd_global.newline;
15983: l_document VARCHAR2(32000) := '';
15984: l_disp_type VARCHAR2(20) := 'text/plain';
15985: l_item_type wf_items.item_type%TYPE;
15986: l_item_key wf_items.item_key%TYPE;

Line 16192: NL VARCHAR2(1) := fnd_global.newline;

16188: document IN OUT NOCOPY CLOB,
16189: document_type IN OUT NOCOPY VARCHAR2)
16190: IS
16191:
16192: NL VARCHAR2(1) := fnd_global.newline;
16193: l_document VARCHAR2(32000) := '';
16194: l_disp_type VARCHAR2(20) := 'text/plain';
16195: l_item_type wf_items.item_type%TYPE;
16196: l_item_key wf_items.item_key%TYPE;

Line 16341: NL VARCHAR2(1) := fnd_global.newline;

16337: document IN OUT NOCOPY CLOB,
16338: document_type IN OUT NOCOPY VARCHAR2)
16339: IS
16340:
16341: NL VARCHAR2(1) := fnd_global.newline;
16342: l_document VARCHAR2(32000) := '';
16343: l_disp_type VARCHAR2(20) := 'text/plain';
16344: l_item_type wf_items.item_type%TYPE;
16345: l_item_key wf_items.item_key%TYPE;

Line 16580: NL VARCHAR2(1) := fnd_global.newline;

16576: document IN OUT NOCOPY CLOB,
16577: document_type IN OUT NOCOPY VARCHAR2)
16578: IS
16579:
16580: NL VARCHAR2(1) := fnd_global.newline;
16581: l_document VARCHAR2(32000) := '';
16582: l_disp_type VARCHAR2(20) := 'text/plain';
16583: l_item_type wf_items.item_type%TYPE;
16584: l_item_key wf_items.item_key%TYPE;

Line 16764: NL VARCHAR2(1) := fnd_global.newline;

16760: document IN OUT NOCOPY CLOB,
16761: document_type IN OUT NOCOPY VARCHAR2)
16762: IS
16763:
16764: NL VARCHAR2(1) := fnd_global.newline;
16765: l_document VARCHAR2(32000) := '';
16766: l_disp_type VARCHAR2(20) := 'text/plain';
16767: l_item_type wf_items.item_type%TYPE;
16768: l_item_key wf_items.item_key%TYPE;

Line 16963: NL VARCHAR2(1) := fnd_global.newline;

16959: document IN OUT NOCOPY CLOB,
16960: document_type IN OUT NOCOPY VARCHAR2)
16961: IS
16962:
16963: NL VARCHAR2(1) := fnd_global.newline;
16964: l_document VARCHAR2(32000) := '';
16965: l_disp_type VARCHAR2(20) := 'text/plain';
16966: l_item_type wf_items.item_type%TYPE;
16967: l_item_key wf_items.item_key%TYPE;

Line 17145: NL VARCHAR2(1) := fnd_global.newline;

17141: document IN OUT NOCOPY CLOB,
17142: document_type IN OUT NOCOPY VARCHAR2)
17143: IS
17144:
17145: NL VARCHAR2(1) := fnd_global.newline;
17146: l_document VARCHAR2(32000) := '';
17147: l_disp_type VARCHAR2(20) := 'text/plain';
17148: l_item_type wf_items.item_type%TYPE;
17149: l_item_key wf_items.item_key%TYPE;

Line 17546: X_created_by => fnd_global.user_id,

17542: X_from_pk1_value => p_auction_header_id,
17543: X_from_pk2_value => bid.bid_number,
17544: X_to_entity_name => 'PO_VENDORS',
17545: X_to_pk1_value => bid.vendor_id,
17546: X_created_by => fnd_global.user_id,
17547: X_last_update_login => fnd_global.login_id);
17548:
17549: END LOOP;
17550:

Line 17547: X_last_update_login => fnd_global.login_id);

17543: X_from_pk2_value => bid.bid_number,
17544: X_to_entity_name => 'PO_VENDORS',
17545: X_to_pk1_value => bid.vendor_id,
17546: X_created_by => fnd_global.user_id,
17547: X_last_update_login => fnd_global.login_id);
17548:
17549: END LOOP;
17550:
17551: END IF;

Line 17634: l_document := l_document || fnd_global.newline || fnd_global.newline ||

17630: fnd_message.set_token('PREPARER_TP_NAME', l_auction_owner_tp_name);
17631: fnd_message.set_token('ISP_NEW_SUPPLIER_REG_URL', l_isp_new_supplier_reg_url);
17632: fnd_message.set_token('AUCTION_END_DATE', l_auction_end_date_format);
17633: fnd_message.set_token('TP_TIME_ZONE', l_timezone_disp);
17634: l_document := l_document || fnd_global.newline || fnd_global.newline ||
17635: fnd_message.get;
17636: WF_NOTIFICATION.WriteToClob(document, l_document);
17637: ELSE
17638: fnd_message.set_name('PON','PON_SM_REQ_SUPP_AMEND_TB');

Line 17645: l_document := l_document || fnd_global.newline || fnd_global.newline ||

17641: fnd_message.set_token('PREPARER_TP_NAME', l_auction_owner_tp_name);
17642: fnd_message.set_token('ISP_NEW_SUPPLIER_REG_URL', l_isp_new_supplier_reg_url);
17643: fnd_message.set_token('AUCTION_END_DATE', l_auction_end_date_format);
17644: fnd_message.set_token('TP_TIME_ZONE', l_timezone_disp);
17645: l_document := l_document || fnd_global.newline || fnd_global.newline ||
17646: fnd_message.get;
17647: WF_NOTIFICATION.WriteToClob(document, l_document);
17648: END IF;
17649:

Line 17715: l_document := l_document || fnd_global.newline || fnd_global.newline ||

17711: fnd_message.set_token('PREPARER_TP_NAME', l_auction_owner_tp_name);
17712: fnd_message.set_token('ISP_NEW_SUPPLIER_REG_URL', l_isp_new_supplier_reg_url);
17713: fnd_message.set_token('AUCTION_END_DATE', l_auction_end_date_format);
17714: fnd_message.set_token('TP_TIME_ZONE', l_timezone_disp);
17715: l_document := l_document || fnd_global.newline || fnd_global.newline ||
17716: fnd_message.get;
17717: WF_NOTIFICATION.WriteToClob(document, l_document);
17718: ELSE
17719: fnd_message.set_name('PON','PON_SM_INV_REQ_SUPP_NEWRND_TB');

Line 17726: l_document := l_document || fnd_global.newline || fnd_global.newline ||

17722: fnd_message.set_token('PREPARER_TP_NAME', l_auction_owner_tp_name);
17723: fnd_message.set_token('ISP_NEW_SUPPLIER_REG_URL', l_isp_new_supplier_reg_url);
17724: fnd_message.set_token('AUCTION_END_DATE', l_auction_end_date_format);
17725: fnd_message.set_token('TP_TIME_ZONE', l_timezone_disp);
17726: l_document := l_document || fnd_global.newline || fnd_global.newline ||
17727: fnd_message.get;
17728: WF_NOTIFICATION.WriteToClob(document, l_document);
17729: END IF;
17730:

Line 17809: SYSDATE, FND_GLOBAL.USER_ID, SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.LOGIN_ID);

17805: BEGIN
17806: INSERT INTO pon_backing_requisitions(auction_header_id, line_number, requisition_header_id, requisition_line_id, requisition_number,
17807: creation_date, created_by, last_update_date, last_updated_by, last_update_login)
17808: VALUES (p_auction_header_id, p_auction_line_number(i), l_req_header_id, p_requisition_line_id(j), l_req_number,
17809: SYSDATE, FND_GLOBAL.USER_ID, SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.LOGIN_ID);
17810:
17811: l_no_of_rows_inserted := l_no_of_rows_inserted + sql%rowcount; --counting the no. of rows inserted
17812:
17813: IF (fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN