DBA Data[Home] [Help]

APPS.PO_RELGEN_PKG dependencies on FND_MESSAGE

Line 16: g_reqmsg CONSTANT VARCHAR2(75) := substr(FND_MESSAGE.GET_STRING('PO', 'PO_REQ_TYPE'),1,25);

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

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

15:
16: g_reqmsg CONSTANT VARCHAR2(75) := substr(FND_MESSAGE.GET_STRING('PO', 'PO_REQ_TYPE'),1,25);
17:
18: --Contains message 'Line#'
19: g_linemsg CONSTANT VARCHAR2(75) := substr(FND_MESSAGE.GET_STRING('PO', 'PO_ZMVOR_LINE'), 1,25);
20:
21: --Contains message 'Shipment#'
22: g_shipmsg CONSTANT VARCHAR2(75) := substr(FND_MESSAGE.GET_STRING('PO', 'PO_ZMVOR_SHIPMENT'), 1,25);
23:

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

18: --Contains message 'Line#'
19: g_linemsg CONSTANT VARCHAR2(75) := substr(FND_MESSAGE.GET_STRING('PO', 'PO_ZMVOR_LINE'), 1,25);
20:
21: --Contains message 'Shipment#'
22: g_shipmsg CONSTANT VARCHAR2(75) := substr(FND_MESSAGE.GET_STRING('PO', 'PO_ZMVOR_SHIPMENT'), 1,25);
23:
24: --Contains message 'Distribution#'
25: g_distmsg CONSTANT VARCHAR2(75) := substr(FND_MESSAGE.GET_STRING('PO', 'PO_ZMVOR_DISTRIBUTION'), 1,25);
26:

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

21: --Contains message 'Shipment#'
22: g_shipmsg CONSTANT VARCHAR2(75) := substr(FND_MESSAGE.GET_STRING('PO', 'PO_ZMVOR_SHIPMENT'), 1,25);
23:
24: --Contains message 'Distribution#'
25: g_distmsg CONSTANT VARCHAR2(75) := substr(FND_MESSAGE.GET_STRING('PO', 'PO_ZMVOR_DISTRIBUTION'), 1,25);
26:
27: g_pkg_name CONSTANT VARCHAR2(30) := 'PO_RELGEN_PKG';
28: c_log_head CONSTANT VARCHAR2(50) := 'po.plsql.'|| G_PKG_NAME || '.';
29:

Line 181: fnd_message.set_name ('PO', 'PO_REQ_BPA_CONVERT_UOM');

177:
178: /* if the profile is unset we take it as yes because we want
179: the create releases to behave as earlier */
180:
181: fnd_message.set_name ('PO', 'PO_REQ_BPA_CONVERT_UOM');
182: fnd_message.set_token('REQ', x_req_num);
183: fnd_message.set_token('LINE', x_req_line_num);
184: x_error_msg := fnd_message.get;
185: fnd_file.put_line(fnd_file.log,x_error_msg);

Line 182: fnd_message.set_token('REQ', x_req_num);

178: /* if the profile is unset we take it as yes because we want
179: the create releases to behave as earlier */
180:
181: fnd_message.set_name ('PO', 'PO_REQ_BPA_CONVERT_UOM');
182: fnd_message.set_token('REQ', x_req_num);
183: fnd_message.set_token('LINE', x_req_line_num);
184: x_error_msg := fnd_message.get;
185: fnd_file.put_line(fnd_file.log,x_error_msg);
186: x_no_convert_flag := 'Y';

Line 183: fnd_message.set_token('LINE', x_req_line_num);

179: the create releases to behave as earlier */
180:
181: fnd_message.set_name ('PO', 'PO_REQ_BPA_CONVERT_UOM');
182: fnd_message.set_token('REQ', x_req_num);
183: fnd_message.set_token('LINE', x_req_line_num);
184: x_error_msg := fnd_message.get;
185: fnd_file.put_line(fnd_file.log,x_error_msg);
186: x_no_convert_flag := 'Y';
187:

Line 184: x_error_msg := fnd_message.get;

180:
181: fnd_message.set_name ('PO', 'PO_REQ_BPA_CONVERT_UOM');
182: fnd_message.set_token('REQ', x_req_num);
183: fnd_message.set_token('LINE', x_req_line_num);
184: x_error_msg := fnd_message.get;
185: fnd_file.put_line(fnd_file.log,x_error_msg);
186: x_no_convert_flag := 'Y';
187:
188: END IF;

Line 2293: x_error_msg := FND_MESSAGE.GET_STRING('PO',

2289: IF (release_amount < min_release_amount)
2290: THEN
2291: -- Bug 2701147 START
2292: -- Write an error message to the log file.
2293: x_error_msg := FND_MESSAGE.GET_STRING('PO',
2294: 'PO_SUB_REL_AMT_LESS_MINREL_AMT');
2295: FND_FILE.put_line(FND_FILE.LOG,
2296: substr(g_reqmsg||g_delim||x_req_num||g_delim||g_linemsg||g_delim||
2297: x_req_line_num||g_delim||

Line 2308: fnd_message.set_name ('PO', 'PO_REQ_REL_AMT_GRT_LIMIT_AMT');

2304: THEN
2305: /* Bug#2057344 Added the below piece of code to write the message
2306: PO_REQ_REL_AMT_GRT_LIMIT_AMT to the log file when the Total Release amount is
2307: greater than the Amount in BPO */
2308: fnd_message.set_name ('PO', 'PO_REQ_REL_AMT_GRT_LIMIT_AMT');
2309: fnd_message.set_token('REQ_NUM', x_req_num);
2310: fnd_message.set_token('LINE_NUM', x_req_line_num);
2311: fnd_message.set_token('PO_NUM',x_po_num);
2312: x_error_msg := fnd_message.get;

Line 2309: fnd_message.set_token('REQ_NUM', x_req_num);

2305: /* Bug#2057344 Added the below piece of code to write the message
2306: PO_REQ_REL_AMT_GRT_LIMIT_AMT to the log file when the Total Release amount is
2307: greater than the Amount in BPO */
2308: fnd_message.set_name ('PO', 'PO_REQ_REL_AMT_GRT_LIMIT_AMT');
2309: fnd_message.set_token('REQ_NUM', x_req_num);
2310: fnd_message.set_token('LINE_NUM', x_req_line_num);
2311: fnd_message.set_token('PO_NUM',x_po_num);
2312: x_error_msg := fnd_message.get;
2313: fnd_file.put_line(fnd_file.log,x_error_msg);

Line 2310: fnd_message.set_token('LINE_NUM', x_req_line_num);

2306: PO_REQ_REL_AMT_GRT_LIMIT_AMT to the log file when the Total Release amount is
2307: greater than the Amount in BPO */
2308: fnd_message.set_name ('PO', 'PO_REQ_REL_AMT_GRT_LIMIT_AMT');
2309: fnd_message.set_token('REQ_NUM', x_req_num);
2310: fnd_message.set_token('LINE_NUM', x_req_line_num);
2311: fnd_message.set_token('PO_NUM',x_po_num);
2312: x_error_msg := fnd_message.get;
2313: fnd_file.put_line(fnd_file.log,x_error_msg);
2314: x_check_status := FND_API.G_RET_STS_ERROR; -- Bug 2701147

Line 2311: fnd_message.set_token('PO_NUM',x_po_num);

2307: greater than the Amount in BPO */
2308: fnd_message.set_name ('PO', 'PO_REQ_REL_AMT_GRT_LIMIT_AMT');
2309: fnd_message.set_token('REQ_NUM', x_req_num);
2310: fnd_message.set_token('LINE_NUM', x_req_line_num);
2311: fnd_message.set_token('PO_NUM',x_po_num);
2312: x_error_msg := fnd_message.get;
2313: fnd_file.put_line(fnd_file.log,x_error_msg);
2314: x_check_status := FND_API.G_RET_STS_ERROR; -- Bug 2701147
2315: END IF;

Line 2312: x_error_msg := fnd_message.get;

2308: fnd_message.set_name ('PO', 'PO_REQ_REL_AMT_GRT_LIMIT_AMT');
2309: fnd_message.set_token('REQ_NUM', x_req_num);
2310: fnd_message.set_token('LINE_NUM', x_req_line_num);
2311: fnd_message.set_token('PO_NUM',x_po_num);
2312: x_error_msg := fnd_message.get;
2313: fnd_file.put_line(fnd_file.log,x_error_msg);
2314: x_check_status := FND_API.G_RET_STS_ERROR; -- Bug 2701147
2315: END IF;
2316:

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

2709: > (l_price_tolerance_allowed + 1.000001))
2710: THEN
2711: l_progress := '009';
2712: --Report the price tolerance error
2713: l_textline := FND_MESSAGE.GET_STRING('PO',
2714: 'PO_SUB_REQ_PRICE_TOL_EXCEED');
2715: get_req_info_from_po_shipment(
2716: l_line_location_id(shipment_line),
2717: l_req_num, l_req_line_num);

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

2792: THEN
2793: l_progress := '012';
2794: --Report the price amount exceeded error
2795: l_textline :=
2796: FND_MESSAGE.GET_STRING('PO', 'PO_SUB_REQ_AMT_TOL_EXCEED');
2797: get_req_info_from_po_shipment(
2798: l_line_location_id(shipment_line),
2799: l_req_num, l_req_line_num);
2800: FND_FILE.put_line(FND_FILE.LOG,

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

2906: -- Check 12: The Amount being released for all shipments for a particular line
2907: -- must be greater than the min release amount specified in agreement line
2908: -- PO_SUB_REL_SHIPAMT_LESS_MINREL
2909:
2910: l_textline := FND_MESSAGE.GET_STRING('PO','PO_SUB_REL_SHIPAMT_LESS_MINREL');
2911: SELECT substr(g_reqmsg||g_delim||p_req_num||g_delim||
2912: g_linemsg||g_delim||p_req_line_num||
2913: g_delim||l_textline||g_delim||POL.min_release_amount,1,240)
2914: BULK COLLECT INTO l_error_messages

Line 2966: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_PDOI_INVALID_GL_ENC_PER');

2962: IF l_purch_enc_flag = 'Y' THEN
2963:
2964: -- bug 3296181
2965: -- Changed the message name.
2966: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_PDOI_INVALID_GL_ENC_PER');
2967: SELECT substr(l_textline,1,240),
2968: POD.po_distribution_id
2969: BULK COLLECT INTO l_error_messages, l_dist_id
2970: FROM PO_DISTRIBUTIONS POD, PO_LINE_LOCATIONS PLL, PO_LINES POL

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

3019: -- Message inserted is:
3020: --'Following Interclass UOM conversion is not defined or
3021: -- is disabled '
3022: -- Bug #1630662
3023: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_UOM_CLASS_CONVERSION');
3024: SELECT substr(l_textline||g_delim||
3025: MTL1.uom_class||' , '||MTL2.uom_class,1,240),
3026: POLL.line_location_id
3027: BULK COLLECT INTO l_error_messages, l_line_location_id

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

3066: -- Check 15: If an item is restricted then the Purchase Order Vendor
3067: -- must be listed in the Approved Suppliers List table and must be approved.
3068: -- PO_SUB_ITEM_NOT_APPROVED_REL
3069: -- Bug# 2461828
3070: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_ITEM_NOT_APPROVED_REL');
3071: SELECT substr(g_reqmsg||g_delim||p_req_num||g_delim||
3072: g_linemsg||g_delim||p_req_line_num||
3073: g_delim||l_textline,1,240)
3074: BULK COLLECT INTO l_error_messages

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

3140: -- List table and must be approved for release to get approved.
3141: -- Bug 839743
3142: -- PO_SUB_ITEM_ASL_DEBARRED_REL
3143:
3144: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_ITEM_ASL_DEBARRED_REL');
3145: SELECT substr(g_reqmsg||g_delim||p_req_num||g_delim||
3146: g_linemsg||g_delim||p_req_line_num||
3147: g_delim||l_textline,1,240)
3148: BULK COLLECT INTO l_error_messages

Line 3241: l_textline := FND_MESSAGE.get_string('PO', 'PO_VENDOR_SITE_CCR_INVALID');

3237: p_vendor_id => l_vendor_id,
3238: p_vendor_site_id => l_vendor_site_id);
3239:
3240: IF NOT l_valid_registration THEN
3241: l_textline := FND_MESSAGE.get_string('PO', 'PO_VENDOR_SITE_CCR_INVALID');
3242: FND_FILE.put_line(FND_FILE.LOG, substr(g_reqmsg||g_delim
3243: ||p_req_num||g_delim||g_linemsg||g_delim
3244: ||p_req_line_num||g_delim||l_textline,1,240));
3245: x_check_status := FND_API.G_RET_STS_ERROR;

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

3255: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || '.'||l_api_name||'.'
3256: || l_progress,'LCM enabled release shipment should have invoice match option as receipt');
3257: END IF;
3258: END IF;
3259: l_textline := FND_MESSAGE.GET_STRING('PO','PO_SUB_REL_SHIP_INV_MATCH_NE_R');
3260:
3261: SELECT substr (g_shipmsg||g_delim||PLL.shipment_num||g_delim||l_textline,1,240)
3262: BULK COLLECT INTO l_error_messages
3263: FROM PO_RELEASES_ALL POR,

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

3281: || l_progress,'LCM enabled release distribution should have destination type as Inventory');
3282: END IF;
3283: END IF;
3284:
3285: l_textline := FND_MESSAGE.GET_STRING('PO','PO_SUB_REL_DIST_DEST_TYPE_NE_I');
3286:
3287: SELECT substr (g_shipmsg||g_delim||PLL.shipment_num||g_delim||g_distmsg||g_delim||
3288: POD.distribution_num||g_delim||l_textline, 1,240)
3289: BULK COLLECT INTO l_error_messages