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_EXTERNAL_CREDIT_PVT dependencies on FND_MESSAGE

Line 33: FND_MESSAGE.Set_Name('ONT', 'OE_CC_PARAMETER_NULL');

29: IS
30: BEGIN
31: OE_DEBUG_PUB.Add('OEXVCECB: In Is_Amount_Valid');
32: IF p_amount IS NULL THEN
33: FND_MESSAGE.Set_Name('ONT', 'OE_CC_PARAMETER_NULL');
34: FND_MESSAGE.SET_TOKEN ('PARAMETER_NAME', 'P_TRANSACTION_AMOUNT' );
35: OE_MSG_PUB.Add;
36: OE_DEBUG_PUB.Add('Validate Amount Failed.');
37: RETURN FALSE;

Line 34: FND_MESSAGE.SET_TOKEN ('PARAMETER_NAME', 'P_TRANSACTION_AMOUNT' );

30: BEGIN
31: OE_DEBUG_PUB.Add('OEXVCECB: In Is_Amount_Valid');
32: IF p_amount IS NULL THEN
33: FND_MESSAGE.Set_Name('ONT', 'OE_CC_PARAMETER_NULL');
34: FND_MESSAGE.SET_TOKEN ('PARAMETER_NAME', 'P_TRANSACTION_AMOUNT' );
35: OE_MSG_PUB.Add;
36: OE_DEBUG_PUB.Add('Validate Amount Failed.');
37: RETURN FALSE;
38: ELSE

Line 64: FND_MESSAGE.Set_Name('ONT', 'OE_CC_PARAMETER_NULL');

60: l_curr_valid NUMBER;
61: BEGIN
62: OE_DEBUG_PUB.Add('OEXVCECB: In Is_Currency_Valid');
63: IF p_currency_code IS NULL THEN
64: FND_MESSAGE.Set_Name('ONT', 'OE_CC_PARAMETER_NULL');
65: FND_MESSAGE.SET_TOKEN ('PARAMETER_NAME', p_parameter_name );
66: OE_MSG_PUB.Add;
67: OE_DEBUG_PUB.Add('Validate Currency Failed - NULL.');
68: l_return_value := FALSE;

Line 65: FND_MESSAGE.SET_TOKEN ('PARAMETER_NAME', p_parameter_name );

61: BEGIN
62: OE_DEBUG_PUB.Add('OEXVCECB: In Is_Currency_Valid');
63: IF p_currency_code IS NULL THEN
64: FND_MESSAGE.Set_Name('ONT', 'OE_CC_PARAMETER_NULL');
65: FND_MESSAGE.SET_TOKEN ('PARAMETER_NAME', p_parameter_name );
66: OE_MSG_PUB.Add;
67: OE_DEBUG_PUB.Add('Validate Currency Failed - NULL.');
68: l_return_value := FALSE;
69: ELSE

Line 82: FND_MESSAGE.Set_Name('ONT', 'OE_CC_CURRENCY_INVALID');

78: AND NVL(end_date_active, TO_DATE('31/12/9999','DD/MM/YYYY'))
79: >= TRUNC(SYSDATE) ;
80: EXCEPTION
81: WHEN NO_DATA_FOUND THEN
82: FND_MESSAGE.Set_Name('ONT', 'OE_CC_CURRENCY_INVALID');
83: FND_MESSAGE.SET_TOKEN ('PARAMETER_NAME', p_parameter_name);
84: FND_MESSAGE.SET_TOKEN ('PARAMETER_VALUE', p_currency_code);
85: OE_MSG_PUB.Add;
86: OE_DEBUG_PUB.Add('Validate Currency Failed - Invalid.');

Line 83: FND_MESSAGE.SET_TOKEN ('PARAMETER_NAME', p_parameter_name);

79: >= TRUNC(SYSDATE) ;
80: EXCEPTION
81: WHEN NO_DATA_FOUND THEN
82: FND_MESSAGE.Set_Name('ONT', 'OE_CC_CURRENCY_INVALID');
83: FND_MESSAGE.SET_TOKEN ('PARAMETER_NAME', p_parameter_name);
84: FND_MESSAGE.SET_TOKEN ('PARAMETER_VALUE', p_currency_code);
85: OE_MSG_PUB.Add;
86: OE_DEBUG_PUB.Add('Validate Currency Failed - Invalid.');
87: l_return_value := FALSE;

Line 84: FND_MESSAGE.SET_TOKEN ('PARAMETER_VALUE', p_currency_code);

80: EXCEPTION
81: WHEN NO_DATA_FOUND THEN
82: FND_MESSAGE.Set_Name('ONT', 'OE_CC_CURRENCY_INVALID');
83: FND_MESSAGE.SET_TOKEN ('PARAMETER_NAME', p_parameter_name);
84: FND_MESSAGE.SET_TOKEN ('PARAMETER_VALUE', p_currency_code);
85: OE_MSG_PUB.Add;
86: OE_DEBUG_PUB.Add('Validate Currency Failed - Invalid.');
87: l_return_value := FALSE;
88: END;

Line 134: FND_MESSAGE.Set_Name('ONT', 'OE_CC_ORG_ID_INVALID');

