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.CSD_RETURNS_UTIL dependencies on FND_LOG

Line 13: G_LEVEL_PROCEDURE NUMBER := FND_LOG.LEVEL_PROCEDURE;

9:
10: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSD_RETURNS_UTIL';
11: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csduretb.pls';
12:
13: G_LEVEL_PROCEDURE NUMBER := FND_LOG.LEVEL_PROCEDURE;
14: G_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
15:
16: G_RET_STS_SUCCESS VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
17: G_RET_STS_ERROR VARCHAR2(1) := FND_API.G_RET_STS_ERROR;

Line 14: G_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

10: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSD_RETURNS_UTIL';
11: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csduretb.pls';
12:
13: G_LEVEL_PROCEDURE NUMBER := FND_LOG.LEVEL_PROCEDURE;
14: G_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
15:
16: G_RET_STS_SUCCESS VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
17: G_RET_STS_ERROR VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
18:

Line 71: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Begin API');

67:
68: BEGIN
69:
70: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
71: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Begin API');
72: END IF;
73:
74: -- standard check for API compatibility.
75: IF NOT Fnd_Api.Compatible_API_Call

Line 107: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Calling csd_repairs_util.GET_ENTITLEMENTS for item_id = '||p_item_ids(i));

103: WHERE NAME = 'Depot Repair'
104: AND ROWNUM < 2;
105: -- call the API to get the contract details.
106: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
107: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Calling csd_repairs_util.GET_ENTITLEMENTS for item_id = '||p_item_ids(i));
108: END IF;
109: csd_repairs_util.GET_ENTITLEMENTS
110: ( p_api_version_number => 1.0,
111: p_init_msg_list => fnd_api.g_true,

Line 173: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Begin API');

169: l_param_id NUMBER;
170:
171: BEGIN
172: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
173: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Begin API');
174: END IF;
175:
176: -- standard check for API compatibility.
177: IF NOT Fnd_Api.Compatible_API_Call

Line 212: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Calling CSD_PARAMETER_EFFECTIVITY_PVT.PARAMETER_VALUE for param_id = '||l_param_id);

208: RETURN;
209: END;
210:
211: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
212: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Calling CSD_PARAMETER_EFFECTIVITY_PVT.PARAMETER_VALUE for param_id = '||l_param_id);
213: END IF;
214:
215: CSD_PARAMETER_EFFECTIVITY_PVT.PARAMETER_VALUE
216: (p_api_version => 1.0,

Line 362: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Begin API');

358: x_profile_pl_id NUMBER;
359:
360: BEGIN
361: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
362: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Begin API');
363: END IF;
364:
365: -- standard check for API compatibility.
366: IF NOT Fnd_Api.Compatible_API_Call

Line 387: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Begin Loop');

383: -- For each item entered, if the calculate charges is yes, then we will calculate the
384: -- charge by making call to advanced pricing, and then a call to calculate the contract discount.
385: -- the final charge will be price - discount.
386: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
387: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Begin Loop');
388: END IF;
389: FOR i IN 1 ..p_item_ids.COUNT
390: LOOP
391: x_price_lists.extend;

Line 395: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Getting the price list for iteration:'||i);

391: x_price_lists.extend;
392: x_prices.extend;
393: -- step:1 Get the pricelist and currency.
394: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
395: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Getting the price list for iteration:'||i);
396: END IF;
397: csd_process_util.get_ro_default_curr_pl
398: (p_api_version => 1.0,
399: p_init_msg_list => p_init_msg_list,

Line 522: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Calling csd_process_util.get_charge_selling_price');

518: l_pricing_attr_rec.PRICING_CONTEXT := p_PRICING_CONTEXT(i);
519:
520: -- call the API.
521: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
522: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Calling csd_process_util.get_charge_selling_price');
523: END IF;
524: csd_process_util.get_charge_selling_price
525: (p_inventory_item_id => p_item_ids(i),
526: p_price_list_header_id => x_price_lists(i),

Line 539: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Returned from csd_process_util.get_charge_selling_price. Return status:'||x_return_status||' message:'||x_msg_data);

535: x_msg_count => x_msg_count,
536: x_msg_data => x_msg_data
537: );
538: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
539: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Returned from csd_process_util.get_charge_selling_price. Return status:'||x_return_status||' message:'||x_msg_data);
540: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Price : '||l_selling_price);
541: END IF;
542: -- if the selling price is 0 or null then no need to call the contracts API.
543: IF NVL(l_selling_price,0) = 0

Line 540: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Price : '||l_selling_price);

536: x_msg_data => x_msg_data
537: );
538: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
539: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Returned from csd_process_util.get_charge_selling_price. Return status:'||x_return_status||' message:'||x_msg_data);
540: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Price : '||l_selling_price);
541: END IF;
542: -- if the selling price is 0 or null then no need to call the contracts API.
543: IF NVL(l_selling_price,0) = 0
544: THEN

Line 557: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Calling csd_charge_line_util.get_discountedprice to get warranty discounts:');

553: FROM csd_repair_types_sar_vl
554: WHERE repair_type_id = p_repair_type_ids(i)
555: AND billing_type = 'M';
556: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
557: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Calling csd_charge_line_util.get_discountedprice to get warranty discounts:');
558: END IF;
559: --
560: csd_charge_line_util.get_discountedprice
561: (p_api_version => 1.0,

Line 636: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Begin API');

632:
633:
634: BEGIN
635: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
636: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Begin API');
637: END IF;
638:
639: -- standard check for API compatibility.
640: IF NOT Fnd_Api.Compatible_API_Call

Line 665: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Getting default account site use id for account:'||p_account_id);

661: -- establish the save point.
662: SAVEPOINT process_credit_card;
663: -- get the default account_site_id
664: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
665: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Getting default account site use id for account:'||p_account_id);
666: END IF;
667: BEGIN
668: SELECT site_use_id
669: INTO l_payer_context_rec.account_site_id

Line 691: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Calling HZ_CUST_ACCOUNT_SITE_V2PUB.create_cust_acct_site to create a default account site');

687:
688: l_cust_acct_site_rec.status := 'A';
689: l_cust_acct_site_rec.created_by_module := 'CSDSR';
690: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
691: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Calling HZ_CUST_ACCOUNT_SITE_V2PUB.create_cust_acct_site to create a default account site');
692: END IF;
693: hz_cust_account_site_v2pub.create_cust_acct_site
694: (p_init_msg_list => p_init_msg_list,
695: p_cust_acct_site_rec => l_cust_acct_site_rec,

Line 705: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Error in creating default customer account site.');

701:
702: IF x_return_status <> fnd_api.g_ret_sts_success
703: THEN
704: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
705: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Error in creating default customer account site.');
706: END IF;
707: RAISE fnd_api.g_exc_error;
708: END IF;
709: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN

Line 710: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Returned from hz_cust_account_site_v2pub.create_cust_acct_site.');

706: END IF;
707: RAISE fnd_api.g_exc_error;
708: END IF;
709: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
710: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Returned from hz_cust_account_site_v2pub.create_cust_acct_site.');
711: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Status:'||x_return_status);
712: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Message:'||x_msg);
713: END IF;
714:

Line 711: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Status:'||x_return_status);

707: RAISE fnd_api.g_exc_error;
708: END IF;
709: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
710: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Returned from hz_cust_account_site_v2pub.create_cust_acct_site.');
711: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Status:'||x_return_status);
712: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Message:'||x_msg);
713: END IF;
714:
715: -- create the bill to site use for the account.

Line 712: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Message:'||x_msg);

708: END IF;
709: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
710: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Returned from hz_cust_account_site_v2pub.create_cust_acct_site.');
711: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Status:'||x_return_status);
712: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Message:'||x_msg);
713: END IF;
714:
715: -- create the bill to site use for the account.
716: l_cust_site_use_rec.cust_acct_site_id := x_cust_acct_site_id;

Line 724: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Calling HZ_CUST_ACCOUNT_SITE_V2PUB.create_cust_site_use to create a default account site use (BILL_TO).');

720: l_cust_site_use_rec.primary_flag := 'Y';
721: l_cust_site_use_rec.site_use_code := 'BILL_TO';
722:
723: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
724: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Calling HZ_CUST_ACCOUNT_SITE_V2PUB.create_cust_site_use to create a default account site use (BILL_TO).');
725: END IF;
726:
727: hz_cust_account_site_v2pub.create_cust_site_use
728: (p_init_msg_list => p_init_msg_list,

Line 741: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Error in creating default customer account site use.');

737:
738: IF x_return_status <> fnd_api.g_ret_sts_success
739: THEN
740: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
741: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Error in creating default customer account site use.');
742: END IF;
743: RAISE fnd_api.g_exc_error;
744: END IF;
745: l_payer_context_rec.account_site_id := x_acct_site_use_id;

Line 749: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Calling iby_fndcpt_setup_pub.set_payer_attributes');

745: l_payer_context_rec.account_site_id := x_acct_site_use_id;
746: END;
747:
748: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
749: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Calling iby_fndcpt_setup_pub.set_payer_attributes');
750: END IF;
751: iby_fndcpt_setup_pub.set_payer_attributes
752: (p_api_version => 1.0,
753: p_init_msg_list => p_init_msg_list,

Line 769: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Card registration failed. The message is:'||x_msg);

765: THEN
766: x_msg := x_result_rec_type.result_message;
767: x_return_status := fnd_api.g_ret_sts_error;
768: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
769: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Card registration failed. The message is:'||x_msg);
770: END IF;
771: RAISE fnd_api.g_exc_error;
772: END IF;
773:

Line 783: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Registering the card.');

779: l_creditcard_rec.instrument_type := 'CREDITCARD';
780: l_creditcard_rec.owner_id := p_party_id;
781:
782: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
783: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Registering the card.');
784: END IF;
785: -- here we call a autonomous transaction to save the CC details. This is required because before calling
786: -- authorization API, the IBY code requires us to commit the card details.
787: Create_Card

Line 804: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Card registration failed. Message:'||x_result_rec_type.result_message);

800: THEN
801: x_msg := x_result_rec_type.result_message;
802: x_return_status := fnd_api.g_ret_sts_error;
803: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
804: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Card registration failed. Message:'||x_result_rec_type.result_message);
805: END IF;
806: RAISE fnd_api.g_exc_error;
807: END IF;
808:

Line 818: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Calling instrument assignment API.');

814: l_instr_assign_rec.start_date := SYSDATE;
815:
816: -- call API to create the assignment.
817: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
818: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Calling instrument assignment API.');
819: END IF;
820:
821: iby_fndcpt_setup_pub.set_payer_instr_assignment
822: (p_api_version => 1.0,

Line 839: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Error in adding instrument assignment. Message is:'||x_result_rec_type.result_message);

835: THEN
836: x_msg := x_result_rec_type.result_message;
837: x_return_status := fnd_api.g_ret_sts_error;
838: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
839: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Error in adding instrument assignment. Message is:'||x_result_rec_type.result_message);
840: END IF;
841: RAISE fnd_api.g_exc_error;
842: END IF;
843:

Line 852: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Creating an transaction extension.');

848: l_TrxnExtension_rec.originating_application_id := 512;
849: l_TrxnExtension_rec.trxn_ref_number1 := 'CSD_REPAIRORDER';
850: l_TrxnExtension_rec.trxn_ref_number1 := 'ONLINE_RETURNS';
851: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
852: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Creating an transaction extension.');
853: END IF;
854: iby_fndcpt_trxn_pub.Create_Transaction_Extension
855: (p_api_version => 1.0,
856: p_init_msg_list => p_init_msg_list,

Line 874: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Error while creating the transaction extension. Message is:'||x_result_rec_type.result_message);

870: THEN
871: x_msg := x_result_rec_type.result_message;
872: x_return_status := fnd_api.g_ret_sts_error;
873: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
874: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Error while creating the transaction extension. Message is:'||x_result_rec_type.result_message);
875: END IF;
876: RAISE fnd_api.g_exc_error;
877: END IF;
878: -- we need to authorize the payment.

Line 900: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Calling create_authorization API to authorize the payment.');

896: -- the default values are good as per IBY documentation.
897:
898: -- step 4. Call the authorization API.
899: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
900: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Calling create_authorization API to authorize the payment.');
901: END IF;
902: iby_fndcpt_trxn_pub.create_authorization
903: (p_api_version => 1.0,
904: p_init_msg_list => p_init_msg_list,

Line 923: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Error in creating the authorization. Message is:'||x_msg);

919: THEN
920: x_msg := x_authresult_rec.paymentsys_msg;
921: x_return_status := fnd_api.g_ret_sts_error;
922: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
923: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Error in creating the authorization. Message is:'||x_msg);
924: END IF;
925: RAISE fnd_api.g_exc_error;
926: END IF;
927: x_authorized_flag := fnd_api.g_true;

Line 990: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Begin API');

986: x_party_site_number VARCHAR2(30);
987:
988: BEGIN
989: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
990: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Begin API');
991: END IF;
992:
993: -- standard check for API compatibility.
994: IF NOT Fnd_Api.Compatible_API_Call

Line 1016: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Populating the location record.');

1012: THEN
1013: -- we need to create the location first.
1014: -- populate the location record.
1015: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
1016: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Populating the location record.');
1017: END IF;
1018: l_location_rec.country := p_country;
1019: l_location_rec.address1 := p_address1;
1020: l_location_rec.address2 := p_address2;

Line 1032: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Before calling HZ_LOCATION_V2PUB.create_location');

1028: l_location_rec.address_style := p_address_style;
1029: l_location_rec.created_by_module := 'CSDSR';
1030:
1031: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
1032: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Before calling HZ_LOCATION_V2PUB.create_location');
1033: END IF;
1034:
1035: HZ_LOCATION_V2PUB.create_location
1036: (p_init_msg_list => p_init_msg_list,

Line 1045: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Returned from HZ_LOCATION_V2PUB.create_location');

1041: x_msg_count => x_msg_count,
1042: x_msg_data => x_msg_data
1043: );
1044: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
1045: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Returned from HZ_LOCATION_V2PUB.create_location');
1046: END IF;
1047:
1048: IF x_return_status <> fnd_api.g_ret_sts_success
1049: THEN

Line 1051: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Error while creating the location. The error message is:'||x_msg_data);

1047:
1048: IF x_return_status <> fnd_api.g_ret_sts_success
1049: THEN
1050: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
1051: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Error while creating the location. The error message is:'||x_msg_data);
1052: END IF;
1053: RAISE fnd_api.g_exc_error;
1054: END IF;
1055: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN

Line 1056: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Successfully created the location. The location id is ='||x_location_id);

1052: END IF;
1053: RAISE fnd_api.g_exc_error;
1054: END IF;
1055: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
1056: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Successfully created the location. The location id is ='||x_location_id);
1057: END IF;
1058: l_location_id := x_location_id;
1059: END IF;
1060:

Line 1066: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Populating l_party_site_rec for creation of party site');

1062: -- create it only if we are asked to.
1063: IF p_site_use_type IS NOT NULL
1064: THEN
1065: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
1066: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Populating l_party_site_rec for creation of party site');
1067: END IF;
1068: l_party_site_rec.party_id := p_party_id;
1069: l_party_site_rec.location_id := l_location_id;
1070: l_party_site_rec.identifying_address_flag := 'Y';

Line 1075: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Before calling HZ_PARTY_SITE_V2PUB.create_party_site');

1071: l_party_site_rec.status := 'A';
1072: l_party_site_rec.created_by_module := 'CSDSR';
1073: -- call API to create the party site.
1074: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
1075: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Before calling HZ_PARTY_SITE_V2PUB.create_party_site');
1076: END IF;
1077: HZ_PARTY_SITE_V2PUB.create_party_site
1078: (p_init_msg_list => p_init_msg_list,
1079: p_party_site_rec => l_party_site_rec,

Line 1087: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Returned from HZ_PARTY_SITE_V2PUB.create_party_site');

1083: x_msg_count => x_msg_count,
1084: x_msg_data => x_msg_data
1085: );
1086: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
1087: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Returned from HZ_PARTY_SITE_V2PUB.create_party_site');
1088: END IF;
1089:
1090: IF x_return_status <> fnd_api.g_ret_sts_success
1091: THEN

Line 1093: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Error while creating the party site. The error message is:'||x_msg_data);

1089:
1090: IF x_return_status <> fnd_api.g_ret_sts_success
1091: THEN
1092: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
1093: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Error while creating the party site. The error message is:'||x_msg_data);
1094: END IF;
1095: RAISE fnd_api.g_exc_error;
1096: END IF;
1097: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN

Line 1098: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Successfully created the party site. The site id is ='||x_party_site_id);

1094: END IF;
1095: RAISE fnd_api.g_exc_error;
1096: END IF;
1097: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
1098: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Successfully created the party site. The site id is ='||x_party_site_id);
1099: END IF;
1100:
1101: -- create party site use.
1102: -- populate the party site use rec.

Line 1104: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Populating party site use rec.');

1100:
1101: -- create party site use.
1102: -- populate the party site use rec.
1103: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
1104: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Populating party site use rec.');
1105: END IF;
1106: l_party_site_use_rec.party_site_id := x_party_site_id;
1107: l_party_site_use_rec.site_use_type := p_site_use_type;
1108: l_party_site_use_rec.primary_per_type := 'Y';

Line 1114: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Calling HZ_PARTY_SITE_V2PUB.create_party_site_use');

1110: l_party_site_use_rec.application_id := 512;
1111: l_party_site_use_rec.created_by_module := 'CSDSR';
1112:
1113: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
1114: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Calling HZ_PARTY_SITE_V2PUB.create_party_site_use');
1115: END IF;
1116: HZ_PARTY_SITE_V2PUB.create_party_site_use
1117: (p_init_msg_list => p_init_msg_list,
1118: p_party_site_use_rec => l_party_site_use_rec,

Line 1128: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Error while creating the party site use. The error message is:'||x_msg_data);

1124:
1125: IF x_return_status <> fnd_api.g_ret_sts_success
1126: THEN
1127: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
1128: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Error while creating the party site use. The error message is:'||x_msg_data);
1129: END IF;
1130: RAISE fnd_api.g_exc_error;
1131: END IF;
1132: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN

Line 1133: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Successfully created the party site. The site use id is ='||x_party_site_use_id);

1129: END IF;
1130: RAISE fnd_api.g_exc_error;
1131: END IF;
1132: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
1133: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Successfully created the party site. The site use id is ='||x_party_site_use_id);
1134: END IF;
1135: END IF;
1136:
1137: IF fnd_api.to_boolean(p_commit)

Line 1376: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Begin process_returns API');

1372:
1373: BEGIN
1374:
1375: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
1376: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Begin process_returns API');
1377: END IF;
1378:
1379: -- standard check for API compatibility.
1380: IF NOT Fnd_Api.Compatible_API_Call

Line 1399: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Initializing the SR rec');

1395: x_return_status := fnd_api.g_ret_sts_success;
1396:
1397: -- the API will create one service request per return request.
1398: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
1399: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Initializing the SR rec');
1400: END IF;
1401: l_service_request_rec.customer_id := p_party_id;
1402: l_service_request_rec.account_id := p_account_id;
1403: l_service_request_rec.request_date := sysdate;

Line 1489: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Calling HZ_CONTACT_POINT_V2PUB.create_email_contact_point'||x_msg_data);

1485: l_email_rec.email_address := p_email;
1486:
1487: -- call API to create the contact point.
1488: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
1489: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Calling HZ_CONTACT_POINT_V2PUB.create_email_contact_point'||x_msg_data);
1490: END IF;
1491: HZ_CONTACT_POINT_V2PUB.create_email_contact_point
1492: (p_init_msg_list => p_init_msg_list,
1493: p_contact_point_rec => l_contact_point_rec,

Line 1559: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Error in SR creation. Error msg is = '||x_msg_data);

1555: IF NOT x_return_status = FND_API.G_RET_STS_SUCCESS
1556: THEN
1557: -- need to present a good error message to the web user. set it here. To do.
1558: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
1559: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Error in SR creation. Error msg is = '||x_msg_data);
1560: END IF;
1561: RAISE FND_API.G_EXC_ERROR;
1562: END IF;
1563: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN

Line 1564: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Created the SR, incident id = '||x_incident_id);

1560: END IF;
1561: RAISE FND_API.G_EXC_ERROR;
1562: END IF;
1563: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
1564: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Created the SR, incident id = '||x_incident_id);
1565: END IF;
1566: -- call to user hook procedure.
1567: CSD_RETURNS_CUHK.after_sr_creation
1568: (p_api_version => 1.0,

Line 1699: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'calling csd_repairs_util.change_item_ib_owner to change IB owner');

1695: IF NVL(l_param_value,'N') = 'Y'
1696: THEN
1697: -- change IB ownership
1698: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
1699: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'calling csd_repairs_util.change_item_ib_owner to change IB owner');
1700: END IF;
1701: csd_repairs_util.change_item_ib_owner
1702: (p_instance_id => x_instance_id,
1703: p_new_owner_party_id => p_party_id,

Line 1715: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Error in change owner. Message is: '||x_msg_data);

1711:
1712: IF x_return_status <> fnd_api.g_ret_sts_success
1713: THEN
1714: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
1715: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Error in change owner. Message is: '||x_msg_data);
1716: END IF;
1717: RAISE fnd_api.g_exc_error;
1718: END IF;
1719: END IF;

Line 1777: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Error in csd_mass_rcv_pvt.create_item_instance. Message is: '||x_msg_data);

1773:
1774: IF x_return_status <> fnd_api.g_ret_sts_success
1775: THEN
1776: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
1777: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Error in csd_mass_rcv_pvt.create_item_instance. Message is: '||x_msg_data);
1778: END IF;
1779: RAISE fnd_api.g_exc_error;
1780: END IF;
1781:

Line 1895: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Calling CSD_REPAIRS_PVT.Create_Repair_Order.');

1891: x_msg_data => x_msg_data
1892: );
1893: -- call the create repair order API.
1894: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
1895: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Calling CSD_REPAIRS_PVT.Create_Repair_Order.');
1896: END IF;
1897: CSD_REPAIRS_PVT.Create_Repair_Order
1898: (p_api_version_number => 1.0,
1899: p_commit => p_commit,

Line 1914: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Error in CSD_REPAIRS_PVT.Create_Repair_Order. Message is: '||x_msg_data);

1910:
1911: IF x_return_status <> fnd_api.g_ret_sts_success
1912: THEN
1913: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
1914: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Error in CSD_REPAIRS_PVT.Create_Repair_Order. Message is: '||x_msg_data);
1915: END IF;
1916: RAISE fnd_api.g_exc_error;
1917: END IF;
1918:

Line 1949: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Calling csd_repair_manager_util.mass_create_attachments to create attachments.');

1945: LOOP
1946: l_repair_line_id_tbl.extend;
1947: l_repair_line_id_tbl(1) := x_repair_line_id;
1948: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
1949: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Calling csd_repair_manager_util.mass_create_attachments to create attachments.');
1950: END IF;
1951: -- call the create attachments API.
1952: csd_repair_manager_util.mass_create_attachments
1953: (p_api_version => 1.0,

Line 2016: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Calling csd_repair_estimate_pvt.create_repair_estimate for repair line id= '||x_repair_line_id);

2012: l_estimate_rec.not_to_exceed := NULL;
2013:
2014: -- call API to create the repair estimate.
2015: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
2016: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Calling csd_repair_estimate_pvt.create_repair_estimate for repair line id= '||x_repair_line_id);
2017: END IF;
2018: csd_repair_estimate_pvt.create_repair_estimate
2019: (p_api_version => 1.0,
2020: p_commit => p_commit,

Line 2239: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Calling csd_repair_estimate_pvt.create_repair_estimate_lines for repair line id= '||x_repair_line_id);

2235: l_estimate_lines_rec.pricing_attribute100 := p_pricing_attribute100(i);
2236:
2237: -- call the create estimate lines API.
2238: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
2239: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Calling csd_repair_estimate_pvt.create_repair_estimate_lines for repair line id= '||x_repair_line_id);
2240: END IF;
2241: csd_repair_estimate_pvt.create_repair_estimate_lines
2242: (p_api_version => 1.0,
2243: p_commit => p_commit,

Line 2303: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

2299: p_msg_index => j,
2300: p_encoded => 'F',
2301: p_data => x_msg_data,
2302: p_msg_index_out => x_msg_index_out);
2303: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2304: THEN
2305: fnd_log.STRING (fnd_log.level_procedure,lc_api_name,'Error count '||x_msg_count||' Message '||x_msg_data);
2306: END IF;
2307: END LOOP;

Line 2305: fnd_log.STRING (fnd_log.level_procedure,lc_api_name,'Error count '||x_msg_count||' Message '||x_msg_data);

2301: p_data => x_msg_data,
2302: p_msg_index_out => x_msg_index_out);
2303: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2304: THEN
2305: fnd_log.STRING (fnd_log.level_procedure,lc_api_name,'Error count '||x_msg_count||' Message '||x_msg_data);
2306: END IF;
2307: END LOOP;
2308: x_return_status := fnd_api.g_ret_sts_error;
2309:

Line 2347: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'begin the api to create logistics lines..');

2343: x_msg_data VARCHAR2(2000);
2344:
2345: BEGIN
2346: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
2347: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'begin the api to create logistics lines..');
2348: END IF;
2349:
2350: SELECT repair_line_id
2351: BULK COLLECT INTO l_repair_line_ids

Line 2358: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Calling create default product transaction for repair line id:'||l_repair_line_ids(i));

2354:
2355: FOR i IN 1 ..l_repair_line_ids.COUNT
2356: LOOP
2357: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
2358: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Calling create default product transaction for repair line id:'||l_repair_line_ids(i));
2359: END IF;
2360: IF INSTR(l_return_reason_code,',') = 0
2361: THEN
2362: l_ret_reason := l_return_reason_code;