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.

[Home] [Help]

APPS.OE_CREDIT_CHECK_LINES_PVT dependencies on FND_MESSAGE

Line 1094: FND_MESSAGE.Set_Name('ONT','OE_CC_LINE_HOLD_MSG');

1090: IF p_cc_limit_used <> 'ITEM' THEN
1091: -- bug 4002820
1092: IF INSTR(p_cc_limit_used, ',') > 0 THEN
1093: l_cc_profile_used := OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_PROFILE', p_cc_profile_used);
1094: FND_MESSAGE.Set_Name('ONT','OE_CC_LINE_HOLD_MSG');
1095: FND_MESSAGE.Set_Token('ORDER_NUMBER' ,p_order_number);
1096: FND_MESSAGE.Set_Token('LINE_NUMBER' ,p_line_number);
1097: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
1098: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used);

Line 1095: FND_MESSAGE.Set_Token('ORDER_NUMBER' ,p_order_number);

1091: -- bug 4002820
1092: IF INSTR(p_cc_limit_used, ',') > 0 THEN
1093: l_cc_profile_used := OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_PROFILE', p_cc_profile_used);
1094: FND_MESSAGE.Set_Name('ONT','OE_CC_LINE_HOLD_MSG');
1095: FND_MESSAGE.Set_Token('ORDER_NUMBER' ,p_order_number);
1096: FND_MESSAGE.Set_Token('LINE_NUMBER' ,p_line_number);
1097: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
1098: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used);
1099: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);

Line 1096: FND_MESSAGE.Set_Token('LINE_NUMBER' ,p_line_number);

1092: IF INSTR(p_cc_limit_used, ',') > 0 THEN
1093: l_cc_profile_used := OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_PROFILE', p_cc_profile_used);
1094: FND_MESSAGE.Set_Name('ONT','OE_CC_LINE_HOLD_MSG');
1095: FND_MESSAGE.Set_Token('ORDER_NUMBER' ,p_order_number);
1096: FND_MESSAGE.Set_Token('LINE_NUMBER' ,p_line_number);
1097: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
1098: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used);
1099: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
1100: FND_MESSAGE.Set_Name('ONT','OE_CC_LINE_HOLD_MSG');

Line 1097: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);

1093: l_cc_profile_used := OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_PROFILE', p_cc_profile_used);
1094: FND_MESSAGE.Set_Name('ONT','OE_CC_LINE_HOLD_MSG');
1095: FND_MESSAGE.Set_Token('ORDER_NUMBER' ,p_order_number);
1096: FND_MESSAGE.Set_Token('LINE_NUMBER' ,p_line_number);
1097: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
1098: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used);
1099: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
1100: FND_MESSAGE.Set_Name('ONT','OE_CC_LINE_HOLD_MSG');
1101: FND_MESSAGE.Set_Token('ORDER_NUMBER' ,p_order_number);

Line 1098: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used);

1094: FND_MESSAGE.Set_Name('ONT','OE_CC_LINE_HOLD_MSG');
1095: FND_MESSAGE.Set_Token('ORDER_NUMBER' ,p_order_number);
1096: FND_MESSAGE.Set_Token('LINE_NUMBER' ,p_line_number);
1097: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
1098: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used);
1099: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
1100: FND_MESSAGE.Set_Name('ONT','OE_CC_LINE_HOLD_MSG');
1101: FND_MESSAGE.Set_Token('ORDER_NUMBER' ,p_order_number);
1102: FND_MESSAGE.Set_Token('LINE_NUMBER' ,p_line_number);

Line 1099: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);

1095: FND_MESSAGE.Set_Token('ORDER_NUMBER' ,p_order_number);
1096: FND_MESSAGE.Set_Token('LINE_NUMBER' ,p_line_number);
1097: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
1098: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used);
1099: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
1100: FND_MESSAGE.Set_Name('ONT','OE_CC_LINE_HOLD_MSG');
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);

Line 1100: FND_MESSAGE.Set_Name('ONT','OE_CC_LINE_HOLD_MSG');

1096: FND_MESSAGE.Set_Token('LINE_NUMBER' ,p_line_number);
1097: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
1098: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used);
1099: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
1100: FND_MESSAGE.Set_Name('ONT','OE_CC_LINE_HOLD_MSG');
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);

Line 1101: FND_MESSAGE.Set_Token('ORDER_NUMBER' ,p_order_number);

1097: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
1098: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used);
1099: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
1100: FND_MESSAGE.Set_Name('ONT','OE_CC_LINE_HOLD_MSG');
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;

Line 1102: FND_MESSAGE.Set_Token('LINE_NUMBER' ,p_line_number);

1098: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used);
1099: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
1100: FND_MESSAGE.Set_Name('ONT','OE_CC_LINE_HOLD_MSG');
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:

Line 1103: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);

1099: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
1100: FND_MESSAGE.Set_Name('ONT','OE_CC_LINE_HOLD_MSG');
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

Line 1104: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used);

1100: FND_MESSAGE.Set_Name('ONT','OE_CC_LINE_HOLD_MSG');
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

Line 1109: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_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||'_'||
1110: p_cc_profile_used);
1111: FND_MESSAGE.Set_Token('ORDER_NUMBER' ,p_order_number);
1112: FND_MESSAGE.Set_Token('LINE_NUMBER' ,p_line_number);
1113: FND_MESSAGE.Set_Token('CUSTOMER_NAME',p_customer_name);