130: x_org_id := p_org_id;
131: EXCEPTION
132: WHEN NO_DATA_FOUND THEN
133: x_return_status := FND_API.G_RET_STS_ERROR;
134: FND_MESSAGE.Set_Name('ONT', 'OE_CC_ORG_ID_INVALID');
135: FND_MESSAGE.SET_TOKEN ('PARAMETER_NAME', 'P_ORG_ID' );
136: FND_MESSAGE.SET_TOKEN ('PARAMETER_VALUE', p_org_id);
137: OE_MSG_PUB.Add;
138: END;

Line 135: FND_MESSAGE.SET_TOKEN ('PARAMETER_NAME', 'P_ORG_ID' );

131: EXCEPTION
132: WHEN NO_DATA_FOUND THEN
133: x_return_status := FND_API.G_RET_STS_ERROR;
134: FND_MESSAGE.Set_Name('ONT', 'OE_CC_ORG_ID_INVALID');
135: FND_MESSAGE.SET_TOKEN ('PARAMETER_NAME', 'P_ORG_ID' );
136: FND_MESSAGE.SET_TOKEN ('PARAMETER_VALUE', p_org_id);
137: OE_MSG_PUB.Add;
138: END;
139: ELSIF p_org_id IS NULL THEN

Line 136: FND_MESSAGE.SET_TOKEN ('PARAMETER_VALUE', p_org_id);

132: WHEN NO_DATA_FOUND THEN
133: x_return_status := FND_API.G_RET_STS_ERROR;
134: FND_MESSAGE.Set_Name('ONT', 'OE_CC_ORG_ID_INVALID');
135: FND_MESSAGE.SET_TOKEN ('PARAMETER_NAME', 'P_ORG_ID' );
136: FND_MESSAGE.SET_TOKEN ('PARAMETER_VALUE', p_org_id);
137: OE_MSG_PUB.Add;
138: END;
139: ELSIF p_org_id IS NULL THEN
140: x_return_status := FND_API.G_RET_STS_ERROR;

Line 141: FND_MESSAGE.Set_Name('ONT', 'OE_CC_ORG_PARAMETER_NULL');

137: OE_MSG_PUB.Add;
138: END;
139: ELSIF p_org_id IS NULL THEN
140: x_return_status := FND_API.G_RET_STS_ERROR;
141: FND_MESSAGE.Set_Name('ONT', 'OE_CC_ORG_PARAMETER_NULL');
142: FND_MESSAGE.SET_TOKEN ('PARAMETER_NAME', 'P_ORG_ID' );
143: OE_MSG_PUB.Add;
144: ELSIF p_operating_unit_name IS NOT NULL AND
145: p_operating_unit_name <> FND_API.G_MISS_CHAR THEN

Line 142: FND_MESSAGE.SET_TOKEN ('PARAMETER_NAME', 'P_ORG_ID' );

138: END;
139: ELSIF p_org_id IS NULL THEN
140: x_return_status := FND_API.G_RET_STS_ERROR;
141: FND_MESSAGE.Set_Name('ONT', 'OE_CC_ORG_PARAMETER_NULL');
142: FND_MESSAGE.SET_TOKEN ('PARAMETER_NAME', 'P_ORG_ID' );
143: OE_MSG_PUB.Add;
144: ELSIF p_operating_unit_name IS NOT NULL AND
145: p_operating_unit_name <> FND_API.G_MISS_CHAR THEN
146: BEGIN

Line 155: FND_MESSAGE.Set_Name('ONT', 'OE_CC_ORG_NAME_INVALID');

151: x_org_id := l_org_id;
152: EXCEPTION
153: WHEN NO_DATA_FOUND THEN
154: x_return_status := FND_API.G_RET_STS_ERROR;
155: FND_MESSAGE.Set_Name('ONT', 'OE_CC_ORG_NAME_INVALID');
156: FND_MESSAGE.SET_TOKEN ('PARAMETER_NAME', 'P_OPERATION_UNIT_NAME');
157: FND_MESSAGE.SET_TOKEN ('PARAMETER_VALUE', p_operating_unit_name );
158: OE_MSG_PUB.Add;
159: END;

Line 156: FND_MESSAGE.SET_TOKEN ('PARAMETER_NAME', 'P_OPERATION_UNIT_NAME');

152: EXCEPTION
153: WHEN NO_DATA_FOUND THEN
154: x_return_status := FND_API.G_RET_STS_ERROR;
155: FND_MESSAGE.Set_Name('ONT', 'OE_CC_ORG_NAME_INVALID');
156: FND_MESSAGE.SET_TOKEN ('PARAMETER_NAME', 'P_OPERATION_UNIT_NAME');
157: FND_MESSAGE.SET_TOKEN ('PARAMETER_VALUE', p_operating_unit_name );
158: OE_MSG_PUB.Add;
159: END;
160: ELSIF p_operating_unit_name IS NULL THEN

Line 157: FND_MESSAGE.SET_TOKEN ('PARAMETER_VALUE', p_operating_unit_name );

153: WHEN NO_DATA_FOUND THEN
154: x_return_status := FND_API.G_RET_STS_ERROR;
155: FND_MESSAGE.Set_Name('ONT', 'OE_CC_ORG_NAME_INVALID');
156: FND_MESSAGE.SET_TOKEN ('PARAMETER_NAME', 'P_OPERATION_UNIT_NAME');
157: FND_MESSAGE.SET_TOKEN ('PARAMETER_VALUE', p_operating_unit_name );
158: OE_MSG_PUB.Add;
159: END;
160: ELSIF p_operating_unit_name IS NULL THEN
161: x_return_status := FND_API.G_RET_STS_ERROR;

Line 162: FND_MESSAGE.Set_Name('ONT', 'OE_CC_ORG_PARAMETER_NULL');

158: OE_MSG_PUB.Add;
159: END;
160: ELSIF p_operating_unit_name IS NULL THEN
161: x_return_status := FND_API.G_RET_STS_ERROR;
162: FND_MESSAGE.Set_Name('ONT', 'OE_CC_ORG_PARAMETER_NULL');
163: FND_MESSAGE.SET_TOKEN ('PARAMETER_NAME', 'P_OPERATION_UNIT_NAME' );
164: OE_MSG_PUB.Add;
165: ELSE
166: x_return_status := FND_API.G_RET_STS_ERROR;

Line 163: FND_MESSAGE.SET_TOKEN ('PARAMETER_NAME', 'P_OPERATION_UNIT_NAME' );

159: END;
160: ELSIF p_operating_unit_name IS NULL THEN
161: x_return_status := FND_API.G_RET_STS_ERROR;
162: FND_MESSAGE.Set_Name('ONT', 'OE_CC_ORG_PARAMETER_NULL');
163: FND_MESSAGE.SET_TOKEN ('PARAMETER_NAME', 'P_OPERATION_UNIT_NAME' );
164: OE_MSG_PUB.Add;
165: ELSE
166: x_return_status := FND_API.G_RET_STS_ERROR;
167: FND_MESSAGE.Set_Name('ONT', 'OE_CC_ORG_INFO_MISSING');

Line 167: FND_MESSAGE.Set_Name('ONT', 'OE_CC_ORG_INFO_MISSING');

163: FND_MESSAGE.SET_TOKEN ('PARAMETER_NAME', 'P_OPERATION_UNIT_NAME' );
164: OE_MSG_PUB.Add;
165: ELSE
166: x_return_status := FND_API.G_RET_STS_ERROR;
167: FND_MESSAGE.Set_Name('ONT', 'OE_CC_ORG_INFO_MISSING');
168: FND_MESSAGE.SET_TOKEN ('P_ORG_NAME', 'P_OPERATION_UNIT_NAME' );
169: FND_MESSAGE.SET_TOKEN ('P_ORG_ID', 'P_ORG_ID' );
170: OE_MSG_PUB.Add;
171: END IF;

Line 168: FND_MESSAGE.SET_TOKEN ('P_ORG_NAME', 'P_OPERATION_UNIT_NAME' );

164: OE_MSG_PUB.Add;
165: ELSE
166: x_return_status := FND_API.G_RET_STS_ERROR;
167: FND_MESSAGE.Set_Name('ONT', 'OE_CC_ORG_INFO_MISSING');
168: FND_MESSAGE.SET_TOKEN ('P_ORG_NAME', 'P_OPERATION_UNIT_NAME' );
169: FND_MESSAGE.SET_TOKEN ('P_ORG_ID', 'P_ORG_ID' );
170: OE_MSG_PUB.Add;
171: END IF;
172: ELSE

Line 169: FND_MESSAGE.SET_TOKEN ('P_ORG_ID', 'P_ORG_ID' );

165: ELSE
166: x_return_status := FND_API.G_RET_STS_ERROR;
167: FND_MESSAGE.Set_Name('ONT', 'OE_CC_ORG_INFO_MISSING');
168: FND_MESSAGE.SET_TOKEN ('P_ORG_NAME', 'P_OPERATION_UNIT_NAME' );
169: FND_MESSAGE.SET_TOKEN ('P_ORG_ID', 'P_ORG_ID' );
170: OE_MSG_PUB.Add;
171: END IF;
172: ELSE
173: x_org_id := NULL;

Line 221: FND_MESSAGE.Set_Name('ONT', 'OE_CC_CCR_ID_INVALID');

217: WHERE credit_check_rule_id = p_credit_check_rule_id;
218: EXCEPTION
219: WHEN NO_DATA_FOUND THEN
220: x_return_status := FND_API.G_RET_STS_ERROR;
221: FND_MESSAGE.Set_Name('ONT', 'OE_CC_CCR_ID_INVALID');
222: FND_MESSAGE.SET_TOKEN('PARAMETER_NAME', 'P_CREDIT_CHECK_RULE_ID');
223: FND_MESSAGE.SET_TOKEN('PARAMETER_VALUE', p_credit_check_rule_id );
224: OE_MSG_PUB.Add;
225: END;

Line 222: FND_MESSAGE.SET_TOKEN('PARAMETER_NAME', 'P_CREDIT_CHECK_RULE_ID');

218: EXCEPTION
219: WHEN NO_DATA_FOUND THEN
220: x_return_status := FND_API.G_RET_STS_ERROR;
221: FND_MESSAGE.Set_Name('ONT', 'OE_CC_CCR_ID_INVALID');
222: FND_MESSAGE.SET_TOKEN('PARAMETER_NAME', 'P_CREDIT_CHECK_RULE_ID');
223: FND_MESSAGE.SET_TOKEN('PARAMETER_VALUE', p_credit_check_rule_id );
224: OE_MSG_PUB.Add;
225: END;
226: ELSIF p_credit_check_rule_id IS NULL THEN

Line 223: FND_MESSAGE.SET_TOKEN('PARAMETER_VALUE', p_credit_check_rule_id );

219: WHEN NO_DATA_FOUND THEN
220: x_return_status := FND_API.G_RET_STS_ERROR;
221: FND_MESSAGE.Set_Name('ONT', 'OE_CC_CCR_ID_INVALID');
222: FND_MESSAGE.SET_TOKEN('PARAMETER_NAME', 'P_CREDIT_CHECK_RULE_ID');
223: FND_MESSAGE.SET_TOKEN('PARAMETER_VALUE', p_credit_check_rule_id );
224: OE_MSG_PUB.Add;
225: END;
226: ELSIF p_credit_check_rule_id IS NULL THEN
227: x_return_status := FND_API.G_RET_STS_ERROR;

Line 228: FND_MESSAGE.Set_Name('ONT', 'OE_CC_PARAMETER_NULL');

224: OE_MSG_PUB.Add;
225: END;
226: ELSIF p_credit_check_rule_id IS NULL THEN
227: x_return_status := FND_API.G_RET_STS_ERROR;
228: FND_MESSAGE.Set_Name('ONT', 'OE_CC_PARAMETER_NULL');
229: FND_MESSAGE.SET_TOKEN ('PARAMETER_NAME', 'P_CREDIT_CHECK_RULE_ID' );
230: OE_MSG_PUB.Add;
231: ELSIF p_credit_check_rule_name IS NOT NULL AND
232: p_credit_check_rule_name <> FND_API.G_MISS_CHAR THEN

Line 229: FND_MESSAGE.SET_TOKEN ('PARAMETER_NAME', 'P_CREDIT_CHECK_RULE_ID' );

225: END;
226: ELSIF p_credit_check_rule_id IS NULL THEN
227: x_return_status := FND_API.G_RET_STS_ERROR;
228: FND_MESSAGE.Set_Name('ONT', 'OE_CC_PARAMETER_NULL');
229: FND_MESSAGE.SET_TOKEN ('PARAMETER_NAME', 'P_CREDIT_CHECK_RULE_ID' );
230: OE_MSG_PUB.Add;
231: ELSIF p_credit_check_rule_name IS NOT NULL AND
232: p_credit_check_rule_name <> FND_API.G_MISS_CHAR THEN
233: BEGIN

Line 247: FND_MESSAGE.Set_Name('ONT', 'OE_CC_CCR_NAME_INVALID');

243: WHERE name = p_credit_check_rule_name;
244: EXCEPTION
245: WHEN NO_DATA_FOUND THEN
246: x_return_status := FND_API.G_RET_STS_ERROR;
247: FND_MESSAGE.Set_Name('ONT', 'OE_CC_CCR_NAME_INVALID');
248: FND_MESSAGE.SET_TOKEN ('PARAMETER_NAME', 'P_CREDIT_CHECK_RULE_NAME');
249: FND_MESSAGE.SET_TOKEN ('PARAMETER_VALUE', p_credit_check_rule_name );
250: OE_MSG_PUB.Add;
251: END;

Line 248: FND_MESSAGE.SET_TOKEN ('PARAMETER_NAME', 'P_CREDIT_CHECK_RULE_NAME');

244: EXCEPTION
245: WHEN NO_DATA_FOUND THEN
246: x_return_status := FND_API.G_RET_STS_ERROR;
247: FND_MESSAGE.Set_Name('ONT', 'OE_CC_CCR_NAME_INVALID');
248: FND_MESSAGE.SET_TOKEN ('PARAMETER_NAME', 'P_CREDIT_CHECK_RULE_NAME');
249: FND_MESSAGE.SET_TOKEN ('PARAMETER_VALUE', p_credit_check_rule_name );
250: OE_MSG_PUB.Add;
251: END;
252: ELSIF p_credit_check_rule_name IS NULL THEN

Line 249: FND_MESSAGE.SET_TOKEN ('PARAMETER_VALUE', p_credit_check_rule_name );

245: WHEN NO_DATA_FOUND THEN
246: x_return_status := FND_API.G_RET_STS_ERROR;
247: FND_MESSAGE.Set_Name('ONT', 'OE_CC_CCR_NAME_INVALID');
248: FND_MESSAGE.SET_TOKEN ('PARAMETER_NAME', 'P_CREDIT_CHECK_RULE_NAME');
249: FND_MESSAGE.SET_TOKEN ('PARAMETER_VALUE', p_credit_check_rule_name );
250: OE_MSG_PUB.Add;
251: END;
252: ELSIF p_credit_check_rule_name IS NULL THEN
253: x_return_status := FND_API.G_RET_STS_ERROR;

Line 254: FND_MESSAGE.Set_Name('ONT', 'OE_CC_PARAMETER_NULL');

250: OE_MSG_PUB.Add;
251: END;
252: ELSIF p_credit_check_rule_name IS NULL THEN
253: x_return_status := FND_API.G_RET_STS_ERROR;
254: FND_MESSAGE.Set_Name('ONT', 'OE_CC_PARAMETER_NULL');
255: FND_MESSAGE.SET_TOKEN('PARAMETER_NAME', 'P_CREDIT_CHECK_RULE_NAME');
256: OE_MSG_PUB.Add;
257: ELSE
258: x_return_status := FND_API.G_RET_STS_ERROR;

Line 255: FND_MESSAGE.SET_TOKEN('PARAMETER_NAME', 'P_CREDIT_CHECK_RULE_NAME');

251: END;
252: ELSIF p_credit_check_rule_name IS NULL THEN
253: x_return_status := FND_API.G_RET_STS_ERROR;
254: FND_MESSAGE.Set_Name('ONT', 'OE_CC_PARAMETER_NULL');
255: FND_MESSAGE.SET_TOKEN('PARAMETER_NAME', 'P_CREDIT_CHECK_RULE_NAME');
256: OE_MSG_PUB.Add;
257: ELSE
258: x_return_status := FND_API.G_RET_STS_ERROR;
259: FND_MESSAGE.Set_Name('ONT', 'OE_CC_CCR_INFO_MISSING');

Line 259: FND_MESSAGE.Set_Name('ONT', 'OE_CC_CCR_INFO_MISSING');

255: FND_MESSAGE.SET_TOKEN('PARAMETER_NAME', 'P_CREDIT_CHECK_RULE_NAME');
256: OE_MSG_PUB.Add;
257: ELSE
258: x_return_status := FND_API.G_RET_STS_ERROR;
259: FND_MESSAGE.Set_Name('ONT', 'OE_CC_CCR_INFO_MISSING');
260: FND_MESSAGE.SET_TOKEN ('P_CCR_NAME', 'P_CREDIT_CHECK_RULE_NAME' );
261: FND_MESSAGE.SET_TOKEN ('P_CCR_ID', 'P_CREDIT_CHECK_RULE_ID' );
262: OE_MSG_PUB.Add;
263: END IF;

Line 260: FND_MESSAGE.SET_TOKEN ('P_CCR_NAME', 'P_CREDIT_CHECK_RULE_NAME' );

256: OE_MSG_PUB.Add;
257: ELSE
258: x_return_status := FND_API.G_RET_STS_ERROR;
259: FND_MESSAGE.Set_Name('ONT', 'OE_CC_CCR_INFO_MISSING');
260: FND_MESSAGE.SET_TOKEN ('P_CCR_NAME', 'P_CREDIT_CHECK_RULE_NAME' );
261: FND_MESSAGE.SET_TOKEN ('P_CCR_ID', 'P_CREDIT_CHECK_RULE_ID' );
262: OE_MSG_PUB.Add;
263: END IF;
264: --

Line 261: FND_MESSAGE.SET_TOKEN ('P_CCR_ID', 'P_CREDIT_CHECK_RULE_ID' );

257: ELSE
258: x_return_status := FND_API.G_RET_STS_ERROR;
259: FND_MESSAGE.Set_Name('ONT', 'OE_CC_CCR_INFO_MISSING');
260: FND_MESSAGE.SET_TOKEN ('P_CCR_NAME', 'P_CREDIT_CHECK_RULE_NAME' );
261: FND_MESSAGE.SET_TOKEN ('P_CCR_ID', 'P_CREDIT_CHECK_RULE_ID' );
262: OE_MSG_PUB.Add;
263: END IF;
264: --
265: -- If the credit rule is valid, check that it has the correct flag set.

Line 275: FND_MESSAGE.Set_Name('ONT', 'OE_CC_CCR_INVALID');

271: IF l_credit_check_rule_id IS NOT NULL THEN
272: IF NVL(l_credit_check_level_code, 'ORDER') <> 'ORDER' OR
273: NVL(l_check_item_categories_flag,'N') <> 'N' THEN
274: x_return_status := FND_API.G_RET_STS_ERROR;
275: FND_MESSAGE.Set_Name('ONT', 'OE_CC_CCR_INVALID');
276: FND_MESSAGE.Set_Token('CCR_NAME', l_credit_check_rule_name);
277: FND_MESSAGE.Set_Token('API_NAME', 'Check_External_Credit');
278: OE_MSG_PUB.Add;
279: ELSE

Line 276: FND_MESSAGE.Set_Token('CCR_NAME', l_credit_check_rule_name);

272: IF NVL(l_credit_check_level_code, 'ORDER') <> 'ORDER' OR
273: NVL(l_check_item_categories_flag,'N') <> 'N' THEN
274: x_return_status := FND_API.G_RET_STS_ERROR;
275: FND_MESSAGE.Set_Name('ONT', 'OE_CC_CCR_INVALID');
276: FND_MESSAGE.Set_Token('CCR_NAME', l_credit_check_rule_name);
277: FND_MESSAGE.Set_Token('API_NAME', 'Check_External_Credit');
278: OE_MSG_PUB.Add;
279: ELSE
280: x_credit_check_rule_id := l_credit_check_rule_id;

Line 277: FND_MESSAGE.Set_Token('API_NAME', 'Check_External_Credit');

273: NVL(l_check_item_categories_flag,'N') <> 'N' THEN
274: x_return_status := FND_API.G_RET_STS_ERROR;
275: FND_MESSAGE.Set_Name('ONT', 'OE_CC_CCR_INVALID');
276: FND_MESSAGE.Set_Token('CCR_NAME', l_credit_check_rule_name);
277: FND_MESSAGE.Set_Token('API_NAME', 'Check_External_Credit');
278: OE_MSG_PUB.Add;
279: ELSE
280: x_credit_check_rule_id := l_credit_check_rule_id;
281: END IF;

Line 540: FND_MESSAGE.SET_NAME('ONT','OE_CC_BILL_TO_ADDRESS_INVALID');

536: IF C2%ISOPEN then
537: CLOSE C2;
538: END IF;
539:
540: FND_MESSAGE.SET_NAME('ONT','OE_CC_BILL_TO_ADDRESS_INVALID');
541: OE_MSG_PUB.Add;
542: OE_DEBUG_PUB.Add('No data found error in Address_Value_To_ID');
543: RETURN FND_API.G_MISS_NUM;
544: WHEN TOO_MANY_ROWS THEN

Line 557: FND_MESSAGE.SET_NAME('ONT','OE_CC_BILL_TO_ADDRESS_MULTI');

553: IF C2%ISOPEN then
554: CLOSE C2;
555: END IF;
556:
557: FND_MESSAGE.SET_NAME('ONT','OE_CC_BILL_TO_ADDRESS_MULTI');
558: OE_MSG_PUB.Add;
559: OE_DEBUG_PUB.Add('Too many rows error in Address_Value_To_ID');
560: RETURN FND_API.G_MISS_NUM;
561: WHEN OTHERS THEN

Line 635: FND_MESSAGE.Set_Name('ONT', 'OE_CC_SITE_USE_ID_INVALID');

631: WHEN NO_DATA_FOUND THEN
632: -- This same error message takes care of the case of NULL value
633: -- passed in since a NULL in the select will not select any rows.
634: x_return_status := FND_API.G_RET_STS_ERROR;
635: FND_MESSAGE.Set_Name('ONT', 'OE_CC_SITE_USE_ID_INVALID');
636: FND_MESSAGE.Set_Token('PARAMETER_NAME', 'P_BILL_TO_SITE_USE_ID');
637: FND_MESSAGE.Set_Token('PARAMETER_VALUE', p_bill_to_site_use_id );
638: OE_MSG_PUB.Add;
639: END;

Line 636: FND_MESSAGE.Set_Token('PARAMETER_NAME', 'P_BILL_TO_SITE_USE_ID');

632: -- This same error message takes care of the case of NULL value
633: -- passed in since a NULL in the select will not select any rows.
634: x_return_status := FND_API.G_RET_STS_ERROR;
635: FND_MESSAGE.Set_Name('ONT', 'OE_CC_SITE_USE_ID_INVALID');
636: FND_MESSAGE.Set_Token('PARAMETER_NAME', 'P_BILL_TO_SITE_USE_ID');
637: FND_MESSAGE.Set_Token('PARAMETER_VALUE', p_bill_to_site_use_id );
638: OE_MSG_PUB.Add;
639: END;
640: ELSIF p_bill_to_site_use_id IS NULL THEN

Line 637: FND_MESSAGE.Set_Token('PARAMETER_VALUE', p_bill_to_site_use_id );

633: -- passed in since a NULL in the select will not select any rows.
634: x_return_status := FND_API.G_RET_STS_ERROR;
635: FND_MESSAGE.Set_Name('ONT', 'OE_CC_SITE_USE_ID_INVALID');
636: FND_MESSAGE.Set_Token('PARAMETER_NAME', 'P_BILL_TO_SITE_USE_ID');
637: FND_MESSAGE.Set_Token('PARAMETER_VALUE', p_bill_to_site_use_id );
638: OE_MSG_PUB.Add;
639: END;
640: ELSIF p_bill_to_site_use_id IS NULL THEN
641: x_return_status := FND_API.G_RET_STS_ERROR;

Line 642: FND_MESSAGE.Set_Name('ONT', 'OE_CC_PARAMETER_NULL');

638: OE_MSG_PUB.Add;
639: END;
640: ELSIF p_bill_to_site_use_id IS NULL THEN
641: x_return_status := FND_API.G_RET_STS_ERROR;
642: FND_MESSAGE.Set_Name('ONT', 'OE_CC_PARAMETER_NULL');
643: FND_MESSAGE.SET_TOKEN ('PARAMETER_NAME', 'P_BILL_TO_SITE_USE_ID' );
644: OE_MSG_PUB.Add;
645:
646: ELSIF

Line 643: FND_MESSAGE.SET_TOKEN ('PARAMETER_NAME', 'P_BILL_TO_SITE_USE_ID' );

639: END;
640: ELSIF p_bill_to_site_use_id IS NULL THEN
641: x_return_status := FND_API.G_RET_STS_ERROR;
642: FND_MESSAGE.Set_Name('ONT', 'OE_CC_PARAMETER_NULL');
643: FND_MESSAGE.SET_TOKEN ('PARAMETER_NAME', 'P_BILL_TO_SITE_USE_ID' );
644: OE_MSG_PUB.Add;
645:
646: ELSIF
647: -- The location and customer information must be provided to derive a

Line 690: FND_MESSAGE.Set_Name('ONT', 'OE_CC_PARAMETER_NULL');

686: END IF;
687: ELSIF p_customer_id IS NULL THEN
688: -- set error message
689: x_return_status := FND_API.G_RET_STS_ERROR;
690: FND_MESSAGE.Set_Name('ONT', 'OE_CC_PARAMETER_NULL');
691: FND_MESSAGE.SET_TOKEN ('PARAMETER_NAME', 'P_CUSTOMER_ID' );
692: OE_MSG_PUB.Add;
693: ELSIF p_customer_name <> FND_API.G_MISS_CHAR AND
694: p_customer_number <> FND_API.G_MISS_CHAR THEN

Line 691: FND_MESSAGE.SET_TOKEN ('PARAMETER_NAME', 'P_CUSTOMER_ID' );

687: ELSIF p_customer_id IS NULL THEN
688: -- set error message
689: x_return_status := FND_API.G_RET_STS_ERROR;
690: FND_MESSAGE.Set_Name('ONT', 'OE_CC_PARAMETER_NULL');
691: FND_MESSAGE.SET_TOKEN ('PARAMETER_NAME', 'P_CUSTOMER_ID' );
692: OE_MSG_PUB.Add;
693: ELSIF p_customer_name <> FND_API.G_MISS_CHAR AND
694: p_customer_number <> FND_API.G_MISS_CHAR THEN
695: -- check for valid customer_id

Line 725: FND_MESSAGE.Set_Name('ONT', 'OE_CC_CUSTOMER_INFO_INVALID');

721: END IF;
722: EXCEPTION
723: WHEN NO_DATA_FOUND THEN
724: x_return_status := FND_API.G_RET_STS_ERROR;
725: FND_MESSAGE.Set_Name('ONT', 'OE_CC_CUSTOMER_INFO_INVALID');
726: FND_MESSAGE.SET_TOKEN ('P_CUSTOMER_NAME', 'P_CUSTOMER_NAME' );
727: FND_MESSAGE.SET_TOKEN ('P_CUSTOMER_NUMBER', 'P_CUSTOMER_NUMBER' );
728: OE_MSG_PUB.Add;
729: END;

Line 726: FND_MESSAGE.SET_TOKEN ('P_CUSTOMER_NAME', 'P_CUSTOMER_NAME' );

722: EXCEPTION
723: WHEN NO_DATA_FOUND THEN
724: x_return_status := FND_API.G_RET_STS_ERROR;
725: FND_MESSAGE.Set_Name('ONT', 'OE_CC_CUSTOMER_INFO_INVALID');
726: FND_MESSAGE.SET_TOKEN ('P_CUSTOMER_NAME', 'P_CUSTOMER_NAME' );
727: FND_MESSAGE.SET_TOKEN ('P_CUSTOMER_NUMBER', 'P_CUSTOMER_NUMBER' );
728: OE_MSG_PUB.Add;
729: END;
730: ELSE

Line 727: FND_MESSAGE.SET_TOKEN ('P_CUSTOMER_NUMBER', 'P_CUSTOMER_NUMBER' );

723: WHEN NO_DATA_FOUND THEN
724: x_return_status := FND_API.G_RET_STS_ERROR;
725: FND_MESSAGE.Set_Name('ONT', 'OE_CC_CUSTOMER_INFO_INVALID');
726: FND_MESSAGE.SET_TOKEN ('P_CUSTOMER_NAME', 'P_CUSTOMER_NAME' );
727: FND_MESSAGE.SET_TOKEN ('P_CUSTOMER_NUMBER', 'P_CUSTOMER_NUMBER' );
728: OE_MSG_PUB.Add;
729: END;
730: ELSE
731: -- customer information is missing

Line 733: FND_MESSAGE.Set_Name('ONT', 'OE_CC_CUSTOMER_INFO_MISSING');

729: END;
730: ELSE
731: -- customer information is missing
732: x_return_status := FND_API.G_RET_STS_ERROR;
733: FND_MESSAGE.Set_Name('ONT', 'OE_CC_CUSTOMER_INFO_MISSING');
734: FND_MESSAGE.SET_TOKEN ('P_CUSTOMER_NAME', 'P_CUSTOMER_NAME' );
735: FND_MESSAGE.SET_TOKEN ('P_CUSTOMER_NUMBER', 'P_CUSTOMER_NUMBER' );
736: FND_MESSAGE.SET_TOKEN ('P_CUSTOMER_ID', 'P_CUSTOMER_ID');
737: OE_MSG_PUB.Add;

Line 734: FND_MESSAGE.SET_TOKEN ('P_CUSTOMER_NAME', 'P_CUSTOMER_NAME' );

730: ELSE
731: -- customer information is missing
732: x_return_status := FND_API.G_RET_STS_ERROR;
733: FND_MESSAGE.Set_Name('ONT', 'OE_CC_CUSTOMER_INFO_MISSING');
734: FND_MESSAGE.SET_TOKEN ('P_CUSTOMER_NAME', 'P_CUSTOMER_NAME' );
735: FND_MESSAGE.SET_TOKEN ('P_CUSTOMER_NUMBER', 'P_CUSTOMER_NUMBER' );
736: FND_MESSAGE.SET_TOKEN ('P_CUSTOMER_ID', 'P_CUSTOMER_ID');
737: OE_MSG_PUB.Add;
738: END IF;

Line 735: FND_MESSAGE.SET_TOKEN ('P_CUSTOMER_NUMBER', 'P_CUSTOMER_NUMBER' );

731: -- customer information is missing
732: x_return_status := FND_API.G_RET_STS_ERROR;
733: FND_MESSAGE.Set_Name('ONT', 'OE_CC_CUSTOMER_INFO_MISSING');
734: FND_MESSAGE.SET_TOKEN ('P_CUSTOMER_NAME', 'P_CUSTOMER_NAME' );
735: FND_MESSAGE.SET_TOKEN ('P_CUSTOMER_NUMBER', 'P_CUSTOMER_NUMBER' );
736: FND_MESSAGE.SET_TOKEN ('P_CUSTOMER_ID', 'P_CUSTOMER_ID');
737: OE_MSG_PUB.Add;
738: END IF;
739: ELSE

Line 736: FND_MESSAGE.SET_TOKEN ('P_CUSTOMER_ID', 'P_CUSTOMER_ID');

732: x_return_status := FND_API.G_RET_STS_ERROR;
733: FND_MESSAGE.Set_Name('ONT', 'OE_CC_CUSTOMER_INFO_MISSING');
734: FND_MESSAGE.SET_TOKEN ('P_CUSTOMER_NAME', 'P_CUSTOMER_NAME' );
735: FND_MESSAGE.SET_TOKEN ('P_CUSTOMER_NUMBER', 'P_CUSTOMER_NUMBER' );
736: FND_MESSAGE.SET_TOKEN ('P_CUSTOMER_ID', 'P_CUSTOMER_ID');
737: OE_MSG_PUB.Add;
738: END IF;
739: ELSE
740: -- insufficient information is provided to derive the invoice site use id.

Line 744: FND_MESSAGE.Set_Name('ONT', 'OE_CC_SITE_USE_INFO_INVALID');

740: -- insufficient information is provided to derive the invoice site use id.
741: -- refer use to API documentation. Either the bill_to site use ID needs
742: -- to be provided or the bill-to address.
743: x_return_status := FND_API.G_RET_STS_ERROR;
744: FND_MESSAGE.Set_Name('ONT', 'OE_CC_SITE_USE_INFO_INVALID');
745: OE_MSG_PUB.Add;
746: END IF;
747: x_bill_to_site_use_id := l_bill_to_site_use_id;
748: OE_DEBUG_PUB.Add('OEXVCECB: Out Get_Bill_To_Site_Use_ID');

Line 815: FND_MESSAGE.Set_Name('ONT', 'OE_CC_API_VERSION_MISMATCH');

811: l_api_name,
812: G_PKG_NAME)
813: THEN
814: FND_MSG_PUB.Delete_Msg;
815: FND_MESSAGE.Set_Name('ONT', 'OE_CC_API_VERSION_MISMATCH');
816: FND_MESSAGE.SET_TOKEN ('API_NAME', l_api_name );
817: FND_MESSAGE.SET_TOKEN ('P_API_VERSION', p_api_version );
818: FND_MESSAGE.SET_TOKEN ('CURR_VER_NUM',l_api_version);
819: FND_MESSAGE.SET_TOKEN ('CALLER_VER_NUM',p_api_version);

Line 816: FND_MESSAGE.SET_TOKEN ('API_NAME', l_api_name );

812: G_PKG_NAME)
813: THEN
814: FND_MSG_PUB.Delete_Msg;
815: FND_MESSAGE.Set_Name('ONT', 'OE_CC_API_VERSION_MISMATCH');
816: FND_MESSAGE.SET_TOKEN ('API_NAME', l_api_name );
817: FND_MESSAGE.SET_TOKEN ('P_API_VERSION', p_api_version );
818: FND_MESSAGE.SET_TOKEN ('CURR_VER_NUM',l_api_version);
819: FND_MESSAGE.SET_TOKEN ('CALLER_VER_NUM',p_api_version);
820: OE_MSG_PUB.Add;

Line 817: FND_MESSAGE.SET_TOKEN ('P_API_VERSION', p_api_version );

813: THEN
814: FND_MSG_PUB.Delete_Msg;
815: FND_MESSAGE.Set_Name('ONT', 'OE_CC_API_VERSION_MISMATCH');
816: FND_MESSAGE.SET_TOKEN ('API_NAME', l_api_name );
817: FND_MESSAGE.SET_TOKEN ('P_API_VERSION', p_api_version );
818: FND_MESSAGE.SET_TOKEN ('CURR_VER_NUM',l_api_version);
819: FND_MESSAGE.SET_TOKEN ('CALLER_VER_NUM',p_api_version);
820: OE_MSG_PUB.Add;
821: OE_DEBUG_PUB.Add('l_api_version: '||l_api_version);

Line 818: FND_MESSAGE.SET_TOKEN ('CURR_VER_NUM',l_api_version);

814: FND_MSG_PUB.Delete_Msg;
815: FND_MESSAGE.Set_Name('ONT', 'OE_CC_API_VERSION_MISMATCH');
816: FND_MESSAGE.SET_TOKEN ('API_NAME', l_api_name );
817: FND_MESSAGE.SET_TOKEN ('P_API_VERSION', p_api_version );
818: FND_MESSAGE.SET_TOKEN ('CURR_VER_NUM',l_api_version);
819: FND_MESSAGE.SET_TOKEN ('CALLER_VER_NUM',p_api_version);
820: OE_MSG_PUB.Add;
821: OE_DEBUG_PUB.Add('l_api_version: '||l_api_version);
822: OE_DEBUG_PUB.Add('p_api_version: '||p_api_version);

Line 819: FND_MESSAGE.SET_TOKEN ('CALLER_VER_NUM',p_api_version);

815: FND_MESSAGE.Set_Name('ONT', 'OE_CC_API_VERSION_MISMATCH');
816: FND_MESSAGE.SET_TOKEN ('API_NAME', l_api_name );
817: FND_MESSAGE.SET_TOKEN ('P_API_VERSION', p_api_version );
818: FND_MESSAGE.SET_TOKEN ('CURR_VER_NUM',l_api_version);
819: FND_MESSAGE.SET_TOKEN ('CALLER_VER_NUM',p_api_version);
820: OE_MSG_PUB.Add;
821: OE_DEBUG_PUB.Add('l_api_version: '||l_api_version);
822: OE_DEBUG_PUB.Add('p_api_version: '||p_api_version);
823: OE_DEBUG_PUB.Add('API Versin Check Failed.');