DBA Data[Home] [Help]

APPS.CSD_BULK_RECEIVE_UTIL dependencies on FND_API

Line 344: p_commit => fnd_api.g_false,

340:
341: -- Call the Service Request API
342: CSD_PROCESS_PVT.process_service_request
343: ( p_api_version => 1.0,
344: p_commit => fnd_api.g_false,
345: p_init_msg_list => fnd_api.g_true,
346: p_validation_level => fnd_api.g_valid_level_full,
347: p_action => 'CREATE',
348: p_incident_id => NULL,

Line 345: p_init_msg_list => fnd_api.g_true,

341: -- Call the Service Request API
342: CSD_PROCESS_PVT.process_service_request
343: ( p_api_version => 1.0,
344: p_commit => fnd_api.g_false,
345: p_init_msg_list => fnd_api.g_true,
346: p_validation_level => fnd_api.g_valid_level_full,
347: p_action => 'CREATE',
348: p_incident_id => NULL,
349: p_service_request_rec => l_service_request_rec,

Line 346: p_validation_level => fnd_api.g_valid_level_full,

342: CSD_PROCESS_PVT.process_service_request
343: ( p_api_version => 1.0,
344: p_commit => fnd_api.g_false,
345: p_init_msg_list => fnd_api.g_true,
346: p_validation_level => fnd_api.g_valid_level_full,
347: p_action => 'CREATE',
348: p_incident_id => NULL,
349: p_service_request_rec => l_service_request_rec,
350: p_notes_tbl => p_sr_notes_tbl,

Line 358: If NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) then

354: x_msg_count => x_msg_count,
355: x_msg_data => x_msg_data
356: );
357:
358: If NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) then
359: RAISE FND_API.G_EXC_ERROR;
360: End If;
361:
362: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then

Line 359: RAISE FND_API.G_EXC_ERROR;

355: x_msg_data => x_msg_data
356: );
357:
358: If NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) then
359: RAISE FND_API.G_EXC_ERROR;
360: End If;
361:
362: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
363: fnd_log.STRING (fnd_log.level_procedure,

Line 369: When FND_API.G_EXC_ERROR then

365: 'Exit - Create Blkrcv SR');
366: End if;
367:
368: EXCEPTION
369: When FND_API.G_EXC_ERROR then
370: Rollback To create_blkrcv_sr;
371: x_return_status := FND_API.G_RET_STS_ERROR ;
372: FND_MSG_PUB.Count_And_Get
373: (p_count => x_msg_count,

Line 371: x_return_status := FND_API.G_RET_STS_ERROR ;

367:
368: EXCEPTION
369: When FND_API.G_EXC_ERROR then
370: Rollback To create_blkrcv_sr;
371: x_return_status := FND_API.G_RET_STS_ERROR ;
372: FND_MSG_PUB.Count_And_Get
373: (p_count => x_msg_count,
374: p_data => x_msg_data );
375:

Line 376: When FND_API.G_EXC_UNEXPECTED_ERROR then

372: FND_MSG_PUB.Count_And_Get
373: (p_count => x_msg_count,
374: p_data => x_msg_data );
375:
376: When FND_API.G_EXC_UNEXPECTED_ERROR then
377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
378: ROLLBACK TO create_blkrcv_sr;
379: FND_MSG_PUB.Count_And_Get
380: ( p_count => x_msg_count,

Line 377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

373: (p_count => x_msg_count,
374: p_data => x_msg_data );
375:
376: When FND_API.G_EXC_UNEXPECTED_ERROR then
377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
378: ROLLBACK TO create_blkrcv_sr;
379: FND_MSG_PUB.Count_And_Get
380: ( p_count => x_msg_count,
381: p_data => x_msg_data );

Line 384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

380: ( p_count => x_msg_count,
381: p_data => x_msg_data );
382:
383: When OTHERS then
384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
385: Rollback To create_blkrcv_sr;
386: If FND_MSG_PUB.Check_Msg_Level
387: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)then
388: FND_MSG_PUB.Add_Exc_Msg

Line 644: p_init_msg_list => fnd_api.g_false,

640:
641:
642: csd_mass_rcv_pvt.create_item_instance (
643: p_api_version => 1.0,
644: p_init_msg_list => fnd_api.g_false,
645: p_commit => fnd_api.g_false,
646: p_validation_level => fnd_api.g_valid_level_full,
647: x_return_status => x_return_status,
648: x_msg_count => x_msg_count,

Line 645: p_commit => fnd_api.g_false,

641:
642: csd_mass_rcv_pvt.create_item_instance (
643: p_api_version => 1.0,
644: p_init_msg_list => fnd_api.g_false,
645: p_commit => fnd_api.g_false,
646: p_validation_level => fnd_api.g_valid_level_full,
647: x_return_status => x_return_status,
648: x_msg_count => x_msg_count,
649: x_msg_data => x_msg_data,

Line 646: p_validation_level => fnd_api.g_valid_level_full,

642: csd_mass_rcv_pvt.create_item_instance (
643: p_api_version => 1.0,
644: p_init_msg_list => fnd_api.g_false,
645: p_commit => fnd_api.g_false,
646: p_validation_level => fnd_api.g_valid_level_full,
647: x_return_status => x_return_status,
648: x_msg_count => x_msg_count,
649: x_msg_data => x_msg_data,
650: px_instance_rec => l_instance_rec,

Line 653: If NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) then

649: x_msg_data => x_msg_data,
650: px_instance_rec => l_instance_rec,
651: x_instance_id => l_instance_id );
652:
653: If NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) then
654: RAISE FND_API.G_EXC_ERROR;
655: End if;
656:
657: End if;

Line 654: RAISE FND_API.G_EXC_ERROR;

650: px_instance_rec => l_instance_rec,
651: x_instance_id => l_instance_id );
652:
653: If NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) then
654: RAISE FND_API.G_EXC_ERROR;
655: End if;
656:
657: End if;
658:

Line 696: p_init_msg_list => fnd_api.g_false,

692: fnd_profile.get('SERVER_TIMEZONE_ID', l_server_tz_id);
693:
694: CSD_REPAIRS_UTIL.GET_ENTITLEMENTS(
695: p_api_version_number => 1.0,
696: p_init_msg_list => fnd_api.g_false,
697: p_commit => fnd_api.g_false,
698: p_contract_number => null,
699: p_service_line_id => null,
700: p_customer_id => l_customer_id,

Line 697: p_commit => fnd_api.g_false,

693:
694: CSD_REPAIRS_UTIL.GET_ENTITLEMENTS(
695: p_api_version_number => 1.0,
696: p_init_msg_list => fnd_api.g_false,
697: p_commit => fnd_api.g_false,
698: p_contract_number => null,
699: p_service_line_id => null,
700: p_customer_id => l_customer_id,
701: p_site_id => l_install_site_use_id,

Line 717: If NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) then

713: x_return_status => x_return_status,
714: x_msg_count => x_msg_count,
715: x_msg_data => x_msg_data);
716:
717: If NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) then
718: RAISE FND_API.G_EXC_ERROR;
719: End if;
720:
721: If (l_ent_contracts.count = 0 ) then

Line 718: RAISE FND_API.G_EXC_ERROR;

714: x_msg_count => x_msg_count,
715: x_msg_data => x_msg_data);
716:
717: If NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) then
718: RAISE FND_API.G_EXC_ERROR;
719: End if;
720:
721: If (l_ent_contracts.count = 0 ) then
722:

Line 738: l_repln_rec.contract_line_id = fnd_api.g_miss_num) then

734: end if;
735: End Loop;
736:
737: If (l_repln_rec.contract_line_id is null or
738: l_repln_rec.contract_line_id = fnd_api.g_miss_num) then
739: l_repln_rec.contract_line_id := l_ent_contracts(1).service_line_id;
740: End if;
741:
742: End if;

Line 749: p_init_msg_list => fnd_api.g_false,

