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.PO_DOCUMENT_CHECKS_PVT dependencies on FND_MESSAGE

Line 15: g_linemsg CONSTANT VARCHAR2(75) := substr(FND_MESSAGE.GET_STRING('PO', 'PO_ZMVOR_LINE'), 1,25);

11: -- This is used as a delimiter in constructing the error msgs
12: g_delim CONSTANT VARCHAR2(1) := ' ';
13:
14: --Contains message 'Line#'
15: g_linemsg CONSTANT VARCHAR2(75) := substr(FND_MESSAGE.GET_STRING('PO', 'PO_ZMVOR_LINE'), 1,25);
16:
17: --Contains message 'Schedule#'
18: g_shipmsg CONSTANT VARCHAR2(75) := substr(FND_MESSAGE.GET_STRING('PO', 'PO_ZMVOR_SCHEDULE'), 1,25);
19:

Line 18: g_shipmsg CONSTANT VARCHAR2(75) := substr(FND_MESSAGE.GET_STRING('PO', 'PO_ZMVOR_SCHEDULE'), 1,25);

14: --Contains message 'Line#'
15: g_linemsg CONSTANT VARCHAR2(75) := substr(FND_MESSAGE.GET_STRING('PO', 'PO_ZMVOR_LINE'), 1,25);
16:
17: --Contains message 'Schedule#'
18: g_shipmsg CONSTANT VARCHAR2(75) := substr(FND_MESSAGE.GET_STRING('PO', 'PO_ZMVOR_SCHEDULE'), 1,25);
19:
20: --Contains message 'Distribution#'
21: g_distmsg CONSTANT VARCHAR2(75) := substr(FND_MESSAGE.GET_STRING('PO', 'PO_ZMVOR_DISTRIBUTION'), 1,25);
22:

Line 21: g_distmsg CONSTANT VARCHAR2(75) := substr(FND_MESSAGE.GET_STRING('PO', 'PO_ZMVOR_DISTRIBUTION'), 1,25);

17: --Contains message 'Schedule#'
18: g_shipmsg CONSTANT VARCHAR2(75) := substr(FND_MESSAGE.GET_STRING('PO', 'PO_ZMVOR_SCHEDULE'), 1,25);
19:
20: --Contains message 'Distribution#'
21: g_distmsg CONSTANT VARCHAR2(75) := substr(FND_MESSAGE.GET_STRING('PO', 'PO_ZMVOR_DISTRIBUTION'), 1,25);
22:
23: --Contains message 'Price Break#'
24: g_price_breakmsg CONSTANT VARCHAR2(75) := substr(FND_MESSAGE.GET_STRING('PO', 'PO_ZMVOR_PRICE_BREAK'), 1,25);
25:

Line 24: g_price_breakmsg CONSTANT VARCHAR2(75) := substr(FND_MESSAGE.GET_STRING('PO', 'PO_ZMVOR_PRICE_BREAK'), 1,25);

20: --Contains message 'Distribution#'
21: g_distmsg CONSTANT VARCHAR2(75) := substr(FND_MESSAGE.GET_STRING('PO', 'PO_ZMVOR_DISTRIBUTION'), 1,25);
22:
23: --Contains message 'Price Break#'
24: g_price_breakmsg CONSTANT VARCHAR2(75) := substr(FND_MESSAGE.GET_STRING('PO', 'PO_ZMVOR_PRICE_BREAK'), 1,25);
25:
26: --Contains message 'Quantity'
27: g_qtymsg CONSTANT VARCHAR2(75) := substr(FND_MESSAGE.GET_STRING('PO', 'PO_SUB_TOKEN_QUANTITY'),1,25);
28:

Line 27: g_qtymsg CONSTANT VARCHAR2(75) := substr(FND_MESSAGE.GET_STRING('PO', 'PO_SUB_TOKEN_QUANTITY'),1,25);

23: --Contains message 'Price Break#'
24: g_price_breakmsg CONSTANT VARCHAR2(75) := substr(FND_MESSAGE.GET_STRING('PO', 'PO_ZMVOR_PRICE_BREAK'), 1,25);
25:
26: --Contains message 'Quantity'
27: g_qtymsg CONSTANT VARCHAR2(75) := substr(FND_MESSAGE.GET_STRING('PO', 'PO_SUB_TOKEN_QUANTITY'),1,25);
28:
29: --
30: --Contains message 'Shipment Quantity'
31: g_shipqtymsg CONSTANT VARCHAR2(40) := substrb(FND_MESSAGE.GET_STRING('PO', 'PO_SUB_TOKEN_SHIP_QUANTITY'),1,40);

Line 31: g_shipqtymsg CONSTANT VARCHAR2(40) := substrb(FND_MESSAGE.GET_STRING('PO', 'PO_SUB_TOKEN_SHIP_QUANTITY'),1,40);

27: g_qtymsg CONSTANT VARCHAR2(75) := substr(FND_MESSAGE.GET_STRING('PO', 'PO_SUB_TOKEN_QUANTITY'),1,25);
28:
29: --
30: --Contains message 'Shipment Quantity'
31: g_shipqtymsg CONSTANT VARCHAR2(40) := substrb(FND_MESSAGE.GET_STRING('PO', 'PO_SUB_TOKEN_SHIP_QUANTITY'),1,40);
32:
33: --Contains message 'Distribution Quantity'
34: g_distqtymsg CONSTANT VARCHAR2(40) := substrb(FND_MESSAGE.GET_STRING('PO', 'PO_SUB_TOKEN_DIST_QUANTITY'),1,40);
35:

Line 34: g_distqtymsg CONSTANT VARCHAR2(40) := substrb(FND_MESSAGE.GET_STRING('PO', 'PO_SUB_TOKEN_DIST_QUANTITY'),1,40);

30: --Contains message 'Shipment Quantity'
31: g_shipqtymsg CONSTANT VARCHAR2(40) := substrb(FND_MESSAGE.GET_STRING('PO', 'PO_SUB_TOKEN_SHIP_QUANTITY'),1,40);
32:
33: --Contains message 'Distribution Quantity'
34: g_distqtymsg CONSTANT VARCHAR2(40) := substrb(FND_MESSAGE.GET_STRING('PO', 'PO_SUB_TOKEN_DIST_QUANTITY'),1,40);
35:
36: G_PKG_NAME CONSTANT varchar2(30) := 'PO_DOCUMENT_CHECKS_PVT';
37:
38: g_log_head CONSTANT VARCHAR2(50) := 'po.plsql.'|| G_PKG_NAME || '.';

Line 1715: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_REQ_HEADER_NO_LINES');

1711: END IF;
1712:
1713: -- Check 1: Each Requisition Header must have atleast one line
1714: -- PO_SUB_REQ_HEADER_NO_LINES
1715: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_REQ_HEADER_NO_LINES');
1716: INSERT INTO po_online_report_text_gt(online_report_id,
1717: last_update_login,
1718: last_updated_by,
1719: last_update_date,

Line 1762: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_REQ_LINE_NO_DIST');

1758:
1759: -- Check 2: Each Requisition line must have atleast one distribution
1760: -- PO_SUB_REQ_LINE_NO_DIST
1761:
1762: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_REQ_LINE_NO_DIST');
1763: INSERT INTO po_online_report_text_gt(online_report_id,
1764: last_update_login,
1765: last_updated_by,
1766: last_update_date,

Line 1922: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_REQ_SOURCE_ONE_DIST');

1918:
1919: -- Check 4:Lines with SOURCE type as INVENTORY can have one only one dist
1920: -- PO_SUB_REQ_SOURCE_ONE_DIST
1921:
1922: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_REQ_SOURCE_ONE_DIST');
1923: INSERT INTO po_online_report_text_gt(online_report_id,
1924: last_update_login,
1925: last_updated_by,
1926: last_update_date,

Line 1970: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_REQ_RATE_NULL');

1966: END IF;
1967:
1968: -- Check 5: Requistion Rate cannot be NULL if using a foreign currency vendor
1969: -- PO_SUB_REQ_RATE_NULL
1970: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_REQ_RATE_NULL');
1971: INSERT INTO po_online_report_text_gt(online_report_id,
1972: last_update_login,
1973: last_updated_by,
1974: last_update_date,

Line 2058: l_textline := FND_MESSAGE.GET_STRING('PO','PO_ATO_ITEM_NA');

2054: END IF;
2055:
2056: -- Check 7: Requisitions cannot have ATO/CTO model items (Bug 3362369)
2057: -- PO_ATO_ITEM_NA
2058: l_textline := FND_MESSAGE.GET_STRING('PO','PO_ATO_ITEM_NA');
2059: INSERT INTO po_online_report_text_gt(online_report_id,
2060: last_update_login,
2061: last_updated_by,
2062: last_update_date,

Line 2135: l_tax_message := fnd_message.get_string('PO','PO_TAX_CALCULATION')||' : ' ;

2131: 'REQ 10: Calculate tax has errored out');
2132: END IF;
2133: END IF;
2134:
2135: l_tax_message := fnd_message.get_string('PO','PO_TAX_CALCULATION')||' : ' ;
2136:
2137: FORALL i IN 1..po_tax_interface_pvt.G_TAX_ERRORS_TBL.MESSAGE_TEXT.COUNT
2138: INSERT INTO po_online_report_text_gt
2139: (

Line 2186: fnd_message.set_name('PO','PO_TAX_CALC_UNEXPECTED_ERROR');

2182: l_textline := l_textline || po_tax_interface_pvt.G_TAX_ERRORS_TBL.MESSAGE_TEXT(1);
2183: ELSE
2184: l_textline := l_textline || SQLERRM();
2185: END IF;
2186: fnd_message.set_name('PO','PO_TAX_CALC_UNEXPECTED_ERROR');
2187: fnd_message.set_token('ERROR',l_textline);
2188: FND_MSG_PUB.Add;
2189: l_progress := '014';
2190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2187: fnd_message.set_token('ERROR',l_textline);

2183: ELSE
2184: l_textline := l_textline || SQLERRM();
2185: END IF;
2186: fnd_message.set_name('PO','PO_TAX_CALC_UNEXPECTED_ERROR');
2187: fnd_message.set_token('ERROR',l_textline);
2188: FND_MSG_PUB.Add;
2189: l_progress := '014';
2190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2191: END IF;

Line 2313: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_REL_PA_APPROVED');

2309: -- PO_SUB_REL_PA_APPROVED
2310: --< Bug 3422733 > Only do this check if the BPA is not ON HOLD. The ON HOLD
2311: -- check is done later. Avoids showing 2 msgs for BPA that is ON HOLD.
2312:
2313: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_REL_PA_APPROVED');
2314: INSERT INTO po_online_report_text_gt(online_report_id,
2315: last_update_login,
2316: last_updated_by,
2317: last_update_date,

Line 2364: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_REL_PA_EXPIRED');

2360: -- Modified Check 2 so that an error will be thrown only when
2361: -- 1) Release has not been approved once yet, AND
2362: -- 2) SYSDATE is after expiration date on the blanket header
2363:
2364: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_REL_PA_EXPIRED');
2365: INSERT INTO po_online_report_text_gt(online_report_id,
2366: last_update_login,
2367: last_updated_by,
2368: last_update_date,

Line 2412: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_REL_PA_ON_HOLD');

2408: -- Check 3: Purchase Agreement assocaited with this release must not be
2409: -- on hold
2410: -- PO_SUB_REL_PA_ON_HOLD
2411:
2412: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_REL_PA_ON_HOLD');
2413: INSERT INTO po_online_report_text_gt(online_report_id,
2414: last_update_login,
2415: last_updated_by,
2416: last_update_date,

Line 2458: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_REL_VENDOR_ON_HOLD');

2454:
2455: -- Check 4: Associated Purchase Agreement's supplier should not be on hold
2456: -- PO_SUB_REL_VENDOR_ON_HOLD
2457:
2458: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_REL_VENDOR_ON_HOLD');
2459: INSERT INTO po_online_report_text_gt(online_report_id,
2460: last_update_login,
2461: last_updated_by,
2462: last_update_date,

Line 2507: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_REL_NO_SHIP');

2503:
2504: -- Check 5: Every Release must have atleast one shipment
2505: -- PO_SUB_REL_NO_SHIP
2506:
2507: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_REL_NO_SHIP');
2508: INSERT INTO po_online_report_text_gt(online_report_id,
2509: last_update_login,
2510: last_updated_by,
2511: last_update_date,

Line 2810: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_REL_SHIP_NO_DIST');

2806:
2807: -- Check 8: All Release shipments should have atleast one distribution
2808: -- PO_SUB_REL_SHIP_NO_DIST
2809:
2810: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_REL_SHIP_NO_DIST');
2811: INSERT INTO po_online_report_text_gt(online_report_id,
2812: last_update_login,
2813: last_updated_by,
2814: last_update_date,

Line 2862: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_REL_RATE_NULL');

2858: -- Check 9: Rate on the Release shipment must not be NULL if using a foreign
2859: -- currency vendor. We are using foreign currency if the currency on PO
2860: -- Header does not match Set of Books currency
2861: -- PO_SUB_REL_RATE_NULL
2862: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_REL_RATE_NULL');
2863: INSERT INTO po_online_report_text_gt(online_report_id,
2864: last_update_login,
2865: last_updated_by,
2866: last_update_date,

Line 2921: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_REL_AMT_LESS_MINREL_AMT');

2917: -- Check 10:Release total amount must be greater than Purchase Agreement
2918: -- minimum release amount
2919: -- PO_SUB_REL_AMT_LESS_MINREL_AMT
2920:
2921: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_REL_AMT_LESS_MINREL_AMT');
2922: INSERT INTO po_online_report_text_gt(online_report_id,
2923: last_update_login,
2924: last_updated_by,
2925: last_update_date,

Line 3035: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_REL_AMT_GRT_LIMIT_AMT');

3031: l_total_rel_amount := l_this_rel_amount + l_previous_rel_amount;
3032: --
3033:
3034:
3035: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_REL_AMT_GRT_LIMIT_AMT');
3036: INSERT INTO po_online_report_text_gt (online_report_id,
3037: last_update_login,
3038: last_updated_by,
3039: last_update_date,

Line 3087: l_textline := FND_MESSAGE.GET_STRING('PO','PO_SUB_REL_SHIPAMT_LESS_MINREL');

3083: -- Check 12: The Amount being released for all shipments for a particular line
3084: -- must be greater than the min release amount specified in agreement line
3085: -- PO_SUB_REL_SHIPAMT_LESS_MINREL
3086:
3087: l_textline := FND_MESSAGE.GET_STRING('PO','PO_SUB_REL_SHIPAMT_LESS_MINREL');
3088: SELECT
3089: POL.line_num,
3090: 0,
3091: 0,

Line 3216: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_UOM_CLASS_CONVERSION');

3212: -- Message inserted is:
3213: --'Shipment# Following Interclass UOM conversion is not defined or
3214: -- is disabled '
3215: -- Bug #1630662
3216: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_UOM_CLASS_CONVERSION');
3217: INSERT INTO po_online_report_text_gt(online_report_id,
3218: last_update_login,
3219: last_updated_by,
3220: last_update_date,

Line 3279: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_ITEM_NOT_APPROVED_REL');

3275: is restricted by checking 'Use approved supplier list' there should be
3276: atlease one approved ASL either at item level or at category level
3277: if there is no item ASL*/
3278:
3279: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_ITEM_NOT_APPROVED_REL');
3280: INSERT INTO po_online_report_text_gt(online_report_id,
3281: last_update_login,
3282: last_updated_by,
3283: last_update_date,

Line 3381: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_ITEM_ASL_DEBARRED_REL');

3377: Need to remove the join with mtl_item_categories for one
3378: time items as there will not be any record
3379: */
3380:
3381: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_ITEM_ASL_DEBARRED_REL');
3382: INSERT INTO po_online_report_text_gt(online_report_id,
3383: last_update_login,
3384: last_updated_by,
3385: last_update_date,

Line 3463: l_textline := FND_MESSAGE.get_string('PO', 'PO_ATO_ITEM_NA');

3459: END IF;
3460:
3461: -- Check 17: ATO/CTO Model items not allowed on Releases (Bug 3362369)
3462:
3463: l_textline := FND_MESSAGE.get_string('PO', 'PO_ATO_ITEM_NA');
3464:
3465: INSERT INTO po_online_report_text_gt(
3466: online_report_id,
3467: last_update_login,

Line 3523: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_ALL_NO_ITEM');

3519: END IF;
3520:
3521: -- Check 018: Item has to purchasable
3522:
3523: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_ALL_NO_ITEM');
3524: INSERT INTO po_online_report_text_gt(online_report_id,
3525: last_update_login,
3526: last_updated_by,
3527: last_update_date,

Line 3576: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_ON_HOLD_CANNOT_APPROVE');

3572: END IF;
3573: -- Check 19: Release should not be on hold (Bug 3678912)
3574: -- PO_ON_HOLD_CANNOT_APPROVE
3575:
3576: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_ON_HOLD_CANNOT_APPROVE');
3577: INSERT INTO po_online_report_text_gt(online_report_id,
3578: last_update_login,
3579: last_updated_by,
3580: last_update_date,

Line 3622: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_PDOI_INVALID_VENDOR');

3618: -- Check 20: Vendor should be valid when approving the document.
3619: -- Important for reapproval, to avoid the case when the vendor has
3620: -- been invalidated by first successful approval.
3621:
3622: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_PDOI_INVALID_VENDOR');
3623: ---------------------------------------------------------------------------
3624: if (l_vendor_id is NOT NULL) then
3625: fnd_message.set_name('PO', 'PO_PDOI_INVALID_VENDOR');
3626: fnd_message.set_token('VALUE', to_char(l_vendor_id), FALSE);

Line 3625: fnd_message.set_name('PO', 'PO_PDOI_INVALID_VENDOR');

3621:
3622: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_PDOI_INVALID_VENDOR');
3623: ---------------------------------------------------------------------------
3624: if (l_vendor_id is NOT NULL) then
3625: fnd_message.set_name('PO', 'PO_PDOI_INVALID_VENDOR');
3626: fnd_message.set_token('VALUE', to_char(l_vendor_id), FALSE);
3627: l_textline := substr(fnd_message.get, 1, 240);
3628:
3629:

Line 3626: fnd_message.set_token('VALUE', to_char(l_vendor_id), FALSE);

3622: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_PDOI_INVALID_VENDOR');
3623: ---------------------------------------------------------------------------
3624: if (l_vendor_id is NOT NULL) then
3625: fnd_message.set_name('PO', 'PO_PDOI_INVALID_VENDOR');
3626: fnd_message.set_token('VALUE', to_char(l_vendor_id), FALSE);
3627: l_textline := substr(fnd_message.get, 1, 240);
3628:
3629:
3630: INSERT INTO po_online_report_text_gt(online_report_id,

Line 3627: l_textline := substr(fnd_message.get, 1, 240);

3623: ---------------------------------------------------------------------------
3624: if (l_vendor_id is NOT NULL) then
3625: fnd_message.set_name('PO', 'PO_PDOI_INVALID_VENDOR');
3626: fnd_message.set_token('VALUE', to_char(l_vendor_id), FALSE);
3627: l_textline := substr(fnd_message.get, 1, 240);
3628:
3629:
3630: INSERT INTO po_online_report_text_gt(online_report_id,
3631: last_update_login,

Line 3671: fnd_message.set_name('PO', 'PO_PDOI_INVALID_VENDOR_SITE');

3667: -------------------------------------------------------------------------------------
3668: -- Check 21: check the validity of the vendor site.
3669: if (l_vendor_site_id is not null) then
3670:
3671: fnd_message.set_name('PO', 'PO_PDOI_INVALID_VENDOR_SITE');
3672: fnd_message.set_token('VALUE', to_char(l_vendor_site_id), FALSE);
3673: l_textline := substr(fnd_message.get, 1, 240);
3674:
3675: INSERT INTO po_online_report_text_gt(online_report_id,

Line 3672: fnd_message.set_token('VALUE', to_char(l_vendor_site_id), FALSE);

3668: -- Check 21: check the validity of the vendor site.
3669: if (l_vendor_site_id is not null) then
3670:
3671: fnd_message.set_name('PO', 'PO_PDOI_INVALID_VENDOR_SITE');
3672: fnd_message.set_token('VALUE', to_char(l_vendor_site_id), FALSE);
3673: l_textline := substr(fnd_message.get, 1, 240);
3674:
3675: INSERT INTO po_online_report_text_gt(online_report_id,
3676: last_update_login,

Line 3673: l_textline := substr(fnd_message.get, 1, 240);

3669: if (l_vendor_site_id is not null) then
3670:
3671: fnd_message.set_name('PO', 'PO_PDOI_INVALID_VENDOR_SITE');
3672: fnd_message.set_token('VALUE', to_char(l_vendor_site_id), FALSE);
3673: l_textline := substr(fnd_message.get, 1, 240);
3674:
3675: INSERT INTO po_online_report_text_gt(online_report_id,
3676: last_update_login,
3677: last_updated_by,

Line 3715: fnd_message.set_name('PO', 'PO_PDOI_INVALID_VDR_CNTCT');

3711: -------------------------------------------------------------------------------------
3712: -- check 22: validate vendor contact
3713: if (l_vendor_contact_id is not null) then
3714:
3715: fnd_message.set_name('PO', 'PO_PDOI_INVALID_VDR_CNTCT');
3716: fnd_message.set_token('VALUE', to_char(l_vendor_contact_id), FALSE);
3717: l_textline := substr(fnd_message.get, 1, 240);
3718:
3719: INSERT INTO po_online_report_text_gt(online_report_id,

Line 3716: fnd_message.set_token('VALUE', to_char(l_vendor_contact_id), FALSE);

3712: -- check 22: validate vendor contact
3713: if (l_vendor_contact_id is not null) then
3714:
3715: fnd_message.set_name('PO', 'PO_PDOI_INVALID_VDR_CNTCT');
3716: fnd_message.set_token('VALUE', to_char(l_vendor_contact_id), FALSE);
3717: l_textline := substr(fnd_message.get, 1, 240);
3718:
3719: INSERT INTO po_online_report_text_gt(online_report_id,
3720: last_update_login,

Line 3717: l_textline := substr(fnd_message.get, 1, 240);

3713: if (l_vendor_contact_id is not null) then
3714:
3715: fnd_message.set_name('PO', 'PO_PDOI_INVALID_VDR_CNTCT');
3716: fnd_message.set_token('VALUE', to_char(l_vendor_contact_id), FALSE);
3717: l_textline := substr(fnd_message.get, 1, 240);
3718:
3719: INSERT INTO po_online_report_text_gt(online_report_id,
3720: last_update_login,
3721: last_updated_by,

Line 3795: l_tax_message := fnd_message.get_string('PO','PO_TAX_CALCULATION')||' : ' ;

3791: END IF;
3792: END IF;
3793: l_progress := '023';
3794:
3795: l_tax_message := fnd_message.get_string('PO','PO_TAX_CALCULATION')||' : ' ;
3796:
3797: FORALL i IN 1..po_tax_interface_pvt.G_TAX_ERRORS_TBL.MESSAGE_TEXT.COUNT
3798: INSERT INTO po_online_report_text_gt
3799: (

Line 3845: fnd_message.set_name('PO','PO_TAX_CALC_UNEXPECTED_ERROR');

3841: l_textline := l_textline || po_tax_interface_pvt.G_TAX_ERRORS_TBL.MESSAGE_TEXT(1);
3842: ELSE
3843: l_textline := l_textline || SQLERRM();
3844: END IF;
3845: fnd_message.set_name('PO','PO_TAX_CALC_UNEXPECTED_ERROR');
3846: fnd_message.set_token('ERROR',l_textline);
3847: FND_MSG_PUB.Add;
3848: l_progress := '025';
3849: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3846: fnd_message.set_token('ERROR',l_textline);

3842: ELSE
3843: l_textline := l_textline || SQLERRM();
3844: END IF;
3845: fnd_message.set_name('PO','PO_TAX_CALC_UNEXPECTED_ERROR');
3846: fnd_message.set_token('ERROR',l_textline);
3847: FND_MSG_PUB.Add;
3848: l_progress := '025';
3849: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3850: END IF;

Line 3867: l_textline := FND_MESSAGE.GET_STRING('PO','PO_SUB_REL_SHIP_INV_MATCH_NE_R');

3863: || l_progress,'Rel 25: LCM enabled release shipment should have invoice match option as receipt');
3864: END IF;
3865: END IF;
3866: -- Check 25: Validation for LCM enabled release to check whether its shipment has invoice match option as 'Receipt'
3867: l_textline := FND_MESSAGE.GET_STRING('PO','PO_SUB_REL_SHIP_INV_MATCH_NE_R');
3868: INSERT INTO po_online_report_text_gt (online_report_id,
3869: last_update_login,
3870: last_updated_by,
3871: last_update_date,

Line 3911: l_textline := FND_MESSAGE.GET_STRING('PO','PO_SUB_REL_DIST_DEST_TYPE_NE_I');

3907: || l_progress,'Rel 26: LCM enabled release distribution should have destination type as Inventory');
3908: END IF;
3909: END IF;
3910: -- Check 26: Validation for LCM enabled release to check whether its distribution has destination type as 'Inventory'
3911: l_textline := FND_MESSAGE.GET_STRING('PO','PO_SUB_REL_DIST_DEST_TYPE_NE_I');
3912: INSERT INTO po_online_report_text_gt (online_report_id,
3913: last_update_login,
3914: last_updated_by,
3915: last_update_date,

Line 4544: l_textline := FND_MESSAGE.GET_STRING('PO',

4540: ) THEN
4541: --
4542: l_progress := '009';
4543: --Report the price tolerance error
4544: l_textline := FND_MESSAGE.GET_STRING('PO',
4545: 'PO_SUB_REQ_PRICE_TOL_EXCEED');
4546: INSERT into po_online_report_text_gt(
4547: online_report_id,
4548: last_update_login,

Line 4722: FND_MESSAGE.GET_STRING('PO', 'PO_SUB_REQ_AMT_TOL_EXCEED');

4718: THEN
4719: l_progress := '012';
4720: --Report the price amount exceeded error
4721: l_textline :=
4722: FND_MESSAGE.GET_STRING('PO', 'PO_SUB_REQ_AMT_TOL_EXCEED');
4723: INSERT into po_online_report_text_gt(
4724: online_report_id,
4725: last_update_login,
4726: last_updated_by,

Line 4851: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_VENDOR_ON_HOLD');

4847:
4848: -- Check 1: Purchase Order vendor should not be on hold
4849: -- PO_SUB_VENDOR_ON_HOLD
4850:
4851: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_VENDOR_ON_HOLD');
4852: INSERT INTO po_online_report_text_gt(online_report_id,
4853: last_update_login,
4854: last_updated_by,
4855: last_update_date,

Line 4925: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_SYSTEM_SETUP');

4921: END IF;
4922: -- Check 2: When no rows are returned, its likely that there
4923: --are problems with system setup
4924: -- See if we need to stop further processing
4925: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_SYSTEM_SETUP');
4926: INSERT INTO po_online_report_text_gt(online_report_id,
4927: last_update_login,
4928: last_updated_by,
4929: last_update_date,

Line 4972: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_ENTER_VENDOR');

4968: END IF;
4969:
4970: --Check 3: vendor_id is NULL
4971: IF l_vendor_id IS NULL THEN
4972: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_ENTER_VENDOR');
4973: INSERT INTO po_online_report_text_gt(online_report_id,
4974: last_update_login,
4975: last_updated_by,
4976: last_update_date,

Line 5012: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_ENTER_VENDOR_SITE');

5008: END IF;
5009:
5010: --Check 4: vendor_site_id is NULL
5011: IF l_vendor_site_id IS NULL THEN
5012: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_ENTER_VENDOR_SITE');
5013: INSERT INTO po_online_report_text_gt(online_report_id,
5014: last_update_login,
5015: last_updated_by,
5016: last_update_date,

Line 5052: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_NO_SHIP_TO_LOC_ID');

5048: END IF;
5049:
5050: --Check 5: ship_to_location_id is NULL
5051: IF l_ship_to_location_id IS NULL THEN
5052: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_NO_SHIP_TO_LOC_ID');
5053: INSERT INTO po_online_report_text_gt(online_report_id,
5054: last_update_login,
5055: last_updated_by,
5056: last_update_date,

Line 5143: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_NO_BILL_TO_LOC_ID');

5139:
5140: --Check 6: bill_to_location_id is NULL
5141: IF l_bill_to_location_id IS NULL THEN
5142:
5143: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_NO_BILL_TO_LOC_ID');
5144: INSERT INTO po_online_report_text_gt(online_report_id,
5145: last_update_login,
5146: last_updated_by,
5147: last_update_date,

Line 5230: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_NO_CURRENCY_CODE');

5226: END IF;
5227:
5228: --Check 7: currency_code is NULL
5229: IF l_currency_code IS NULL THEN
5230: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_NO_CURRENCY_CODE');
5231: INSERT INTO po_online_report_text_gt(online_report_id,
5232: last_update_login,
5233: last_updated_by,
5234: last_update_date,

Line 5273: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_NO_RATE_TYPE');

5269: IF l_currency_code <> l_sob_currency_code AND
5270: (l_rate_type IS NULL OR l_rate IS NULL OR
5271: (l_rate_type <> 'User' AND l_rate_date IS NULL)) -- Bug 3759198
5272: THEN
5273: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_NO_RATE_TYPE');
5274: INSERT INTO po_online_report_text_gt(online_report_id,
5275: last_update_login,
5276: last_updated_by,
5277: last_update_date,

Line 5319: l_textline := FND_MESSAGE.get_string('PO','PO_SUB_USER_RATE_TYPE');

5315: -- contains any Lines with Value Basis of "Rate".
5316:
5317: IF ( l_rate_type = 'User' ) THEN
5318:
5319: l_textline := FND_MESSAGE.get_string('PO','PO_SUB_USER_RATE_TYPE');
5320:
5321: INSERT INTO po_online_report_text_gt
5322: ( online_report_id
5323: , last_update_login

Line 5373: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_ON_HOLD_CANNOT_APPROVE');

5369: END IF;
5370: -- Check 10: Purchase Order should not be on hold (Bug 3678912)
5371: -- PO_ON_HOLD_CANNOT_APPROVE
5372:
5373: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_ON_HOLD_CANNOT_APPROVE');
5374: INSERT INTO po_online_report_text_gt(online_report_id,
5375: last_update_login,
5376: last_updated_by,
5377: last_update_date,

Line 5412: fnd_message.set_name('PO', 'PO_PDOI_INVALID_VENDOR');

5408: -- been invalidated by first successful approval.
5409:
5410: /* Need to find out.
5411:
5412: fnd_message.set_name('PO', 'PO_PDOI_INVALID_VENDOR');
5413: fnd_message.set_token('VALUE', to_char(x_vendor_id), FALSE);
5414: l_textline := fnd_message.get;
5415:
5416: */

Line 5413: fnd_message.set_token('VALUE', to_char(x_vendor_id), FALSE);

5409:
5410: /* Need to find out.
5411:
5412: fnd_message.set_name('PO', 'PO_PDOI_INVALID_VENDOR');
5413: fnd_message.set_token('VALUE', to_char(x_vendor_id), FALSE);
5414: l_textline := fnd_message.get;
5415:
5416: */
5417:

Line 5414: l_textline := fnd_message.get;

5410: /* Need to find out.
5411:
5412: fnd_message.set_name('PO', 'PO_PDOI_INVALID_VENDOR');
5413: fnd_message.set_token('VALUE', to_char(x_vendor_id), FALSE);
5414: l_textline := fnd_message.get;
5415:
5416: */
5417:
5418: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_PDOI_INVALID_VENDOR');

Line 5418: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_PDOI_INVALID_VENDOR');

5414: l_textline := fnd_message.get;
5415:
5416: */
5417:
5418: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_PDOI_INVALID_VENDOR');
5419:
5420: if (l_vendor_id is NOT NULL) then
5421: fnd_message.set_name('PO', 'PO_PDOI_INVALID_VENDOR');
5422: fnd_message.set_token('VALUE', to_char(l_vendor_id), FALSE);

Line 5421: fnd_message.set_name('PO', 'PO_PDOI_INVALID_VENDOR');

5417:
5418: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_PDOI_INVALID_VENDOR');
5419:
5420: if (l_vendor_id is NOT NULL) then
5421: fnd_message.set_name('PO', 'PO_PDOI_INVALID_VENDOR');
5422: fnd_message.set_token('VALUE', to_char(l_vendor_id), FALSE);
5423: l_textline := substr(fnd_message.get, 1, 240);
5424:
5425:

Line 5422: fnd_message.set_token('VALUE', to_char(l_vendor_id), FALSE);

5418: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_PDOI_INVALID_VENDOR');
5419:
5420: if (l_vendor_id is NOT NULL) then
5421: fnd_message.set_name('PO', 'PO_PDOI_INVALID_VENDOR');
5422: fnd_message.set_token('VALUE', to_char(l_vendor_id), FALSE);
5423: l_textline := substr(fnd_message.get, 1, 240);
5424:
5425:
5426: INSERT INTO po_online_report_text_gt(online_report_id,

Line 5423: l_textline := substr(fnd_message.get, 1, 240);

5419:
5420: if (l_vendor_id is NOT NULL) then
5421: fnd_message.set_name('PO', 'PO_PDOI_INVALID_VENDOR');
5422: fnd_message.set_token('VALUE', to_char(l_vendor_id), FALSE);
5423: l_textline := substr(fnd_message.get, 1, 240);
5424:
5425:
5426: INSERT INTO po_online_report_text_gt(online_report_id,
5427: last_update_login,

Line 5466: fnd_message.set_name('PO', 'PO_PDOI_INVALID_VENDOR_SITE');

5462:
5463: -- Check 12: check the validity of the vendor site.
5464: if (l_vendor_site_id is not null) then
5465:
5466: fnd_message.set_name('PO', 'PO_PDOI_INVALID_VENDOR_SITE');
5467: fnd_message.set_token('VALUE', to_char(l_vendor_site_id), FALSE);
5468: l_textline := substr(fnd_message.get, 1, 240);
5469:
5470: INSERT INTO po_online_report_text_gt(online_report_id,

Line 5467: fnd_message.set_token('VALUE', to_char(l_vendor_site_id), FALSE);

5463: -- Check 12: check the validity of the vendor site.
5464: if (l_vendor_site_id is not null) then
5465:
5466: fnd_message.set_name('PO', 'PO_PDOI_INVALID_VENDOR_SITE');
5467: fnd_message.set_token('VALUE', to_char(l_vendor_site_id), FALSE);
5468: l_textline := substr(fnd_message.get, 1, 240);
5469:
5470: INSERT INTO po_online_report_text_gt(online_report_id,
5471: last_update_login,

Line 5468: l_textline := substr(fnd_message.get, 1, 240);

5464: if (l_vendor_site_id is not null) then
5465:
5466: fnd_message.set_name('PO', 'PO_PDOI_INVALID_VENDOR_SITE');
5467: fnd_message.set_token('VALUE', to_char(l_vendor_site_id), FALSE);
5468: l_textline := substr(fnd_message.get, 1, 240);
5469:
5470: INSERT INTO po_online_report_text_gt(online_report_id,
5471: last_update_login,
5472: last_updated_by,

Line 5509: fnd_message.set_name('PO', 'PO_PDOI_INVALID_VDR_CNTCT');

5505:
5506: -- check 13: validate vendor contact
5507: if (l_vendor_contact_id is not null) then
5508:
5509: fnd_message.set_name('PO', 'PO_PDOI_INVALID_VDR_CNTCT');
5510: fnd_message.set_token('VALUE', to_char(l_vendor_contact_id), FALSE);
5511: l_textline := substr(fnd_message.get, 1, 240);
5512:
5513: INSERT INTO po_online_report_text_gt(online_report_id,

Line 5510: fnd_message.set_token('VALUE', to_char(l_vendor_contact_id), FALSE);

5506: -- check 13: validate vendor contact
5507: if (l_vendor_contact_id is not null) then
5508:
5509: fnd_message.set_name('PO', 'PO_PDOI_INVALID_VDR_CNTCT');
5510: fnd_message.set_token('VALUE', to_char(l_vendor_contact_id), FALSE);
5511: l_textline := substr(fnd_message.get, 1, 240);
5512:
5513: INSERT INTO po_online_report_text_gt(online_report_id,
5514: last_update_login,

Line 5511: l_textline := substr(fnd_message.get, 1, 240);

5507: if (l_vendor_contact_id is not null) then
5508:
5509: fnd_message.set_name('PO', 'PO_PDOI_INVALID_VDR_CNTCT');
5510: fnd_message.set_token('VALUE', to_char(l_vendor_contact_id), FALSE);
5511: l_textline := substr(fnd_message.get, 1, 240);
5512:
5513: INSERT INTO po_online_report_text_gt(online_report_id,
5514: last_update_login,
5515: last_updated_by,

Line 5656: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_HEADER_NO_LINES');

5652:
5653: -- Check 1: Header must have at least one line
5654: -- PO_SUB_HEADER_NO_LINES
5655: -- Message inserted is 'Purchase Document has no lines'
5656: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_HEADER_NO_LINES');
5657: INSERT INTO po_online_report_text_gt(online_report_id,
5658: last_update_login,
5659: last_updated_by,
5660: last_update_date,

Line 5706: l_line_loc_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_LINE_LOC_TYPE_LOW_PAYITEMS');

5702:
5703: l_is_complex_po := PO_COMPLEX_WORK_PVT.is_complex_work_po(p_document_id);
5704:
5705: IF (l_is_complex_po) THEN
5706: l_line_loc_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_LINE_LOC_TYPE_LOW_PAYITEMS');
5707: ELSE
5708: l_line_loc_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_LINE_LOC_TYPE_LOW_SCHEDULES');
5709: END IF;
5710:

Line 5708: l_line_loc_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_LINE_LOC_TYPE_LOW_SCHEDULES');

5704:
5705: IF (l_is_complex_po) THEN
5706: l_line_loc_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_LINE_LOC_TYPE_LOW_PAYITEMS');
5707: ELSE
5708: l_line_loc_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_LINE_LOC_TYPE_LOW_SCHEDULES');
5709: END IF;
5710:
5711: FND_MESSAGE.SET_NAME('PO','PO_SUB_LINE_NO_SHIP');
5712: FND_MESSAGE.SET_TOKEN('LINE_LOCATION_TYPE', l_line_loc_token_value);

Line 5711: FND_MESSAGE.SET_NAME('PO','PO_SUB_LINE_NO_SHIP');

5707: ELSE
5708: l_line_loc_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_LINE_LOC_TYPE_LOW_SCHEDULES');
5709: END IF;
5710:
5711: FND_MESSAGE.SET_NAME('PO','PO_SUB_LINE_NO_SHIP');
5712: FND_MESSAGE.SET_TOKEN('LINE_LOCATION_TYPE', l_line_loc_token_value);
5713:
5714: l_textline := FND_MESSAGE.GET;
5715: INSERT INTO po_online_report_text_gt(online_report_id,

Line 5712: FND_MESSAGE.SET_TOKEN('LINE_LOCATION_TYPE', l_line_loc_token_value);

5708: l_line_loc_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_LINE_LOC_TYPE_LOW_SCHEDULES');
5709: END IF;
5710:
5711: FND_MESSAGE.SET_NAME('PO','PO_SUB_LINE_NO_SHIP');
5712: FND_MESSAGE.SET_TOKEN('LINE_LOCATION_TYPE', l_line_loc_token_value);
5713:
5714: l_textline := FND_MESSAGE.GET;
5715: INSERT INTO po_online_report_text_gt(online_report_id,
5716: last_update_login,

Line 5714: l_textline := FND_MESSAGE.GET;

5710:
5711: FND_MESSAGE.SET_NAME('PO','PO_SUB_LINE_NO_SHIP');
5712: FND_MESSAGE.SET_TOKEN('LINE_LOCATION_TYPE', l_line_loc_token_value);
5713:
5714: l_textline := FND_MESSAGE.GET;
5715: INSERT INTO po_online_report_text_gt(online_report_id,
5716: last_update_login,
5717: last_updated_by,
5718: last_update_date,

Line 5764: l_line_loc_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_LINE_LOC_TYPE_LOW_P_PAYITEM');

5760: --Check 3: Each PO shipment must have atleast one distribution
5761: --PO_SUB_SHIP_NO_DIST
5762:
5763: IF (l_is_complex_po) THEN
5764: l_line_loc_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_LINE_LOC_TYPE_LOW_P_PAYITEM');
5765: ELSE
5766: l_line_loc_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_LINE_LOC_TYPE_LOWER_S_SCH');
5767: END IF;
5768:

Line 5766: l_line_loc_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_LINE_LOC_TYPE_LOWER_S_SCH');

5762:
5763: IF (l_is_complex_po) THEN
5764: l_line_loc_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_LINE_LOC_TYPE_LOW_P_PAYITEM');
5765: ELSE
5766: l_line_loc_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_LINE_LOC_TYPE_LOWER_S_SCH');
5767: END IF;
5768:
5769: FND_MESSAGE.SET_NAME('PO', 'PO_SUB_SHIP_NO_DIST');
5770: FND_MESSAGE.SET_TOKEN('LINE_LOCATION_TYPE', l_line_loc_token_value);

Line 5769: FND_MESSAGE.SET_NAME('PO', 'PO_SUB_SHIP_NO_DIST');

5765: ELSE
5766: l_line_loc_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_LINE_LOC_TYPE_LOWER_S_SCH');
5767: END IF;
5768:
5769: FND_MESSAGE.SET_NAME('PO', 'PO_SUB_SHIP_NO_DIST');
5770: FND_MESSAGE.SET_TOKEN('LINE_LOCATION_TYPE', l_line_loc_token_value);
5771: l_textline := FND_MESSAGE.GET;
5772: INSERT INTO po_online_report_text_gt(online_report_id,
5773: last_update_login,

Line 5770: FND_MESSAGE.SET_TOKEN('LINE_LOCATION_TYPE', l_line_loc_token_value);

5766: l_line_loc_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_LINE_LOC_TYPE_LOWER_S_SCH');
5767: END IF;
5768:
5769: FND_MESSAGE.SET_NAME('PO', 'PO_SUB_SHIP_NO_DIST');
5770: FND_MESSAGE.SET_TOKEN('LINE_LOCATION_TYPE', l_line_loc_token_value);
5771: l_textline := FND_MESSAGE.GET;
5772: INSERT INTO po_online_report_text_gt(online_report_id,
5773: last_update_login,
5774: last_updated_by,

Line 5771: l_textline := FND_MESSAGE.GET;

5767: END IF;
5768:
5769: FND_MESSAGE.SET_NAME('PO', 'PO_SUB_SHIP_NO_DIST');
5770: FND_MESSAGE.SET_TOKEN('LINE_LOCATION_TYPE', l_line_loc_token_value);
5771: l_textline := FND_MESSAGE.GET;
5772: INSERT INTO po_online_report_text_gt(online_report_id,
5773: last_update_login,
5774: last_updated_by,
5775: last_update_date,

Line 5850: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_DIST_RATE_NULL');

5846: -- if the po header currency code is not the same as the sets of
5847: -- books currency code.
5848: -- PO_SUB_DIST_RATE_NULL
5849:
5850: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_DIST_RATE_NULL');
5851: INSERT INTO po_online_report_text_gt(online_report_id,
5852: last_update_login,
5853: last_updated_by,
5854: last_update_date,

Line 5909: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_DIST_RATE_NOT_NULL');

5905: END IF;
5906:
5907: -- Check 7: If using functional currency then rate has to be null.
5908: -- PO_SUB_DIST_RATE_NOT_NULL
5909: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_DIST_RATE_NOT_NULL');
5910: INSERT INTO po_online_report_text_gt(online_report_id,
5911: last_update_login,
5912: last_updated_by,
5913: last_update_date,

Line 5978: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_STD_CONTRACT_AMT_LIMIT');

5974: );
5975:
5976: IF (l_val_contract_limit = 0) THEN
5977:
5978: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_STD_CONTRACT_AMT_LIMIT');
5979: INSERT INTO po_online_report_text_gt(online_report_id,
5980: last_update_login,
5981: last_updated_by,
5982: last_update_date,

Line 6028: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_REF_UNAPPROVED_CONTRACT');

6024: -- PO_SUB_REF_UNAPPROVED_CONTRACT
6025: --< Bug 3422733 > Only do this check if Contract is not ON HOLD. The ON HOLD
6026: -- check is done later. Avoids showing 2 msgs for Contract that is ON HOLD.
6027:
6028: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_REF_UNAPPROVED_CONTRACT');
6029: INSERT INTO po_online_report_text_gt(online_report_id,
6030: last_update_login,
6031: last_updated_by,
6032: last_update_date,

Line 6086: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_LINE_CONTRACT_MISMATCH');

6082: -- Check 10: Any of the standard PO's lines should not reference a
6083: -- contract whose vendor is different than the one on PO header.
6084: -- PO_SUB_LINE_CONTRACT_MISMATCH
6085:
6086: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_LINE_CONTRACT_MISMATCH');
6087: INSERT INTO po_online_report_text_gt(online_report_id,
6088: last_update_login,
6089: last_updated_by,
6090: last_update_date,

Line 6179: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_UOM_CLASS_CONVERSION');

6175: -- Message inserted is:
6176: --'Line# Following Interclass UOM conversion is not defined or
6177: -- is disabled '
6178: -- Bug #1630662
6179: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_UOM_CLASS_CONVERSION');
6180: INSERT INTO po_online_report_text_gt(online_report_id,
6181: last_update_login,
6182: last_updated_by,
6183: last_update_date,

Line 6290: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_ITEM_NOT_APPROVED');

6286: is restricted by checking 'Use approved supplier list' there should be
6287: atlease one approved ASL either at item level or at category level
6288: if there is no item ASL*/
6289:
6290: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_ITEM_NOT_APPROVED');
6291: INSERT INTO po_online_report_text_gt(online_report_id,
6292: last_update_login,
6293: last_updated_by,
6294: last_update_date,

Line 6387: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_ITEM_ASL_DEBARRED');

6383: supplier flag'. This check would apply even for one time items.
6384: If supplier is debarred in any of the ASL item/category (Global/Local)
6385: (Suplier/Supplier+site) then the approval of the PO will not be allowed */
6386:
6387: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_ITEM_ASL_DEBARRED');
6388: INSERT INTO po_online_report_text_gt(online_report_id,
6389: last_update_login,
6390: last_updated_by,
6391: last_update_date,

Line 6472: l_textline := FND_MESSAGE.get_string('PO', 'PO_SUB_LINE_CONTRACT_HOLD');

6468:
6469: -- Check 15: Contract referenced on a PO line should not be on hold
6470: -- (If contract is in incomplete status)
6471:
6472: l_textline := FND_MESSAGE.get_string('PO', 'PO_SUB_LINE_CONTRACT_HOLD');
6473:
6474: INSERT INTO po_online_report_text_gt(
6475: online_report_id,
6476: last_update_login,

Line 6528: l_textline := FND_MESSAGE.get_string('PO', 'PO_SUB_LINE_CONTRACT_EXP');

6524:
6525: -- Check 16: Creation date of the contract should be within the effective
6526: -- dates of the contracts referenced
6527:
6528: l_textline := FND_MESSAGE.get_string('PO', 'PO_SUB_LINE_CONTRACT_EXP');
6529:
6530: INSERT INTO po_online_report_text_gt(
6531: online_report_id,
6532: last_update_login,

Line 6584: l_textline := FND_MESSAGE.get_string('PO', 'PO_ATO_ITEM_NA');

6580: END IF;
6581:
6582: -- Check 17: ATO/CTO Model items not allowed on PO's (Bug 3362369)
6583:
6584: l_textline := FND_MESSAGE.get_string('PO', 'PO_ATO_ITEM_NA');
6585:
6586: INSERT INTO po_online_report_text_gt(
6587: online_report_id,
6588: last_update_login,

Line 6641: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_ALL_NO_ITEM');

6637: l_api_name||'.' || l_progress,
6638: 'PO 18: Non Purchasable Item is not allowed');
6639: END IF;
6640: END IF;
6641: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_ALL_NO_ITEM');
6642: INSERT INTO po_online_report_text_gt(online_report_id,
6643: last_update_login,
6644: last_updated_by,
6645: last_update_date,

Line 6688: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_ALL_NO_ITEM');

6684: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || '.'||
6685: l_api_name||'.' || l_progress,
6686: 'PO 19: Non Purchasable Item is not allowed'); END IF;
6687: END IF;
6688: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_ALL_NO_ITEM');
6689: INSERT INTO po_online_report_text_gt(online_report_id,
6690: last_update_login,
6691: last_updated_by,
6692: last_update_date,

Line 6749: l_textline := FND_MESSAGE.get_string('PO', 'PO_PO_PLANNED_ITEM_DATE_REQ');

6745:
6746: -- Check 20: Either Promised Date or Need by date is required for planned
6747: -- items (ECO 4503425 for HTML Orders R12)
6748:
6749: l_textline := FND_MESSAGE.get_string('PO', 'PO_PO_PLANNED_ITEM_DATE_REQ');
6750:
6751: INSERT INTO po_online_report_text_gt(
6752: online_report_id,
6753: last_update_login,

Line 6914: l_tax_message := fnd_message.get_string('PO','PO_TAX_CALCULATION')||' : ' ;

6910: l_api_name||'.' || l_progress,
6911: 'PO 23: Calculate tax has errored out');
6912: END IF;
6913: END IF;
6914: l_tax_message := fnd_message.get_string('PO','PO_TAX_CALCULATION')||' : ' ;
6915: FORALL i IN 1..po_tax_interface_pvt.G_TAX_ERRORS_TBL.MESSAGE_TEXT.COUNT
6916: INSERT INTO po_online_report_text_gt
6917: (
6918: online_report_id,

Line 6963: fnd_message.set_name('PO','PO_TAX_CALC_UNEXPECTED_ERROR');

6959: l_textline := l_textline || po_tax_interface_pvt.G_TAX_ERRORS_TBL.MESSAGE_TEXT(1);
6960: ELSE
6961: l_textline := l_textline || SQLERRM();
6962: END IF;
6963: fnd_message.set_name('PO','PO_TAX_CALC_UNEXPECTED_ERROR');
6964: fnd_message.set_token('ERROR',l_textline);
6965: FND_MSG_PUB.Add;
6966: l_progress := '025';
6967: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6964: fnd_message.set_token('ERROR',l_textline);

6960: ELSE
6961: l_textline := l_textline || SQLERRM();
6962: END IF;
6963: fnd_message.set_name('PO','PO_TAX_CALC_UNEXPECTED_ERROR');
6964: fnd_message.set_token('ERROR',l_textline);
6965: FND_MSG_PUB.Add;
6966: l_progress := '025';
6967: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6968: END IF;

Line 6995: l_textline := FND_MESSAGE.get_string('PO', 'PO_SUB_VMI_ASL_EXISTS');

6991: fnd_profile.get(PO_PROFILES.PO_VMI_DISPLAY_WARNING,l_po_vmi_display_warning);
6992:
6993: IF (l_po_vmi_display_warning = 'Y') THEN
6994:
6995: l_textline := FND_MESSAGE.get_string('PO', 'PO_SUB_VMI_ASL_EXISTS');
6996:
6997: INSERT INTO po_online_report_text_gt(
6998: online_report_id,
6999: last_update_login,

Line 7226: l_textline := FND_MESSAGE.GET_STRING('PO','PO_SUB_PO_SHIP_INV_MATCH_NE_R');

7222: l_api_name||'.' || l_progress,'PO 24: Validate the LCM enabled PO to check whether its invoice match option is set as Receipt');
7223: END IF;
7224: END IF;
7225: -- Check 24: Validate the LCM enabled PO to check whether its invoice match option is set as 'Receipt'.
7226: l_textline := FND_MESSAGE.GET_STRING('PO','PO_SUB_PO_SHIP_INV_MATCH_NE_R');
7227: INSERT INTO po_online_report_text_gt (online_report_id,
7228: last_update_login,
7229: last_updated_by,
7230: last_update_date,

Line 7276: l_textline := FND_MESSAGE.GET_STRING('PO','PO_SUB_PO_DIST_DEST_TYPE_NE_IN');

7272:
7273:
7274: END IF;
7275: -- Check 25: Validate the LCM enabled PO to check whether its destination type is set as 'Inventory'
7276: l_textline := FND_MESSAGE.GET_STRING('PO','PO_SUB_PO_DIST_DEST_TYPE_NE_IN');
7277: INSERT INTO po_online_report_text_gt (online_report_id,
7278: last_update_login,
7279: last_updated_by,
7280: last_update_date,

Line 7388: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_AGREED_GRT_LIMIT');

7384: -- Check 1: The amount agreed specified on the planned po and blanket
7385: -- pa should be less than the amount limit.
7386: -- PO_SUB_AGREED_GRT_LIMIT
7387:
7388: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_AGREED_GRT_LIMIT');
7389: INSERT INTO po_online_report_text_gt(online_report_id,
7390: last_update_login,
7391: last_updated_by,
7392: last_update_date,

Line 7437: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_MINREL_GRT_LIMIT');

7433: -- Check 2: The min release amount specified on the planned po and
7434: -- blanket pa should be less than the amount limit.
7435: -- PO_SUB_MINREL_GRT_LIMIT
7436:
7437: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_MINREL_GRT_LIMIT');
7438: INSERT INTO po_online_report_text_gt(online_report_id,
7439: last_update_login,
7440: last_updated_by,
7441: last_update_date,

Line 7486: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_LIMIT_GRT_REL_AMT');

7482: -- Check 3: The Amount Limit should be greater than the total of all
7483: -- Releases.
7484: -- PO_SUB_LIMIT_GRT_REL_AMT
7485:
7486: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_LIMIT_GRT_REL_AMT');
7487: INSERT INTO po_online_report_text_gt(online_report_id,
7488: last_update_login,
7489: last_updated_by,
7490: last_update_date,

Line 7581: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SVC_PRICE_LIMIT_LT_PRICE');

7577: -- Check 4: The price limit when price_override_flag = 'Y' should be
7578: -- at least as large as the unit price for that line.
7579: -- PO_SVC_PRICE_LIMIT_LT_PRICE
7580:
7581: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SVC_PRICE_LIMIT_LT_PRICE');
7582:
7583:
7584: INSERT into po_online_report_text_gt(online_report_id,
7585: last_update_login,

Line 7697: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_HEADER_NO_LINES');

7693:
7694: -- Check 1: Blanket Header must have at least one line
7695: -- PO_SUB_HEADER_NO_LINES
7696: -- Message inserted is 'Purchase Document has no lines'
7697: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_HEADER_NO_LINES');
7698: INSERT INTO po_online_report_text_gt(online_report_id,
7699: last_update_login,
7700: last_updated_by,
7701: last_update_date,

Line 7786: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_ALL_NO_ITEM');

7782: l_api_name||'.' || l_progress,
7783: 'PO 04: Non Purchasable Item is not allowed');
7784: END IF;
7785: END IF;
7786: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_ALL_NO_ITEM');
7787: INSERT INTO po_online_report_text_gt(online_report_id,
7788: last_update_login,
7789: last_updated_by,
7790: last_update_date,

Line 7868: ||FND_MESSAGE.GET_STRING('PO', PO_MESSAGE_S.POX_EFFECTIVE_DATES1),1,240)

7864: CASE
7865: WHEN pll.start_date < ph.start_date
7866: THEN substr(g_linemsg||g_delim||pl.line_num||g_delim
7867: ||g_price_breakmsg||g_delim||pll.shipment_num||g_delim
7868: ||FND_MESSAGE.GET_STRING('PO', PO_MESSAGE_S.POX_EFFECTIVE_DATES1),1,240)
7869: WHEN pll.end_date > ph.end_date
7870: THEN substr(g_linemsg||g_delim||pl.line_num||g_delim
7871: ||g_price_breakmsg||g_delim||pll.shipment_num||g_delim
7872: ||FND_MESSAGE.GET_STRING('PO', PO_MESSAGE_S.POX_EFFECTIVE_DATES),1,240)

Line 7872: ||FND_MESSAGE.GET_STRING('PO', PO_MESSAGE_S.POX_EFFECTIVE_DATES),1,240)

7868: ||FND_MESSAGE.GET_STRING('PO', PO_MESSAGE_S.POX_EFFECTIVE_DATES1),1,240)
7869: WHEN pll.end_date > ph.end_date
7870: THEN substr(g_linemsg||g_delim||pl.line_num||g_delim
7871: ||g_price_breakmsg||g_delim||pll.shipment_num||g_delim
7872: ||FND_MESSAGE.GET_STRING('PO', PO_MESSAGE_S.POX_EFFECTIVE_DATES),1,240)
7873: WHEN pll.start_date > ph.end_date
7874: THEN substr(g_linemsg||g_delim||pl.line_num||g_delim
7875: ||g_price_breakmsg||g_delim||pll.shipment_num||g_delim
7876: ||FND_MESSAGE.GET_STRING('PO', PO_MESSAGE_S.POX_EFFECTIVE_DATES4),1,240)

Line 7876: ||FND_MESSAGE.GET_STRING('PO', PO_MESSAGE_S.POX_EFFECTIVE_DATES4),1,240)

7872: ||FND_MESSAGE.GET_STRING('PO', PO_MESSAGE_S.POX_EFFECTIVE_DATES),1,240)
7873: WHEN pll.start_date > ph.end_date
7874: THEN substr(g_linemsg||g_delim||pl.line_num||g_delim
7875: ||g_price_breakmsg||g_delim||pll.shipment_num||g_delim
7876: ||FND_MESSAGE.GET_STRING('PO', PO_MESSAGE_S.POX_EFFECTIVE_DATES4),1,240)
7877: WHEN pll.end_date < ph.start_date
7878: THEN substr(g_linemsg||g_delim||pl.line_num||g_delim
7879: ||g_price_breakmsg||g_delim||pll.shipment_num||g_delim
7880: ||FND_MESSAGE.GET_STRING('PO', PO_MESSAGE_S.POX_EFFECTIVE_DATES5),1,240)

Line 7880: ||FND_MESSAGE.GET_STRING('PO', PO_MESSAGE_S.POX_EFFECTIVE_DATES5),1,240)

7876: ||FND_MESSAGE.GET_STRING('PO', PO_MESSAGE_S.POX_EFFECTIVE_DATES4),1,240)
7877: WHEN pll.end_date < ph.start_date
7878: THEN substr(g_linemsg||g_delim||pl.line_num||g_delim
7879: ||g_price_breakmsg||g_delim||pll.shipment_num||g_delim
7880: ||FND_MESSAGE.GET_STRING('PO', PO_MESSAGE_S.POX_EFFECTIVE_DATES5),1,240)
7881: WHEN pll.start_date > pl.expiration_date
7882: THEN substr(g_linemsg||g_delim||pl.line_num||g_delim
7883: ||g_price_breakmsg||g_delim||pll.shipment_num||g_delim
7884: ||FND_MESSAGE.GET_STRING('PO', PO_MESSAGE_S.POX_EFFECTIVE_DATES6),1,240)

Line 7884: ||FND_MESSAGE.GET_STRING('PO', PO_MESSAGE_S.POX_EFFECTIVE_DATES6),1,240)

7880: ||FND_MESSAGE.GET_STRING('PO', PO_MESSAGE_S.POX_EFFECTIVE_DATES5),1,240)
7881: WHEN pll.start_date > pl.expiration_date
7882: THEN substr(g_linemsg||g_delim||pl.line_num||g_delim
7883: ||g_price_breakmsg||g_delim||pll.shipment_num||g_delim
7884: ||FND_MESSAGE.GET_STRING('PO', PO_MESSAGE_S.POX_EFFECTIVE_DATES6),1,240)
7885: WHEN pll.end_date > pl.expiration_date
7886: THEN substr(g_linemsg||g_delim||pl.line_num||g_delim
7887: ||g_price_breakmsg||g_delim||pll.shipment_num||g_delim
7888: ||FND_MESSAGE.GET_STRING('PO', PO_MESSAGE_S.POX_EFFECTIVE_DATES2),1,240)

Line 7888: ||FND_MESSAGE.GET_STRING('PO', PO_MESSAGE_S.POX_EFFECTIVE_DATES2),1,240)

7884: ||FND_MESSAGE.GET_STRING('PO', PO_MESSAGE_S.POX_EFFECTIVE_DATES6),1,240)
7885: WHEN pll.end_date > pl.expiration_date
7886: THEN substr(g_linemsg||g_delim||pl.line_num||g_delim
7887: ||g_price_breakmsg||g_delim||pll.shipment_num||g_delim
7888: ||FND_MESSAGE.GET_STRING('PO', PO_MESSAGE_S.POX_EFFECTIVE_DATES2),1,240)
7889: END
7890: ,
7891: CASE
7892: WHEN pll.start_date < ph.start_date

Line 7931: l_textline := FND_MESSAGE.GET_STRING('PO', PO_MESSAGE_S.POX_EXPIRATION_DATES);

7927: 'BPA 07: Checking the lines expiration date');
7928: END IF;
7929: END IF;
7930:
7931: l_textline := FND_MESSAGE.GET_STRING('PO', PO_MESSAGE_S.POX_EXPIRATION_DATES);
7932: INSERT INTO po_online_report_text_gt(online_report_id,
7933: last_update_login,
7934: last_updated_by,
7935: last_update_date,

Line 8233: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUP_CONS_DOC_REF_COEXIST');

8229: -- Organization cannot be used to create a consigned shipment because
8230: -- order line contains a document reference. Enter a new order line
8231: -- for this shipment.
8232:
8233: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUP_CONS_DOC_REF_COEXIST');
8234:
8235: INSERT INTO
8236: po_online_report_text_gt(online_report_id,
8237: last_update_login,

Line 8310: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUP_CONS_STATUS_MISMATCH');

8306: -- item_id and ship_to_organization_id, in the bulk collct select statement.
8307: -- SQL Why: Consigned status on shipments and that on ASL must match
8308: -- SQL Join: po_header_id, po_line_id
8309:
8310: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUP_CONS_STATUS_MISMATCH');
8311:
8312: SELECT POH.vendor_id,
8313: POH.vendor_site_id,
8314: POL.item_id,

Line 8538: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_STD_GA_DISABLED');

8534:
8535: --
8536: --Check 1: The GA should be enabled for purchasing in the current OU.
8537: --< Shared Proc FPJ > Bug 3301427: Only do this check for new SPO lines
8538: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_STD_GA_DISABLED');
8539: INSERT into po_online_report_text_gt(online_report_id,
8540: last_update_login,
8541: last_updated_by,
8542: last_update_date,

Line 8607: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_STD_GA_APPROVED');

8603: --< Shared Proc FPJ > Bug 3301427: Only do this check for new SPO lines
8604: --< Bug 3422733 > Only do this check if GA is not ON HOLD. The ON HOLD check
8605: -- is done later. Avoids showing 2 msgs for Contract that is ON HOLD.
8606:
8607: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_STD_GA_APPROVED');
8608: INSERT into po_online_report_text_gt(online_report_id,
8609: last_update_login,
8610: last_updated_by,
8611: last_update_date,

Line 8664: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_STD_GA_ON_HOLD');

8660: END IF;
8661:
8662: --Check 3: The GA should not be on hold.
8663: --< Shared Proc FPJ > Bug 3301427: Only do this check for new SPO lines
8664: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_STD_GA_ON_HOLD');
8665: INSERT into po_online_report_text_gt(online_report_id,
8666: last_update_login,
8667: last_updated_by,
8668: last_update_date,

Line 8723: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_STD_GA_VENDOR_MISMATCH');

8719: END IF;
8720: END IF;
8721:
8722: --Check 4: The vendor on the PO should match the GA.
8723: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_STD_GA_VENDOR_MISMATCH');
8724: INSERT into po_online_report_text_gt(online_report_id,
8725: last_update_login,
8726: last_updated_by,
8727: last_update_date,

Line 8777: FND_MESSAGE.GET_STRING('PO', 'PO_SUB_STD_GA_VDR_SITE_MISMT');

8773: --Check 5: The vendor site on the PO should match a vendor site on one of
8774: -- the GA's enabled org assignments.
8775: --< Shared Proc FPJ > Bug 3301427: Only do this check for new SPO lines
8776: l_textline :=
8777: FND_MESSAGE.GET_STRING('PO', 'PO_SUB_STD_GA_VDR_SITE_MISMT');
8778: INSERT into po_online_report_text_gt(online_report_id,
8779: last_update_login,
8780: last_updated_by,
8781: last_update_date,

Line 8842: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_STD_AFTER_GA_DATE');

8838: END IF;
8839:
8840: --Check 6: The PO creation date should be before Blanket(GA) or
8841: -- corresponding Line expiration date
8842: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_STD_AFTER_GA_DATE');
8843: INSERT into po_online_report_text_gt(online_report_id,
8844: last_update_login,
8845: last_updated_by,
8846: last_update_date,

Line 8898: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_STD_BEFORE_GA_DATE');

8894: END IF;
8895:
8896: --Check 7: The Need-by-date (or if NULL the PO creation date) should be
8897: -- after the start dates of the GA
8898: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_STD_BEFORE_GA_DATE');
8899: INSERT into po_online_report_text_gt(online_report_id,
8900: last_update_login,
8901: last_updated_by,
8902: last_update_date,

Line 8951: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_STD_GA_CURR_MISMATCH');

8947: END IF;
8948: END IF;
8949:
8950: --Check 8: The currency_code on the PO should match the GA.
8951: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_STD_GA_CURR_MISMATCH');
8952: INSERT into po_online_report_text_gt(online_report_id,
8953: last_update_login,
8954: last_updated_by,
8955: last_update_date,

Line 9115: FND_MESSAGE.GET_STRING('PO', 'PO_SUB_STD_AMT_GRT_GA_AMT_LMT');

9111:
9112: END LOOP;
9113:
9114: l_textline :=
9115: FND_MESSAGE.GET_STRING('PO', 'PO_SUB_STD_AMT_GRT_GA_AMT_LMT');
9116:
9117: --Go through all lines in current PO (which refer to a GA)
9118: FOR l_curr_doc_line_index IN 1..l_curr_doc_line_num.COUNT LOOP
9119:

Line 9269: FND_MESSAGE.GET_STRING('PO','PO_SUB_STD_GA_LINE_LESS_MINREL');

9265: --Check 11: The total amount on all the lines on the standard PO
9266: --referencing same GA line should be greater than the minimum release amount
9267: --on the GA line.
9268: l_textline := -- <2710030>
9269: FND_MESSAGE.GET_STRING('PO','PO_SUB_STD_GA_LINE_LESS_MINREL');
9270: INSERT into po_online_report_text_gt(online_report_id,
9271: last_update_login,
9272: last_updated_by,
9273: last_update_date,

Line 9428: l_textline := FND_MESSAGE.get_string ('PO', 'PO_SUB_STD_GC_NOT_EN_PUR');

9424: -- Check 1: Current OU should still be enabled for purchasing on the GC
9425: -- being referenced
9426: --< Shared Proc FPJ > Bug 3301427: Only do this check for new SPO lines
9427:
9428: l_textline := FND_MESSAGE.get_string ('PO', 'PO_SUB_STD_GC_NOT_EN_PUR');
9429:
9430: INSERT INTO po_online_report_text_gt (
9431: online_report_id,
9432: last_update_login,

Line 9501: l_textline := FND_MESSAGE.get_string ('PO', 'PO_SUB_STD_GC_INVALID_SITE');

9497: /* R12 GCPA
9498: Skip Vendor Site validation for Contracts having "Enable All Sites" is set to Y
9499: */
9500:
9501: l_textline := FND_MESSAGE.get_string ('PO', 'PO_SUB_STD_GC_INVALID_SITE');
9502:
9503: INSERT INTO po_online_report_text_gt (
9504: online_report_id,
9505: last_update_login,

Line 9683: l_textline := FND_MESSAGE.get_string('PO',

9679: 'PO STD GC 3: Amount Released Check');
9680: END IF;
9681: END IF;
9682:
9683: l_textline := FND_MESSAGE.get_string('PO',
9684: 'PO_SUB_STD_CONTRACT_AMT_LIMIT');
9685:
9686: -- Go through all lines in current PO (which refer to GCs)
9687: FOR l_curr_doc_line_index IN 1..l_curr_doc_line_num.COUNT LOOP

Line 9806: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_CONTRACT_AMT_LIMIT');

9802: -- PO_SUB_CONTRACT_AMT_LIMIT
9803: --: changed query to use Line qty/amt/price
9804: --instead of summing up the Line Loc values. The results should be
9805: --equivalent for SPOs.
9806: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_CONTRACT_AMT_LIMIT');
9807: INSERT INTO po_online_report_text_gt(online_report_id,
9808: last_update_login,
9809: last_updated_by,
9810: last_update_date,

Line 9996: l_textline := FND_MESSAGE.GET_STRING('IGC',

9992: l_textline := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
9993: p_encoded => 'F');
9994:
9995: IF l_textline = NULL THEN
9996: l_textline := FND_MESSAGE.GET_STRING('IGC',
9997: 'IGC_MULT_FISCAL_YEARS');
9998: END IF;
9999: --Deleting msg so that we can always use G_Last to get the
10000: --message we want

Line 13600: FND_MESSAGE.set_name('PO', 'PO_STATCHK_GENERAL_ERROR');

13596:
13597: l_progress := '050';
13598:
13599: IF x_return_status is null THEN -- no valid check status request specified
13600: FND_MESSAGE.set_name('PO', 'PO_STATCHK_GENERAL_ERROR');
13601: FND_MESSAGE.set_token('ERROR_TEXT', 'No Valid p_mode specified !');
13602: FND_MSG_PUB.Add;
13603: RAISE FND_API.G_EXC_ERROR;
13604: END IF;

Line 13601: FND_MESSAGE.set_token('ERROR_TEXT', 'No Valid p_mode specified !');

13597: l_progress := '050';
13598:
13599: IF x_return_status is null THEN -- no valid check status request specified
13600: FND_MESSAGE.set_name('PO', 'PO_STATCHK_GENERAL_ERROR');
13601: FND_MESSAGE.set_token('ERROR_TEXT', 'No Valid p_mode specified !');
13602: FND_MSG_PUB.Add;
13603: RAISE FND_API.G_EXC_ERROR;
13604: END IF;
13605:

Line 14750: l_textline := FND_MESSAGE.get_string('PO',l_msg_name);

14746: IF g_debug_stmt THEN
14747: PO_DEBUG.debug_var(l_log_head,l_progress,'l_msg_name',l_msg_name);
14748: END IF;
14749:
14750: l_textline := FND_MESSAGE.get_string('PO',l_msg_name);
14751:
14752: l_progress := '040';
14753: IF g_debug_stmt THEN
14754: PO_DEBUG.debug_var(l_log_head,l_progress,'l_textline',l_textline);

Line 15247: l_text_line := FND_MESSAGE.get_string('PO', 'PO_VENDOR_SITE_CCR_INVALID');

15243: ' Vendor site registration is not valid');
15244: END IF;
15245: END IF;
15246:
15247: l_text_line := FND_MESSAGE.get_string('PO', 'PO_VENDOR_SITE_CCR_INVALID');
15248: INSERT INTO po_online_report_text_gt
15249: (online_report_id
15250: ,last_updated_by
15251: ,last_update_date

Line 15637: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_CAN_POH_WITH_RCV_TRX');

15633: THEN
15634:
15635: d_progress := 10;
15636:
15637: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_CAN_POH_WITH_RCV_TRX');
15638:
15639: INSERT INTO PO_ONLINE_REPORT_TEXT_GT
15640: ( online_report_id
15641: , last_update_login

Line 15689: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_CAN_REL_WITH_RCV_TRX');

15685: ELSE
15686:
15687: d_progress := 20;
15688:
15689: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_CAN_REL_WITH_RCV_TRX');
15690:
15691: INSERT INTO PO_ONLINE_REPORT_TEXT_GT
15692: ( online_report_id
15693: , last_update_login

Line 15744: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_CAN_POL_WITH_RCV_TRX');

15740: THEN
15741:
15742: d_progress := 30;
15743:
15744: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_CAN_POL_WITH_RCV_TRX');
15745:
15746: INSERT INTO PO_ONLINE_REPORT_TEXT_GT
15747: ( online_report_id
15748: , last_update_login

Line 15802: l_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_LINE_LOC_TYPE_LOW_P_PAYITEM');

15798: THEN
15799: l_is_complex_po := PO_COMPLEX_WORK_PVT.is_complex_work_po(p_document_id);
15800:
15801: IF (l_is_complex_po) THEN
15802: l_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_LINE_LOC_TYPE_LOW_P_PAYITEM');
15803: ELSE
15804: l_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_LINE_LOC_TYPE_LOWER_S_SCH');
15805: END IF;
15806:

Line 15804: l_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_LINE_LOC_TYPE_LOWER_S_SCH');

15800:
15801: IF (l_is_complex_po) THEN
15802: l_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_LINE_LOC_TYPE_LOW_P_PAYITEM');
15803: ELSE
15804: l_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_LINE_LOC_TYPE_LOWER_S_SCH');
15805: END IF;
15806:
15807: FND_MESSAGE.SET_NAME('PO','PO_CAN_POLL_WITH_RCV_TRX');
15808: FND_MESSAGE.SET_TOKEN('LINE_LOCATION_TYPE', l_token_value);

Line 15807: FND_MESSAGE.SET_NAME('PO','PO_CAN_POLL_WITH_RCV_TRX');

15803: ELSE
15804: l_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_LINE_LOC_TYPE_LOWER_S_SCH');
15805: END IF;
15806:
15807: FND_MESSAGE.SET_NAME('PO','PO_CAN_POLL_WITH_RCV_TRX');
15808: FND_MESSAGE.SET_TOKEN('LINE_LOCATION_TYPE', l_token_value);
15809:
15810: l_textline := FND_MESSAGE.GET;
15811: ELSE

Line 15808: FND_MESSAGE.SET_TOKEN('LINE_LOCATION_TYPE', l_token_value);

15804: l_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_LINE_LOC_TYPE_LOWER_S_SCH');
15805: END IF;
15806:
15807: FND_MESSAGE.SET_NAME('PO','PO_CAN_POLL_WITH_RCV_TRX');
15808: FND_MESSAGE.SET_TOKEN('LINE_LOCATION_TYPE', l_token_value);
15809:
15810: l_textline := FND_MESSAGE.GET;
15811: ELSE
15812: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_CAN_RELS_WITH_RCV_TRX');

Line 15810: l_textline := FND_MESSAGE.GET;

15806:
15807: FND_MESSAGE.SET_NAME('PO','PO_CAN_POLL_WITH_RCV_TRX');
15808: FND_MESSAGE.SET_TOKEN('LINE_LOCATION_TYPE', l_token_value);
15809:
15810: l_textline := FND_MESSAGE.GET;
15811: ELSE
15812: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_CAN_RELS_WITH_RCV_TRX');
15813: END IF;
15814:

Line 15812: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_CAN_RELS_WITH_RCV_TRX');

15808: FND_MESSAGE.SET_TOKEN('LINE_LOCATION_TYPE', l_token_value);
15809:
15810: l_textline := FND_MESSAGE.GET;
15811: ELSE
15812: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_CAN_RELS_WITH_RCV_TRX');
15813: END IF;
15814:
15815: INSERT INTO PO_ONLINE_REPORT_TEXT_GT
15816: ( online_report_id

Line 15938: l_text_normal_po := FND_MESSAGE.GET_STRING('PO', 'PO_CAN_POLL_WITH_ASN');

15934: END IF;
15935:
15936: d_progress := 10;
15937:
15938: l_text_normal_po := FND_MESSAGE.GET_STRING('PO', 'PO_CAN_POLL_WITH_ASN');
15939: l_text_complex_po := FND_MESSAGE.GET_STRING('PO', 'PO_CAN_POLL_WITH_PENDING_WCR');
15940:
15941: --: change message to use Work Confirmation instead of ASN for Complex Work
15942: INSERT INTO PO_ONLINE_REPORT_TEXT_GT

Line 15939: l_text_complex_po := FND_MESSAGE.GET_STRING('PO', 'PO_CAN_POLL_WITH_PENDING_WCR');

15935:
15936: d_progress := 10;
15937:
15938: l_text_normal_po := FND_MESSAGE.GET_STRING('PO', 'PO_CAN_POLL_WITH_ASN');
15939: l_text_complex_po := FND_MESSAGE.GET_STRING('PO', 'PO_CAN_POLL_WITH_PENDING_WCR');
15940:
15941: --: change message to use Work Confirmation instead of ASN for Complex Work
15942: INSERT INTO PO_ONLINE_REPORT_TEXT_GT
15943: ( online_report_id

Line 16303: l_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_LINE_LOC_TYPE_LOW_P_PAYITEM');

16299: l_is_complex_po := PO_COMPLEX_WORK_PVT.is_complex_work_po(p_document_id);
16300: end if;
16301:
16302: IF (l_is_complex_po) THEN
16303: l_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_LINE_LOC_TYPE_LOW_P_PAYITEM');
16304: ELSE
16305: l_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_LINE_LOC_TYPE_LOWER_S_SCH');
16306: END IF;
16307:

Line 16305: l_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_LINE_LOC_TYPE_LOWER_S_SCH');

16301:
16302: IF (l_is_complex_po) THEN
16303: l_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_LINE_LOC_TYPE_LOW_P_PAYITEM');
16304: ELSE
16305: l_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_LINE_LOC_TYPE_LOWER_S_SCH');
16306: END IF;
16307:
16308: FND_MESSAGE.SET_NAME('PO','PO_CAN_POLL_INVALID_ACCT_FLEX');
16309: FND_MESSAGE.SET_TOKEN('LINE_LOCATION_TYPE', l_token_value);

Line 16308: FND_MESSAGE.SET_NAME('PO','PO_CAN_POLL_INVALID_ACCT_FLEX');

16304: ELSE
16305: l_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_LINE_LOC_TYPE_LOWER_S_SCH');
16306: END IF;
16307:
16308: FND_MESSAGE.SET_NAME('PO','PO_CAN_POLL_INVALID_ACCT_FLEX');
16309: FND_MESSAGE.SET_TOKEN('LINE_LOCATION_TYPE', l_token_value);
16310:
16311: l_textline := FND_MESSAGE.GET;
16312:

Line 16309: FND_MESSAGE.SET_TOKEN('LINE_LOCATION_TYPE', l_token_value);

16305: l_token_value := FND_MESSAGE.GET_STRING('PO', 'PO_LINE_LOC_TYPE_LOWER_S_SCH');
16306: END IF;
16307:
16308: FND_MESSAGE.SET_NAME('PO','PO_CAN_POLL_INVALID_ACCT_FLEX');
16309: FND_MESSAGE.SET_TOKEN('LINE_LOCATION_TYPE', l_token_value);
16310:
16311: l_textline := FND_MESSAGE.GET;
16312:
16313: INSERT INTO PO_ONLINE_REPORT_TEXT_GT

Line 16311: l_textline := FND_MESSAGE.GET;

16307:
16308: FND_MESSAGE.SET_NAME('PO','PO_CAN_POLL_INVALID_ACCT_FLEX');
16309: FND_MESSAGE.SET_TOKEN('LINE_LOCATION_TYPE', l_token_value);
16310:
16311: l_textline := FND_MESSAGE.GET;
16312:
16313: INSERT INTO PO_ONLINE_REPORT_TEXT_GT
16314: ( online_report_id
16315: , last_update_login

Line 16415: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_CAN_POL_PLAN_WITH_OPEN_REL');

16411: END IF;
16412:
16413: d_progress := 10;
16414:
16415: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_CAN_POL_PLAN_WITH_OPEN_REL');
16416:
16417: INSERT INTO PO_ONLINE_REPORT_TEXT_GT
16418: ( online_report_id
16419: , last_update_login

Line 16512: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_CAN_GAL_WITH_OPEN_STD_REF');

16508: END IF;
16509:
16510: d_progress := 10;
16511:
16512: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_CAN_GAL_WITH_OPEN_STD_REF');
16513:
16514: INSERT INTO PO_ONLINE_REPORT_TEXT_GT
16515: ( online_report_id
16516: , last_update_login

Line 16608: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_CAN_CGA_WITH_OPEN_STD_REF');

16604: END IF;
16605:
16606: d_progress := 10;
16607:
16608: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_CAN_CGA_WITH_OPEN_STD_REF');
16609:
16610: INSERT INTO PO_ONLINE_REPORT_TEXT_GT
16611: ( online_report_id
16612: , last_update_login

Line 16704: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_CAN_POLL_PLAN_WITH_OPEN_REL');

16700: END IF;
16701:
16702: d_progress := 10;
16703:
16704: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_CAN_POLL_PLAN_WITH_OPEN_REL');
16705:
16706: INSERT INTO PO_ONLINE_REPORT_TEXT_GT
16707: ( online_report_id
16708: , last_update_login

Line 17282: FND_MESSAGE.set_name('PO','CWPOTODOMESSAGE');

17278:
17279: IF (p_add_reasons_to_msg_list = PO_CORE_S.G_PARAMETER_YES) THEN
17280: d_progress := 40;
17281: -- : FILL IN THE MESSAGES
17282: FND_MESSAGE.set_name('PO','CWPOTODOMESSAGE');
17283: FND_MSG_PUB.add;
17284: END IF;
17285: END IF;
17286:

Line 17678: l_textline := FND_MESSAGE.GET_STRING('PO',l_message_name);

17674: l_invoice_type := 'CREDIT';
17675:
17676: IF (p_document_level = g_document_level_HEADER) THEN
17677: l_message_name := 'PO_UNRES_AP_DOCS_PENDING';
17678: l_textline := FND_MESSAGE.GET_STRING('PO',l_message_name);
17679: ELSIF (p_document_level = g_document_level_LINE) THEN
17680: l_message_name := 'PO_UNRES_POL_AP_DOCS_PENDING';
17681: l_textline := FND_MESSAGE.GET_STRING('PO',l_message_name);
17682: ELSIF (p_document_level = g_document_level_SHIPMENT) THEN

Line 17681: l_textline := FND_MESSAGE.GET_STRING('PO',l_message_name);

17677: l_message_name := 'PO_UNRES_AP_DOCS_PENDING';
17678: l_textline := FND_MESSAGE.GET_STRING('PO',l_message_name);
17679: ELSIF (p_document_level = g_document_level_LINE) THEN
17680: l_message_name := 'PO_UNRES_POL_AP_DOCS_PENDING';
17681: l_textline := FND_MESSAGE.GET_STRING('PO',l_message_name);
17682: ELSIF (p_document_level = g_document_level_SHIPMENT) THEN
17683: IF (l_is_complex_po) THEN
17684: l_message_name := 'PO_UNRES_POPI_AP_DOCS_PENDING';
17685: l_textline := FND_MESSAGE.GET_STRING('PO',l_message_name);

Line 17685: l_textline := FND_MESSAGE.GET_STRING('PO',l_message_name);

17681: l_textline := FND_MESSAGE.GET_STRING('PO',l_message_name);
17682: ELSIF (p_document_level = g_document_level_SHIPMENT) THEN
17683: IF (l_is_complex_po) THEN
17684: l_message_name := 'PO_UNRES_POPI_AP_DOCS_PENDING';
17685: l_textline := FND_MESSAGE.GET_STRING('PO',l_message_name);
17686: ELSE
17687: l_message_name := 'PO_UNRES_POLL_AP_DOCS_PENDING';
17688: l_textline := FND_MESSAGE.GET_STRING('PO',l_message_name);
17689: END IF;

Line 17688: l_textline := FND_MESSAGE.GET_STRING('PO',l_message_name);

17684: l_message_name := 'PO_UNRES_POPI_AP_DOCS_PENDING';
17685: l_textline := FND_MESSAGE.GET_STRING('PO',l_message_name);
17686: ELSE
17687: l_message_name := 'PO_UNRES_POLL_AP_DOCS_PENDING';
17688: l_textline := FND_MESSAGE.GET_STRING('PO',l_message_name);
17689: END IF;
17690: ELSIF (p_document_level = g_document_level_DISTRIBUTION) THEN
17691: l_message_name := 'PO_UNRES_POD_AP_DOCS_PENDING';
17692: l_textline := FND_MESSAGE.GET_STRING('PO',l_message_name);

Line 17692: l_textline := FND_MESSAGE.GET_STRING('PO',l_message_name);

17688: l_textline := FND_MESSAGE.GET_STRING('PO',l_message_name);
17689: END IF;
17690: ELSIF (p_document_level = g_document_level_DISTRIBUTION) THEN
17691: l_message_name := 'PO_UNRES_POD_AP_DOCS_PENDING';
17692: l_textline := FND_MESSAGE.GET_STRING('PO',l_message_name);
17693: END IF;
17694: ELSIF (p_action_requested = g_action_FINAL_CLOSE_CHECK) THEN
17695: l_invoice_type := 'BOTH';
17696:

Line 17699: l_textline := FND_MESSAGE.GET_STRING('PO',l_message_name);

17695: l_invoice_type := 'BOTH';
17696:
17697: IF (p_document_level = g_document_level_HEADER) THEN
17698: l_message_name := 'PO_FC_POH_AP_DOCS_PENDING';
17699: l_textline := FND_MESSAGE.GET_STRING('PO',l_message_name);
17700: ELSIF (p_document_level = g_document_level_LINE) THEN
17701: l_message_name := 'PO_FC_POL_AP_DOCS_PENDING';
17702: l_textline := FND_MESSAGE.GET_STRING('PO',l_message_name);
17703: ELSIF (p_document_level = g_document_level_SHIPMENT) THEN

Line 17702: l_textline := FND_MESSAGE.GET_STRING('PO',l_message_name);

17698: l_message_name := 'PO_FC_POH_AP_DOCS_PENDING';
17699: l_textline := FND_MESSAGE.GET_STRING('PO',l_message_name);
17700: ELSIF (p_document_level = g_document_level_LINE) THEN
17701: l_message_name := 'PO_FC_POL_AP_DOCS_PENDING';
17702: l_textline := FND_MESSAGE.GET_STRING('PO',l_message_name);
17703: ELSIF (p_document_level = g_document_level_SHIPMENT) THEN
17704: IF (l_is_complex_po) THEN
17705: l_message_name := 'PO_FC_POPI_AP_DOCS_PENDING';
17706: l_textline := FND_MESSAGE.GET_STRING('PO',l_message_name);

Line 17706: l_textline := FND_MESSAGE.GET_STRING('PO',l_message_name);

17702: l_textline := FND_MESSAGE.GET_STRING('PO',l_message_name);
17703: ELSIF (p_document_level = g_document_level_SHIPMENT) THEN
17704: IF (l_is_complex_po) THEN
17705: l_message_name := 'PO_FC_POPI_AP_DOCS_PENDING';
17706: l_textline := FND_MESSAGE.GET_STRING('PO',l_message_name);
17707: ELSE
17708: l_message_name := 'PO_FC_POLL_AP_DOCS_PENDING';
17709: l_textline := FND_MESSAGE.GET_STRING('PO',l_message_name);
17710: END IF;

Line 17709: l_textline := FND_MESSAGE.GET_STRING('PO',l_message_name);

17705: l_message_name := 'PO_FC_POPI_AP_DOCS_PENDING';
17706: l_textline := FND_MESSAGE.GET_STRING('PO',l_message_name);
17707: ELSE
17708: l_message_name := 'PO_FC_POLL_AP_DOCS_PENDING';
17709: l_textline := FND_MESSAGE.GET_STRING('PO',l_message_name);
17710: END IF;
17711: END IF;
17712: END IF;
17713: l_calling_sequence := l_message_name; -- can be any string(tracking in AP)