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_DEBUG_PUB

Line 31: OE_DEBUG_PUB.Add('OEXVCECB: In Is_Amount_Valid');

27: )
28: RETURN BOOLEAN
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;

Line 36: OE_DEBUG_PUB.Add('Validate Amount Failed.');

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

Line 41: OE_DEBUG_PUB.Add('OEXVCECB: Out Is_Amount_Valid');

37: RETURN FALSE;
38: ELSE
39: RETURN TRUE;
40: END IF;
41: OE_DEBUG_PUB.Add('OEXVCECB: Out Is_Amount_Valid');
42: EXCEPTION
43: WHEN OTHERS THEN
44: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
45: END Is_Amount_Valid;

Line 62: OE_DEBUG_PUB.Add('OEXVCECB: In Is_Currency_Valid');

58: IS
59: l_return_value BOOLEAN := TRUE;
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;

Line 67: OE_DEBUG_PUB.Add('Validate Currency Failed - NULL.');

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
71: SELECT 1

Line 86: OE_DEBUG_PUB.Add('Validate Currency Failed - Invalid.');

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;
90: RETURN l_return_value;

Line 91: OE_DEBUG_PUB.Add('OEXVCECB: Out Is_Currency_Valid');

87: l_return_value := FALSE;
88: END;
89: END IF;
90: RETURN l_return_value;
91: OE_DEBUG_PUB.Add('OEXVCECB: Out Is_Currency_Valid');
92: EXCEPTION
93: WHEN OTHERS THEN
94: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
95: END Is_Currency_Valid;

Line 113: OE_DEBUG_PUB.Add('OEXVCECB: In Get_Operating_Unit_ID');

109: IS
110: l_multi_org_flag fnd_product_groups.multi_org_flag%TYPE;
111: l_org_id NUMBER;
112: BEGIN
113: OE_DEBUG_PUB.Add('OEXVCECB: In Get_Operating_Unit_ID');
114: x_return_status := FND_API.G_RET_STS_SUCCESS;
115: --If the set is multi-org, then get the operating unit information, else
116: --return NULL for the org_id.
117: SELECT NVL(multi_org_flag, 'N')

Line 175: OE_DEBUG_PUB.Add('OEXVCECB: Out Get_Operating_Unit_ID');

171: END IF;
172: ELSE
173: x_org_id := NULL;
174: END IF;
175: OE_DEBUG_PUB.Add('OEXVCECB: Out Get_Operating_Unit_ID');
176: EXCEPTION
177: WHEN OTHERS THEN
178: OE_DEBUG_PUB.Add('Get_Operating_Unit_ID: Unexpected Error');
179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 178: OE_DEBUG_PUB.Add('Get_Operating_Unit_ID: Unexpected Error');

174: END IF;
175: OE_DEBUG_PUB.Add('OEXVCECB: Out Get_Operating_Unit_ID');
176: EXCEPTION
177: WHEN OTHERS THEN
178: OE_DEBUG_PUB.Add('Get_Operating_Unit_ID: Unexpected Error');
179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
180: END Get_Operating_Unit_ID;
181:
182: --=====================================================================

Line 203: OE_DEBUG_PUB.Add('OEXVCECB: In Get_Credit_Check_Rule_ID');

199: oe_credit_check_rules.credit_check_level_code%TYPE := NULL;
200: l_check_item_categories_flag
201: oe_credit_check_rules.check_item_categories_flag%TYPE := NULL;
202: BEGIN
203: OE_DEBUG_PUB.Add('OEXVCECB: In Get_Credit_Check_Rule_ID');
204: x_return_status := FND_API.G_RET_STS_SUCCESS;
205: IF p_credit_check_rule_id IS NOT NULL AND
206: p_credit_check_rule_id <> FND_API.G_MISS_NUM THEN
207: BEGIN

Line 267: OE_DEBUG_PUB.Add('l_credit_check_rule_id: '||l_credit_check_rule_id);

263: END IF;
264: --
265: -- If the credit rule is valid, check that it has the correct flag set.
266: --
267: OE_DEBUG_PUB.Add('l_credit_check_rule_id: '||l_credit_check_rule_id);
268: OE_DEBUG_PUB.Add('l_name : '||l_credit_check_rule_name);
269: OE_DEBUG_PUB.Add('l_check_item_categories_flag: '||l_check_item_categories_flag);
270: OE_DEBUG_PUB.Add('l_credit_check_level_code: '||l_credit_check_level_code);
271: IF l_credit_check_rule_id IS NOT NULL THEN

Line 268: OE_DEBUG_PUB.Add('l_name : '||l_credit_check_rule_name);

264: --
265: -- If the credit rule is valid, check that it has the correct flag set.
266: --
267: OE_DEBUG_PUB.Add('l_credit_check_rule_id: '||l_credit_check_rule_id);
268: OE_DEBUG_PUB.Add('l_name : '||l_credit_check_rule_name);
269: OE_DEBUG_PUB.Add('l_check_item_categories_flag: '||l_check_item_categories_flag);
270: OE_DEBUG_PUB.Add('l_credit_check_level_code: '||l_credit_check_level_code);
271: IF l_credit_check_rule_id IS NOT NULL THEN
272: IF NVL(l_credit_check_level_code, 'ORDER') <> 'ORDER' OR

Line 269: OE_DEBUG_PUB.Add('l_check_item_categories_flag: '||l_check_item_categories_flag);

265: -- If the credit rule is valid, check that it has the correct flag set.
266: --
267: OE_DEBUG_PUB.Add('l_credit_check_rule_id: '||l_credit_check_rule_id);
268: OE_DEBUG_PUB.Add('l_name : '||l_credit_check_rule_name);
269: OE_DEBUG_PUB.Add('l_check_item_categories_flag: '||l_check_item_categories_flag);
270: OE_DEBUG_PUB.Add('l_credit_check_level_code: '||l_credit_check_level_code);
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

Line 270: OE_DEBUG_PUB.Add('l_credit_check_level_code: '||l_credit_check_level_code);

266: --
267: OE_DEBUG_PUB.Add('l_credit_check_rule_id: '||l_credit_check_rule_id);
268: OE_DEBUG_PUB.Add('l_name : '||l_credit_check_rule_name);
269: OE_DEBUG_PUB.Add('l_check_item_categories_flag: '||l_check_item_categories_flag);
270: OE_DEBUG_PUB.Add('l_credit_check_level_code: '||l_credit_check_level_code);
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;

Line 283: OE_DEBUG_PUB.Add('OEXVCECB: Out Get_Credit_Check_Rule_ID');

279: ELSE
280: x_credit_check_rule_id := l_credit_check_rule_id;
281: END IF;
282: END IF;
283: OE_DEBUG_PUB.Add('OEXVCECB: Out Get_Credit_Check_Rule_ID');
284: EXCEPTION
285: WHEN OTHERS THEN
286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
287: END Get_Credit_Check_Rule_ID;

Line 386: OE_DEBUG_PUB.Add('OEXVCECB: In Address_Value_To_ID');

382: l_bill_to_site_use_id2 NUMBER;
383: l_customer_relations VARCHAR2(1);
384: l_org varchar2(100);
385: BEGIN
386: OE_DEBUG_PUB.Add('OEXVCECB: In Address_Value_To_ID');
387: OE_DEBUG_PUB.Add('p_customer_id: '||p_customer_id);
388: OE_DEBUG_PUB.Add('p_bill_to_address1: '||p_bill_to_address1);
389: OE_DEBUG_PUB.Add('p_bill_to_address2: '||p_bill_to_address2);
390: OE_DEBUG_PUB.Add('p_bill_to_address3: '||p_bill_to_address3);

Line 387: OE_DEBUG_PUB.Add('p_customer_id: '||p_customer_id);

383: l_customer_relations VARCHAR2(1);
384: l_org varchar2(100);
385: BEGIN
386: OE_DEBUG_PUB.Add('OEXVCECB: In Address_Value_To_ID');
387: OE_DEBUG_PUB.Add('p_customer_id: '||p_customer_id);
388: OE_DEBUG_PUB.Add('p_bill_to_address1: '||p_bill_to_address1);
389: OE_DEBUG_PUB.Add('p_bill_to_address2: '||p_bill_to_address2);
390: OE_DEBUG_PUB.Add('p_bill_to_address3: '||p_bill_to_address3);
391: OE_DEBUG_PUB.Add('p_bill_to_address4: '||p_bill_to_address4);

Line 388: OE_DEBUG_PUB.Add('p_bill_to_address1: '||p_bill_to_address1);

384: l_org varchar2(100);
385: BEGIN
386: OE_DEBUG_PUB.Add('OEXVCECB: In Address_Value_To_ID');
387: OE_DEBUG_PUB.Add('p_customer_id: '||p_customer_id);
388: OE_DEBUG_PUB.Add('p_bill_to_address1: '||p_bill_to_address1);
389: OE_DEBUG_PUB.Add('p_bill_to_address2: '||p_bill_to_address2);
390: OE_DEBUG_PUB.Add('p_bill_to_address3: '||p_bill_to_address3);
391: OE_DEBUG_PUB.Add('p_bill_to_address4: '||p_bill_to_address4);
392: -- Comment out this part as this is not needed for this API

Line 389: OE_DEBUG_PUB.Add('p_bill_to_address2: '||p_bill_to_address2);

385: BEGIN
386: OE_DEBUG_PUB.Add('OEXVCECB: In Address_Value_To_ID');
387: OE_DEBUG_PUB.Add('p_customer_id: '||p_customer_id);
388: OE_DEBUG_PUB.Add('p_bill_to_address1: '||p_bill_to_address1);
389: OE_DEBUG_PUB.Add('p_bill_to_address2: '||p_bill_to_address2);
390: OE_DEBUG_PUB.Add('p_bill_to_address3: '||p_bill_to_address3);
391: OE_DEBUG_PUB.Add('p_bill_to_address4: '||p_bill_to_address4);
392: -- Comment out this part as this is not needed for this API
393: --IF p_bill_to_address1 IS NULL

Line 390: OE_DEBUG_PUB.Add('p_bill_to_address3: '||p_bill_to_address3);

386: OE_DEBUG_PUB.Add('OEXVCECB: In Address_Value_To_ID');
387: OE_DEBUG_PUB.Add('p_customer_id: '||p_customer_id);
388: OE_DEBUG_PUB.Add('p_bill_to_address1: '||p_bill_to_address1);
389: OE_DEBUG_PUB.Add('p_bill_to_address2: '||p_bill_to_address2);
390: OE_DEBUG_PUB.Add('p_bill_to_address3: '||p_bill_to_address3);
391: OE_DEBUG_PUB.Add('p_bill_to_address4: '||p_bill_to_address4);
392: -- Comment out this part as this is not needed for this API
393: --IF p_bill_to_address1 IS NULL
394: -- OR p_bill_to_address2 IS NULL

Line 391: OE_DEBUG_PUB.Add('p_bill_to_address4: '||p_bill_to_address4);

387: OE_DEBUG_PUB.Add('p_customer_id: '||p_customer_id);
388: OE_DEBUG_PUB.Add('p_bill_to_address1: '||p_bill_to_address1);
389: OE_DEBUG_PUB.Add('p_bill_to_address2: '||p_bill_to_address2);
390: OE_DEBUG_PUB.Add('p_bill_to_address3: '||p_bill_to_address3);
391: OE_DEBUG_PUB.Add('p_bill_to_address4: '||p_bill_to_address4);
392: -- Comment out this part as this is not needed for this API
393: --IF p_bill_to_address1 IS NULL
394: -- OR p_bill_to_address2 IS NULL
395: -- OR p_bill_to_address3 IS NULL

Line 402: OE_DEBUG_PUB.Add('CUSTOMER_RELATIONSHIPS_FLAG: '||l_customer_relations);

398: -- RETURN NULL;
399: --END IF;
400:
401: l_customer_relations:= OE_Sys_Parameters.VALUE('CUSTOMER_RELATIONSHIPS_FLAG');
402: OE_DEBUG_PUB.Add('CUSTOMER_RELATIONSHIPS_FLAG: '||l_customer_relations);
403:
404: IF l_customer_relations = 'N' THEN
405: OPEN c_bill_to_site_use_id;
406: FETCH c_bill_to_site_use_id

Line 446: OE_DEBUG_PUB.Add('Found');

442: FETCH C1
443: INTO l_bill_to_site_use_id;
444:
445: IF C1%FOUND then
446: OE_DEBUG_PUB.Add('Found');
447: -- Check for more than one site use
448: FETCH C1
449: INTO l_bill_to_site_use_id2;
450: IF C1%FOUND THEN

Line 456: oe_debug_pub.add('not found');

452: END IF;
453: CLOSE C1;
454: RETURN l_bill_to_site_use_id;
455: ELSE
456: oe_debug_pub.add('not found');
457: -- comment out the following call for MOAC
458: -- select userenv('CLIENT_INFO') into l_org from dual;
459: -- oe_debug_pub.add('org='||l_org);
460:

Line 459: -- oe_debug_pub.add('org='||l_org);

455: ELSE
456: oe_debug_pub.add('not found');
457: -- comment out the following call for MOAC
458: -- select userenv('CLIENT_INFO') into l_org from dual;
459: -- oe_debug_pub.add('org='||l_org);
460:
461: SELECT /* MOAC_SQL_NO_CHANGE */ ORGANIZATION_ID
462: INTO l_bill_to_site_use_id
463: FROM OE_INVOICE_TO_ORGS_V

Line 484: oe_debug_pub.add('after select found='||l_bill_to_site_use_id);

480: SELECT CUST_ACCOUNT_ID
481: FROM HZ_CUST_ACCT_RELATE
482: WHERE RELATED_CUST_ACCOUNT_ID = p_customer_id
483: AND bill_to_flag = 'Y');
484: oe_debug_pub.add('after select found='||l_bill_to_site_use_id);
485: END IF;
486:
487: CLOSE C1;
488: oe_debug_pub.add('returning from the function');

Line 488: oe_debug_pub.add('returning from the function');

484: oe_debug_pub.add('after select found='||l_bill_to_site_use_id);
485: END IF;
486:
487: CLOSE C1;
488: oe_debug_pub.add('returning from the function');
489: RETURN l_bill_to_site_use_id;
490: ELSIF l_customer_relations = 'A' THEN
491: OPEN C2;
492: FETCH C2

Line 542: OE_DEBUG_PUB.Add('No data found error in Address_Value_To_ID');

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
546: CLOSE c_bill_to_site_use_id;

Line 559: OE_DEBUG_PUB.Add('Too many rows error in Address_Value_To_ID');

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');
563: IF c_bill_to_site_use_id%ISOPEN then

Line 562: OE_DEBUG_PUB.Add('Unexpected error in Address_Value_To_ID');

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');
563: IF c_bill_to_site_use_id%ISOPEN then
564: CLOSE c_bill_to_site_use_id;
565: END IF;
566:

Line 614: OE_DEBUG_PUB.Add('OEXVCECB: In Get_Bill_To_Site_Use_ID');

610: l_bill_to_site_use_id NUMBER;
611: l_customer_id NUMBER;
612: l_bill_to_state VARCHAR2(60);
613: BEGIN
614: OE_DEBUG_PUB.Add('OEXVCECB: In Get_Bill_To_Site_Use_ID');
615: x_return_status := FND_API.G_RET_STS_SUCCESS;
616:
617: --bug4933291
618: OE_DEBUG_PUB.Add('p_org_id: '||p_org_id);

Line 618: OE_DEBUG_PUB.Add('p_org_id: '||p_org_id);

614: OE_DEBUG_PUB.Add('OEXVCECB: In Get_Bill_To_Site_Use_ID');
615: x_return_status := FND_API.G_RET_STS_SUCCESS;
616:
617: --bug4933291
618: OE_DEBUG_PUB.Add('p_org_id: '||p_org_id);
619: OE_DEBUG_PUB.Add('p_bill_to_site_use_id: '||p_bill_to_site_use_id);
620:
621: IF p_bill_to_site_use_id IS NOT NULL AND
622: p_bill_to_site_use_id <> FND_API.G_MISS_NUM THEN

Line 619: OE_DEBUG_PUB.Add('p_bill_to_site_use_id: '||p_bill_to_site_use_id);

615: x_return_status := FND_API.G_RET_STS_SUCCESS;
616:
617: --bug4933291
618: OE_DEBUG_PUB.Add('p_org_id: '||p_org_id);
619: OE_DEBUG_PUB.Add('p_bill_to_site_use_id: '||p_bill_to_site_use_id);
620:
621: IF p_bill_to_site_use_id IS NOT NULL AND
622: p_bill_to_site_use_id <> FND_API.G_MISS_NUM THEN
623: BEGIN

Line 683: OE_DEBUG_PUB.Add('l_bill_to_site_use_id: '||l_bill_to_site_use_id);

679: p_bill_to_state => l_bill_to_state,
680: p_bill_to_postal_code => p_bill_to_postal_code,
681: p_bill_to_country => p_bill_to_country
682: );
683: OE_DEBUG_PUB.Add('l_bill_to_site_use_id: '||l_bill_to_site_use_id);
684: IF NVL(l_bill_to_site_use_id,FND_API.G_MISS_NUM)=FND_API.G_MISS_NUM THEN
685: x_return_status := FND_API.G_RET_STS_ERROR;
686: END IF;
687: ELSIF p_customer_id IS NULL THEN

Line 718: OE_DEBUG_PUB.Add('l_bill_to_site_use_id: '||l_bill_to_site_use_id);

714: p_bill_to_state => l_bill_to_state,
715: p_bill_to_postal_code => p_bill_to_postal_code,
716: p_bill_to_country => p_bill_to_country
717: );
718: OE_DEBUG_PUB.Add('l_bill_to_site_use_id: '||l_bill_to_site_use_id);
719: IF NVL(l_bill_to_site_use_id,FND_API.G_MISS_NUM)=FND_API.G_MISS_NUM THEN
720: x_return_status := FND_API.G_RET_STS_ERROR;
721: END IF;
722: EXCEPTION

Line 748: OE_DEBUG_PUB.Add('OEXVCECB: Out Get_Bill_To_Site_Use_ID');

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
750: WHEN OTHERS THEN
751: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
752: END Get_Bill_To_Site_Use_ID;

Line 804: OE_DEBUG_PUB.Add('OEXVCECB: In Check_External_Credit');

800: l_org_id NUMBER;
801: l_bill_to_site_use_id NUMBER;
802: l_credit_check_rule_id NUMBER;
803: BEGIN
804: OE_DEBUG_PUB.Add('OEXVCECB: In Check_External_Credit');
805: -- Initialize API return status to success
806: x_return_status := FND_API.G_RET_STS_SUCCESS;
807: -- Check the API version and issue an error if the given API version does not
808: -- match the one in this package.

Line 821: OE_DEBUG_PUB.Add('l_api_version: '||l_api_version);

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

Line 822: OE_DEBUG_PUB.Add('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;
825: END IF;
826: --

Line 823: OE_DEBUG_PUB.Add('API Versin Check Failed.');

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;
825: END IF;
826: --
827: -- Show input parameters

Line 829: OE_DEBUG_PUB.Add('API Input Parameters');

825: END IF;
826: --
827: -- Show input parameters
828: --
829: OE_DEBUG_PUB.Add('*****API Input Parameters*****');
830: OE_DEBUG_PUB.Add('p_credit_check_rule_name: '||p_credit_check_rule_name);
831: OE_DEBUG_PUB.Add('p_credit_check_rule_id: '||p_credit_check_rule_id);
832: OE_DEBUG_PUB.Add('p_operating_unit_name: '||p_operating_unit_name);
833: OE_DEBUG_PUB.Add('p_org_id: '||p_org_id);

Line 830: OE_DEBUG_PUB.Add('p_credit_check_rule_name: '||p_credit_check_rule_name);

826: --
827: -- Show input parameters
828: --
829: OE_DEBUG_PUB.Add('*****API Input Parameters*****');
830: OE_DEBUG_PUB.Add('p_credit_check_rule_name: '||p_credit_check_rule_name);
831: OE_DEBUG_PUB.Add('p_credit_check_rule_id: '||p_credit_check_rule_id);
832: OE_DEBUG_PUB.Add('p_operating_unit_name: '||p_operating_unit_name);
833: OE_DEBUG_PUB.Add('p_org_id: '||p_org_id);
834: OE_DEBUG_PUB.Add('p_functional_currency_code: '||p_functional_currency_code);

Line 831: OE_DEBUG_PUB.Add('p_credit_check_rule_id: '||p_credit_check_rule_id);

827: -- Show input parameters
828: --
829: OE_DEBUG_PUB.Add('*****API Input Parameters*****');
830: OE_DEBUG_PUB.Add('p_credit_check_rule_name: '||p_credit_check_rule_name);
831: OE_DEBUG_PUB.Add('p_credit_check_rule_id: '||p_credit_check_rule_id);
832: OE_DEBUG_PUB.Add('p_operating_unit_name: '||p_operating_unit_name);
833: OE_DEBUG_PUB.Add('p_org_id: '||p_org_id);
834: OE_DEBUG_PUB.Add('p_functional_currency_code: '||p_functional_currency_code);
835: OE_DEBUG_PUB.Add('p_transaction_currency_code: '||p_transaction_currency_code);

Line 832: OE_DEBUG_PUB.Add('p_operating_unit_name: '||p_operating_unit_name);

828: --
829: OE_DEBUG_PUB.Add('*****API Input Parameters*****');
830: OE_DEBUG_PUB.Add('p_credit_check_rule_name: '||p_credit_check_rule_name);
831: OE_DEBUG_PUB.Add('p_credit_check_rule_id: '||p_credit_check_rule_id);
832: OE_DEBUG_PUB.Add('p_operating_unit_name: '||p_operating_unit_name);
833: OE_DEBUG_PUB.Add('p_org_id: '||p_org_id);
834: OE_DEBUG_PUB.Add('p_functional_currency_code: '||p_functional_currency_code);
835: OE_DEBUG_PUB.Add('p_transaction_currency_code: '||p_transaction_currency_code);
836: OE_DEBUG_PUB.Add('p_transaction_amount: '||p_transaction_amount);

Line 833: OE_DEBUG_PUB.Add('p_org_id: '||p_org_id);

829: OE_DEBUG_PUB.Add('*****API Input Parameters*****');
830: OE_DEBUG_PUB.Add('p_credit_check_rule_name: '||p_credit_check_rule_name);
831: OE_DEBUG_PUB.Add('p_credit_check_rule_id: '||p_credit_check_rule_id);
832: OE_DEBUG_PUB.Add('p_operating_unit_name: '||p_operating_unit_name);
833: OE_DEBUG_PUB.Add('p_org_id: '||p_org_id);
834: OE_DEBUG_PUB.Add('p_functional_currency_code: '||p_functional_currency_code);
835: OE_DEBUG_PUB.Add('p_transaction_currency_code: '||p_transaction_currency_code);
836: OE_DEBUG_PUB.Add('p_transaction_amount: '||p_transaction_amount);
837: OE_DEBUG_PUB.Add('p_customer_name: '||p_customer_name);

Line 834: OE_DEBUG_PUB.Add('p_functional_currency_code: '||p_functional_currency_code);

830: OE_DEBUG_PUB.Add('p_credit_check_rule_name: '||p_credit_check_rule_name);
831: OE_DEBUG_PUB.Add('p_credit_check_rule_id: '||p_credit_check_rule_id);
832: OE_DEBUG_PUB.Add('p_operating_unit_name: '||p_operating_unit_name);
833: OE_DEBUG_PUB.Add('p_org_id: '||p_org_id);
834: OE_DEBUG_PUB.Add('p_functional_currency_code: '||p_functional_currency_code);
835: OE_DEBUG_PUB.Add('p_transaction_currency_code: '||p_transaction_currency_code);
836: OE_DEBUG_PUB.Add('p_transaction_amount: '||p_transaction_amount);
837: OE_DEBUG_PUB.Add('p_customer_name: '||p_customer_name);
838: OE_DEBUG_PUB.Add('p_customer_number: '||p_customer_number);

Line 835: OE_DEBUG_PUB.Add('p_transaction_currency_code: '||p_transaction_currency_code);

831: OE_DEBUG_PUB.Add('p_credit_check_rule_id: '||p_credit_check_rule_id);
832: OE_DEBUG_PUB.Add('p_operating_unit_name: '||p_operating_unit_name);
833: OE_DEBUG_PUB.Add('p_org_id: '||p_org_id);
834: OE_DEBUG_PUB.Add('p_functional_currency_code: '||p_functional_currency_code);
835: OE_DEBUG_PUB.Add('p_transaction_currency_code: '||p_transaction_currency_code);
836: OE_DEBUG_PUB.Add('p_transaction_amount: '||p_transaction_amount);
837: OE_DEBUG_PUB.Add('p_customer_name: '||p_customer_name);
838: OE_DEBUG_PUB.Add('p_customer_number: '||p_customer_number);
839: OE_DEBUG_PUB.Add('p_customer_id: '||p_customer_id);

Line 836: OE_DEBUG_PUB.Add('p_transaction_amount: '||p_transaction_amount);

832: OE_DEBUG_PUB.Add('p_operating_unit_name: '||p_operating_unit_name);
833: OE_DEBUG_PUB.Add('p_org_id: '||p_org_id);
834: OE_DEBUG_PUB.Add('p_functional_currency_code: '||p_functional_currency_code);
835: OE_DEBUG_PUB.Add('p_transaction_currency_code: '||p_transaction_currency_code);
836: OE_DEBUG_PUB.Add('p_transaction_amount: '||p_transaction_amount);
837: OE_DEBUG_PUB.Add('p_customer_name: '||p_customer_name);
838: OE_DEBUG_PUB.Add('p_customer_number: '||p_customer_number);
839: OE_DEBUG_PUB.Add('p_customer_id: '||p_customer_id);
840: OE_DEBUG_PUB.Add('p_bill_to_site_use_id: '||p_bill_to_site_use_id);

Line 837: OE_DEBUG_PUB.Add('p_customer_name: '||p_customer_name);

833: OE_DEBUG_PUB.Add('p_org_id: '||p_org_id);
834: OE_DEBUG_PUB.Add('p_functional_currency_code: '||p_functional_currency_code);
835: OE_DEBUG_PUB.Add('p_transaction_currency_code: '||p_transaction_currency_code);
836: OE_DEBUG_PUB.Add('p_transaction_amount: '||p_transaction_amount);
837: OE_DEBUG_PUB.Add('p_customer_name: '||p_customer_name);
838: OE_DEBUG_PUB.Add('p_customer_number: '||p_customer_number);
839: OE_DEBUG_PUB.Add('p_customer_id: '||p_customer_id);
840: OE_DEBUG_PUB.Add('p_bill_to_site_use_id: '||p_bill_to_site_use_id);
841: OE_DEBUG_PUB.Add('p_bill_to_address1: '||p_bill_to_address1);

Line 838: OE_DEBUG_PUB.Add('p_customer_number: '||p_customer_number);

834: OE_DEBUG_PUB.Add('p_functional_currency_code: '||p_functional_currency_code);
835: OE_DEBUG_PUB.Add('p_transaction_currency_code: '||p_transaction_currency_code);
836: OE_DEBUG_PUB.Add('p_transaction_amount: '||p_transaction_amount);
837: OE_DEBUG_PUB.Add('p_customer_name: '||p_customer_name);
838: OE_DEBUG_PUB.Add('p_customer_number: '||p_customer_number);
839: OE_DEBUG_PUB.Add('p_customer_id: '||p_customer_id);
840: OE_DEBUG_PUB.Add('p_bill_to_site_use_id: '||p_bill_to_site_use_id);
841: OE_DEBUG_PUB.Add('p_bill_to_address1: '||p_bill_to_address1);
842: OE_DEBUG_PUB.Add('p_bill_to_address2: '||p_bill_to_address2);

Line 839: OE_DEBUG_PUB.Add('p_customer_id: '||p_customer_id);

835: OE_DEBUG_PUB.Add('p_transaction_currency_code: '||p_transaction_currency_code);
836: OE_DEBUG_PUB.Add('p_transaction_amount: '||p_transaction_amount);
837: OE_DEBUG_PUB.Add('p_customer_name: '||p_customer_name);
838: OE_DEBUG_PUB.Add('p_customer_number: '||p_customer_number);
839: OE_DEBUG_PUB.Add('p_customer_id: '||p_customer_id);
840: OE_DEBUG_PUB.Add('p_bill_to_site_use_id: '||p_bill_to_site_use_id);
841: OE_DEBUG_PUB.Add('p_bill_to_address1: '||p_bill_to_address1);
842: OE_DEBUG_PUB.Add('p_bill_to_address2: '||p_bill_to_address2);
843: OE_DEBUG_PUB.Add('p_bill_to_address3: '||p_bill_to_address3);

Line 840: OE_DEBUG_PUB.Add('p_bill_to_site_use_id: '||p_bill_to_site_use_id);

836: OE_DEBUG_PUB.Add('p_transaction_amount: '||p_transaction_amount);
837: OE_DEBUG_PUB.Add('p_customer_name: '||p_customer_name);
838: OE_DEBUG_PUB.Add('p_customer_number: '||p_customer_number);
839: OE_DEBUG_PUB.Add('p_customer_id: '||p_customer_id);
840: OE_DEBUG_PUB.Add('p_bill_to_site_use_id: '||p_bill_to_site_use_id);
841: OE_DEBUG_PUB.Add('p_bill_to_address1: '||p_bill_to_address1);
842: OE_DEBUG_PUB.Add('p_bill_to_address2: '||p_bill_to_address2);
843: OE_DEBUG_PUB.Add('p_bill_to_address3: '||p_bill_to_address3);
844: OE_DEBUG_PUB.Add('p_bill_to_address4: '||p_bill_to_address4);

Line 841: OE_DEBUG_PUB.Add('p_bill_to_address1: '||p_bill_to_address1);

837: OE_DEBUG_PUB.Add('p_customer_name: '||p_customer_name);
838: OE_DEBUG_PUB.Add('p_customer_number: '||p_customer_number);
839: OE_DEBUG_PUB.Add('p_customer_id: '||p_customer_id);
840: OE_DEBUG_PUB.Add('p_bill_to_site_use_id: '||p_bill_to_site_use_id);
841: OE_DEBUG_PUB.Add('p_bill_to_address1: '||p_bill_to_address1);
842: OE_DEBUG_PUB.Add('p_bill_to_address2: '||p_bill_to_address2);
843: OE_DEBUG_PUB.Add('p_bill_to_address3: '||p_bill_to_address3);
844: OE_DEBUG_PUB.Add('p_bill_to_address4: '||p_bill_to_address4);
845: OE_DEBUG_PUB.Add('p_bill_to_city: '||p_bill_to_city);

Line 842: OE_DEBUG_PUB.Add('p_bill_to_address2: '||p_bill_to_address2);

838: OE_DEBUG_PUB.Add('p_customer_number: '||p_customer_number);
839: OE_DEBUG_PUB.Add('p_customer_id: '||p_customer_id);
840: OE_DEBUG_PUB.Add('p_bill_to_site_use_id: '||p_bill_to_site_use_id);
841: OE_DEBUG_PUB.Add('p_bill_to_address1: '||p_bill_to_address1);
842: OE_DEBUG_PUB.Add('p_bill_to_address2: '||p_bill_to_address2);
843: OE_DEBUG_PUB.Add('p_bill_to_address3: '||p_bill_to_address3);
844: OE_DEBUG_PUB.Add('p_bill_to_address4: '||p_bill_to_address4);
845: OE_DEBUG_PUB.Add('p_bill_to_city: '||p_bill_to_city);
846: OE_DEBUG_PUB.Add('p_bill_to_state: '||p_bill_to_state);

Line 843: OE_DEBUG_PUB.Add('p_bill_to_address3: '||p_bill_to_address3);

839: OE_DEBUG_PUB.Add('p_customer_id: '||p_customer_id);
840: OE_DEBUG_PUB.Add('p_bill_to_site_use_id: '||p_bill_to_site_use_id);
841: OE_DEBUG_PUB.Add('p_bill_to_address1: '||p_bill_to_address1);
842: OE_DEBUG_PUB.Add('p_bill_to_address2: '||p_bill_to_address2);
843: OE_DEBUG_PUB.Add('p_bill_to_address3: '||p_bill_to_address3);
844: OE_DEBUG_PUB.Add('p_bill_to_address4: '||p_bill_to_address4);
845: OE_DEBUG_PUB.Add('p_bill_to_city: '||p_bill_to_city);
846: OE_DEBUG_PUB.Add('p_bill_to_state: '||p_bill_to_state);
847: OE_DEBUG_PUB.Add('p_bill_to_postal_code: '||p_bill_to_postal_code);

Line 844: OE_DEBUG_PUB.Add('p_bill_to_address4: '||p_bill_to_address4);

840: OE_DEBUG_PUB.Add('p_bill_to_site_use_id: '||p_bill_to_site_use_id);
841: OE_DEBUG_PUB.Add('p_bill_to_address1: '||p_bill_to_address1);
842: OE_DEBUG_PUB.Add('p_bill_to_address2: '||p_bill_to_address2);
843: OE_DEBUG_PUB.Add('p_bill_to_address3: '||p_bill_to_address3);
844: OE_DEBUG_PUB.Add('p_bill_to_address4: '||p_bill_to_address4);
845: OE_DEBUG_PUB.Add('p_bill_to_city: '||p_bill_to_city);
846: OE_DEBUG_PUB.Add('p_bill_to_state: '||p_bill_to_state);
847: OE_DEBUG_PUB.Add('p_bill_to_postal_code: '||p_bill_to_postal_code);
848: OE_DEBUG_PUB.Add('p_bill_to_country: '||p_bill_to_country);

Line 845: OE_DEBUG_PUB.Add('p_bill_to_city: '||p_bill_to_city);

841: OE_DEBUG_PUB.Add('p_bill_to_address1: '||p_bill_to_address1);
842: OE_DEBUG_PUB.Add('p_bill_to_address2: '||p_bill_to_address2);
843: OE_DEBUG_PUB.Add('p_bill_to_address3: '||p_bill_to_address3);
844: OE_DEBUG_PUB.Add('p_bill_to_address4: '||p_bill_to_address4);
845: OE_DEBUG_PUB.Add('p_bill_to_city: '||p_bill_to_city);
846: OE_DEBUG_PUB.Add('p_bill_to_state: '||p_bill_to_state);
847: OE_DEBUG_PUB.Add('p_bill_to_postal_code: '||p_bill_to_postal_code);
848: OE_DEBUG_PUB.Add('p_bill_to_country: '||p_bill_to_country);
849: OE_DEBUG_PUB.Add('p_bill_to_county: '||p_bill_to_county);

Line 846: OE_DEBUG_PUB.Add('p_bill_to_state: '||p_bill_to_state);

842: OE_DEBUG_PUB.Add('p_bill_to_address2: '||p_bill_to_address2);
843: OE_DEBUG_PUB.Add('p_bill_to_address3: '||p_bill_to_address3);
844: OE_DEBUG_PUB.Add('p_bill_to_address4: '||p_bill_to_address4);
845: OE_DEBUG_PUB.Add('p_bill_to_city: '||p_bill_to_city);
846: OE_DEBUG_PUB.Add('p_bill_to_state: '||p_bill_to_state);
847: OE_DEBUG_PUB.Add('p_bill_to_postal_code: '||p_bill_to_postal_code);
848: OE_DEBUG_PUB.Add('p_bill_to_country: '||p_bill_to_country);
849: OE_DEBUG_PUB.Add('p_bill_to_county: '||p_bill_to_county);
850: OE_DEBUG_PUB.Add('p_bill_to_province: '||p_bill_to_province);

Line 847: OE_DEBUG_PUB.Add('p_bill_to_postal_code: '||p_bill_to_postal_code);

843: OE_DEBUG_PUB.Add('p_bill_to_address3: '||p_bill_to_address3);
844: OE_DEBUG_PUB.Add('p_bill_to_address4: '||p_bill_to_address4);
845: OE_DEBUG_PUB.Add('p_bill_to_city: '||p_bill_to_city);
846: OE_DEBUG_PUB.Add('p_bill_to_state: '||p_bill_to_state);
847: OE_DEBUG_PUB.Add('p_bill_to_postal_code: '||p_bill_to_postal_code);
848: OE_DEBUG_PUB.Add('p_bill_to_country: '||p_bill_to_country);
849: OE_DEBUG_PUB.Add('p_bill_to_county: '||p_bill_to_county);
850: OE_DEBUG_PUB.Add('p_bill_to_province: '||p_bill_to_province);
851:

Line 848: OE_DEBUG_PUB.Add('p_bill_to_country: '||p_bill_to_country);

844: OE_DEBUG_PUB.Add('p_bill_to_address4: '||p_bill_to_address4);
845: OE_DEBUG_PUB.Add('p_bill_to_city: '||p_bill_to_city);
846: OE_DEBUG_PUB.Add('p_bill_to_state: '||p_bill_to_state);
847: OE_DEBUG_PUB.Add('p_bill_to_postal_code: '||p_bill_to_postal_code);
848: OE_DEBUG_PUB.Add('p_bill_to_country: '||p_bill_to_country);
849: OE_DEBUG_PUB.Add('p_bill_to_county: '||p_bill_to_county);
850: OE_DEBUG_PUB.Add('p_bill_to_province: '||p_bill_to_province);
851:
852:

Line 849: OE_DEBUG_PUB.Add('p_bill_to_county: '||p_bill_to_county);

845: OE_DEBUG_PUB.Add('p_bill_to_city: '||p_bill_to_city);
846: OE_DEBUG_PUB.Add('p_bill_to_state: '||p_bill_to_state);
847: OE_DEBUG_PUB.Add('p_bill_to_postal_code: '||p_bill_to_postal_code);
848: OE_DEBUG_PUB.Add('p_bill_to_country: '||p_bill_to_country);
849: OE_DEBUG_PUB.Add('p_bill_to_county: '||p_bill_to_county);
850: OE_DEBUG_PUB.Add('p_bill_to_province: '||p_bill_to_province);
851:
852:
853: -- Validate the transaction amount parameter

Line 850: OE_DEBUG_PUB.Add('p_bill_to_province: '||p_bill_to_province);

846: OE_DEBUG_PUB.Add('p_bill_to_state: '||p_bill_to_state);
847: OE_DEBUG_PUB.Add('p_bill_to_postal_code: '||p_bill_to_postal_code);
848: OE_DEBUG_PUB.Add('p_bill_to_country: '||p_bill_to_country);
849: OE_DEBUG_PUB.Add('p_bill_to_county: '||p_bill_to_county);
850: OE_DEBUG_PUB.Add('p_bill_to_province: '||p_bill_to_province);
851:
852:
853: -- Validate the transaction amount parameter
854: IF NOT Is_Amount_Valid(p_amount => p_transaction_amount) AND

Line 857: OE_DEBUG_PUB.Add('Validate Amount Failed.');

853: -- Validate the transaction amount parameter
854: IF NOT Is_Amount_Valid(p_amount => p_transaction_amount) AND
855: NOT l_any_errors THEN
856: l_any_errors := TRUE;
857: OE_DEBUG_PUB.Add('Validate Amount Failed.');
858: END IF;
859:
860: -- Validate the currency parameters
861: IF NOT Is_Currency_Valid(p_currency_code => p_transaction_currency_code,

Line 866: OE_DEBUG_PUB.Add('Validate Transaction Currency Failed.');

862: p_parameter_name => 'P_TRANSACTION_CURRENCY_CODE')
863: AND
864: NOT l_any_errors THEN
865: l_any_errors := TRUE;
866: OE_DEBUG_PUB.Add('Validate Transaction Currency Failed.');
867: END IF;
868:
869: IF NOT Is_Currency_Valid(p_currency_code => p_functional_currency_code,
870: p_parameter_name => 'P_FUNCTIONAL_CURRENCY_CODE')

Line 874: OE_DEBUG_PUB.Add('Validate Functional Currency Failed.');

870: p_parameter_name => 'P_FUNCTIONAL_CURRENCY_CODE')
871: AND
872: NOT l_any_errors THEN
873: l_any_errors := TRUE;
874: OE_DEBUG_PUB.Add('Validate Functional Currency Failed.');
875: END IF;
876:
877: -- Validate the credit check rule parameters
878: Get_Credit_Check_Rule_ID(

Line 884: OE_DEBUG_PUB.Add('l_credit_check_rule_id: '||l_credit_check_rule_id);

880: , p_credit_check_rule_name => p_credit_check_rule_name
881: , x_credit_check_rule_id => l_credit_check_rule_id
882: , x_return_status => l_return_status
883: );
884: OE_DEBUG_PUB.Add('l_credit_check_rule_id: '||l_credit_check_rule_id);
885: IF l_return_status <> FND_API.G_RET_STS_SUCCESS AND
886: NOT l_any_errors THEN
887: l_any_errors := TRUE;
888: OE_DEBUG_PUB.Add('Validate Credit Check Rule Failed.');

Line 888: OE_DEBUG_PUB.Add('Validate Credit Check Rule Failed.');

884: OE_DEBUG_PUB.Add('l_credit_check_rule_id: '||l_credit_check_rule_id);
885: IF l_return_status <> FND_API.G_RET_STS_SUCCESS AND
886: NOT l_any_errors THEN
887: l_any_errors := TRUE;
888: OE_DEBUG_PUB.Add('Validate Credit Check Rule Failed.');
889: END IF;
890:
891: -- Validate the operating unit parameters
892: -- MOAC related changes, comment out the code per discussion

Line 901: OE_DEBUG_PUB.Add('l_return_status: '||l_return_status);

897: , p_operating_unit_name => p_operating_unit_name
898: , x_org_id => l_org_id
899: , x_return_status => l_return_status
900: );
901: OE_DEBUG_PUB.Add('l_return_status: '||l_return_status);
902: OE_DEBUG_PUB.Add('l_org_id: '|| l_org_id);
903: */
904:
905: -- dbms_application_info.set_client_info(l_org_id);

Line 902: OE_DEBUG_PUB.Add('l_org_id: '|| l_org_id);

898: , x_org_id => l_org_id
899: , x_return_status => l_return_status
900: );
901: OE_DEBUG_PUB.Add('l_return_status: '||l_return_status);
902: OE_DEBUG_PUB.Add('l_org_id: '|| l_org_id);
903: */
904:
905: -- dbms_application_info.set_client_info(l_org_id);
906: -- MO_GLOBAL.set_policy_context ('S', p_org_id); --bug4933291

Line 912: OE_DEBUG_PUB.Add('Context is set for org_id : '|| l_org_id);

908: --bug4933291
909: IF p_org_id IS NOT NULL THEN
910: MO_GLOBAL.Set_Policy_Context('S',p_org_id);
911: l_org_id := p_org_id;
912: OE_DEBUG_PUB.Add('Context is set for org_id : '|| l_org_id);
913: ELSE
914: l_return_status := FND_API.G_RET_STS_ERROR;
915: OE_DEBUG_PUB.Add('Could not set org context');
916: END IF;

Line 915: OE_DEBUG_PUB.Add('Could not set org context');

911: l_org_id := p_org_id;
912: OE_DEBUG_PUB.Add('Context is set for org_id : '|| l_org_id);
913: ELSE
914: l_return_status := FND_API.G_RET_STS_ERROR;
915: OE_DEBUG_PUB.Add('Could not set org context');
916: END IF;
917:
918: IF l_return_status <> FND_API.G_RET_STS_SUCCESS AND
919: NOT l_any_errors THEN

Line 921: OE_DEBUG_PUB.Add('Validate Operating Unit Failed.');

917:
918: IF l_return_status <> FND_API.G_RET_STS_SUCCESS AND
919: NOT l_any_errors THEN
920: l_any_errors := TRUE;
921: OE_DEBUG_PUB.Add('Validate Operating Unit Failed.');
922: END IF;
923:
924: -- Validate the location parameters
925: Get_Bill_To_Site_Use_ID

Line 945: OE_DEBUG_PUB.Add('l_bill_to_site_use_id: '|| l_bill_to_site_use_id);

941: ,x_return_status => l_return_status
942: ,x_bill_to_site_use_id => l_bill_to_site_use_id
943: );
944:
945: OE_DEBUG_PUB.Add('l_bill_to_site_use_id: '|| l_bill_to_site_use_id);
946: IF l_return_status <> FND_API.G_RET_STS_SUCCESS AND
947: NOT l_any_errors THEN
948: l_any_errors := TRUE;
949: OE_DEBUG_PUB.Add('Validate Bill-To Site Use Failed.');

Line 949: OE_DEBUG_PUB.Add('Validate Bill-To Site Use Failed.');

945: OE_DEBUG_PUB.Add('l_bill_to_site_use_id: '|| l_bill_to_site_use_id);
946: IF l_return_status <> FND_API.G_RET_STS_SUCCESS AND
947: NOT l_any_errors THEN
948: l_any_errors := TRUE;
949: OE_DEBUG_PUB.Add('Validate Bill-To Site Use Failed.');
950: END IF;
951:
952: --
953: -- If the are any errors encountered during validation of the parameters

Line 978: OE_DEBUG_PUB.Add('Check_Credit Results');

974: , x_result_out => x_result_out
975: , x_cc_hold_comment => x_cc_hold_comment
976: );
977:
978: OE_DEBUG_PUB.Add('Check_Credit Results');
979: OE_DEBUG_PUB.Add('x_return_status: '|| x_return_status);
980: OE_DEBUG_PUB.Add('x_result_out: '|| x_result_out);
981: OE_DEBUG_PUB.Add('x_cc_hold_comment: '|| x_cc_hold_comment);
982: OE_DEBUG_PUB.Add('OEXVCECB: Out Check_External_Credit');

Line 979: OE_DEBUG_PUB.Add('x_return_status: '|| x_return_status);

975: , x_cc_hold_comment => x_cc_hold_comment
976: );
977:
978: OE_DEBUG_PUB.Add('Check_Credit Results');
979: OE_DEBUG_PUB.Add('x_return_status: '|| x_return_status);
980: OE_DEBUG_PUB.Add('x_result_out: '|| x_result_out);
981: OE_DEBUG_PUB.Add('x_cc_hold_comment: '|| x_cc_hold_comment);
982: OE_DEBUG_PUB.Add('OEXVCECB: Out Check_External_Credit');
983: EXCEPTION

Line 980: OE_DEBUG_PUB.Add('x_result_out: '|| x_result_out);

976: );
977:
978: OE_DEBUG_PUB.Add('Check_Credit Results');
979: OE_DEBUG_PUB.Add('x_return_status: '|| x_return_status);
980: OE_DEBUG_PUB.Add('x_result_out: '|| x_result_out);
981: OE_DEBUG_PUB.Add('x_cc_hold_comment: '|| x_cc_hold_comment);
982: OE_DEBUG_PUB.Add('OEXVCECB: Out Check_External_Credit');
983: EXCEPTION
984: WHEN FND_API.G_EXC_ERROR THEN

Line 981: OE_DEBUG_PUB.Add('x_cc_hold_comment: '|| x_cc_hold_comment);

977:
978: OE_DEBUG_PUB.Add('Check_Credit Results');
979: OE_DEBUG_PUB.Add('x_return_status: '|| x_return_status);
980: OE_DEBUG_PUB.Add('x_result_out: '|| x_result_out);
981: OE_DEBUG_PUB.Add('x_cc_hold_comment: '|| x_cc_hold_comment);
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;

Line 982: OE_DEBUG_PUB.Add('OEXVCECB: Out Check_External_Credit');

978: OE_DEBUG_PUB.Add('Check_Credit Results');
979: OE_DEBUG_PUB.Add('x_return_status: '|| x_return_status);
980: OE_DEBUG_PUB.Add('x_result_out: '|| x_result_out);
981: OE_DEBUG_PUB.Add('x_cc_hold_comment: '|| x_cc_hold_comment);
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 (