DBA Data[Home] [Help]

APPS.PON_AUCTION_PKG dependencies on WF_CORE

Line 444: x_staggered_close_note := wf_core.newline || wf_core.newline ||

440:
441: BEGIN
442: x_staggered_close_note := NULL;
443: IF x_staggered_closing_interval IS NOT NULL THEN
444: x_staggered_close_note := wf_core.newline || wf_core.newline ||
445: getMessage('PON_STAGGERED_CLOSE_NOTIF_MSG') ||
446: wf_core.newline || wf_core.newline;
447: END IF;
448: wf_engine.SetItemAttrText( itemtype => x_itemtype,

Line 446: wf_core.newline || wf_core.newline;

442: x_staggered_close_note := NULL;
443: IF x_staggered_closing_interval IS NOT NULL THEN
444: x_staggered_close_note := wf_core.newline || wf_core.newline ||
445: getMessage('PON_STAGGERED_CLOSE_NOTIF_MSG') ||
446: wf_core.newline || wf_core.newline;
447: END IF;
448: wf_engine.SetItemAttrText( itemtype => x_itemtype,
449: itemkey => x_itemkey,
450: aname => 'STAGGERED_CLOSE_NOTE',

Line 1767: x_staggered_close_note := wf_core.newline || wf_core.newline ||

1763:
1764: BEGIN
1765: x_staggered_close_note := NULL;
1766: IF x_staggered_closing_interval IS NOT NULL THEN
1767: x_staggered_close_note := wf_core.newline || wf_core.newline ||
1768: getMessage('PON_STAGGERED_CLOSE_NOTIF_MSG') ||
1769: wf_core.newline || wf_core.newline;
1770: END IF;
1771: wf_engine.SetItemAttrText( itemtype => x_itemtype,

Line 1769: wf_core.newline || wf_core.newline;

1765: x_staggered_close_note := NULL;
1766: IF x_staggered_closing_interval IS NOT NULL THEN
1767: x_staggered_close_note := wf_core.newline || wf_core.newline ||
1768: getMessage('PON_STAGGERED_CLOSE_NOTIF_MSG') ||
1769: wf_core.newline || wf_core.newline;
1770: END IF;
1771: wf_engine.SetItemAttrText( itemtype => x_itemtype,
1772: itemkey => x_itemkey,
1773: aname => 'STAGGERED_CLOSE_NOTE',

Line 2334: x_staggered_close_note := wf_core.newline || wf_core.newline ||

2330:
2331: BEGIN
2332: x_staggered_close_note := NULL;
2333: IF x_staggered_closing_interval IS NOT NULL THEN
2334: x_staggered_close_note := wf_core.newline || wf_core.newline ||
2335: getMessage('PON_STAGGERED_CLOSE_NOTIF_MSG') ||
2336: wf_core.newline || wf_core.newline;
2337: END IF;
2338: wf_engine.SetItemAttrText( itemtype => x_itemtype,

Line 2336: wf_core.newline || wf_core.newline;

2332: x_staggered_close_note := NULL;
2333: IF x_staggered_closing_interval IS NOT NULL THEN
2334: x_staggered_close_note := wf_core.newline || wf_core.newline ||
2335: getMessage('PON_STAGGERED_CLOSE_NOTIF_MSG') ||
2336: wf_core.newline || wf_core.newline;
2337: END IF;
2338: wf_engine.SetItemAttrText( itemtype => x_itemtype,
2339: itemkey => x_itemkey,
2340: aname => 'STAGGERED_CLOSE_NOTE',

Line 2915: x_staggered_close_note := wf_core.newline || wf_core.newline ||

2911:
2912: -- Set the staggered closing attribute
2913: x_staggered_close_note := NULL;
2914: IF p_staggered_closing_interval IS NOT NULL THEN
2915: x_staggered_close_note := wf_core.newline || wf_core.newline ||
2916: getMessage('PON_STAGGERED_CLOSE_NOTIF_MSG') ||
2917: wf_core.newline || wf_core.newline;
2918: END IF;
2919: wf_Notification.setAttrText(x_nid, 'STAGGERED_CLOSE_NOTE', x_staggered_close_note);

Line 2917: wf_core.newline || wf_core.newline;

2913: x_staggered_close_note := NULL;
2914: IF p_staggered_closing_interval IS NOT NULL THEN
2915: x_staggered_close_note := wf_core.newline || wf_core.newline ||
2916: getMessage('PON_STAGGERED_CLOSE_NOTIF_MSG') ||
2917: wf_core.newline || wf_core.newline;
2918: END IF;
2919: wf_Notification.setAttrText(x_nid, 'STAGGERED_CLOSE_NOTE', x_staggered_close_note);
2920:
2921: BEGIN

Line 3386: x_staggered_close_note := wf_core.newline || wf_core.newline ||

3382:
3383: BEGIN
3384: x_staggered_close_note := NULL;
3385: IF x_staggered_closing_interval IS NOT NULL THEN
3386: x_staggered_close_note := wf_core.newline || wf_core.newline ||
3387: getMessage('PON_STAGGERED_CLOSE_NOTIF_MSG') ||
3388: wf_core.newline || wf_core.newline;
3389: END IF;
3390: wf_engine.SetItemAttrText( itemtype => x_itemtype,

Line 3388: wf_core.newline || wf_core.newline;

3384: x_staggered_close_note := NULL;
3385: IF x_staggered_closing_interval IS NOT NULL THEN
3386: x_staggered_close_note := wf_core.newline || wf_core.newline ||
3387: getMessage('PON_STAGGERED_CLOSE_NOTIF_MSG') ||
3388: wf_core.newline || wf_core.newline;
3389: END IF;
3390: wf_engine.SetItemAttrText( itemtype => x_itemtype,
3391: itemkey => x_itemkey,
3392: aname => 'STAGGERED_CLOSE_NOTE',

Line 6848: x_staggered_close_note := wf_core.newline || wf_core.newline ||

6844:
6845: BEGIN
6846: x_staggered_close_note := NULL;
6847: IF x_staggered_closing_interval IS NOT NULL THEN
6848: x_staggered_close_note := wf_core.newline || wf_core.newline ||
6849: getMessage('PON_STAGGERED_CLOSE_NOTIF_MSG') ||
6850: wf_core.newline || wf_core.newline;
6851: END IF;
6852: wf_engine.SetItemAttrText( itemtype => t_itemtype,

Line 6850: wf_core.newline || wf_core.newline;

6846: x_staggered_close_note := NULL;
6847: IF x_staggered_closing_interval IS NOT NULL THEN
6848: x_staggered_close_note := wf_core.newline || wf_core.newline ||
6849: getMessage('PON_STAGGERED_CLOSE_NOTIF_MSG') ||
6850: wf_core.newline || wf_core.newline;
6851: END IF;
6852: wf_engine.SetItemAttrText( itemtype => t_itemtype,
6853: itemkey => t_itemkey,
6854: aname => 'STAGGERED_CLOSE_NOTE',

Line 11568: WF_CORE.CONTEXT ('PONAUCT','SEND_MSG_SENT_NOTIF','Process:'||l_progress||'SQL error:' || sqlcode|| ', error message:' ||substr(sqlerrm,1,512));

11564: x_return_status := FND_API.G_RET_STS_SUCCESS;
11565:
11566: EXCEPTION
11567: WHEN OTHERS THEN
11568: WF_CORE.CONTEXT ('PONAUCT','SEND_MSG_SENT_NOTIF','Process:'||l_progress||'SQL error:' || sqlcode|| ', error message:' ||substr(sqlerrm,1,512));
11569: RAISE;
11570:
11571: END SEND_MSG_SENT_NOTIF; -- }
11572:

Line 11963: l_staggered_close_note := wf_core.newline || wf_core.newline ||

11959: l_staggered_close_note := NULL;
11960: IF (p_notif_performer IS NOT NULL AND
11961: p_notif_performer = 'SUPPLIER' AND
11962: p_stagger_closing_interval IS NOT NULL ) THEN
11963: l_staggered_close_note := wf_core.newline || wf_core.newline ||
11964: getMessage('PON_STAGGERED_CLOSE_NOTIF_MSG') ||
11965: wf_core.newline || wf_core.newline;
11966:
11967: END IF;

Line 11965: wf_core.newline || wf_core.newline;

11961: p_notif_performer = 'SUPPLIER' AND
11962: p_stagger_closing_interval IS NOT NULL ) THEN
11963: l_staggered_close_note := wf_core.newline || wf_core.newline ||
11964: getMessage('PON_STAGGERED_CLOSE_NOTIF_MSG') ||
11965: wf_core.newline || wf_core.newline;
11966:
11967: END IF;
11968:
11969:

Line 12124: WF_CORE.CONTEXT ('PONAUCT','NOTIFY_MEMBER','Progress:'|| l_progress ||', SQL error:' || sqlcode|| ', error message:' ||substr(sqlerrm,1,512));

12120: END IF;
12121:
12122: EXCEPTION
12123: WHEN OTHERS THEN
12124: WF_CORE.CONTEXT ('PONAUCT','NOTIFY_MEMBER','Progress:'|| l_progress ||', SQL error:' || sqlcode|| ', error message:' ||substr(sqlerrm,1,512));
12125: RAISE;
12126: --}
12127: END NOTIFY_MEMBER;
12128: