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_CREATE_PO_PKG dependencies on PON_AUCTION_PKG

Line 152: PON_AUCTION_PKG.SET_SESSION_LANGUAGE(null, x_language_code);

148: -- return the correct message in user's language
149:
150: PON_PROFILE_UTIL_PKG.GET_WF_LANGUAGE(p_user_name, x_language_code);
151:
152: PON_AUCTION_PKG.SET_SESSION_LANGUAGE(null, x_language_code);
153:
154: if(l_debug_enabled = 'Y') then
155: x_progress := ++l_progress || l_api_name || ' : after retrieving language code, etc';
156: log_message(x_progress);

Line 244: x_allocation_error := PON_AUCTION_PKG.getMessage('PON_AUC_WF_SPLIT_ERROR') || ' - ' || x_split_failure_reason;

240: -- setting failure reason and item line and req line on which
241: -- split failure occurred
242: -- assigning error to x_allocation_error variable to be accessed
243: -- after rollback to savepoint PON_BEFORE_AUTO_ALLOC
244: x_allocation_error := PON_AUCTION_PKG.getMessage('PON_AUC_WF_SPLIT_ERROR') || ' - ' || x_split_failure_reason;
245:
246: if(l_debug_enabled = 'Y') then
247: x_progress := ++l_progress || l_api_name || ' : alloc_error reported is '
248: || x_allocation_error;

Line 271: PON_AUCTION_PKG.cancel_negotiation_ref(p_auction_header_id, x_return_code);

267: x_progress := ++l_progress || l_api_name || ' : invoking cancel_negotiation_ref for auction ' || p_auction_header_id;
268: log_message(x_progress);
269: end if;
270:
271: PON_AUCTION_PKG.cancel_negotiation_ref(p_auction_header_id, x_return_code);
272: IF (x_return_code = 'SUCCESS') THEN
273:
274: if(l_debug_enabled = 'Y') then
275: x_progress := ++l_progress || l_api_name || ' : successful cancel_negotiation_ref for auction ' || p_auction_header_id;

Line 288: x_allocation_error := PON_AUCTION_PKG.getMessage('PON_AUC_WF_ALLOC_ERROR');

284: end if;
285:
286: x_failure_status := 'FAILURE';
287: -- assigning error to x_allocation_error variable to be accessed
288: x_allocation_error := PON_AUCTION_PKG.getMessage('PON_AUC_WF_ALLOC_ERROR');
289:
290: END IF;
291: END IF;
292: END IF;

Line 321: PON_AUCTION_PKG.UNSET_SESSION_LANGUAGE;

317: end if;
318:
319: END IF;
320:
321: PON_AUCTION_PKG.UNSET_SESSION_LANGUAGE;
322:
323: if(l_debug_enabled = 'Y') then
324: x_progress := ++l_progress || l_api_name || ' : END' ;
325: log_message(x_progress);

Line 343: x_allocation_error := PON_AUCTION_PKG.getMessage('PON_AUC_WF_SYS_ERROR') || ' - ' || substrb(SQLERRM, 1, 500);

339: x_progress := ++l_progress || l_api_name || ' : set output to failure for auction ' || p_auction_header_id;
340: log_error(x_progress);
341: end if;
342:
343: x_allocation_error := PON_AUCTION_PKG.getMessage('PON_AUC_WF_SYS_ERROR') || ' - ' || substrb(SQLERRM, 1, 500);
344:
345: if(l_exception_enabled = 'Y') then
346: x_progress := ++l_progress || l_api_name || ' : for auction ' || p_auction_header_id || ' error:: ' || x_allocation_error;
347: log_error(x_progress);

Line 502: p_failure_reason := PON_AUCTION_PKG.getMessage('PON_AUC_WF_SYS_ERROR') || ' - ' || SUBSTRB(SQLERRM, 1, 500) || PON_AUCTION_PKG.getMessage('PON_LINE_INFO_NOT_AVAIL');

498: end if;
499:
500:
501: IF p_item_line_number IS NULL THEN -- -- it means the exception was thrown before line information is selected
502: p_failure_reason := PON_AUCTION_PKG.getMessage('PON_AUC_WF_SYS_ERROR') || ' - ' || SUBSTRB(SQLERRM, 1, 500) || PON_AUCTION_PKG.getMessage('PON_LINE_INFO_NOT_AVAIL');
503: ELSE
504: p_failure_reason := PON_AUCTION_PKG.getMessage('PON_AUC_WF_SYS_ERROR') || ' - ' || SUBSTRB(SQLERRM, 1, 500);
505: END IF;
506:

Line 504: p_failure_reason := PON_AUCTION_PKG.getMessage('PON_AUC_WF_SYS_ERROR') || ' - ' || SUBSTRB(SQLERRM, 1, 500);

500:
501: IF p_item_line_number IS NULL THEN -- -- it means the exception was thrown before line information is selected
502: p_failure_reason := PON_AUCTION_PKG.getMessage('PON_AUC_WF_SYS_ERROR') || ' - ' || SUBSTRB(SQLERRM, 1, 500) || PON_AUCTION_PKG.getMessage('PON_LINE_INFO_NOT_AVAIL');
503: ELSE
504: p_failure_reason := PON_AUCTION_PKG.getMessage('PON_AUC_WF_SYS_ERROR') || ' - ' || SUBSTRB(SQLERRM, 1, 500);
505: END IF;
506:
507: if(l_exception_enabled = 'Y') then
508: x_progress := ++l_progress || l_api_name || ' :EXCEPTION :' || p_failure_reason;

Line 650: p_split_failure_reason := PON_AUCTION_PKG.getMessage('PON_AUC_WF_SPLIT_ERROR') || ' - ' || PON_AUCTION_PKG.getMessage('PON_AUC_CANNOT_GET_LOCK') || PON_AUCTION_PKG.getMessage('PON_LINE_INFO_NOT_AVAIL');

646: EXIT;
647: EXCEPTION
648: WHEN lock_not_acquired THEN
649: IF l_index >= 20 THEN
650: p_split_failure_reason := PON_AUCTION_PKG.getMessage('PON_AUC_WF_SPLIT_ERROR') || ' - ' || PON_AUCTION_PKG.getMessage('PON_AUC_CANNOT_GET_LOCK') || PON_AUCTION_PKG.getMessage('PON_LINE_INFO_NOT_AVAIL');
651: p_split_result := 'FAILURE';
652:
653: RETURN;
654: END IF;

Line 669: p_split_failure_reason := PON_AUCTION_PKG.getMessage('PON_AUC_WF_SPLIT_ERROR') || ' - ' || PON_AUCTION_PKG.getMessage('PON_AUC_WF_REQ_RESCHEDULED');

665: EXIT WHEN reqRescheduledMultSupplier%NOTFOUND;
666:
667: p_split_result := 'FAILURE';
668: --p_split_failed_req := l_orig_req_line;
669: p_split_failure_reason := PON_AUCTION_PKG.getMessage('PON_AUC_WF_SPLIT_ERROR') || ' - ' || PON_AUCTION_PKG.getMessage('PON_AUC_WF_REQ_RESCHEDULED');
670:
671: -- Fetch the line_number, item_number, item_revision, item_description,
672: -- requisition_number and job_name values for a given line_number.
673: OPEN wf_item_cur (p_auction_header_id, l_orig_req_line);

Line 818: p_split_failure_reason := PON_AUCTION_PKG.getMessage('PON_UNEXPECTED_ERROR') || ': ' || p_split_failure_reason;

814:
815: -- if unexpected error, append the text 'Unexpected System Error' to
816: -- error message
817: IF (p_split_result = FND_API.G_RET_STS_UNEXP_ERROR) THEN
818: p_split_failure_reason := PON_AUCTION_PKG.getMessage('PON_UNEXPECTED_ERROR') || ': ' || p_split_failure_reason;
819: END IF;
820:
821: p_split_result := 'FAILURE';
822:

Line 854: p_split_failure_reason := PON_AUCTION_PKG.getMessage('PON_AUC_WF_SYS_ERROR') || ' - ' || SUBSTRB(SQLERRM, 1, 500) || PON_AUCTION_PKG.getMessage('PON_LINE_INFO_NOT_AVAIL');

850: end if;
851:
852:
853: IF p_item_line_number IS NULL THEN -- -- it means the exception was thrown before line information is selected
854: p_split_failure_reason := PON_AUCTION_PKG.getMessage('PON_AUC_WF_SYS_ERROR') || ' - ' || SUBSTRB(SQLERRM, 1, 500) || PON_AUCTION_PKG.getMessage('PON_LINE_INFO_NOT_AVAIL');
855: ELSE
856: p_split_failure_reason := PON_AUCTION_PKG.getMessage('PON_AUC_WF_SYS_ERROR') || ' - ' || SUBSTRB(SQLERRM, 1, 500);
857: END IF;
858:

Line 856: p_split_failure_reason := PON_AUCTION_PKG.getMessage('PON_AUC_WF_SYS_ERROR') || ' - ' || SUBSTRB(SQLERRM, 1, 500);

852:
853: IF p_item_line_number IS NULL THEN -- -- it means the exception was thrown before line information is selected
854: p_split_failure_reason := PON_AUCTION_PKG.getMessage('PON_AUC_WF_SYS_ERROR') || ' - ' || SUBSTRB(SQLERRM, 1, 500) || PON_AUCTION_PKG.getMessage('PON_LINE_INFO_NOT_AVAIL');
855: ELSE
856: p_split_failure_reason := PON_AUCTION_PKG.getMessage('PON_AUC_WF_SYS_ERROR') || ' - ' || SUBSTRB(SQLERRM, 1, 500);
857: END IF;
858:
859: if(l_exception_enabled = 'Y') then
860: x_progress := ++l_progress || l_api_name || ' : EXCEPTION with reason :' || p_split_failure_reason;

Line 1113: p_error_message := PON_AUCTION_PKG.getMessage('PON_AUC_WF_SYS_ERROR') || ' - ' || SUBSTRB(SQLERRM, 1, 500);

1109:
1110: EXCEPTION
1111: WHEN OTHERS THEN
1112: p_result := 'FAILURE';
1113: p_error_message := PON_AUCTION_PKG.getMessage('PON_AUC_WF_SYS_ERROR') || ' - ' || SUBSTRB(SQLERRM, 1, 500);
1114: log_message(x_progress);
1115: END Auto_Req_Allocation;
1116:
1117:

Line 1223: PON_AUCTION_PKG.SET_SESSION_LANGUAGE(null, x_language_code);

1219: x_progress := '20: START_PO_WORKFLOW: Just after CreateProcess';
1220:
1221: log_message(x_itemtype || ' ' || x_progress);
1222:
1223: PON_AUCTION_PKG.SET_SESSION_LANGUAGE(null, x_language_code);
1224:
1225:
1226:
1227: wf_engine.SetItemAttrDate (itemtype => x_itemtype,

Line 1253: x_oex_timezone := pon_auction_pkg.Get_Oex_Time_Zone;

1249: --
1250: -- Get the exchange's time zone
1251: --
1252:
1253: x_oex_timezone := pon_auction_pkg.Get_Oex_Time_Zone;
1254:
1255: --
1256: -- Get the user's time zone
1257: --

Line 1258: x_timezone := pon_auction_pkg.Get_Time_Zone(p_trading_partner_contact_id);

1254:
1255: --
1256: -- Get the user's time zone
1257: --
1258: x_timezone := pon_auction_pkg.Get_Time_Zone(p_trading_partner_contact_id);
1259:
1260: --
1261: -- Make sure that it is a valid time zone
1262: --

Line 1276: x_timezone_disp:= pon_auction_pkg.Get_TimeZone_Description(x_timezone, x_language_code);

1272: x_newstarttime := PON_OEX_TIMEZONE_PKG.CONVERT_TIME(p_open_bidding_date,x_oex_timezone,x_timezone);
1273: x_newendtime := PON_OEX_TIMEZONE_PKG.CONVERT_TIME(p_close_bidding_date,x_oex_timezone,x_timezone);
1274: x_newpreviewtime := PON_OEX_TIMEZONE_PKG.CONVERT_TIME(p_preview_date,x_oex_timezone,x_timezone);
1275:
1276: x_timezone_disp:= pon_auction_pkg.Get_TimeZone_Description(x_timezone, x_language_code);
1277:
1278: wf_engine.SetItemAttrText (itemtype => x_itemtype,
1279: itemkey => x_itemkey,
1280: aname => 'TP_TIME_ZONE',

Line 1313: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_PREVIEW_DATE_NOTSPEC',x_msg_suffix));

1309:
1310: wf_engine.SetItemAttrText (itemtype => x_itemtype,
1311: itemkey => x_itemkey,
1312: aname => 'PREVIEW_DATE_NOTSPECIFIED',
1313: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_PREVIEW_DATE_NOTSPEC',x_msg_suffix));
1314: ELSE
1315: wf_engine.SetItemAttrDate (itemtype => x_itemtype,
1316: itemkey => x_itemkey,
1317: aname => 'PREVIEW_DATE_TZ',

Line 1357: avalue => PON_AUCTION_PKG.replaceHtmlChars(p_auction_title));

1353:
1354: wf_engine.SetItemAttrText (itemtype => x_itemtype,
1355: itemkey => x_itemkey,
1356: aname => 'AUCTION_TITLE',
1357: avalue => PON_AUCTION_PKG.replaceHtmlChars(p_auction_title));
1358:
1359: wf_engine.SetItemAttrText (itemtype => x_itemtype,
1360: itemkey => x_itemkey,
1361: aname => 'HAS_ITEMS_FLAG',

Line 1454: x_msg_suffix := PON_AUCTION_PKG.GET_MESSAGE_SUFFIX (x_doctype_group_name);

1450: FROM pon_auction_headers_all auh, pon_auc_doctypes dt
1451: WHERE auh.auction_header_id = p_auction_header_id and
1452: auh.doctype_id = dt.doctype_id;
1453:
1454: x_msg_suffix := PON_AUCTION_PKG.GET_MESSAGE_SUFFIX (x_doctype_group_name);
1455:
1456: IF (x_contract_type = 'STANDARD') THEN
1457: x_purchase_order := 'Standard Purchase Order';
1458: x_purchase_orders := 'Standard Purchase Orders';

Line 1462: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_WF_PO_CREATE_SUBJ', x_msg_suffix, 'DOC_NUMBER', x_doc_number_dsp));

1458: x_purchase_orders := 'Standard Purchase Orders';
1459: wf_engine.SetItemAttrText (itemtype => x_itemtype,
1460: itemkey => x_itemkey,
1461: aname => 'PON_AUC_WF_PO_CREATE_SUBJ',
1462: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_WF_PO_CREATE_SUBJ', x_msg_suffix, 'DOC_NUMBER', x_doc_number_dsp));
1463: ELSIF (x_contract_type = 'BLANKET') THEN
1464: x_purchase_order := 'Blanket Purchase Agreement';
1465: x_purchase_orders := 'Blanket Purchase Agreements';
1466: wf_engine.SetItemAttrText (itemtype => x_itemtype,

Line 1469: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_WF_BL_CREATE_SUBJ', x_msg_suffix, 'DOC_NUMBER', x_doc_number_dsp));

1465: x_purchase_orders := 'Blanket Purchase Agreements';
1466: wf_engine.SetItemAttrText (itemtype => x_itemtype,
1467: itemkey => x_itemkey,
1468: aname => 'PON_AUC_WF_PO_CREATE_SUBJ',
1469: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_WF_BL_CREATE_SUBJ', x_msg_suffix, 'DOC_NUMBER', x_doc_number_dsp));
1470: ELSIF (x_contract_type = 'CONTRACT') THEN
1471: x_purchase_order := 'Contract Purchase Agreement';
1472: x_purchase_orders := 'Contract Purchase Agreements';
1473: wf_engine.SetItemAttrText (itemtype => x_itemtype,

Line 1476: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_WF_CPA_CREATE_SUBJ', x_msg_suffix, 'DOC_NUMBER', x_doc_number_dsp));

1472: x_purchase_orders := 'Contract Purchase Agreements';
1473: wf_engine.SetItemAttrText (itemtype => x_itemtype,
1474: itemkey => x_itemkey,
1475: aname => 'PON_AUC_WF_PO_CREATE_SUBJ',
1476: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_WF_CPA_CREATE_SUBJ', x_msg_suffix, 'DOC_NUMBER', x_doc_number_dsp));
1477:
1478: END IF;
1479:
1480: wf_engine.SetItemAttrText (itemtype => x_itemtype,

Line 1516: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_WF_ORG'));

1512:
1513: wf_engine.SetItemAttrText (itemtype => x_itemtype,
1514: itemkey => x_itemkey,
1515: aname => 'PON_AUC_WF_ORG',
1516: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_WF_ORG'));
1517:
1518: wf_engine.SetItemAttrText (itemtype => x_itemtype,
1519: itemkey => x_itemkey,
1520: aname => 'PON_AUC_WF_SUCC_MESSAGE',

Line 1521: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_WF_SUCC_MESSAGE'));

1517:
1518: wf_engine.SetItemAttrText (itemtype => x_itemtype,
1519: itemkey => x_itemkey,
1520: aname => 'PON_AUC_WF_SUCC_MESSAGE',
1521: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_WF_SUCC_MESSAGE'));
1522:
1523: wf_engine.SetItemAttrText (itemtype => x_itemtype,
1524: itemkey => x_itemkey,
1525: aname => 'PON_AUC_WF_RESTART_WF_MSG',

Line 1526: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_WF_RESTART_WF_MSG', x_msg_suffix));

1522:
1523: wf_engine.SetItemAttrText (itemtype => x_itemtype,
1524: itemkey => x_itemkey,
1525: aname => 'PON_AUC_WF_RESTART_WF_MSG',
1526: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_WF_RESTART_WF_MSG', x_msg_suffix));
1527:
1528: wf_engine.SetItemAttrText (itemtype => x_itemtype,
1529: itemkey => x_itemkey,
1530: aname => 'PON_AUC_WF_RESTART_MSG',

Line 1531: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_WF_RESTART_MSG', x_msg_suffix));

1527:
1528: wf_engine.SetItemAttrText (itemtype => x_itemtype,
1529: itemkey => x_itemkey,
1530: aname => 'PON_AUC_WF_RESTART_MSG',
1531: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_WF_RESTART_MSG', x_msg_suffix));
1532:
1533: wf_engine.SetItemAttrText (itemtype => x_itemtype,
1534: itemkey => x_itemkey,
1535: aname => 'PON_AUC_WF_ALLOC_SUBJ',

Line 1536: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_WF_ALLOC_SUBJ', x_msg_suffix,

1532:
1533: wf_engine.SetItemAttrText (itemtype => x_itemtype,
1534: itemkey => x_itemkey,
1535: aname => 'PON_AUC_WF_ALLOC_SUBJ',
1536: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_WF_ALLOC_SUBJ', x_msg_suffix,
1537: 'PURCHASE_ORDERS', x_purchase_order,
1538: 'DOC_NUMBER', x_doc_number_dsp));
1539:
1540: --check if the negotiation has requistion based line

Line 1575: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_WF_SYS_ERROR') || ' - ' || substrb(SQLERRM, 1, 500));

1571:
1572: wf_engine.SetItemAttrText (itemtype => x_itemtype,
1573: itemkey => x_itemkey,
1574: aname => 'ALLOC_ERROR',
1575: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_WF_SYS_ERROR') || ' - ' || substrb(SQLERRM, 1, 500));
1576:
1577: IF x_line_number IS NULL THEN
1578:
1579: -- it means the exception was thrown before line information is selected

Line 1585: avalue => PON_AUCTION_PKG.getMessage('PON_LINE_INFO_NOT_AVAIL'));

1581:
1582: wf_engine.SetItemAttrText (itemtype => x_itemtype,
1583: itemkey => x_itemkey,
1584: aname => 'LINE_NUMBER',
1585: avalue => PON_AUCTION_PKG.getMessage('PON_LINE_INFO_NOT_AVAIL'));
1586: ELSE
1587: wf_engine.SetItemAttrText (itemtype => x_itemtype,
1588: itemkey => x_itemkey,
1589: aname => 'LINE_NUMBER',

Line 1638: PON_AUCTION_PKG.UNSET_SESSION_LANGUAGE;

1634: wf_engine.StartProcess(itemtype => x_itemtype,
1635: itemkey => x_itemkey );
1636:
1637:
1638: PON_AUCTION_PKG.UNSET_SESSION_LANGUAGE;
1639:
1640: END START_PO_WORKFLOW;
1641:
1642: /*

Line 3550: PON_AUCTION_PKG.SET_SESSION_LANGUAGE(null, x_language_code);

3546:
3547:
3548: PON_PROFILE_UTIL_PKG.GET_WF_LANGUAGE(p_user_name, x_language_code);
3549:
3550: PON_AUCTION_PKG.SET_SESSION_LANGUAGE(null, x_language_code);
3551: OPEN awardedBids;
3552: x_progress := '40: GENERATE_POS: Going through the awarded bids';
3553:
3554: log_message(x_progress);

Line 3835: PON_AUCTION_PKG.UNSET_SESSION_LANGUAGE;

3831: END LOOP;
3832:
3833: CLOSE awardedBids;
3834:
3835: PON_AUCTION_PKG.UNSET_SESSION_LANGUAGE;
3836:
3837: EXCEPTION
3838:
3839: when others then

Line 4209: PON_AUCTION_PKG.SET_SESSION_LANGUAGE(null, x_language_code);

4205: FROM pon_auction_headers_all
4206: WHERE auction_header_id = x_auction_header_id;
4207:
4208: PON_PROFILE_UTIL_PKG.GET_WF_LANGUAGE(x_user_name, x_language_code);
4209: PON_AUCTION_PKG.SET_SESSION_LANGUAGE(null, x_language_code);
4210: IF (x_contract_type = 'STANDARD') THEN
4211: x_purchase_orders := 'Standard Purchase Order';
4212: msgNumCreated := PON_AUCTION_PKG.getMessage('PON_AUC_WF_NUM_OF_SUCC_PO');
4213: msgPOdetails := PON_AUCTION_PKG.getMessage('PON_AUC_WF_PO_DETAILS');

Line 4212: msgNumCreated := PON_AUCTION_PKG.getMessage('PON_AUC_WF_NUM_OF_SUCC_PO');

4208: PON_PROFILE_UTIL_PKG.GET_WF_LANGUAGE(x_user_name, x_language_code);
4209: PON_AUCTION_PKG.SET_SESSION_LANGUAGE(null, x_language_code);
4210: IF (x_contract_type = 'STANDARD') THEN
4211: x_purchase_orders := 'Standard Purchase Order';
4212: msgNumCreated := PON_AUCTION_PKG.getMessage('PON_AUC_WF_NUM_OF_SUCC_PO');
4213: msgPOdetails := PON_AUCTION_PKG.getMessage('PON_AUC_WF_PO_DETAILS');
4214: ELSIF (x_contract_type = 'BLANKET') THEN
4215: x_purchase_orders := 'Blanket Purchase Agreement';
4216: msgNumCreated := PON_AUCTION_PKG.getMessage('PON_AUC_WF_NUM_OF_SUCC_BL');

Line 4213: msgPOdetails := PON_AUCTION_PKG.getMessage('PON_AUC_WF_PO_DETAILS');

4209: PON_AUCTION_PKG.SET_SESSION_LANGUAGE(null, x_language_code);
4210: IF (x_contract_type = 'STANDARD') THEN
4211: x_purchase_orders := 'Standard Purchase Order';
4212: msgNumCreated := PON_AUCTION_PKG.getMessage('PON_AUC_WF_NUM_OF_SUCC_PO');
4213: msgPOdetails := PON_AUCTION_PKG.getMessage('PON_AUC_WF_PO_DETAILS');
4214: ELSIF (x_contract_type = 'BLANKET') THEN
4215: x_purchase_orders := 'Blanket Purchase Agreement';
4216: msgNumCreated := PON_AUCTION_PKG.getMessage('PON_AUC_WF_NUM_OF_SUCC_BL');
4217: msgPOdetails := PON_AUCTION_PKG.getMessage('PON_AUC_WF_BL_DETAILS');

Line 4216: msgNumCreated := PON_AUCTION_PKG.getMessage('PON_AUC_WF_NUM_OF_SUCC_BL');

4212: msgNumCreated := PON_AUCTION_PKG.getMessage('PON_AUC_WF_NUM_OF_SUCC_PO');
4213: msgPOdetails := PON_AUCTION_PKG.getMessage('PON_AUC_WF_PO_DETAILS');
4214: ELSIF (x_contract_type = 'BLANKET') THEN
4215: x_purchase_orders := 'Blanket Purchase Agreement';
4216: msgNumCreated := PON_AUCTION_PKG.getMessage('PON_AUC_WF_NUM_OF_SUCC_BL');
4217: msgPOdetails := PON_AUCTION_PKG.getMessage('PON_AUC_WF_BL_DETAILS');
4218: ELSIF (x_contract_type = 'CONTRACT') THEN
4219: x_purchase_orders := 'Contract Purchase Agreement';
4220: msgNumCreated := PON_AUCTION_PKG.getMessage('PON_AUC_WF_NUM_OF_SUCC_CPA');

Line 4217: msgPOdetails := PON_AUCTION_PKG.getMessage('PON_AUC_WF_BL_DETAILS');

4213: msgPOdetails := PON_AUCTION_PKG.getMessage('PON_AUC_WF_PO_DETAILS');
4214: ELSIF (x_contract_type = 'BLANKET') THEN
4215: x_purchase_orders := 'Blanket Purchase Agreement';
4216: msgNumCreated := PON_AUCTION_PKG.getMessage('PON_AUC_WF_NUM_OF_SUCC_BL');
4217: msgPOdetails := PON_AUCTION_PKG.getMessage('PON_AUC_WF_BL_DETAILS');
4218: ELSIF (x_contract_type = 'CONTRACT') THEN
4219: x_purchase_orders := 'Contract Purchase Agreement';
4220: msgNumCreated := PON_AUCTION_PKG.getMessage('PON_AUC_WF_NUM_OF_SUCC_CPA');
4221: msgPOdetails := PON_AUCTION_PKG.getMessage('PON_AUC_WF_CPA_DETAILS');

Line 4220: msgNumCreated := PON_AUCTION_PKG.getMessage('PON_AUC_WF_NUM_OF_SUCC_CPA');

4216: msgNumCreated := PON_AUCTION_PKG.getMessage('PON_AUC_WF_NUM_OF_SUCC_BL');
4217: msgPOdetails := PON_AUCTION_PKG.getMessage('PON_AUC_WF_BL_DETAILS');
4218: ELSIF (x_contract_type = 'CONTRACT') THEN
4219: x_purchase_orders := 'Contract Purchase Agreement';
4220: msgNumCreated := PON_AUCTION_PKG.getMessage('PON_AUC_WF_NUM_OF_SUCC_CPA');
4221: msgPOdetails := PON_AUCTION_PKG.getMessage('PON_AUC_WF_CPA_DETAILS');
4222: END IF;
4223: msgBid := PON_AUCTION_PKG.getMessage('PON_AUC_WF_BID', x_msg_suffix);
4224: msgSupplier := PON_AUCTION_PKG.getMessage('PON_AUC_WF_SUPPLIER');

Line 4221: msgPOdetails := PON_AUCTION_PKG.getMessage('PON_AUC_WF_CPA_DETAILS');

4217: msgPOdetails := PON_AUCTION_PKG.getMessage('PON_AUC_WF_BL_DETAILS');
4218: ELSIF (x_contract_type = 'CONTRACT') THEN
4219: x_purchase_orders := 'Contract Purchase Agreement';
4220: msgNumCreated := PON_AUCTION_PKG.getMessage('PON_AUC_WF_NUM_OF_SUCC_CPA');
4221: msgPOdetails := PON_AUCTION_PKG.getMessage('PON_AUC_WF_CPA_DETAILS');
4222: END IF;
4223: msgBid := PON_AUCTION_PKG.getMessage('PON_AUC_WF_BID', x_msg_suffix);
4224: msgSupplier := PON_AUCTION_PKG.getMessage('PON_AUC_WF_SUPPLIER');
4225: msgSupplierSite := PON_AUCTION_PKG.getMessage('PON_AUC_WF_SUPPLIER_SITE');

Line 4223: msgBid := PON_AUCTION_PKG.getMessage('PON_AUC_WF_BID', x_msg_suffix);

4219: x_purchase_orders := 'Contract Purchase Agreement';
4220: msgNumCreated := PON_AUCTION_PKG.getMessage('PON_AUC_WF_NUM_OF_SUCC_CPA');
4221: msgPOdetails := PON_AUCTION_PKG.getMessage('PON_AUC_WF_CPA_DETAILS');
4222: END IF;
4223: msgBid := PON_AUCTION_PKG.getMessage('PON_AUC_WF_BID', x_msg_suffix);
4224: msgSupplier := PON_AUCTION_PKG.getMessage('PON_AUC_WF_SUPPLIER');
4225: msgSupplierSite := PON_AUCTION_PKG.getMessage('PON_AUC_WF_SUPPLIER_SITE');
4226: msgBuyer := PON_AUCTION_PKG.getMessage('PON_AUC_WF_BUYER');
4227: msgPO := PON_AUCTION_PKG.getMessage('PON_AUC_WF_PO', 'null', 'PURCHASE_ORDERS', x_purchase_orders);

Line 4224: msgSupplier := PON_AUCTION_PKG.getMessage('PON_AUC_WF_SUPPLIER');

4220: msgNumCreated := PON_AUCTION_PKG.getMessage('PON_AUC_WF_NUM_OF_SUCC_CPA');
4221: msgPOdetails := PON_AUCTION_PKG.getMessage('PON_AUC_WF_CPA_DETAILS');
4222: END IF;
4223: msgBid := PON_AUCTION_PKG.getMessage('PON_AUC_WF_BID', x_msg_suffix);
4224: msgSupplier := PON_AUCTION_PKG.getMessage('PON_AUC_WF_SUPPLIER');
4225: msgSupplierSite := PON_AUCTION_PKG.getMessage('PON_AUC_WF_SUPPLIER_SITE');
4226: msgBuyer := PON_AUCTION_PKG.getMessage('PON_AUC_WF_BUYER');
4227: msgPO := PON_AUCTION_PKG.getMessage('PON_AUC_WF_PO', 'null', 'PURCHASE_ORDERS', x_purchase_orders);
4228: IF (display_type = 'text/plain') THEN

Line 4225: msgSupplierSite := PON_AUCTION_PKG.getMessage('PON_AUC_WF_SUPPLIER_SITE');

4221: msgPOdetails := PON_AUCTION_PKG.getMessage('PON_AUC_WF_CPA_DETAILS');
4222: END IF;
4223: msgBid := PON_AUCTION_PKG.getMessage('PON_AUC_WF_BID', x_msg_suffix);
4224: msgSupplier := PON_AUCTION_PKG.getMessage('PON_AUC_WF_SUPPLIER');
4225: msgSupplierSite := PON_AUCTION_PKG.getMessage('PON_AUC_WF_SUPPLIER_SITE');
4226: msgBuyer := PON_AUCTION_PKG.getMessage('PON_AUC_WF_BUYER');
4227: msgPO := PON_AUCTION_PKG.getMessage('PON_AUC_WF_PO', 'null', 'PURCHASE_ORDERS', x_purchase_orders);
4228: IF (display_type = 'text/plain') THEN
4229: document_type := 'text/plain';

Line 4226: msgBuyer := PON_AUCTION_PKG.getMessage('PON_AUC_WF_BUYER');

4222: END IF;
4223: msgBid := PON_AUCTION_PKG.getMessage('PON_AUC_WF_BID', x_msg_suffix);
4224: msgSupplier := PON_AUCTION_PKG.getMessage('PON_AUC_WF_SUPPLIER');
4225: msgSupplierSite := PON_AUCTION_PKG.getMessage('PON_AUC_WF_SUPPLIER_SITE');
4226: msgBuyer := PON_AUCTION_PKG.getMessage('PON_AUC_WF_BUYER');
4227: msgPO := PON_AUCTION_PKG.getMessage('PON_AUC_WF_PO', 'null', 'PURCHASE_ORDERS', x_purchase_orders);
4228: IF (display_type = 'text/plain') THEN
4229: document_type := 'text/plain';
4230: newline := fnd_global.newline;

Line 4227: msgPO := PON_AUCTION_PKG.getMessage('PON_AUC_WF_PO', 'null', 'PURCHASE_ORDERS', x_purchase_orders);

4223: msgBid := PON_AUCTION_PKG.getMessage('PON_AUC_WF_BID', x_msg_suffix);
4224: msgSupplier := PON_AUCTION_PKG.getMessage('PON_AUC_WF_SUPPLIER');
4225: msgSupplierSite := PON_AUCTION_PKG.getMessage('PON_AUC_WF_SUPPLIER_SITE');
4226: msgBuyer := PON_AUCTION_PKG.getMessage('PON_AUC_WF_BUYER');
4227: msgPO := PON_AUCTION_PKG.getMessage('PON_AUC_WF_PO', 'null', 'PURCHASE_ORDERS', x_purchase_orders);
4228: IF (display_type = 'text/plain') THEN
4229: document_type := 'text/plain';
4230: newline := fnd_global.newline;
4231: beginBold := '';

Line 4266: PON_AUCTION_PKG.UNSET_SESSION_LANGUAGE;

4262: document := msgNumCreated || ' ' || beginBold || x_count || endBold || newline || newline|| document;
4263: x_progress := '40: GENERAGE_PO_SUCCESS_EMAIL final e-mail message: ' || document;
4264: log_message('PONCOMPL' || ' ' || itemkey || ' ' ||x_progress);
4265:
4266: PON_AUCTION_PKG.UNSET_SESSION_LANGUAGE;
4267: EXCEPTION
4268:
4269: when others then
4270: wf_core.context('PON_AUCTION_CREATE_PO_PKG','generatePOSuccessEmail', x_progress, SQLERRM);

Line 4376: PON_AUCTION_PKG.SET_SESSION_LANGUAGE(null, x_language_code);

4372: x_progress := '20: GENERATE_PO_FAILURE_EMAIL auction id: ' || x_auction_header_id || ', ' || 'message suffix: ' || x_msg_suffix || ', ' || 'user name: ' || x_user_name;
4373:
4374: log_message('PONCOMPL' || ' ' || itemkey || ' ' || x_progress);
4375: PON_PROFILE_UTIL_PKG.GET_WF_LANGUAGE(x_user_name, x_language_code);
4376: PON_AUCTION_PKG.SET_SESSION_LANGUAGE(null, x_language_code);
4377:
4378:
4379: IF (x_contract_type = 'STANDARD') THEN
4380: x_purchase_orders := 'Standard Purchase Order';

Line 4381: msgNumNotCreated := PON_AUCTION_PKG.getMessage('PON_AUC_WF_NUM_OF_FAIL_PO');

4377:
4378:
4379: IF (x_contract_type = 'STANDARD') THEN
4380: x_purchase_orders := 'Standard Purchase Order';
4381: msgNumNotCreated := PON_AUCTION_PKG.getMessage('PON_AUC_WF_NUM_OF_FAIL_PO');
4382: ELSIF (x_contract_type = 'BLANKET') THEN
4383: x_purchase_orders := 'Blanket Purchase Agreement';
4384: msgNumNotCreated := PON_AUCTION_PKG.getMessage('PON_AUC_WF_NUM_OF_FAIL_BL');
4385: ELSIF (x_contract_type = 'CONTRACT') THEN

Line 4384: msgNumNotCreated := PON_AUCTION_PKG.getMessage('PON_AUC_WF_NUM_OF_FAIL_BL');

4380: x_purchase_orders := 'Standard Purchase Order';
4381: msgNumNotCreated := PON_AUCTION_PKG.getMessage('PON_AUC_WF_NUM_OF_FAIL_PO');
4382: ELSIF (x_contract_type = 'BLANKET') THEN
4383: x_purchase_orders := 'Blanket Purchase Agreement';
4384: msgNumNotCreated := PON_AUCTION_PKG.getMessage('PON_AUC_WF_NUM_OF_FAIL_BL');
4385: ELSIF (x_contract_type = 'CONTRACT') THEN
4386: x_purchase_orders := 'Contract Purchase Agreement';
4387: msgNumNotCreated := PON_AUCTION_PKG.getMessage('PON_AUC_WF_NUM_OF_FAIL_CPA');
4388: END IF;

Line 4387: msgNumNotCreated := PON_AUCTION_PKG.getMessage('PON_AUC_WF_NUM_OF_FAIL_CPA');

4383: x_purchase_orders := 'Blanket Purchase Agreement';
4384: msgNumNotCreated := PON_AUCTION_PKG.getMessage('PON_AUC_WF_NUM_OF_FAIL_BL');
4385: ELSIF (x_contract_type = 'CONTRACT') THEN
4386: x_purchase_orders := 'Contract Purchase Agreement';
4387: msgNumNotCreated := PON_AUCTION_PKG.getMessage('PON_AUC_WF_NUM_OF_FAIL_CPA');
4388: END IF;
4389:
4390: msgBid := PON_AUCTION_PKG.getMessage('PON_AUC_WF_BID', x_msg_suffix);
4391: msgSupplier := PON_AUCTION_PKG.getMessage('PON_AUC_WF_SUPPLIER');

Line 4390: msgBid := PON_AUCTION_PKG.getMessage('PON_AUC_WF_BID', x_msg_suffix);

4386: x_purchase_orders := 'Contract Purchase Agreement';
4387: msgNumNotCreated := PON_AUCTION_PKG.getMessage('PON_AUC_WF_NUM_OF_FAIL_CPA');
4388: END IF;
4389:
4390: msgBid := PON_AUCTION_PKG.getMessage('PON_AUC_WF_BID', x_msg_suffix);
4391: msgSupplier := PON_AUCTION_PKG.getMessage('PON_AUC_WF_SUPPLIER');
4392: msgSupplierSite := PON_AUCTION_PKG.getMessage('PON_AUC_WF_SUPPLIER_SITE');
4393: msgBuyer := PON_AUCTION_PKG.getMessage('PON_AUC_WF_BUYER');
4394: msgPurchaseOrder := PON_AUCTION_PKG.getMessage('PON_AUCTS_PAY_PO');

Line 4391: msgSupplier := PON_AUCTION_PKG.getMessage('PON_AUC_WF_SUPPLIER');

4387: msgNumNotCreated := PON_AUCTION_PKG.getMessage('PON_AUC_WF_NUM_OF_FAIL_CPA');
4388: END IF;
4389:
4390: msgBid := PON_AUCTION_PKG.getMessage('PON_AUC_WF_BID', x_msg_suffix);
4391: msgSupplier := PON_AUCTION_PKG.getMessage('PON_AUC_WF_SUPPLIER');
4392: msgSupplierSite := PON_AUCTION_PKG.getMessage('PON_AUC_WF_SUPPLIER_SITE');
4393: msgBuyer := PON_AUCTION_PKG.getMessage('PON_AUC_WF_BUYER');
4394: msgPurchaseOrder := PON_AUCTION_PKG.getMessage('PON_AUCTS_PAY_PO');
4395: msgDuplicatePONumber := PON_AUCTION_PKG.getMessage('PON_AUC_WF_DUP_PO_NUM');

Line 4392: msgSupplierSite := PON_AUCTION_PKG.getMessage('PON_AUC_WF_SUPPLIER_SITE');

4388: END IF;
4389:
4390: msgBid := PON_AUCTION_PKG.getMessage('PON_AUC_WF_BID', x_msg_suffix);
4391: msgSupplier := PON_AUCTION_PKG.getMessage('PON_AUC_WF_SUPPLIER');
4392: msgSupplierSite := PON_AUCTION_PKG.getMessage('PON_AUC_WF_SUPPLIER_SITE');
4393: msgBuyer := PON_AUCTION_PKG.getMessage('PON_AUC_WF_BUYER');
4394: msgPurchaseOrder := PON_AUCTION_PKG.getMessage('PON_AUCTS_PAY_PO');
4395: msgDuplicatePONumber := PON_AUCTION_PKG.getMessage('PON_AUC_WF_DUP_PO_NUM');
4396: msgSystemError := PON_AUCTION_PKG.getMessage('PON_AUC_WF_SYS_ERROR');

Line 4393: msgBuyer := PON_AUCTION_PKG.getMessage('PON_AUC_WF_BUYER');

4389:
4390: msgBid := PON_AUCTION_PKG.getMessage('PON_AUC_WF_BID', x_msg_suffix);
4391: msgSupplier := PON_AUCTION_PKG.getMessage('PON_AUC_WF_SUPPLIER');
4392: msgSupplierSite := PON_AUCTION_PKG.getMessage('PON_AUC_WF_SUPPLIER_SITE');
4393: msgBuyer := PON_AUCTION_PKG.getMessage('PON_AUC_WF_BUYER');
4394: msgPurchaseOrder := PON_AUCTION_PKG.getMessage('PON_AUCTS_PAY_PO');
4395: msgDuplicatePONumber := PON_AUCTION_PKG.getMessage('PON_AUC_WF_DUP_PO_NUM');
4396: msgSystemError := PON_AUCTION_PKG.getMessage('PON_AUC_WF_SYS_ERROR');
4397: msgPO := PON_AUCTION_PKG.getMessage('PON_AUC_WF_PO', 'null', 'PURCHASE_ORDERS', x_purchase_orders);

Line 4394: msgPurchaseOrder := PON_AUCTION_PKG.getMessage('PON_AUCTS_PAY_PO');

4390: msgBid := PON_AUCTION_PKG.getMessage('PON_AUC_WF_BID', x_msg_suffix);
4391: msgSupplier := PON_AUCTION_PKG.getMessage('PON_AUC_WF_SUPPLIER');
4392: msgSupplierSite := PON_AUCTION_PKG.getMessage('PON_AUC_WF_SUPPLIER_SITE');
4393: msgBuyer := PON_AUCTION_PKG.getMessage('PON_AUC_WF_BUYER');
4394: msgPurchaseOrder := PON_AUCTION_PKG.getMessage('PON_AUCTS_PAY_PO');
4395: msgDuplicatePONumber := PON_AUCTION_PKG.getMessage('PON_AUC_WF_DUP_PO_NUM');
4396: msgSystemError := PON_AUCTION_PKG.getMessage('PON_AUC_WF_SYS_ERROR');
4397: msgPO := PON_AUCTION_PKG.getMessage('PON_AUC_WF_PO', 'null', 'PURCHASE_ORDERS', x_purchase_orders);
4398:

Line 4395: msgDuplicatePONumber := PON_AUCTION_PKG.getMessage('PON_AUC_WF_DUP_PO_NUM');

4391: msgSupplier := PON_AUCTION_PKG.getMessage('PON_AUC_WF_SUPPLIER');
4392: msgSupplierSite := PON_AUCTION_PKG.getMessage('PON_AUC_WF_SUPPLIER_SITE');
4393: msgBuyer := PON_AUCTION_PKG.getMessage('PON_AUC_WF_BUYER');
4394: msgPurchaseOrder := PON_AUCTION_PKG.getMessage('PON_AUCTS_PAY_PO');
4395: msgDuplicatePONumber := PON_AUCTION_PKG.getMessage('PON_AUC_WF_DUP_PO_NUM');
4396: msgSystemError := PON_AUCTION_PKG.getMessage('PON_AUC_WF_SYS_ERROR');
4397: msgPO := PON_AUCTION_PKG.getMessage('PON_AUC_WF_PO', 'null', 'PURCHASE_ORDERS', x_purchase_orders);
4398:
4399: IF (display_type = 'text/plain') THEN

Line 4396: msgSystemError := PON_AUCTION_PKG.getMessage('PON_AUC_WF_SYS_ERROR');

4392: msgSupplierSite := PON_AUCTION_PKG.getMessage('PON_AUC_WF_SUPPLIER_SITE');
4393: msgBuyer := PON_AUCTION_PKG.getMessage('PON_AUC_WF_BUYER');
4394: msgPurchaseOrder := PON_AUCTION_PKG.getMessage('PON_AUCTS_PAY_PO');
4395: msgDuplicatePONumber := PON_AUCTION_PKG.getMessage('PON_AUC_WF_DUP_PO_NUM');
4396: msgSystemError := PON_AUCTION_PKG.getMessage('PON_AUC_WF_SYS_ERROR');
4397: msgPO := PON_AUCTION_PKG.getMessage('PON_AUC_WF_PO', 'null', 'PURCHASE_ORDERS', x_purchase_orders);
4398:
4399: IF (display_type = 'text/plain') THEN
4400: document_type := 'text/plain';

Line 4397: msgPO := PON_AUCTION_PKG.getMessage('PON_AUC_WF_PO', 'null', 'PURCHASE_ORDERS', x_purchase_orders);

4393: msgBuyer := PON_AUCTION_PKG.getMessage('PON_AUC_WF_BUYER');
4394: msgPurchaseOrder := PON_AUCTION_PKG.getMessage('PON_AUCTS_PAY_PO');
4395: msgDuplicatePONumber := PON_AUCTION_PKG.getMessage('PON_AUC_WF_DUP_PO_NUM');
4396: msgSystemError := PON_AUCTION_PKG.getMessage('PON_AUC_WF_SYS_ERROR');
4397: msgPO := PON_AUCTION_PKG.getMessage('PON_AUC_WF_PO', 'null', 'PURCHASE_ORDERS', x_purchase_orders);
4398:
4399: IF (display_type = 'text/plain') THEN
4400: document_type := 'text/plain';
4401: newline := fnd_global.newline;

Line 4447: PON_AUCTION_PKG.UNSET_SESSION_LANGUAGE;

4443: document := msgNumNotCreated || ' ' || beginBold || x_count || endBold || newline || newline|| document;
4444: x_progress := '40: GENERATE_PO_FAILURE_EMAIL final e-mail message: ' || document;
4445:
4446: log_message('PONCOMPL' || ' ' || itemkey || ' ' || x_progress);
4447: PON_AUCTION_PKG.UNSET_SESSION_LANGUAGE;
4448:
4449: EXCEPTION
4450:
4451: when others then