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.OE_CREDIT_CHECK_ORDER_PVT dependencies on OE_MSG_PUB

Line 239: OE_MSG_PUB.Add_Exc_Msg

235: EXCEPTION
236: WHEN OTHERS THEN
237: OE_DEBUG_PUB.ADD(SUBSTR(SQLERRM,1,300) ) ;
238:
239: OE_MSG_PUB.Add_Exc_Msg
240: ( G_PKG_NAME
241: , 'Check_Manual_Released_Holds'
242: );
243:

Line 328: OE_MSG_PUB.Add_Exc_Msg

324: END IF;
325:
326: EXCEPTION
327: WHEN OTHERS THEN
328: OE_MSG_PUB.Add_Exc_Msg
329: ( G_PKG_NAME
330: , 'Hold_Exists'
331: );
332:

Line 365: OE_MSG_PUB.Add;

361:
362: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_REMOVED');
363: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);
364: FND_MESSAGE.Set_Token('LINE_NUMBER',p_line_number);
365: OE_MSG_PUB.Add;
366: ---OE_MSG_PUB.Save_Messages(1);
367:
368: IF G_debug_flag = 'Y'
369: THEN

Line 366: ---OE_MSG_PUB.Save_Messages(1);

362: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_REMOVED');
363: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);
364: FND_MESSAGE.Set_Token('LINE_NUMBER',p_line_number);
365: OE_MSG_PUB.Add;
366: ---OE_MSG_PUB.Save_Messages(1);
367:
368: IF G_debug_flag = 'Y'
369: THEN
370: OE_DEBUG_PUB.Add('OEXVCRHB: Out Write_Release_Message');

Line 374: OE_MSG_PUB.Add_Exc_Msg

370: OE_DEBUG_PUB.Add('OEXVCRHB: Out Write_Release_Message');
371: END IF;
372: EXCEPTION
373: WHEN OTHERS THEN
374: OE_MSG_PUB.Add_Exc_Msg
375: ( G_PKG_NAME
376: , 'Write_Release_Message'
377: );
378:

Line 433: OE_MSG_PUB.Add;

429: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_MSG');
430: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
431: --6616741 FND_MESSAGE.Set_Token('CC_PROFILE',p_cc_profile_used);
432: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used); --6616741
433: OE_MSG_PUB.Add;
434: ELSE
435: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_'||p_cc_limit_used||'_'||
436: p_cc_profile_used); --commented ER8880886, uncommented for bug 10305908
437: -- l_cc_profile_used); --ER8880886, commented for bug 10305908

Line 442: OE_MSG_PUB.Add;

438: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
439: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_'||p_cc_limit_used||'_'||
440: p_cc_profile_used); --commented ER8880886, uncommented for bug 10305908
441: --l_cc_profile_used); --ER8880886, commented for bug 10305908
442: OE_MSG_PUB.Add;
443: END IF;
444: ELSE
445: --bug4583872
446: IF INSTR(p_cc_limit_used, ',') > 0 THEN

Line 456: OE_MSG_PUB.Add;

452: FND_MESSAGE.Set_Name('ONT','OE_CC_EXT_MSG');
453: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
454: --FND_MESSAGE.Set_Token('CC_PROFILE',p_cc_profile_used); -- commented for bug 10305908
455: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used); -- added for bug 10305908
456: OE_MSG_PUB.Add;
457: ELSE
458: FND_MESSAGE.Set_Name('ONT','OE_CC_EXT_'||p_cc_limit_used||'_'||
459: p_cc_profile_used);
460: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);

Line 463: OE_MSG_PUB.Add;

459: p_cc_profile_used);
460: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
461: FND_MESSAGE.Set_Name('ONT','OE_CC_EXT_'||p_cc_limit_used||'_'||
462: p_cc_profile_used);
463: OE_MSG_PUB.Add;
464: END IF;
465: END IF;
466: ELSE
467: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_'||p_cc_limit_used||'_CATEGORY');

Line 473: OE_MSG_PUB.Add;

469: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
470: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_'||p_cc_limit_used||'_'||
471: 'CATEGORY');
472: FND_MESSAGE.Set_Token('CATEGORY',p_item_category);
473: OE_MSG_PUB.Add;
474: END IF;
475: --
476: -- Write to logfile if original call was from a concurrent program
477: --

Line 510: OE_MSG_PUB.Add_Exc_Msg

506: END IF;
507:
508: EXCEPTION
509: WHEN OTHERS THEN
510: OE_MSG_PUB.Add_Exc_Msg
511: ( G_PKG_NAME
512: , 'Write_Order_Hold_Msg'
513: );
514:

Line 539: OE_MSG_PUB.Add;

535: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Order '||TO_CHAR(p_order_number)
536: ||': Credit check hold released.');
537: ELSE
538: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_REMOVED');
539: OE_MSG_PUB.Add;
540: END IF;
541: --
542: IF G_debug_flag = 'Y'
543: THEN

