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_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 40: g_bpamsg CONSTANT VARCHAR2(75) := substr(FND_MESSAGE.GET_STRING('PO', 'PO_BLANKET_PO'),1,26) ;--12553671

36: g_chktype_TRACKING_QTY_IND CONSTANT
37: MTL_SYSTEM_ITEMS_B.TRACKING_QUANTITY_IND%TYPE
38: := 'PS';
39:
40: g_bpamsg CONSTANT VARCHAR2(75) := substr(FND_MESSAGE.GET_STRING('PO', 'PO_BLANKET_PO'),1,26) ;--12553671
41:
42: -- Private procedure:
43: PROCEDURE preapproval_checks( p_po_header_id IN NUMBER,
44: p_req_num IN VARCHAR2,

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

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

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

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

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

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

Line 185: x_error_msg := fnd_message.get;

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

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

2314: IF (release_amount < min_release_amount)
2315: THEN
2316: -- Bug 2701147 START
2317: -- Write an error message to the log file.
2318: x_error_msg := FND_MESSAGE.GET_STRING('PO',
2319: 'PO_SUB_REL_AMT_LESS_MINREL_AMT');
2320: FND_FILE.put_line(FND_FILE.LOG,
2321: substr(g_reqmsg||g_delim||x_req_num||g_delim||g_linemsg||g_delim||
2322: x_req_line_num||g_delim||

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

2329: THEN
2330: /* Bug#2057344 Added the below piece of code to write the message
2331: PO_REQ_REL_AMT_GRT_LIMIT_AMT to the log file when the Total Release amount is
2332: greater than the Amount in BPO */
2333: fnd_message.set_name ('PO', 'PO_REQ_REL_AMT_GRT_LIMIT_AMT');
2334: fnd_message.set_token('REQ_NUM', x_req_num);
2335: fnd_message.set_token('LINE_NUM', x_req_line_num);
2336: fnd_message.set_token('PO_NUM',x_po_num);
2337: x_error_msg := fnd_message.get;

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

2330: /* Bug#2057344 Added the below piece of code to write the message
2331: PO_REQ_REL_AMT_GRT_LIMIT_AMT to the log file when the Total Release amount is
2332: greater than the Amount in BPO */
2333: fnd_message.set_name ('PO', 'PO_REQ_REL_AMT_GRT_LIMIT_AMT');
2334: fnd_message.set_token('REQ_NUM', x_req_num);
2335: fnd_message.set_token('LINE_NUM', x_req_line_num);
2336: fnd_message.set_token('PO_NUM',x_po_num);
2337: x_error_msg := fnd_message.get;
2338: fnd_file.put_line(fnd_file.log,x_error_msg);

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

2331: PO_REQ_REL_AMT_GRT_LIMIT_AMT to the log file when the Total Release amount is
2332: greater than the Amount in BPO */
2333: fnd_message.set_name ('PO', 'PO_REQ_REL_AMT_GRT_LIMIT_AMT');
2334: fnd_message.set_token('REQ_NUM', x_req_num);
2335: fnd_message.set_token('LINE_NUM', x_req_line_num);
2336: fnd_message.set_token('PO_NUM',x_po_num);
2337: x_error_msg := fnd_message.get;
2338: fnd_file.put_line(fnd_file.log,x_error_msg);
2339: x_check_status := FND_API.G_RET_STS_ERROR; -- Bug 2701147

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

2332: greater than the Amount in BPO */
2333: fnd_message.set_name ('PO', 'PO_REQ_REL_AMT_GRT_LIMIT_AMT');
2334: fnd_message.set_token('REQ_NUM', x_req_num);
2335: fnd_message.set_token('LINE_NUM', x_req_line_num);
2336: fnd_message.set_token('PO_NUM',x_po_num);
2337: x_error_msg := fnd_message.get;
2338: fnd_file.put_line(fnd_file.log,x_error_msg);
2339: x_check_status := FND_API.G_RET_STS_ERROR; -- Bug 2701147
2340: END IF;

Line 2337: x_error_msg := fnd_message.get;

2333: fnd_message.set_name ('PO', 'PO_REQ_REL_AMT_GRT_LIMIT_AMT');
2334: fnd_message.set_token('REQ_NUM', x_req_num);
2335: fnd_message.set_token('LINE_NUM', x_req_line_num);
2336: fnd_message.set_token('PO_NUM',x_po_num);
2337: x_error_msg := fnd_message.get;
2338: fnd_file.put_line(fnd_file.log,x_error_msg);
2339: x_check_status := FND_API.G_RET_STS_ERROR; -- Bug 2701147
2340: END IF;
2341:

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

2734: > (l_price_tolerance_allowed + 1.000001))
2735: THEN
2736: l_progress := '009';
2737: --Report the price tolerance error
2738: l_textline := FND_MESSAGE.GET_STRING('PO',
2739: 'PO_SUB_REQ_PRICE_TOL_EXCEED');
2740: get_req_info_from_po_shipment(
2741: l_line_location_id(shipment_line),
2742: l_req_num, l_req_line_num);

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

2817: THEN
2818: l_progress := '012';
2819: --Report the price amount exceeded error
2820: l_textline :=
2821: FND_MESSAGE.GET_STRING('PO', 'PO_SUB_REQ_AMT_TOL_EXCEED');
2822: get_req_info_from_po_shipment(
2823: l_line_location_id(shipment_line),
2824: l_req_num, l_req_line_num);
2825: FND_FILE.put_line(FND_FILE.LOG,

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

2931: -- Check 12: The Amount being released for all shipments for a particular line
2932: -- must be greater than the min release amount specified in agreement line
2933: -- PO_SUB_REL_SHIPAMT_LESS_MINREL
2934:
2935: l_textline := FND_MESSAGE.GET_STRING('PO','PO_SUB_REL_SHIPAMT_LESS_MINREL');
2936:
2937: --Bug 12553671 Start
2938: /*SELECT substr(g_reqmsg||g_delim||p_req_num||g_delim||
2939: g_linemsg||g_delim||p_req_line_num||

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

3016: IF l_purch_enc_flag = 'Y' THEN
3017:
3018: -- bug 3296181
3019: -- Changed the message name.
3020: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_PDOI_INVALID_GL_ENC_PER');
3021: SELECT substr(l_textline,1,240),
3022: POD.po_distribution_id
3023: BULK COLLECT INTO l_error_messages, l_dist_id
3024: FROM PO_DISTRIBUTIONS POD, PO_LINE_LOCATIONS PLL, PO_LINES POL

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

3073: -- Message inserted is:
3074: --'Following Interclass UOM conversion is not defined or
3075: -- is disabled '
3076: -- Bug #1630662
3077: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_UOM_CLASS_CONVERSION');
3078: SELECT substr(l_textline||g_delim||
3079: MTL1.uom_class||' , '||MTL2.uom_class,1,240),
3080: POLL.line_location_id
3081: BULK COLLECT INTO l_error_messages, l_line_location_id

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

3120: -- Check 15: If an item is restricted then the Purchase Order Vendor
3121: -- must be listed in the Approved Suppliers List table and must be approved.
3122: -- PO_SUB_ITEM_NOT_APPROVED_REL
3123: -- Bug# 2461828
3124: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_ITEM_NOT_APPROVED_REL');
3125: SELECT substr(g_reqmsg||g_delim||p_req_num||g_delim||
3126: g_linemsg||g_delim||p_req_line_num||
3127: g_delim||l_textline,1,240)
3128: BULK COLLECT INTO l_error_messages

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

3194: -- List table and must be approved for release to get approved.
3195: -- Bug 839743
3196: -- PO_SUB_ITEM_ASL_DEBARRED_REL
3197:
3198: l_textline := FND_MESSAGE.GET_STRING('PO', 'PO_SUB_ITEM_ASL_DEBARRED_REL');
3199: SELECT substr(g_reqmsg||g_delim||p_req_num||g_delim||
3200: g_linemsg||g_delim||p_req_line_num||
3201: g_delim||l_textline,1,240)
3202: BULK COLLECT INTO l_error_messages

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

3291: p_vendor_id => l_vendor_id,
3292: p_vendor_site_id => l_vendor_site_id);
3293:
3294: IF NOT l_valid_registration THEN
3295: l_textline := FND_MESSAGE.get_string('PO', 'PO_VENDOR_SITE_CCR_INVALID');
3296: FND_FILE.put_line(FND_FILE.LOG, substr(g_reqmsg||g_delim
3297: ||p_req_num||g_delim||g_linemsg||g_delim
3298: ||p_req_line_num||g_delim||l_textline,1,240));
3299: x_check_status := FND_API.G_RET_STS_ERROR;

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

3309: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || '.'||l_api_name||'.'
3310: || l_progress,'LCM enabled release shipment should have invoice match option as receipt');
3311: END IF;
3312: END IF;
3313: l_textline := FND_MESSAGE.GET_STRING('PO','PO_SUB_REL_SHIP_INV_MATCH_NE_R');
3314:
3315: SELECT substr (g_shipmsg||g_delim||PLL.shipment_num||g_delim||l_textline,1,240)
3316: BULK COLLECT INTO l_error_messages
3317: FROM PO_RELEASES_ALL POR,

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

3335: || l_progress,'LCM enabled release distribution should have destination type as Inventory');
3336: END IF;
3337: END IF;
3338:
3339: l_textline := FND_MESSAGE.GET_STRING('PO','PO_SUB_REL_DIST_DEST_TYPE_NE_I');
3340:
3341: SELECT substr (g_shipmsg||g_delim||PLL.shipment_num||g_delim||g_distmsg||g_delim||
3342: POD.distribution_num||g_delim||l_textline, 1,240)
3343: BULK COLLECT INTO l_error_messages