Line 1111: FND_MESSAGE.Set_Token('ORDER_NUMBER' ,p_order_number);

1107: ELSE
1108: IF p_cc_profile_used = 'SITE' THEN
1109: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||
1110: p_cc_profile_used);
1111: FND_MESSAGE.Set_Token('ORDER_NUMBER' ,p_order_number);
1112: FND_MESSAGE.Set_Token('LINE_NUMBER' ,p_line_number);
1113: FND_MESSAGE.Set_Token('CUSTOMER_NAME',p_customer_name);
1114: FND_MESSAGE.Set_Token('SITE_NAME' ,p_site_name);
1115: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);

Line 1112: FND_MESSAGE.Set_Token('LINE_NUMBER' ,p_line_number);

1108: IF p_cc_profile_used = 'SITE' THEN
1109: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||
1110: p_cc_profile_used);
1111: FND_MESSAGE.Set_Token('ORDER_NUMBER' ,p_order_number);
1112: FND_MESSAGE.Set_Token('LINE_NUMBER' ,p_line_number);
1113: FND_MESSAGE.Set_Token('CUSTOMER_NAME',p_customer_name);
1114: FND_MESSAGE.Set_Token('SITE_NAME' ,p_site_name);
1115: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
1116:

Line 1113: FND_MESSAGE.Set_Token('CUSTOMER_NAME',p_customer_name);

1109: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||
1110: p_cc_profile_used);
1111: FND_MESSAGE.Set_Token('ORDER_NUMBER' ,p_order_number);
1112: FND_MESSAGE.Set_Token('LINE_NUMBER' ,p_line_number);
1113: FND_MESSAGE.Set_Token('CUSTOMER_NAME',p_customer_name);
1114: FND_MESSAGE.Set_Token('SITE_NAME' ,p_site_name);
1115: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
1116:
1117: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||

Line 1114: FND_MESSAGE.Set_Token('SITE_NAME' ,p_site_name);

1110: p_cc_profile_used);
1111: FND_MESSAGE.Set_Token('ORDER_NUMBER' ,p_order_number);
1112: FND_MESSAGE.Set_Token('LINE_NUMBER' ,p_line_number);
1113: FND_MESSAGE.Set_Token('CUSTOMER_NAME',p_customer_name);
1114: FND_MESSAGE.Set_Token('SITE_NAME' ,p_site_name);
1115: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
1116:
1117: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||
1118: p_cc_profile_used);

Line 1115: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);

1111: FND_MESSAGE.Set_Token('ORDER_NUMBER' ,p_order_number);
1112: FND_MESSAGE.Set_Token('LINE_NUMBER' ,p_line_number);
1113: FND_MESSAGE.Set_Token('CUSTOMER_NAME',p_customer_name);
1114: FND_MESSAGE.Set_Token('SITE_NAME' ,p_site_name);
1115: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
1116:
1117: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||
1118: p_cc_profile_used);
1119: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);

Line 1117: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||

1113: FND_MESSAGE.Set_Token('CUSTOMER_NAME',p_customer_name);
1114: FND_MESSAGE.Set_Token('SITE_NAME' ,p_site_name);
1115: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
1116:
1117: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||
1118: p_cc_profile_used);
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);

Line 1119: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);

1115: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
1116:
1117: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||
1118: p_cc_profile_used);
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;

Line 1120: FND_MESSAGE.Set_Token('LINE_NUMBER',p_line_number);

1116:
1117: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||
1118: p_cc_profile_used);
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'

Line 1121: FND_MESSAGE.Set_Token('CUSTOMER_NAME',p_customer_name);

1117: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||
1118: p_cc_profile_used);
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

Line 1122: FND_MESSAGE.Set_Token('SITE_NAME' ,p_site_name);

1118: p_cc_profile_used);
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||'_'||

Line 1126: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||

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);
1128: FND_MESSAGE.Set_Token('ORDER_NUMBER' ,p_order_number);
1129: FND_MESSAGE.Set_Token('LINE_NUMBER' ,p_line_number);
1130: FND_MESSAGE.Set_Token('CUSTOMER_NAME',p_customer_name);

Line 1128: FND_MESSAGE.Set_Token('ORDER_NUMBER' ,p_order_number);

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);
1128: FND_MESSAGE.Set_Token('ORDER_NUMBER' ,p_order_number);
1129: FND_MESSAGE.Set_Token('LINE_NUMBER' ,p_line_number);
1130: FND_MESSAGE.Set_Token('CUSTOMER_NAME',p_customer_name);
1131: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
1132:

Line 1129: FND_MESSAGE.Set_Token('LINE_NUMBER' ,p_line_number);

1125: THEN
1126: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||
1127: p_cc_profile_used);
1128: FND_MESSAGE.Set_Token('ORDER_NUMBER' ,p_order_number);
1129: FND_MESSAGE.Set_Token('LINE_NUMBER' ,p_line_number);
1130: FND_MESSAGE.Set_Token('CUSTOMER_NAME',p_customer_name);
1131: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
1132:
1133: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||

Line 1130: FND_MESSAGE.Set_Token('CUSTOMER_NAME',p_customer_name);

1126: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||
1127: p_cc_profile_used);
1128: FND_MESSAGE.Set_Token('ORDER_NUMBER' ,p_order_number);
1129: FND_MESSAGE.Set_Token('LINE_NUMBER' ,p_line_number);
1130: FND_MESSAGE.Set_Token('CUSTOMER_NAME',p_customer_name);
1131: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
1132:
1133: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||
1134: p_cc_profile_used);