Line 549: OE_MSG_PUB.Add_Exc_Msg

545: END IF;
546:
547: EXCEPTION
548: WHEN OTHERS THEN
549: OE_MSG_PUB.Add_Exc_Msg
550: ( G_PKG_NAME
551: , 'Write_Order_Release_Msg'
552: );
553:

Line 612: OE_MSG_PUB.Add_Exc_Msg

608: WHEN OTHERS THEN
609: rollback;
610: OE_DEBUG_PUB.ADD(' Error in Apply_hold_and_commit ' );
611: OE_DEBUG_PUB.ADD(' SQLERRM: '|| SQLERRM );
612: OE_MSG_PUB.Add_Exc_Msg
613: ( G_PKG_NAME
614: , 'Apply_hold_and_commit'
615: );
616:

Line 700: OE_MSG_PUB.Add_Exc_Msg

696: WHEN OTHERS THEN
697: rollback;
698: OE_DEBUG_PUB.ADD('OEXVCRHB: Error in Update_Comments_And_Commit' );
699: OE_DEBUG_PUB.ADD('SQLERRM: '|| SQLERRM );
700: OE_MSG_PUB.Add_Exc_Msg
701: ( G_PKG_NAME
702: , 'Update_Comments_And_Commit'
703: );
704:

Line 978: OE_MSG_PUB.Add_Exc_Msg

974: END IF;
975:
976: EXCEPTION
977: WHEN OTHERS THEN
978: OE_MSG_PUB.Add_Exc_Msg
979: ( G_PKG_NAME
980: , 'Apply_Order_CC_Hold'
981: );
982:

Line 1098: OE_MSG_PUB.Add_Exc_Msg

1094: OE_DEBUG_PUB.Add('OEXVCRHB: Out Release_Order_CC_Hold');
1095: END IF;
1096: EXCEPTION
1097: WHEN OTHERS THEN
1098: OE_MSG_PUB.Add_Exc_Msg
1099: ( G_PKG_NAME
1100: , 'Release_Order_CC_Hold'
1101: );
1102:

Line 1188: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1184: END IF;
1185: EXCEPTION
1186: WHEN OTHERS THEN
1187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1188: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1189: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Chk_Past_Due_invoice');
1190: END IF;
1191: END Chk_Past_Due_Invoice;
1192:

Line 1189: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Chk_Past_Due_invoice');

1185: EXCEPTION
1186: WHEN OTHERS THEN
1187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1188: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1189: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Chk_Past_Due_invoice');
1190: END IF;
1191: END Chk_Past_Due_Invoice;
1192:
1193: --------------------------------------------------------------

Line 1360: OE_MSG_PUB.ADD;

1356: FND_MESSAGE.Set_Token('FROM',p_header_rec.transactional_curr_code);
1357: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );
1358: FND_MESSAGE.Set_Token('CONV',
1359: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate'));
1360: OE_MSG_PUB.ADD;
1361:
1362: G_result_out := 'FAIL' ;
1363: x_cc_result_out := 'FAIL';
1364: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1383: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1379: EXCEPTION
1380: WHEN others THEN
1381: OE_DEBUG_PUB.Add('Check_Trx_Limit: Other exceptions');
1382: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1383: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1384: OE_MSG_PUB.Add_Exc_Msg
1385: ( G_PKG_NAME
1386: , 'Check_Trx_Limit'
1387: );

Line 1384: OE_MSG_PUB.Add_Exc_Msg

1380: WHEN others THEN
1381: OE_DEBUG_PUB.Add('Check_Trx_Limit: Other exceptions');
1382: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1383: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1384: OE_MSG_PUB.Add_Exc_Msg
1385: ( G_PKG_NAME
1386: , 'Check_Trx_Limit'
1387: );
1388: END IF;

Line 1460: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1456:
1457: EXCEPTION
1458: WHEN others THEN
1459: OE_DEBUG_PUB.Add('check_credit_check_flags: Other exceptions');
1460: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1461: OE_MSG_PUB.Add_Exc_Msg
1462: ( G_PKG_NAME
1463: , 'check_credit_check_flags'
1464: );

Line 1461: OE_MSG_PUB.Add_Exc_Msg

1457: EXCEPTION
1458: WHEN others THEN
1459: OE_DEBUG_PUB.Add('check_credit_check_flags: Other exceptions');
1460: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1461: OE_MSG_PUB.Add_Exc_Msg
1462: ( G_PKG_NAME
1463: , 'check_credit_check_flags'
1464: );
1465: END IF;

Line 1659: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1655:
1656: EXCEPTION
1657: WHEN OTHERS THEN
1658: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1659: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1660: OE_MSG_PUB.Add_Exc_Msg
1661: ( G_PKG_NAME
1662: , 'Validate_other_credit_check'
1663: );

Line 1660: OE_MSG_PUB.Add_Exc_Msg

1656: EXCEPTION
1657: WHEN OTHERS THEN
1658: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1659: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1660: OE_MSG_PUB.Add_Exc_Msg
1661: ( G_PKG_NAME
1662: , 'Validate_other_credit_check'
1663: );
1664: END IF;

Line 2042: OE_MSG_PUB.ADD;

2038: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );
2039: FND_MESSAGE.Set_Token('CONV',
2040: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate')) ;
2041:
2042: OE_MSG_PUB.ADD;
2043:
2044: G_result_out := 'FAIL' ;
2045: x_cc_result_out := 'FAIL';
2046: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2077: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2073: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2074: IF G_debug_flag = 'Y' THEN
2075: OE_DEBUG_PUB.Add('Check_order_exposure: Other exceptions');
2076: END IF;
2077: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2078: OE_MSG_PUB.Add_Exc_Msg
2079: ( G_PKG_NAME
2080: , 'Check_order_exposure'
2081: );

Line 2078: OE_MSG_PUB.Add_Exc_Msg

2074: IF G_debug_flag = 'Y' THEN
2075: OE_DEBUG_PUB.Add('Check_order_exposure: Other exceptions');
2076: END IF;
2077: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2078: OE_MSG_PUB.Add_Exc_Msg
2079: ( G_PKG_NAME
2080: , 'Check_order_exposure'
2081: );
2082: END IF;

Line 2279: OE_MSG_PUB.ADD ;

2275: FND_MESSAGE.Set_Token('TO',l_limit_curr );
2276: FND_MESSAGE.Set_Token('CONV',
2277: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate')) ;
2278:
2279: OE_MSG_PUB.ADD ;
2280:
2281: G_result_out := 'FAIL' ;
2282: x_cc_result_out := 'FAIL';
2283: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2297: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2293: IF G_debug_flag = 'Y' THEN
2294: OE_DEBUG_PUB.Add('Check_Item_Limit: Other exceptions');
2295: END IF;
2296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2297: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2298: OE_MSG_PUB.Add_Exc_Msg
2299: ( G_PKG_NAME
2300: , 'Check_Item_Limits'
2301: );

Line 2298: OE_MSG_PUB.Add_Exc_Msg

2294: OE_DEBUG_PUB.Add('Check_Item_Limit: Other exceptions');
2295: END IF;
2296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2297: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2298: OE_MSG_PUB.Add_Exc_Msg
2299: ( G_PKG_NAME
2300: , 'Check_Item_Limits'
2301: );
2302: END IF;

Line 3006: OE_MSG_PUB.Add;

3002: THEN
3003:
3004: FND_MESSAGE.Set_Name('ONT','OE_CC_CMGT_REVIEW');
3005: FND_MESSAGE.Set_Token('REQUEST_ID',l_request_id);
3006: OE_MSG_PUB.Add;
3007:
3008: END IF;
3009:
3010: IF G_debug_flag = 'Y'

Line 3070: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

3066: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3067: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3068: WHEN OTHERS THEN
3069: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3070: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3071: OE_MSG_PUB.Add_Exc_Msg
3072: ( G_PKG_NAME, 'Check_Other_Credit_Limits');
3073: END IF;
3074: IF G_debug_flag = 'Y' THEN

Line 3071: OE_MSG_PUB.Add_Exc_Msg

3067: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3068: WHEN OTHERS THEN
3069: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3070: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3071: OE_MSG_PUB.Add_Exc_Msg
3072: ( G_PKG_NAME, 'Check_Other_Credit_Limits');
3073: END IF;
3074: IF G_debug_flag = 'Y' THEN
3075: OE_DEBUG_PUB.Add( SUBSTR(SQLERRM,1,300),1 ) ;

Line 3446: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

3442: IF G_debug_flag = 'Y' THEN
3443: OE_DEBUG_PUB.Add('Check_order_credit: Other Unexpected Error ');
3444: END IF;
3445: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3446: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3447: OE_MSG_PUB.Add_Exc_Msg
3448: ( G_PKG_NAME
3449: , 'Check_order_credit'
3450: );

Line 3447: OE_MSG_PUB.Add_Exc_Msg

3443: OE_DEBUG_PUB.Add('Check_order_credit: Other Unexpected Error ');
3444: END IF;
3445: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3446: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3447: OE_MSG_PUB.Add_Exc_Msg
3448: ( G_PKG_NAME
3449: , 'Check_order_credit'
3450: );
3451: END IF;

Line 3455: OE_MSG_PUB.Count_And_Get

3451: END IF;
3452: IF G_debug_flag = 'Y' THEN
3453: OE_DEBUG_PUB.Add( SUBSTR(SQLERRM,1,300),1 ) ;
3454: END IF;
3455: OE_MSG_PUB.Count_And_Get
3456: ( p_count => x_msg_count
3457: , p_data => x_msg_data
3458: );
3459: