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 OE_MSG_PUB

Line 35: OE_MSG_PUB.Add;

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
39: RETURN TRUE;

Line 66: OE_MSG_PUB.Add;

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
70: BEGIN

Line 85: OE_MSG_PUB.Add;

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

Line 137: OE_MSG_PUB.Add;

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

Line 143: OE_MSG_PUB.Add;

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
147: SELECT organization_id

Line 158: OE_MSG_PUB.Add;

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

Line 164: OE_MSG_PUB.Add;

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');
168: FND_MESSAGE.SET_TOKEN ('P_ORG_NAME', 'P_OPERATION_UNIT_NAME' );

Line 170: OE_MSG_PUB.Add;

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

Line 224: OE_MSG_PUB.Add;

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

Line 230: OE_MSG_PUB.Add;

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
234: SELECT credit_check_rule_id,

Line 250: OE_MSG_PUB.Add;

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

Line 256: OE_MSG_PUB.Add;

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');
260: FND_MESSAGE.SET_TOKEN ('P_CCR_NAME', 'P_CREDIT_CHECK_RULE_NAME' );

Line 262: OE_MSG_PUB.Add;

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.
266: --

Line 278: OE_MSG_PUB.Add;

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

Line 541: OE_MSG_PUB.Add;

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
545: IF c_bill_to_site_use_id%ISOPEN then

Line 558: OE_MSG_PUB.Add;

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
562: OE_DEBUG_PUB.Add('Unexpected error in Address_Value_To_ID');

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

571: IF C2%ISOPEN then
572: CLOSE C2;
573: END IF;
574:
575: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
576: OE_MSG_PUB.Add_Exc_Msg
577: ( G_PKG_NAME
578: , 'Address_Value_To_ID'
579: );

Line 576: OE_MSG_PUB.Add_Exc_Msg

572: CLOSE C2;
573: END IF;
574:
575: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
576: OE_MSG_PUB.Add_Exc_Msg
577: ( G_PKG_NAME
578: , 'Address_Value_To_ID'
579: );
580: END IF;

Line 638: OE_MSG_PUB.Add;

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

Line 644: OE_MSG_PUB.Add;

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
648: -- unique site use id.

Line 692: OE_MSG_PUB.Add;

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
696: BEGIN

Line 728: OE_MSG_PUB.Add;

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
732: x_return_status := FND_API.G_RET_STS_ERROR;

Line 737: OE_MSG_PUB.Add;

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.
741: -- refer use to API documentation. Either the bill_to site use ID needs

Line 745: OE_MSG_PUB.Add;

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');
749: EXCEPTION

Line 820: OE_MSG_PUB.Add;

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.');
824: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 986: OE_MSG_PUB.Count_and_Get (

982: OE_DEBUG_PUB.Add('OEXVCECB: Out Check_External_Credit');
983: EXCEPTION
984: WHEN FND_API.G_EXC_ERROR THEN
985: x_return_status := FND_API.G_RET_STS_ERROR;
986: OE_MSG_PUB.Count_and_Get (
987: p_count => x_msg_count
988: ,p_data => x_msg_data);
989: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
990: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 991: OE_MSG_PUB.Count_and_Get (

987: p_count => x_msg_count
988: ,p_data => x_msg_data);
989: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
990: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
991: OE_MSG_PUB.Count_and_Get (
992: p_count => x_msg_count
993: ,p_data => x_msg_data);
994: WHEN OTHERS THEN
995: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

992: p_count => x_msg_count
993: ,p_data => x_msg_data);
994: WHEN OTHERS THEN
995: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
996: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
997: OE_MSG_PUB.Add_Exc_Msg (
998: G_PKG_NAME
999: , l_api_name);
1000: END IF;

Line 997: OE_MSG_PUB.Add_Exc_Msg (

993: ,p_data => x_msg_data);
994: WHEN OTHERS THEN
995: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
996: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
997: OE_MSG_PUB.Add_Exc_Msg (
998: G_PKG_NAME
999: , l_api_name);
1000: END IF;
1001: OE_MSG_PUB.Count_and_Get(

Line 1001: OE_MSG_PUB.Count_and_Get(

997: OE_MSG_PUB.Add_Exc_Msg (
998: G_PKG_NAME
999: , l_api_name);
1000: END IF;
1001: OE_MSG_PUB.Count_and_Get(
1002: p_count => x_msg_count
1003: ,p_data => x_msg_data);
1004: END Check_External_Credit;
1005: END OE_EXTERNAL_CREDIT_PVT;