Line 1131: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);

1127: p_cc_profile_used);
1128: FND_MESSAGE.Set_Token('ORDER_NUMBER' ,p_order_number);
1129: FND_MESSAGE.Set_Token('LINE_NUMBER' ,p_line_number);
1130: FND_MESSAGE.Set_Token('CUSTOMER_NAME',p_customer_name);
1131: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
1132:
1133: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||
1134: p_cc_profile_used);
1135: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);

Line 1133: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||

1129: FND_MESSAGE.Set_Token('LINE_NUMBER' ,p_line_number);
1130: FND_MESSAGE.Set_Token('CUSTOMER_NAME',p_customer_name);
1131: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
1132:
1133: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||
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);

Line 1135: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);

1131: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
1132:
1133: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||
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:

Line 1136: FND_MESSAGE.Set_Token('LINE_NUMBER',p_line_number);

1132:
1133: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||
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'

Line 1137: FND_MESSAGE.Set_Token('CUSTOMER_NAME',p_customer_name);

1133: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||
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

Line 1142: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||

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||'_'||
1143: p_cc_profile_used);
1144: FND_MESSAGE.Set_Token('ORDER_NUMBER' ,p_order_number);
1145: FND_MESSAGE.Set_Token('LINE_NUMBER' ,p_line_number);
1146: FND_MESSAGE.Set_Token('PARTY_NAME',p_party_name );

Line 1144: FND_MESSAGE.Set_Token('ORDER_NUMBER' ,p_order_number);

1140: ELSIF p_cc_profile_used = 'PARTY'
1141: THEN
1142: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||
1143: p_cc_profile_used);
1144: FND_MESSAGE.Set_Token('ORDER_NUMBER' ,p_order_number);
1145: FND_MESSAGE.Set_Token('LINE_NUMBER' ,p_line_number);
1146: FND_MESSAGE.Set_Token('PARTY_NAME',p_party_name );
1147: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
1148:

Line 1145: FND_MESSAGE.Set_Token('LINE_NUMBER' ,p_line_number);

1141: THEN
1142: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||
1143: p_cc_profile_used);
1144: FND_MESSAGE.Set_Token('ORDER_NUMBER' ,p_order_number);
1145: FND_MESSAGE.Set_Token('LINE_NUMBER' ,p_line_number);
1146: FND_MESSAGE.Set_Token('PARTY_NAME',p_party_name );
1147: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
1148:
1149: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||

Line 1146: FND_MESSAGE.Set_Token('PARTY_NAME',p_party_name );

1142: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||
1143: p_cc_profile_used);
1144: FND_MESSAGE.Set_Token('ORDER_NUMBER' ,p_order_number);
1145: FND_MESSAGE.Set_Token('LINE_NUMBER' ,p_line_number);
1146: FND_MESSAGE.Set_Token('PARTY_NAME',p_party_name );
1147: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
1148:
1149: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||
1150: p_cc_profile_used);

Line 1147: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);

1143: p_cc_profile_used);
1144: FND_MESSAGE.Set_Token('ORDER_NUMBER' ,p_order_number);
1145: FND_MESSAGE.Set_Token('LINE_NUMBER' ,p_line_number);
1146: FND_MESSAGE.Set_Token('PARTY_NAME',p_party_name );
1147: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
1148:
1149: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||
1150: p_cc_profile_used);
1151: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);

Line 1149: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||

1145: FND_MESSAGE.Set_Token('LINE_NUMBER' ,p_line_number);
1146: FND_MESSAGE.Set_Token('PARTY_NAME',p_party_name );
1147: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
1148:
1149: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||
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) ;

Line 1151: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);

1147: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
1148:
1149: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||
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:

Line 1152: FND_MESSAGE.Set_Token('LINE_NUMBER',p_line_number);

1148:
1149: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||
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

Line 1153: FND_MESSAGE.Set_Token('PARTY_NAME',p_party_name) ;

1149: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||
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||'_'||

Line 1157: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||

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);
1159: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);
1160: FND_MESSAGE.Set_Token('LINE_NUMBER',p_line_number);
1161: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);

Line 1159: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);

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);
1159: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);
1160: FND_MESSAGE.Set_Token('LINE_NUMBER',p_line_number);
1161: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
1162:
1163: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||

Line 1160: FND_MESSAGE.Set_Token('LINE_NUMBER',p_line_number);

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);
1159: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);
1160: FND_MESSAGE.Set_Token('LINE_NUMBER',p_line_number);
1161: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
1162:
1163: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||
1164: p_cc_profile_used);

Line 1161: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);

1157: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||
1158: p_cc_profile_used);
1159: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);
1160: FND_MESSAGE.Set_Token('LINE_NUMBER',p_line_number);
1161: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
1162:
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);

Line 1163: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||

1159: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);
1160: FND_MESSAGE.Set_Token('LINE_NUMBER',p_line_number);
1161: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
1162:
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;

Line 1165: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);

1161: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
1162:
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;

Line 1166: FND_MESSAGE.Set_Token('LINE_NUMBER',p_line_number);

1162:
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

Line 1171: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||

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||'_'||
1172: 'CATEGORY');
1173: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);
1174: FND_MESSAGE.Set_Token('LINE_NUMBER',p_line_number);
1175: FND_MESSAGE.Set_Token('CATEGORY',p_item_category);

Line 1173: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);

1169: END IF;
1170: ELSE
1171: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||
1172: 'CATEGORY');
1173: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);
1174: FND_MESSAGE.Set_Token('LINE_NUMBER',p_line_number);
1175: FND_MESSAGE.Set_Token('CATEGORY',p_item_category);
1176: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
1177:

Line 1174: FND_MESSAGE.Set_Token('LINE_NUMBER',p_line_number);

1170: ELSE
1171: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||
1172: 'CATEGORY');
1173: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);
1174: FND_MESSAGE.Set_Token('LINE_NUMBER',p_line_number);
1175: FND_MESSAGE.Set_Token('CATEGORY',p_item_category);
1176: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
1177:
1178: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||

Line 1175: FND_MESSAGE.Set_Token('CATEGORY',p_item_category);

1171: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||
1172: 'CATEGORY');
1173: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);
1174: FND_MESSAGE.Set_Token('LINE_NUMBER',p_line_number);
1175: FND_MESSAGE.Set_Token('CATEGORY',p_item_category);
1176: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
1177:
1178: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||
1179: 'CATEGORY');

Line 1176: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);

1172: 'CATEGORY');
1173: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);
1174: FND_MESSAGE.Set_Token('LINE_NUMBER',p_line_number);
1175: FND_MESSAGE.Set_Token('CATEGORY',p_item_category);
1176: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
1177:
1178: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||
1179: 'CATEGORY');
1180: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);

Line 1178: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||

1174: FND_MESSAGE.Set_Token('LINE_NUMBER',p_line_number);
1175: FND_MESSAGE.Set_Token('CATEGORY',p_item_category);
1176: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
1177:
1178: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||
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);

Line 1180: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);

1176: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
1177:
1178: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||
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;

Line 1181: FND_MESSAGE.Set_Token('LINE_NUMBER',p_line_number);

1177:
1178: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||
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

Line 1182: FND_MESSAGE.Set_Token('CATEGORY',p_item_category);

1178: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||
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: --

Line 1209: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_ACT_COM');

1205: ELSE
1206: l_calling_activity := InitCap(OE_Verify_Payment_PUB.G_init_calling_action);
1207: END IF;
1208:
1209: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_ACT_COM');
1210: FND_MESSAGE.Set_Token('CALLING_ACTIVITY',l_calling_activity);
1211: FND_MESSAGE.Set_Token('CREDIT_CHECK_RULE',OE_Verify_Payment_PUB.G_credit_check_rule);
1212:
1213: l_comment := l_comment||SUBSTR(FND_MESSAGE.GET,1,2000);

Line 1210: FND_MESSAGE.Set_Token('CALLING_ACTIVITY',l_calling_activity);

1206: l_calling_activity := InitCap(OE_Verify_Payment_PUB.G_init_calling_action);
1207: END IF;
1208:
1209: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_ACT_COM');
1210: FND_MESSAGE.Set_Token('CALLING_ACTIVITY',l_calling_activity);
1211: FND_MESSAGE.Set_Token('CREDIT_CHECK_RULE',OE_Verify_Payment_PUB.G_credit_check_rule);
1212:
1213: l_comment := l_comment||SUBSTR(FND_MESSAGE.GET,1,2000);
1214: --ER#7479609 end

Line 1211: FND_MESSAGE.Set_Token('CREDIT_CHECK_RULE',OE_Verify_Payment_PUB.G_credit_check_rule);

1207: END IF;
1208:
1209: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_ACT_COM');
1210: FND_MESSAGE.Set_Token('CALLING_ACTIVITY',l_calling_activity);
1211: FND_MESSAGE.Set_Token('CREDIT_CHECK_RULE',OE_Verify_Payment_PUB.G_credit_check_rule);
1212:
1213: l_comment := l_comment||SUBSTR(FND_MESSAGE.GET,1,2000);
1214: --ER#7479609 end
1215:

Line 1213: l_comment := l_comment||SUBSTR(FND_MESSAGE.GET,1,2000);

1209: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_ACT_COM');
1210: FND_MESSAGE.Set_Token('CALLING_ACTIVITY',l_calling_activity);
1211: FND_MESSAGE.Set_Token('CREDIT_CHECK_RULE',OE_Verify_Payment_PUB.G_credit_check_rule);
1212:
1213: l_comment := l_comment||SUBSTR(FND_MESSAGE.GET,1,2000);
1214: --ER#7479609 end
1215:
1216: x_comment := NVL(OE_Credit_Engine_GRP.G_currency_error_msg,l_comment);
1217:

Line 1256: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_REMOVED');

1252: ||' Line Number: '||TO_CHAR(p_line_number)
1253: ||' released from credit check hold.');
1254: END IF;
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

Line 1257: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);

1253: ||' released from credit check hold.');
1254: END IF;
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);

Line 1258: FND_MESSAGE.Set_Token('LINE_NUMBER',p_line_number);

1254: END IF;
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: --

Line 1310: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_MSG');

1306:
1307: --bug 4153299
1308: l_cc_profile_used := OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_PROFILE', p_cc_profile_used);
1309:
1310: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_MSG');
1311: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
1312: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used);
1313: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
1314: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_MSG');

Line 1311: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);

1307: --bug 4153299
1308: l_cc_profile_used := OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_PROFILE', p_cc_profile_used);
1309:
1310: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_MSG');
1311: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
1312: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used);
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);

Line 1312: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used);

