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_LINES_PVT dependencies on OE_MSG_PUB

Line 167: OE_MSG_PUB.Add_Exc_Msg

163: WHEN OTHERS THEN
164: rollback;
165: OE_DEBUG_PUB.ADD(' Error in Apply_hold_and_commit ' );
166: OE_DEBUG_PUB.ADD(' SQLERRM: '|| SQLERRM );
167: OE_MSG_PUB.Add_Exc_Msg
168: ( G_PKG_NAME
169: , 'Apply_hold_and_commit'
170: );
171:

Line 237: OE_MSG_PUB.Add_Exc_Msg

233: WHEN OTHERS THEN
234: rollback;
235: OE_DEBUG_PUB.ADD('OEXVCRLB: Error in Update_Comments_And_Commit' );
236: OE_DEBUG_PUB.ADD('SQLERRM: '|| SQLERRM );
237: OE_MSG_PUB.Add_Exc_Msg
238: ( G_PKG_NAME
239: , 'Update_Comments_And_Commit'
240: );
241:

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

481: END IF;
482:
483: EXCEPTION
484: WHEN OTHERS THEN
485: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
486: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Create_Holds_Table');
487: END IF;
488: RAISE;
489:

Line 486: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Create_Holds_Table');

482:
483: EXCEPTION
484: WHEN OTHERS THEN
485: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
486: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Create_Holds_Table');
487: END IF;
488: RAISE;
489:
490: END Create_Holds_Table ;

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

585:
586: EXCEPTION
587: WHEN OTHERS THEN
588: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
589: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
590: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Update_Holds_Table');
591: END IF;
592: RAISE;
593: END Update_Holds_Table;

Line 590: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Update_Holds_Table');

586: EXCEPTION
587: WHEN OTHERS THEN
588: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
589: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
590: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Update_Holds_Table');
591: END IF;
592: RAISE;
593: END Update_Holds_Table;
594:

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

683: OE_DEBUG_PUB.Add('OEXVCRLB: Out Update_Holds_Table');
684: END IF;
685: EXCEPTION
686: WHEN OTHERS THEN
687: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
688: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Update_Holds_Table overloaded');
689: END IF;
690: RAISE;
691: END Update_Holds_Table;

Line 688: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Update_Holds_Table overloaded');

684: END IF;
685: EXCEPTION
686: WHEN OTHERS THEN
687: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
688: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Update_Holds_Table overloaded');
689: END IF;
690: RAISE;
691: END Update_Holds_Table;
692: --ER 6135714------------------------------------------------------------------------------------

Line 884: OE_MSG_PUB.Add_Exc_Msg

880: RETURN l_manual_hold_exists ;
881:
882: EXCEPTION
883: WHEN OTHERS THEN
884: OE_MSG_PUB.Add_Exc_Msg
885: (G_PKG_NAME, 'Check_Manual_Released_Holds' );
886: RAISE;
887:
888: END Check_Manual_Released_Holds;

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

957:
958: EXCEPTION
959: WHEN OTHERS THEN
960: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
961: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
962: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Chk_Past_Due_invoice');
963: END IF;
964: END Chk_Past_Due_Invoice;
965:

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

958: EXCEPTION
959: WHEN OTHERS THEN
960: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
961: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
962: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Chk_Past_Due_invoice');
963: END IF;
964: END Chk_Past_Due_Invoice;
965:
966:

Line 1050: OE_MSG_PUB.Add_Exc_Msg

1046: END IF;
1047:
1048: EXCEPTION
1049: WHEN OTHERS THEN
1050: OE_MSG_PUB.Add_Exc_Msg
1051: (G_PKG_NAME, 'Hold_Exists');
1052: RAISE;
1053:
1054: END Hold_Exists;

Line 1105: OE_MSG_PUB.Add;

1101: FND_MESSAGE.Set_Token('ORDER_NUMBER' ,p_order_number);
1102: FND_MESSAGE.Set_Token('LINE_NUMBER' ,p_line_number);
1103: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
1104: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used);
1105: OE_MSG_PUB.Add;
1106:
1107: ELSE
1108: IF p_cc_profile_used = 'SITE' THEN
1109: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||

Line 1123: OE_MSG_PUB.Add;

1119: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);
1120: FND_MESSAGE.Set_Token('LINE_NUMBER',p_line_number);
1121: FND_MESSAGE.Set_Token('CUSTOMER_NAME',p_customer_name);
1122: FND_MESSAGE.Set_Token('SITE_NAME' ,p_site_name);
1123: OE_MSG_PUB.Add;
1124: ELSIF p_cc_profile_used = 'CUSTOMER'
1125: THEN
1126: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||
1127: p_cc_profile_used);

Line 1138: OE_MSG_PUB.Add;

1134: p_cc_profile_used);
1135: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);
1136: FND_MESSAGE.Set_Token('LINE_NUMBER',p_line_number);
1137: FND_MESSAGE.Set_Token('CUSTOMER_NAME',p_customer_name);
1138: OE_MSG_PUB.Add;
1139:
1140: ELSIF p_cc_profile_used = 'PARTY'
1141: THEN
1142: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||

Line 1154: OE_MSG_PUB.Add;

1150: p_cc_profile_used);
1151: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);
1152: FND_MESSAGE.Set_Token('LINE_NUMBER',p_line_number);
1153: FND_MESSAGE.Set_Token('PARTY_NAME',p_party_name) ;
1154: OE_MSG_PUB.Add;
1155:
1156: ELSIF p_cc_profile_used = 'DEFAULT' THEN
1157: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||
1158: p_cc_profile_used);

Line 1167: OE_MSG_PUB.Add;

1163: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||
1164: p_cc_profile_used);
1165: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);
1166: FND_MESSAGE.Set_Token('LINE_NUMBER',p_line_number);
1167: OE_MSG_PUB.Add;
1168: END IF;
1169: END IF;
1170: ELSE
1171: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||

Line 1183: OE_MSG_PUB.Add;

1179: 'CATEGORY');
1180: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);
1181: FND_MESSAGE.Set_Token('LINE_NUMBER',p_line_number);
1182: FND_MESSAGE.Set_Token('CATEGORY',p_item_category);
1183: OE_MSG_PUB.Add;
1184: END IF;
1185: --END IF; -- bug 5467793
1186: --
1187: -- Save messages on message stack to message table

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

1186: --
1187: -- Save messages on message stack to message table
1188: -- Give a dummy request id
1189: -- rajesh
1190: --OE_MSG_PUB.Save_Messages(1);
1191: --OE_MSG_PUB.Delete_Msg(OE_MSG_PUB.G_msg_count);
1192: --
1193: -- Write to logfile if original call was from a concurrent program
1194: --

Line 1191: --OE_MSG_PUB.Delete_Msg(OE_MSG_PUB.G_msg_count);

1187: -- Save messages on message stack to message table
1188: -- Give a dummy request id
1189: -- rajesh
1190: --OE_MSG_PUB.Save_Messages(1);
1191: --OE_MSG_PUB.Delete_Msg(OE_MSG_PUB.G_msg_count);
1192: --
1193: -- Write to logfile if original call was from a concurrent program
1194: --
1195: IF p_calling_action = 'AUTO HOLD' THEN

Line 1226: OE_MSG_PUB.Add_Exc_Msg

1222: END IF;
1223:
1224: EXCEPTION
1225: WHEN OTHERS THEN
1226: OE_MSG_PUB.Add_Exc_Msg
1227: (G_PKG_NAME, 'Write_Hold_Message');
1228: RAISE;
1229:
1230: END Write_Hold_Message;

Line 1259: OE_MSG_PUB.Add;

1255:
1256: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_REMOVED');
1257: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);
1258: FND_MESSAGE.Set_Token('LINE_NUMBER',p_line_number);
1259: OE_MSG_PUB.Add;
1260: --- rajesh
1261: --OE_MSG_PUB.Save_Messages(1);
1262: --
1263: IF G_debug_flag = 'Y'

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

1257: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);
1258: FND_MESSAGE.Set_Token('LINE_NUMBER',p_line_number);
1259: OE_MSG_PUB.Add;
1260: --- rajesh
1261: --OE_MSG_PUB.Save_Messages(1);
1262: --
1263: IF G_debug_flag = 'Y'
1264: THEN
1265: OE_DEBUG_PUB.Add('OEXVCRLB: Out Write_Release_Message');

Line 1270: OE_MSG_PUB.Add_Exc_Msg

1266: END IF;
1267:
1268: EXCEPTION
1269: WHEN OTHERS THEN
1270: OE_MSG_PUB.Add_Exc_Msg
1271: (G_PKG_NAME, 'Write_Release_Message');
1272: RAISE;
1273:
1274: END Write_Release_Message;

Line 1317: OE_MSG_PUB.Add;

1313: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
1314: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_MSG');
1315: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
1316: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used);
1317: OE_MSG_PUB.Add;
1318: ELSE
1319: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_'||p_cc_limit_used||'_'||
1320: p_cc_profile_used);
1321: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);

Line 1324: OE_MSG_PUB.Add;

1320: p_cc_profile_used);
1321: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
1322: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_'||p_cc_limit_used||'_'||
1323: p_cc_profile_used);
1324: OE_MSG_PUB.Add;
1325: END IF;
1326: ELSE
1327: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_'||p_cc_limit_used||'_CATEGORY');
1328: FND_MESSAGE.Set_Token('CATEGORY',p_item_category);

Line 1333: OE_MSG_PUB.Add;

1329: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
1330: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_'||p_cc_limit_used||'_'||
1331: 'CATEGORY');
1332: FND_MESSAGE.Set_Token('CATEGORY',p_item_category);
1333: OE_MSG_PUB.Add;
1334: END IF;
1335: --
1336: -- Write to logfile if original call was from a concurrent program
1337: --

Line 1368: OE_MSG_PUB.Add_Exc_Msg

1364: END IF;
1365:
1366: EXCEPTION
1367: WHEN OTHERS THEN
1368: OE_MSG_PUB.Add_Exc_Msg
1369: (G_PKG_NAME, 'Write_Order_Hold_Msg');
1370: RAISE;
1371:
1372: END Write_Order_Hold_Msg;

Line 1394: OE_MSG_PUB.Add;

1390: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Order '||TO_CHAR(p_order_number)
1391: ||': Credit check hold released.');
1392: ELSE
1393: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_REMOVED');
1394: OE_MSG_PUB.Add;
1395: END IF;
1396: --
1397: IF G_debug_flag = 'Y'
1398: THEN

Line 1404: OE_MSG_PUB.Add_Exc_Msg

1400: END IF;
1401:
1402: EXCEPTION
1403: WHEN OTHERS THEN
1404: OE_MSG_PUB.Add_Exc_Msg
1405: (G_PKG_NAME, 'Write_Order_Release_Msg');
1406: RAISE;
1407:
1408: END Write_Order_Release_Msg;

Line 1746: OE_MSG_PUB.Add_Exc_Msg

1742:
1743:
1744: EXCEPTION
1745: WHEN OTHERS THEN
1746: OE_MSG_PUB.Add_Exc_Msg
1747: (G_PKG_NAME, 'Apply_Line_CC_Hold');
1748: RAISE;
1749:
1750: END Apply_Line_CC_Hold;

Line 1904: OE_MSG_PUB.Add_Exc_Msg

1900: END IF;
1901:
1902: EXCEPTION
1903: WHEN OTHERS THEN
1904: OE_MSG_PUB.Add_Exc_Msg
1905: (G_PKG_NAME, 'Apply_Order_CC_Hold' );
1906: RAISE;
1907:
1908: END Apply_Order_CC_Hold;

Line 2017: OE_MSG_PUB.Add_Exc_Msg

2013: END IF;
2014:
2015: EXCEPTION
2016: WHEN OTHERS THEN
2017: OE_MSG_PUB.Add_Exc_Msg
2018: (G_PKG_NAME, 'Release_Order_CC_Hold');
2019: RAISE;
2020:
2021: END Release_Order_CC_Hold;

Line 2071: OE_MSG_PUB.Add_Exc_Msg

2067: OE_DEBUG_PUB.Add('OEXVCRLB: Out Apply_Item_Category_Holds');
2068:
2069: EXCEPTION
2070: WHEN OTHERS THEN
2071: OE_MSG_PUB.Add_Exc_Msg
2072: (G_PKG_NAME, 'Apply_Item_Category_Holds');
2073: RAISE;
2074:
2075: END Apply_Item_Category_Holds;

Line 2118: OE_MSG_PUB.Add_Exc_Msg

2114: END IF;
2115:
2116: EXCEPTION
2117: WHEN OTHERS THEN
2118: OE_MSG_PUB.Add_Exc_Msg
2119: (G_PKG_NAME, 'Apply_Other_Holds');
2120: RAISE;
2121:
2122: END Apply_Other_Holds;

Line 2256: OE_MSG_PUB.Add_Exc_Msg

2252: END IF;
2253:
2254: EXCEPTION
2255: WHEN OTHERS THEN
2256: OE_MSG_PUB.Add_Exc_Msg
2257: (G_PKG_NAME, 'Release_Line_CC_Hold');
2258: RAISE;
2259:
2260: END Release_Line_CC_Hold;

Line 2408: OE_MSG_PUB.ADD;

2404: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );
2405: FND_MESSAGE.Set_Token('CONV',
2406: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate'));
2407:
2408: OE_MSG_PUB.ADD;
2409: x_return_status := FND_API.G_RET_STS_ERROR;
2410:
2411: END IF;
2412:

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

2424: EXCEPTION
2425: WHEN others THEN
2426: OE_DEBUG_PUB.Add('Check_Trx_Limit: Other exceptions');
2427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2428: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2429: OE_MSG_PUB.Add_Exc_Msg
2430: ( G_PKG_NAME
2431: , 'Check_Trx_Limit'
2432: );

Line 2429: OE_MSG_PUB.Add_Exc_Msg

2425: WHEN others THEN
2426: OE_DEBUG_PUB.Add('Check_Trx_Limit: Other exceptions');
2427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2428: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2429: OE_MSG_PUB.Add_Exc_Msg
2430: ( G_PKG_NAME
2431: , 'Check_Trx_Limit'
2432: );
2433: END IF;

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

2589: END IF;
2590: EXCEPTION
2591: WHEN OTHERS THEN
2592: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2593: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2594: OE_MSG_PUB.Add_Exc_Msg
2595: ( G_PKG_NAME
2596: , 'Validate_other_credit_check'
2597: );

Line 2594: OE_MSG_PUB.Add_Exc_Msg

2590: EXCEPTION
2591: WHEN OTHERS THEN
2592: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2593: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2594: OE_MSG_PUB.Add_Exc_Msg
2595: ( G_PKG_NAME
2596: , 'Validate_other_credit_check'
2597: );
2598: END IF;

Line 2829: OE_MSG_PUB.ADD;

2825: FND_MESSAGE.Set_Token('CONV',
2826: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate'));
2827:
2828:
2829: OE_MSG_PUB.ADD;
2830: x_return_status := FND_API.G_RET_STS_ERROR;
2831: OE_DEBUG_PUB.ADD('Return status after assigned as Error = '
2832: || x_return_status );
2833: END IF;

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

2854: EXCEPTION
2855: WHEN others THEN
2856: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2857: OE_DEBUG_PUB.Add('CHECK_ORDER_LINES_EXPOSURE: Other exceptions');
2858: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2859: OE_MSG_PUB.Add_Exc_Msg
2860: ( G_PKG_NAME
2861: , 'CHECK_ORDER_LINES_EXPOSURE'
2862: );

Line 2859: OE_MSG_PUB.Add_Exc_Msg

2855: WHEN others THEN
2856: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2857: OE_DEBUG_PUB.Add('CHECK_ORDER_LINES_EXPOSURE: Other exceptions');
2858: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2859: OE_MSG_PUB.Add_Exc_Msg
2860: ( G_PKG_NAME
2861: , 'CHECK_ORDER_LINES_EXPOSURE'
2862: );
2863: END IF;

Line 3071: OE_MSG_PUB.ADD ;

3067: FND_MESSAGE.Set_Token('TO',l_limit_currency );
3068: FND_MESSAGE.Set_Token('CONV',
3069: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate'));
3070:
3071: OE_MSG_PUB.ADD ;
3072: x_return_status := FND_API.G_RET_STS_ERROR;
3073: OE_DEBUG_PUB.ADD('Return status after assigned as Error = '
3074: || x_return_status );
3075: END IF;

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

3079:
3080: WHEN others THEN
3081: OE_DEBUG_PUB.Add('Check_Item_Limit: Other exceptions');
3082: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3083: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3084: OE_MSG_PUB.Add_Exc_Msg
3085: ( G_PKG_NAME
3086: , 'Check_Item_Limits'
3087: );

Line 3084: OE_MSG_PUB.Add_Exc_Msg

3080: WHEN others THEN
3081: OE_DEBUG_PUB.Add('Check_Item_Limit: Other exceptions');
3082: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3083: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3084: OE_MSG_PUB.Add_Exc_Msg
3085: ( G_PKG_NAME
3086: , 'Check_Item_Limits'
3087: );
3088: END IF;

Line 3912: OE_MSG_PUB.Add;

3908: IF x_return_status='S'
3909: THEN
3910: FND_MESSAGE.Set_Name('ONT','OE_CC_CMGT_REVIEW');
3911: FND_MESSAGE.Set_Token('REQUEST_ID',l_request_id);
3912: OE_MSG_PUB.Add;
3913: END IF;
3914:
3915: IF G_debug_flag = 'Y'
3916: THEN

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

4010: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4011: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4012: WHEN OTHERS THEN
4013: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4014: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4015: OE_MSG_PUB.Add_Exc_Msg
4016: ( G_PKG_NAME, 'Check_Other_Credit_Limits');
4017: END IF;
4018: OE_DEBUG_PUB.ADD( SUBSTR(SQLERRM,1,300),1 ) ;

Line 4015: OE_MSG_PUB.Add_Exc_Msg

4011: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4012: WHEN OTHERS THEN
4013: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4014: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4015: OE_MSG_PUB.Add_Exc_Msg
4016: ( G_PKG_NAME, 'Check_Other_Credit_Limits');
4017: END IF;
4018: OE_DEBUG_PUB.ADD( SUBSTR(SQLERRM,1,300),1 ) ;
4019:

Line 4065: OE_MSG_PUB.Set_Msg_Context(

4061: IF p_holds_table(i).hold IS NOT NULL
4062: THEN
4063:
4064: --bug 4503551
4065: OE_MSG_PUB.Set_Msg_Context(
4066: p_entity_code => 'LINE'
4067: ,p_entity_id => p_holds_table(i).line_id
4068: ,p_header_id => p_header_id
4069: ,p_line_id => p_holds_table(i).line_id );

Line 4099: OE_MSG_PUB.Reset_Msg_Context('LINE'); --bug 4503551

4095: IF l_result_out = 'FAIL_HOLD' THEN
4096: l_cc_result_out := l_result_out;
4097: END IF;
4098:
4099: OE_MSG_PUB.Reset_Msg_Context('LINE'); --bug 4503551
4100:
4101: ELSIF p_check_exposure_mode = 'INLINE' OR
4102: p_check_exposure_mode = 'NOCHECK'
4103: THEN

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

4180: END IF;
4181: EXCEPTION
4182: WHEN others THEN
4183: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4184: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4185: OE_MSG_PUB.Add_Exc_Msg
4186: ( G_PKG_NAME
4187: , 'Apply_And_Release_Holds'
4188: );

Line 4185: OE_MSG_PUB.Add_Exc_Msg

4181: EXCEPTION
4182: WHEN others THEN
4183: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4184: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4185: OE_MSG_PUB.Add_Exc_Msg
4186: ( G_PKG_NAME
4187: , 'Apply_And_Release_Holds'
4188: );
4189: END IF;

Line 4867: OE_MSG_PUB.Set_Msg_Context(

4863: IF x_return_status='S'
4864: THEN
4865:
4866: --bug 4503551
4867: OE_MSG_PUB.Set_Msg_Context(
4868: p_entity_code => 'HEADER'
4869: ,p_entity_id => p_header_rec.header_id
4870: ,p_header_id => p_header_rec.header_id );
4871:

Line 4874: OE_MSG_PUB.Add;

4870: ,p_header_id => p_header_rec.header_id );
4871:
4872: FND_MESSAGE.Set_Name('ONT','OE_CC_CMGT_REVIEW');
4873: FND_MESSAGE.Set_Token('REQUEST_ID',l_request_id);
4874: OE_MSG_PUB.Add;
4875: OE_MSG_PUB.Reset_Msg_Context('HEADER'); --bug 4503551
4876: END IF;
4877:
4878: IF G_debug_flag = 'Y'

Line 4875: OE_MSG_PUB.Reset_Msg_Context('HEADER'); --bug 4503551

4871:
4872: FND_MESSAGE.Set_Name('ONT','OE_CC_CMGT_REVIEW');
4873: FND_MESSAGE.Set_Token('REQUEST_ID',l_request_id);
4874: OE_MSG_PUB.Add;
4875: OE_MSG_PUB.Reset_Msg_Context('HEADER'); --bug 4503551
4876: END IF;
4877:
4878: IF G_debug_flag = 'Y'
4879: THEN

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

4979: --
4980: IF l_credit_hold_level = 'LINE'
4981: THEN
4982: -- fix bug 4558056
4983: -- OE_MSG_PUB.Save_Messages(1);
4984: -- OE_MSG_PUB.Delete_Msg(OE_MSG_PUB.G_msg_count);
4985:
4986: -- added OR condition for bug 5467793
4987: IF x_cc_result_out = 'FAIL'

Line 4984: -- OE_MSG_PUB.Delete_Msg(OE_MSG_PUB.G_msg_count);

4980: IF l_credit_hold_level = 'LINE'
4981: THEN
4982: -- fix bug 4558056
4983: -- OE_MSG_PUB.Save_Messages(1);
4984: -- OE_MSG_PUB.Delete_Msg(OE_MSG_PUB.G_msg_count);
4985:
4986: -- added OR condition for bug 5467793
4987: IF x_cc_result_out = 'FAIL'
4988: --OR( NVL(OE_credit_engine_GRP.G_delayed_request, FND_API.G_FALSE ) =

Line 4995: OE_MSG_PUB.Add;

4991: -- Display the general message for the user on the screen
4992:
4993: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_GENERAL_MSG');
4994:
4995: OE_MSG_PUB.Add;
4996: END IF;
4997:
4998: IF G_release_status = 'RELEASED'
4999: THEN

Line 5002: OE_MSG_PUB.Add;

4998: IF G_release_status = 'RELEASED'
4999: THEN
5000:
5001: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_REMOVED');
5002: OE_MSG_PUB.Add;
5003:
5004: END IF;
5005:
5006: END IF;

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

5028: OE_CREDIT_ENGINE_GRP.TOLERANCE_CHECK_REQUIRED := TRUE; --ER 12363706
5029: OE_CREDIT_CHECK_UTIL.G_CC_Invoice_tab.delete; --13706069
5030: OE_DEBUG_PUB.Add('Check_order_lines_credit: Other Unexpected Error ',1);
5031: OE_DEBUG_PUB.ADD( SUBSTR(SQLERRM,1,300),1 ) ;
5032: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5033: OE_MSG_PUB.Add_Exc_Msg
5034: ( G_PKG_NAME
5035: , 'Check_order_lines_credit'
5036: );

Line 5033: OE_MSG_PUB.Add_Exc_Msg

5029: OE_CREDIT_CHECK_UTIL.G_CC_Invoice_tab.delete; --13706069
5030: OE_DEBUG_PUB.Add('Check_order_lines_credit: Other Unexpected Error ',1);
5031: OE_DEBUG_PUB.ADD( SUBSTR(SQLERRM,1,300),1 ) ;
5032: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5033: OE_MSG_PUB.Add_Exc_Msg
5034: ( G_PKG_NAME
5035: , 'Check_order_lines_credit'
5036: );
5037: END IF;