745: -- Default PL and Currency
746: --
747: csd_process_util.get_ro_default_curr_pl
748: ( p_api_version => 1.0,
749: p_init_msg_list => fnd_api.g_false,
750: p_incident_id => l_blkrcv_rec.incident_id,
751: p_repair_type_id => l_repair_type_id,
752: p_ro_contract_line_id => l_repln_rec.contract_line_id,
753: x_contract_pl_id => l_contract_pl_id,

Line 760: If NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) then

756: x_return_status => x_return_status,
757: x_msg_count => x_msg_count,
758: x_msg_data => x_msg_data );
759:
760: If NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) then
761: RAISE FND_API.G_EXC_ERROR;
762: End if;
763:
764: If ( l_contract_pl_id is not null) then

Line 761: RAISE FND_API.G_EXC_ERROR;

757: x_msg_count => x_msg_count,
758: x_msg_data => x_msg_data );
759:
760: If NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) then
761: RAISE FND_API.G_EXC_ERROR;
762: End if;
763:
764: If ( l_contract_pl_id is not null) then
765: l_repln_rec.price_list_header_id := l_contract_pl_id;

Line 787: l_repln_rec.inventory_org_id := fnd_api.g_miss_num;

783: -- Inventory org id
784: --
785: -- swai: bug 7657379 - use defaulting rules to get the inventory org
786: -- l_repln_rec.inventory_org_id := fnd_profile.value('CSD_DEF_REP_INV_ORG');
787: l_repln_rec.inventory_org_id := fnd_api.g_miss_num;
788:
789: --
790: -- Initialize / Assign the values to Repair Rec type
791: --

Line 816: p_commit => fnd_api.g_false,

812:
813: -- Call the Repairs private API
814: CSD_REPAIRS_PVT.Create_Repair_Order
815: (p_api_version_number => 1.0,
816: p_commit => fnd_api.g_false,
817: p_init_msg_list => fnd_api.g_true,
818: p_validation_level => fnd_api.g_valid_level_full,
819: p_repair_line_id => x_repair_line_id,
820: p_Repln_Rec => l_repln_rec,

Line 817: p_init_msg_list => fnd_api.g_true,

813: -- Call the Repairs private API
814: CSD_REPAIRS_PVT.Create_Repair_Order
815: (p_api_version_number => 1.0,
816: p_commit => fnd_api.g_false,
817: p_init_msg_list => fnd_api.g_true,
818: p_validation_level => fnd_api.g_valid_level_full,
819: p_repair_line_id => x_repair_line_id,
820: p_Repln_Rec => l_repln_rec,
821: x_repair_line_id => x_repair_line_id,

Line 818: p_validation_level => fnd_api.g_valid_level_full,

814: CSD_REPAIRS_PVT.Create_Repair_Order
815: (p_api_version_number => 1.0,
816: p_commit => fnd_api.g_false,
817: p_init_msg_list => fnd_api.g_true,
818: p_validation_level => fnd_api.g_valid_level_full,
819: p_repair_line_id => x_repair_line_id,
820: p_Repln_Rec => l_repln_rec,
821: x_repair_line_id => x_repair_line_id,
822: x_repair_number => x_repair_number,

Line 828: If NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) then

824: x_msg_count => x_msg_count,
825: x_msg_data => x_msg_data
826: );
827:
828: If NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) then
829: RAISE FND_API.G_EXC_ERROR;
830: End If;
831:
832: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then

Line 829: RAISE FND_API.G_EXC_ERROR;

825: x_msg_data => x_msg_data
826: );
827:
828: If NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) then
829: RAISE FND_API.G_EXC_ERROR;
830: End If;
831:
832: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
833: fnd_log.STRING (fnd_log.level_procedure,

Line 839: When FND_API.G_EXC_ERROR then

835: 'Exit - Create Blkrcv RO');
836: End if;
837:
838: EXCEPTION
839: When FND_API.G_EXC_ERROR then
840: Rollback To create_blkrcv_ro;
841: x_return_status := FND_API.G_RET_STS_ERROR ;
842: FND_MSG_PUB.Count_And_Get
843: (p_count => x_msg_count,

Line 841: x_return_status := FND_API.G_RET_STS_ERROR ;

837:
838: EXCEPTION
839: When FND_API.G_EXC_ERROR then
840: Rollback To create_blkrcv_ro;
841: x_return_status := FND_API.G_RET_STS_ERROR ;
842: FND_MSG_PUB.Count_And_Get
843: (p_count => x_msg_count,
844: p_data => x_msg_data );
845:

Line 846: When FND_API.G_EXC_UNEXPECTED_ERROR then

842: FND_MSG_PUB.Count_And_Get
843: (p_count => x_msg_count,
844: p_data => x_msg_data );
845:
846: When FND_API.G_EXC_UNEXPECTED_ERROR then
847: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
848: ROLLBACK TO create_blkrcv_ro;
849: FND_MSG_PUB.Count_And_Get
850: ( p_count => x_msg_count,

Line 847: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

843: (p_count => x_msg_count,
844: p_data => x_msg_data );
845:
846: When FND_API.G_EXC_UNEXPECTED_ERROR then
847: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
848: ROLLBACK TO create_blkrcv_ro;
849: FND_MSG_PUB.Count_And_Get
850: ( p_count => x_msg_count,
851: p_data => x_msg_data );

Line 854: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

850: ( p_count => x_msg_count,
851: p_data => x_msg_data );
852:
853: When OTHERS then
854: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
855: Rollback To create_blkrcv_ro;
856: If FND_MSG_PUB.Check_Msg_Level
857: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)then
858: FND_MSG_PUB.Add_Exc_Msg

Line 912: p_commit => fnd_api.g_false,

908:
909: -- Call the Create default prod txn api
910: csd_process_pvt.create_default_prod_txn
911: (p_api_version => 1.0,
912: p_commit => fnd_api.g_false,
913: p_init_msg_list => fnd_api.g_true,
914: p_validation_level => fnd_api.g_valid_level_full,
915: p_repair_line_id => l_blkrcv_rec.repair_line_id,
916: x_return_status => x_return_status,

Line 913: p_init_msg_list => fnd_api.g_true,

909: -- Call the Create default prod txn api
910: csd_process_pvt.create_default_prod_txn
911: (p_api_version => 1.0,
912: p_commit => fnd_api.g_false,
913: p_init_msg_list => fnd_api.g_true,
914: p_validation_level => fnd_api.g_valid_level_full,
915: p_repair_line_id => l_blkrcv_rec.repair_line_id,
916: x_return_status => x_return_status,
917: x_msg_count => x_msg_count,

Line 914: p_validation_level => fnd_api.g_valid_level_full,

910: csd_process_pvt.create_default_prod_txn
911: (p_api_version => 1.0,
912: p_commit => fnd_api.g_false,
913: p_init_msg_list => fnd_api.g_true,
914: p_validation_level => fnd_api.g_valid_level_full,
915: p_repair_line_id => l_blkrcv_rec.repair_line_id,
916: x_return_status => x_return_status,
917: x_msg_count => x_msg_count,
918: x_msg_data => x_msg_data);

Line 920: If NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) then

916: x_return_status => x_return_status,
917: x_msg_count => x_msg_count,
918: x_msg_data => x_msg_data);
919:
920: If NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) then
921: RAISE FND_API.G_EXC_ERROR;
922: End If;
923:
924: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then

Line 921: RAISE FND_API.G_EXC_ERROR;

917: x_msg_count => x_msg_count,
918: x_msg_data => x_msg_data);
919:
920: If NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) then
921: RAISE FND_API.G_EXC_ERROR;
922: End If;
923:
924: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
925: fnd_log.STRING (fnd_log.level_procedure,

Line 931: When FND_API.G_EXC_ERROR then

927: 'Exit - Create Blkrcv Default Prod Txn');
928: End if;
929:
930: EXCEPTION
931: When FND_API.G_EXC_ERROR then
932: Rollback To create_blkrcv_default_prod_txn;
933: x_return_status := FND_API.G_RET_STS_ERROR ;
934: FND_MSG_PUB.Count_And_Get
935: (p_count => x_msg_count,

Line 933: x_return_status := FND_API.G_RET_STS_ERROR ;

929:
930: EXCEPTION
931: When FND_API.G_EXC_ERROR then
932: Rollback To create_blkrcv_default_prod_txn;
933: x_return_status := FND_API.G_RET_STS_ERROR ;
934: FND_MSG_PUB.Count_And_Get
935: (p_count => x_msg_count,
936: p_data => x_msg_data );
937:

Line 938: When FND_API.G_EXC_UNEXPECTED_ERROR then

934: FND_MSG_PUB.Count_And_Get
935: (p_count => x_msg_count,
936: p_data => x_msg_data );
937:
938: When FND_API.G_EXC_UNEXPECTED_ERROR then
939: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
940: ROLLBACK TO create_blkrcv_default_prod_txn;
941: FND_MSG_PUB.Count_And_Get
942: ( p_count => x_msg_count,

Line 939: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

935: (p_count => x_msg_count,
936: p_data => x_msg_data );
937:
938: When FND_API.G_EXC_UNEXPECTED_ERROR then
939: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
940: ROLLBACK TO create_blkrcv_default_prod_txn;
941: FND_MSG_PUB.Count_And_Get
942: ( p_count => x_msg_count,
943: p_data => x_msg_data );

Line 946: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

942: ( p_count => x_msg_count,
943: p_data => x_msg_data );
944:
945: When OTHERS then
946: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
947: Rollback To create_blkrcv_default_prod_txn;
948: If FND_MSG_PUB.Check_Msg_Level
949: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)then
950: FND_MSG_PUB.Add_Exc_Msg

Line 1108: p_commit => fnd_api.g_false,

1104: -- Call the Update item instance API
1105: csi_item_instance_pub.update_item_instance
1106: (
1107: p_api_version => 1.0,
1108: p_commit => fnd_api.g_false,
1109: p_init_msg_list => fnd_api.g_true,
1110: p_validation_level => fnd_api.g_valid_level_full,
1111: p_instance_rec => l_instance_rec,
1112: p_ext_attrib_values_tbl => l_ext_attrib_values_tbl,

Line 1109: p_init_msg_list => fnd_api.g_true,

1105: csi_item_instance_pub.update_item_instance
1106: (
1107: p_api_version => 1.0,
1108: p_commit => fnd_api.g_false,
1109: p_init_msg_list => fnd_api.g_true,
1110: p_validation_level => fnd_api.g_valid_level_full,
1111: p_instance_rec => l_instance_rec,
1112: p_ext_attrib_values_tbl => l_ext_attrib_values_tbl,
1113: p_party_tbl => l_party_tbl,

Line 1110: p_validation_level => fnd_api.g_valid_level_full,

1106: (
1107: p_api_version => 1.0,
1108: p_commit => fnd_api.g_false,
1109: p_init_msg_list => fnd_api.g_true,
1110: p_validation_level => fnd_api.g_valid_level_full,
1111: p_instance_rec => l_instance_rec,
1112: p_ext_attrib_values_tbl => l_ext_attrib_values_tbl,
1113: p_party_tbl => l_party_tbl,
1114: p_account_tbl => l_account_tbl,

Line 1125: If NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) then

1121: x_msg_count => x_msg_count,
1122: x_msg_data => x_msg_data
1123: );
1124:
1125: If NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) then
1126: RAISE FND_API.G_EXC_ERROR;
1127: End If;
1128:
1129: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then

Line 1126: RAISE FND_API.G_EXC_ERROR;

1122: x_msg_data => x_msg_data
1123: );
1124:
1125: If NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) then
1126: RAISE FND_API.G_EXC_ERROR;
1127: End If;
1128:
1129: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
1130: fnd_log.STRING (fnd_log.level_procedure,

Line 1136: When FND_API.G_EXC_ERROR then

1132: 'Exit - Change Blkrcv IB Owner');
1133: End if;
1134:
1135: EXCEPTION
1136: When FND_API.G_EXC_ERROR then
1137: Rollback To change_blkrcv_ib_owner;
1138: x_return_status := FND_API.G_RET_STS_ERROR ;
1139: FND_MSG_PUB.Count_And_Get
1140: (p_count => x_msg_count,

Line 1138: x_return_status := FND_API.G_RET_STS_ERROR ;

1134:
1135: EXCEPTION
1136: When FND_API.G_EXC_ERROR then
1137: Rollback To change_blkrcv_ib_owner;
1138: x_return_status := FND_API.G_RET_STS_ERROR ;
1139: FND_MSG_PUB.Count_And_Get
1140: (p_count => x_msg_count,
1141: p_data => x_msg_data );
1142:

Line 1143: When FND_API.G_EXC_UNEXPECTED_ERROR then

1139: FND_MSG_PUB.Count_And_Get
1140: (p_count => x_msg_count,
1141: p_data => x_msg_data );
1142:
1143: When FND_API.G_EXC_UNEXPECTED_ERROR then
1144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1145: ROLLBACK TO change_blkrcv_ib_owner;
1146: FND_MSG_PUB.Count_And_Get
1147: ( p_count => x_msg_count,

Line 1144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1140: (p_count => x_msg_count,
1141: p_data => x_msg_data );
1142:
1143: When FND_API.G_EXC_UNEXPECTED_ERROR then
1144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1145: ROLLBACK TO change_blkrcv_ib_owner;
1146: FND_MSG_PUB.Count_And_Get
1147: ( p_count => x_msg_count,
1148: p_data => x_msg_data );

Line 1151: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1147: ( p_count => x_msg_count,
1148: p_data => x_msg_data );
1149:
1150: When OTHERS then
1151: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1152: Rollback To change_blkrcv_ib_owner;
1153: If FND_MSG_PUB.Check_Msg_Level
1154: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)then
1155: FND_MSG_PUB.Add_Exc_Msg

Line 1328: If NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) then -- Status check If statement

1324: p_receive_tbl => l_rcv_rec_tbl);
1325:
1326:
1327:
1328: If NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) then -- Status check If statement
1329:
1330: -- Verify if there are any errors in header
1331:
1332: csd_bulk_receive_util.write_to_conc_log

Line 1439: p_commit => fnd_api.g_false,

1435:
1436: -- Call Update receipts program
1437: CSD_UPDATE_PROGRAMS_PVT.RECEIPTS_UPDATE
1438: ( p_api_version => 1.0,
1439: p_commit => fnd_api.g_false,
1440: p_init_msg_list => fnd_api.g_true,
1441: p_validation_level => 0,
1442: x_return_status => l_return_status,
1443: x_msg_count => l_msg_count,

Line 1440: p_init_msg_list => fnd_api.g_true,

1436: -- Call Update receipts program
1437: CSD_UPDATE_PROGRAMS_PVT.RECEIPTS_UPDATE
1438: ( p_api_version => 1.0,
1439: p_commit => fnd_api.g_false,
1440: p_init_msg_list => fnd_api.g_true,
1441: p_validation_level => 0,
1442: x_return_status => l_return_status,
1443: x_msg_count => l_msg_count,
1444: x_msg_data => l_msg_data,

Line 1450: If NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) then

1446: p_order_header_id => null,
1447: p_repair_line_id => p_bulk_autorcv_tbl(i).repair_line_id);
1448:
1449: -- fix for bug 5227347
1450: If NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) then
1451:
1452: Fnd_file.put_line(fnd_file.log,'Error : CSD_UPDATE_PROGRAMS_PVT.RECEIPTS_UPDATE failed');
1453: csd_bulk_receive_util.write_to_conc_log
1454: ( p_msg_count => l_msg_count,

Line 1507: p_commit => fnd_api.g_false,

1503:
1504: -- Call Update receipts program
1505: CSD_UPDATE_PROGRAMS_PVT.RECEIPTS_UPDATE
1506: ( p_api_version => 1.0,
1507: p_commit => fnd_api.g_false,
1508: p_init_msg_list => fnd_api.g_true,
1509: p_validation_level => 0,
1510: x_return_status => l_return_status,
1511: x_msg_count => l_msg_count,

Line 1508: p_init_msg_list => fnd_api.g_true,

1504: -- Call Update receipts program
1505: CSD_UPDATE_PROGRAMS_PVT.RECEIPTS_UPDATE
1506: ( p_api_version => 1.0,
1507: p_commit => fnd_api.g_false,
1508: p_init_msg_list => fnd_api.g_true,
1509: p_validation_level => 0,
1510: x_return_status => l_return_status,
1511: x_msg_count => l_msg_count,
1512: x_msg_data => l_msg_data,

Line 1518: If NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) then

1514: p_order_header_id => null,
1515: p_repair_line_id => p_bulk_autorcv_tbl(i).repair_line_id);
1516:
1517: -- fix for bug 5227347
1518: If NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) then
1519:
1520: Fnd_file.put_line(fnd_file.log,'Error : CSD_UPDATE_PROGRAMS_PVT.RECEIPTS_UPDATE failed');
1521: csd_bulk_receive_util.write_to_conc_log
1522: ( p_msg_count => l_msg_count,

Line 1555: When FND_API.G_EXC_ERROR then

1551: 'Exit - Bulk auto receive');
1552: End if;
1553:
1554: EXCEPTION
1555: When FND_API.G_EXC_ERROR then
1556: Rollback To bulk_auto_receive;
1557: x_return_status := FND_API.G_RET_STS_ERROR ;
1558: FND_MSG_PUB.Count_And_Get
1559: (p_count => x_msg_count,

Line 1557: x_return_status := FND_API.G_RET_STS_ERROR ;

1553:
1554: EXCEPTION
1555: When FND_API.G_EXC_ERROR then
1556: Rollback To bulk_auto_receive;
1557: x_return_status := FND_API.G_RET_STS_ERROR ;
1558: FND_MSG_PUB.Count_And_Get
1559: (p_count => x_msg_count,
1560: p_data => x_msg_data );
1561:

Line 1562: When FND_API.G_EXC_UNEXPECTED_ERROR then

1558: FND_MSG_PUB.Count_And_Get
1559: (p_count => x_msg_count,
1560: p_data => x_msg_data );
1561:
1562: When FND_API.G_EXC_UNEXPECTED_ERROR then
1563: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1564: ROLLBACK TO bulk_auto_receive;
1565: FND_MSG_PUB.Count_And_Get
1566: ( p_count => x_msg_count,

Line 1563: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1559: (p_count => x_msg_count,
1560: p_data => x_msg_data );
1561:
1562: When FND_API.G_EXC_UNEXPECTED_ERROR then
1563: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1564: ROLLBACK TO bulk_auto_receive;
1565: FND_MSG_PUB.Count_And_Get
1566: ( p_count => x_msg_count,
1567: p_data => x_msg_data );

Line 1570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1566: ( p_count => x_msg_count,
1567: p_data => x_msg_data );
1568:
1569: When OTHERS then
1570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1571: Rollback To bulk_auto_receive;
1572: If FND_MSG_PUB.Check_Msg_Level
1573: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)then
1574: FND_MSG_PUB.Add_Exc_Msg

Line 1844: p_init_msg_list => fnd_api.g_false,

1840:
1841: l_default_val_num := null;
1842: CSD_RULES_ENGINE_PVT.GET_DEFAULT_VALUE_FROM_RULE(
1843: p_api_version_number => 1.0,
1844: p_init_msg_list => fnd_api.g_false,
1845: p_commit => fnd_api.g_false,
1846: p_validation_level => fnd_api.g_valid_level_full,
1847: p_entity_attribute_type => 'CSD_DEF_ENTITY_ATTR_RO',
1848: p_entity_attribute_code => 'REPAIR_TYPE',

Line 1845: p_commit => fnd_api.g_false,

1841: l_default_val_num := null;
1842: CSD_RULES_ENGINE_PVT.GET_DEFAULT_VALUE_FROM_RULE(
1843: p_api_version_number => 1.0,
1844: p_init_msg_list => fnd_api.g_false,
1845: p_commit => fnd_api.g_false,
1846: p_validation_level => fnd_api.g_valid_level_full,
1847: p_entity_attribute_type => 'CSD_DEF_ENTITY_ATTR_RO',
1848: p_entity_attribute_code => 'REPAIR_TYPE',
1849: p_rule_input_rec => l_rule_input_rec,

Line 1846: p_validation_level => fnd_api.g_valid_level_full,

1842: CSD_RULES_ENGINE_PVT.GET_DEFAULT_VALUE_FROM_RULE(
1843: p_api_version_number => 1.0,
1844: p_init_msg_list => fnd_api.g_false,
1845: p_commit => fnd_api.g_false,
1846: p_validation_level => fnd_api.g_valid_level_full,
1847: p_entity_attribute_type => 'CSD_DEF_ENTITY_ATTR_RO',
1848: p_entity_attribute_code => 'REPAIR_TYPE',
1849: p_rule_input_rec => l_rule_input_rec,
1850: x_default_value => l_default_val_num,

Line 1860: if (l_return_status = fnd_api.g_ret_sts_success) and

1856:
1857: -- if default rule id is null, then no defaulting rule was found, and the
1858: -- profile for regular repair types was returned. We want the bulk receive
1859: -- profile option, so need to check default rule id.
1860: if (l_return_status = fnd_api.g_ret_sts_success) and
1861: (l_default_val_num is not null) and
1862: (l_default_rule_id is not null)
1863: then
1864: l_repair_type_id := l_default_val_num;

Line 1902: p_init_msg_list => fnd_api.g_false,

1898: l_rule_input_rec.repair_line_id := p_repair_line_id;
1899: l_default_val_str := null;
1900: CSD_RULES_ENGINE_PVT.GET_DEFAULT_VALUE_FROM_RULE(
1901: p_api_version_number => 1.0,
1902: p_init_msg_list => fnd_api.g_false,
1903: p_commit => fnd_api.g_false,
1904: p_validation_level => fnd_api.g_valid_level_full,
1905: p_entity_attribute_type => 'CSD_DEF_ENTITY_ATTR_RO',
1906: p_entity_attribute_code => 'RMA_RCV_SUBINV',

Line 1903: p_commit => fnd_api.g_false,

1899: l_default_val_str := null;
1900: CSD_RULES_ENGINE_PVT.GET_DEFAULT_VALUE_FROM_RULE(
1901: p_api_version_number => 1.0,
1902: p_init_msg_list => fnd_api.g_false,
1903: p_commit => fnd_api.g_false,
1904: p_validation_level => fnd_api.g_valid_level_full,
1905: p_entity_attribute_type => 'CSD_DEF_ENTITY_ATTR_RO',
1906: p_entity_attribute_code => 'RMA_RCV_SUBINV',
1907: p_rule_input_rec => l_rule_input_rec,

Line 1904: p_validation_level => fnd_api.g_valid_level_full,

1900: CSD_RULES_ENGINE_PVT.GET_DEFAULT_VALUE_FROM_RULE(
1901: p_api_version_number => 1.0,
1902: p_init_msg_list => fnd_api.g_false,
1903: p_commit => fnd_api.g_false,
1904: p_validation_level => fnd_api.g_valid_level_full,
1905: p_entity_attribute_type => 'CSD_DEF_ENTITY_ATTR_RO',
1906: p_entity_attribute_code => 'RMA_RCV_SUBINV',
1907: p_rule_input_rec => l_rule_input_rec,
1908: x_default_value => l_default_val_str,

Line 1918: if (l_return_status = fnd_api.g_ret_sts_success) and

1914:
1915: -- if default rule id is null, then no defaulting rule was found, and the
1916: -- profile for regular rma subinv was returned. We want the bulk receive
1917: -- profile option, so need to check default rule id.
1918: if (l_return_status = fnd_api.g_ret_sts_success) and
1919: (l_default_val_str is not null) and
1920: (l_default_rule_id is not null)
1921: then
1922: l_rma_subinv := l_default_val_str;