1308: l_cc_profile_used := OE_CREDIT_CHECK_UTIL.Get_CC_Lookup_Meaning('OE_CC_PROFILE', p_cc_profile_used);
1309:
1310: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_MSG');
1311: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
1312: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used);
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);

Line 1313: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);

1309:
1310: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_MSG');
1311: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
1312: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used);
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;

Line 1314: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_MSG');

1310: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_MSG');
1311: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
1312: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used);
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

Line 1315: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);

1311: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
1312: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used);
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||'_'||

Line 1316: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used);

1312: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used);
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);

Line 1319: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_'||p_cc_limit_used||'_'||

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);
1322: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_'||p_cc_limit_used||'_'||
1323: p_cc_profile_used);

Line 1321: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);

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);
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;

Line 1322: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_'||p_cc_limit_used||'_'||

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);
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

Line 1327: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_'||p_cc_limit_used||'_CATEGORY');

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);
1329: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
1330: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_'||p_cc_limit_used||'_'||
1331: 'CATEGORY');

Line 1328: FND_MESSAGE.Set_Token('CATEGORY',p_item_category);

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);
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);

Line 1329: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);

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);
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;

Line 1330: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_'||p_cc_limit_used||'_'||

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);
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;

Line 1332: FND_MESSAGE.Set_Token('CATEGORY',p_item_category);

1328: FND_MESSAGE.Set_Token('CATEGORY',p_item_category);
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

Line 1351: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_ACT_COM');

1347: ELSE
1348: l_calling_activity := InitCap(OE_Verify_Payment_PUB.G_init_calling_action);
1349: END IF;
1350:
1351: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_ACT_COM');
1352: FND_MESSAGE.Set_Token('CALLING_ACTIVITY',l_calling_activity);
1353: FND_MESSAGE.Set_Token('CREDIT_CHECK_RULE',OE_Verify_Payment_PUB.G_credit_check_rule);
1354:
1355: l_comment := l_comment||SUBSTR(FND_MESSAGE.GET,1,2000);

Line 1352: FND_MESSAGE.Set_Token('CALLING_ACTIVITY',l_calling_activity);

1348: l_calling_activity := InitCap(OE_Verify_Payment_PUB.G_init_calling_action);
1349: END IF;
1350:
1351: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_ACT_COM');
1352: FND_MESSAGE.Set_Token('CALLING_ACTIVITY',l_calling_activity);
1353: FND_MESSAGE.Set_Token('CREDIT_CHECK_RULE',OE_Verify_Payment_PUB.G_credit_check_rule);
1354:
1355: l_comment := l_comment||SUBSTR(FND_MESSAGE.GET,1,2000);
1356: --ER#7479609 end

Line 1353: FND_MESSAGE.Set_Token('CREDIT_CHECK_RULE',OE_Verify_Payment_PUB.G_credit_check_rule);

1349: END IF;
1350:
1351: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_ACT_COM');
1352: FND_MESSAGE.Set_Token('CALLING_ACTIVITY',l_calling_activity);
1353: FND_MESSAGE.Set_Token('CREDIT_CHECK_RULE',OE_Verify_Payment_PUB.G_credit_check_rule);
1354:
1355: l_comment := l_comment||SUBSTR(FND_MESSAGE.GET,1,2000);
1356: --ER#7479609 end
1357:

Line 1355: l_comment := l_comment||SUBSTR(FND_MESSAGE.GET,1,2000);

1351: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_ACT_COM');
1352: FND_MESSAGE.Set_Token('CALLING_ACTIVITY',l_calling_activity);
1353: FND_MESSAGE.Set_Token('CREDIT_CHECK_RULE',OE_Verify_Payment_PUB.G_credit_check_rule);
1354:
1355: l_comment := l_comment||SUBSTR(FND_MESSAGE.GET,1,2000);
1356: --ER#7479609 end
1357:
1358: x_comment := l_comment;
1359:

Line 1393: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_REMOVED');

1389: IF p_calling_action = 'AUTO RELEASE' THEN
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'

Line 1972: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_ACT_COM');

1968: ELSE
1969: l_calling_activity := InitCap(OE_Verify_Payment_PUB.G_init_calling_action);
1970: END IF;
1971:
1972: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_ACT_COM');
1973: FND_MESSAGE.Set_Token('CALLING_ACTIVITY',l_calling_activity);
1974: FND_MESSAGE.Set_Token('CREDIT_CHECK_RULE',OE_Verify_Payment_PUB.G_credit_check_rule);
1975:
1976: l_hold_release_rec.release_comment := l_hold_release_rec.release_comment||SUBSTR(FND_MESSAGE.GET,1,2000);

Line 1973: FND_MESSAGE.Set_Token('CALLING_ACTIVITY',l_calling_activity);

1969: l_calling_activity := InitCap(OE_Verify_Payment_PUB.G_init_calling_action);
1970: END IF;
1971:
1972: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_ACT_COM');
1973: FND_MESSAGE.Set_Token('CALLING_ACTIVITY',l_calling_activity);
1974: FND_MESSAGE.Set_Token('CREDIT_CHECK_RULE',OE_Verify_Payment_PUB.G_credit_check_rule);
1975:
1976: l_hold_release_rec.release_comment := l_hold_release_rec.release_comment||SUBSTR(FND_MESSAGE.GET,1,2000);
1977:

Line 1974: FND_MESSAGE.Set_Token('CREDIT_CHECK_RULE',OE_Verify_Payment_PUB.G_credit_check_rule);

1970: END IF;
1971:
1972: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_ACT_COM');
1973: FND_MESSAGE.Set_Token('CALLING_ACTIVITY',l_calling_activity);
1974: FND_MESSAGE.Set_Token('CREDIT_CHECK_RULE',OE_Verify_Payment_PUB.G_credit_check_rule);
1975:
1976: l_hold_release_rec.release_comment := l_hold_release_rec.release_comment||SUBSTR(FND_MESSAGE.GET,1,2000);
1977:
1978: --ER#7479609 end

Line 1976: l_hold_release_rec.release_comment := l_hold_release_rec.release_comment||SUBSTR(FND_MESSAGE.GET,1,2000);

1972: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_ACT_COM');
1973: FND_MESSAGE.Set_Token('CALLING_ACTIVITY',l_calling_activity);
1974: FND_MESSAGE.Set_Token('CREDIT_CHECK_RULE',OE_Verify_Payment_PUB.G_credit_check_rule);
1975:
1976: l_hold_release_rec.release_comment := l_hold_release_rec.release_comment||SUBSTR(FND_MESSAGE.GET,1,2000);
1977:
1978: --ER#7479609 end
1979:
1980:

Line 2199: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_ACT_COM');

2195: ELSE
2196: l_calling_activity := InitCap(OE_Verify_Payment_PUB.G_init_calling_action);
2197: END IF;
2198:
2199: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_ACT_COM');
2200: FND_MESSAGE.Set_Token('CALLING_ACTIVITY',l_calling_activity);
2201: FND_MESSAGE.Set_Token('CREDIT_CHECK_RULE',OE_Verify_Payment_PUB.G_credit_check_rule);
2202:
2203: l_hold_release_rec.release_comment := l_hold_release_rec.release_comment||SUBSTR(FND_MESSAGE.GET,1,2000);

Line 2200: FND_MESSAGE.Set_Token('CALLING_ACTIVITY',l_calling_activity);

2196: l_calling_activity := InitCap(OE_Verify_Payment_PUB.G_init_calling_action);
2197: END IF;
2198:
2199: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_ACT_COM');
2200: FND_MESSAGE.Set_Token('CALLING_ACTIVITY',l_calling_activity);
2201: FND_MESSAGE.Set_Token('CREDIT_CHECK_RULE',OE_Verify_Payment_PUB.G_credit_check_rule);
2202:
2203: l_hold_release_rec.release_comment := l_hold_release_rec.release_comment||SUBSTR(FND_MESSAGE.GET,1,2000);
2204: --ER#7479609 end

Line 2201: FND_MESSAGE.Set_Token('CREDIT_CHECK_RULE',OE_Verify_Payment_PUB.G_credit_check_rule);

2197: END IF;
2198:
2199: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_ACT_COM');
2200: FND_MESSAGE.Set_Token('CALLING_ACTIVITY',l_calling_activity);
2201: FND_MESSAGE.Set_Token('CREDIT_CHECK_RULE',OE_Verify_Payment_PUB.G_credit_check_rule);
2202:
2203: l_hold_release_rec.release_comment := l_hold_release_rec.release_comment||SUBSTR(FND_MESSAGE.GET,1,2000);
2204: --ER#7479609 end
2205:

Line 2203: l_hold_release_rec.release_comment := l_hold_release_rec.release_comment||SUBSTR(FND_MESSAGE.GET,1,2000);

2199: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_ACT_COM');
2200: FND_MESSAGE.Set_Token('CALLING_ACTIVITY',l_calling_activity);
2201: FND_MESSAGE.Set_Token('CREDIT_CHECK_RULE',OE_Verify_Payment_PUB.G_credit_check_rule);
2202:
2203: l_hold_release_rec.release_comment := l_hold_release_rec.release_comment||SUBSTR(FND_MESSAGE.GET,1,2000);
2204: --ER#7479609 end
2205:
2206: OE_Holds_PUB.Release_Holds
2207: ( p_api_version => 1.0

Line 2389: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');

2385: IF x_conversion_status.COUNT > 0
2386: THEN
2387: x_cc_result_out := 'FAIL';
2388:
2389: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
2390: FND_MESSAGE.Set_Token('FROM',p_header_rec.transactional_curr_code);
2391: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );
2392: FND_MESSAGE.Set_Token('CONV',
2393: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate'));

Line 2390: FND_MESSAGE.Set_Token('FROM',p_header_rec.transactional_curr_code);

2386: THEN
2387: x_cc_result_out := 'FAIL';
2388:
2389: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
2390: FND_MESSAGE.Set_Token('FROM',p_header_rec.transactional_curr_code);
2391: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );
2392: FND_MESSAGE.Set_Token('CONV',
2393: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate'));
2394: OE_Credit_Engine_GRP.G_currency_error_msg :=

Line 2391: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );

2387: x_cc_result_out := 'FAIL';
2388:
2389: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
2390: FND_MESSAGE.Set_Token('FROM',p_header_rec.transactional_curr_code);
2391: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );
2392: FND_MESSAGE.Set_Token('CONV',
2393: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate'));
2394: OE_Credit_Engine_GRP.G_currency_error_msg :=
2395: SUBSTR(FND_MESSAGE.GET,1,1000) ;

Line 2392: FND_MESSAGE.Set_Token('CONV',

2388:
2389: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
2390: FND_MESSAGE.Set_Token('FROM',p_header_rec.transactional_curr_code);
2391: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );
2392: FND_MESSAGE.Set_Token('CONV',
2393: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate'));
2394: OE_Credit_Engine_GRP.G_currency_error_msg :=
2395: SUBSTR(FND_MESSAGE.GET,1,1000) ;
2396:

Line 2395: SUBSTR(FND_MESSAGE.GET,1,1000) ;

2391: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );
2392: FND_MESSAGE.Set_Token('CONV',
2393: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate'));
2394: OE_Credit_Engine_GRP.G_currency_error_msg :=
2395: SUBSTR(FND_MESSAGE.GET,1,1000) ;
2396:
2397: G_result_out := 'FAIL' ;
2398: x_cc_result_out := 'FAIL' ;
2399:

Line 2402: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');

2398: x_cc_result_out := 'FAIL' ;
2399:
2400: IF p_credit_check_rule_rec.credit_hold_level_code = 'ORDER'
2401: THEN
2402: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
2403: FND_MESSAGE.Set_Token('FROM',p_header_rec.transactional_curr_code);
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'));

Line 2403: FND_MESSAGE.Set_Token('FROM',p_header_rec.transactional_curr_code);

2399:
2400: IF p_credit_check_rule_rec.credit_hold_level_code = 'ORDER'
2401: THEN
2402: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
2403: FND_MESSAGE.Set_Token('FROM',p_header_rec.transactional_curr_code);
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:

Line 2404: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );

2400: IF p_credit_check_rule_rec.credit_hold_level_code = 'ORDER'
2401: THEN
2402: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
2403: FND_MESSAGE.Set_Token('FROM',p_header_rec.transactional_curr_code);
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;

Line 2405: FND_MESSAGE.Set_Token('CONV',

2401: THEN
2402: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
2403: FND_MESSAGE.Set_Token('FROM',p_header_rec.transactional_curr_code);
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;

Line 2808: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');

2804: x_cc_result_out := 'FAIL' ;
2805:
2806: OE_DEBUG_PUB.Add(' Currency conversion failed ');
2807:
2808: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
2809: FND_MESSAGE.Set_Token('FROM',x_error_curr_tbl(1).usage_curr_code);
2810: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );
2811: FND_MESSAGE.Set_Token('CONV',
2812: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate'));

Line 2809: FND_MESSAGE.Set_Token('FROM',x_error_curr_tbl(1).usage_curr_code);

2805:
2806: OE_DEBUG_PUB.Add(' Currency conversion failed ');
2807:
2808: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
2809: FND_MESSAGE.Set_Token('FROM',x_error_curr_tbl(1).usage_curr_code);
2810: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );
2811: FND_MESSAGE.Set_Token('CONV',
2812: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate'));
2813: OE_Credit_Engine_GRP.G_currency_error_msg :=

Line 2810: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );

2806: OE_DEBUG_PUB.Add(' Currency conversion failed ');
2807:
2808: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
2809: FND_MESSAGE.Set_Token('FROM',x_error_curr_tbl(1).usage_curr_code);
2810: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );
2811: FND_MESSAGE.Set_Token('CONV',
2812: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate'));
2813: OE_Credit_Engine_GRP.G_currency_error_msg :=
2814: SUBSTR(FND_MESSAGE.GET,1,1000) ;

Line 2811: FND_MESSAGE.Set_Token('CONV',

2807:
2808: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
2809: FND_MESSAGE.Set_Token('FROM',x_error_curr_tbl(1).usage_curr_code);
2810: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );
2811: FND_MESSAGE.Set_Token('CONV',
2812: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate'));
2813: OE_Credit_Engine_GRP.G_currency_error_msg :=
2814: SUBSTR(FND_MESSAGE.GET,1,1000) ;
2815:

Line 2814: SUBSTR(FND_MESSAGE.GET,1,1000) ;

2810: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );
2811: FND_MESSAGE.Set_Token('CONV',
2812: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate'));
2813: OE_Credit_Engine_GRP.G_currency_error_msg :=
2814: SUBSTR(FND_MESSAGE.GET,1,1000) ;
2815:
2816: G_result_out := 'FAIL' ;
2817: x_cc_result_out := 'FAIL' ;
2818:

Line 2822: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');

2818:
2819:
2820: IF p_credit_check_rule_rec.credit_hold_level_code = 'ORDER'
2821: THEN
2822: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
2823: FND_MESSAGE.Set_Token('FROM',x_error_curr_tbl(1).usage_curr_code);
2824: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );
2825: FND_MESSAGE.Set_Token('CONV',
2826: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate'));

Line 2823: FND_MESSAGE.Set_Token('FROM',x_error_curr_tbl(1).usage_curr_code);

2819:
2820: IF p_credit_check_rule_rec.credit_hold_level_code = 'ORDER'
2821: THEN
2822: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
2823: FND_MESSAGE.Set_Token('FROM',x_error_curr_tbl(1).usage_curr_code);
2824: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );
2825: FND_MESSAGE.Set_Token('CONV',
2826: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate'));
2827:

Line 2824: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );

2820: IF p_credit_check_rule_rec.credit_hold_level_code = 'ORDER'
2821: THEN
2822: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
2823: FND_MESSAGE.Set_Token('FROM',x_error_curr_tbl(1).usage_curr_code);
2824: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );
2825: FND_MESSAGE.Set_Token('CONV',
2826: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate'));
2827:
2828:

Line 2825: FND_MESSAGE.Set_Token('CONV',

2821: THEN
2822: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
2823: FND_MESSAGE.Set_Token('FROM',x_error_curr_tbl(1).usage_curr_code);
2824: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );
2825: FND_MESSAGE.Set_Token('CONV',
2826: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate'));
2827:
2828:
2829: OE_MSG_PUB.ADD;

Line 3052: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');

3048: OE_DEBUG_PUB.Add('Apply_Order_CC_Hold for Item category');
3049: OE_DEBUG_PUB.Add('currency = '|| p_header_rec.transactional_curr_code );
3050: OE_DEBUG_PUB.Add('checking category = '|| l_check_category_id );
3051:
3052: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
3053: FND_MESSAGE.Set_Token('FROM',p_header_rec.transactional_curr_code );
3054: FND_MESSAGE.Set_Token('TO',l_limit_currency );
3055: FND_MESSAGE.Set_Token('CONV',
3056: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate'));

Line 3053: FND_MESSAGE.Set_Token('FROM',p_header_rec.transactional_curr_code );

3049: OE_DEBUG_PUB.Add('currency = '|| p_header_rec.transactional_curr_code );
3050: OE_DEBUG_PUB.Add('checking category = '|| l_check_category_id );
3051:
3052: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
3053: FND_MESSAGE.Set_Token('FROM',p_header_rec.transactional_curr_code );
3054: FND_MESSAGE.Set_Token('TO',l_limit_currency );
3055: FND_MESSAGE.Set_Token('CONV',
3056: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate'));
3057: OE_Credit_Engine_GRP.G_currency_error_msg :=

Line 3054: FND_MESSAGE.Set_Token('TO',l_limit_currency );

3050: OE_DEBUG_PUB.Add('checking category = '|| l_check_category_id );
3051:
3052: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
3053: FND_MESSAGE.Set_Token('FROM',p_header_rec.transactional_curr_code );
3054: FND_MESSAGE.Set_Token('TO',l_limit_currency );
3055: FND_MESSAGE.Set_Token('CONV',
3056: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate'));
3057: OE_Credit_Engine_GRP.G_currency_error_msg :=
3058: SUBSTR(FND_MESSAGE.GET,1,1000) ;

Line 3055: FND_MESSAGE.Set_Token('CONV',

3051:
3052: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
3053: FND_MESSAGE.Set_Token('FROM',p_header_rec.transactional_curr_code );
3054: FND_MESSAGE.Set_Token('TO',l_limit_currency );
3055: FND_MESSAGE.Set_Token('CONV',
3056: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate'));
3057: OE_Credit_Engine_GRP.G_currency_error_msg :=
3058: SUBSTR(FND_MESSAGE.GET,1,1000) ;
3059: G_result_out := 'FAIL' ;

Line 3058: SUBSTR(FND_MESSAGE.GET,1,1000) ;

3054: FND_MESSAGE.Set_Token('TO',l_limit_currency );
3055: FND_MESSAGE.Set_Token('CONV',
3056: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate'));
3057: OE_Credit_Engine_GRP.G_currency_error_msg :=
3058: SUBSTR(FND_MESSAGE.GET,1,1000) ;
3059: G_result_out := 'FAIL' ;
3060: x_cc_result_out := 'FAIL' ;
3061:
3062:

Line 3065: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');

3061:
3062:
3063: IF p_credit_check_rule_rec.credit_hold_level_code = 'ORDER'
3064: THEN
3065: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
3066: FND_MESSAGE.Set_Token('FROM',p_header_rec.transactional_curr_code );
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'));

Line 3066: FND_MESSAGE.Set_Token('FROM',p_header_rec.transactional_curr_code );

3062:
3063: IF p_credit_check_rule_rec.credit_hold_level_code = 'ORDER'
3064: THEN
3065: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
3066: FND_MESSAGE.Set_Token('FROM',p_header_rec.transactional_curr_code );
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:

Line 3067: FND_MESSAGE.Set_Token('TO',l_limit_currency );

3063: IF p_credit_check_rule_rec.credit_hold_level_code = 'ORDER'
3064: THEN
3065: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
3066: FND_MESSAGE.Set_Token('FROM',p_header_rec.transactional_curr_code );
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 ;

Line 3068: FND_MESSAGE.Set_Token('CONV',

3064: THEN
3065: fnd_message.set_name('ONT', 'OE_CC_CONVERSION_ERORR');
3066: FND_MESSAGE.Set_Token('FROM',p_header_rec.transactional_curr_code );
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;

Line 3910: FND_MESSAGE.Set_Name('ONT','OE_CC_CMGT_REVIEW');

3906: );
3907:
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:

Line 3911: FND_MESSAGE.Set_Token('REQUEST_ID',l_request_id);

3907:
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'

Line 4872: FND_MESSAGE.Set_Name('ONT','OE_CC_CMGT_REVIEW');

4868: p_entity_code => 'HEADER'
4869: ,p_entity_id => p_header_rec.header_id
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;

Line 4873: FND_MESSAGE.Set_Token('REQUEST_ID',l_request_id);

4869: ,p_entity_id => p_header_rec.header_id
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:

Line 4993: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_GENERAL_MSG');

4989: --FND_API.G_TRUE AND x_cc_result_out IN ('FAIL_HOLD', 'FAIL_NONE'))
4990: THEN
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:

Line 5001: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_REMOVED');

4997:
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: