[Home] [Help]
969: PROCEDURE Update_Interface_Tables(p_return_status VARCHAR2)
970: IS
971: l_process_flag NUMBER;
972: BEGIN
973: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
974: l_process_flag := G_PF_SUCCESS;
975: ELSE
976: l_process_flag := G_PF_ERROR;
977: END IF;
3014: FROM mtl_parameters mp1
3015: WHERE mp1.organization_code = eeci.organization_code)
3016: WHERE process_flag = 1
3017: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)
3018: AND (organization_id is null OR organization_id = FND_API.G_MISS_NUM)
3019: AND organization_code is not null
3020: AND exists (SELECT organization_code
3021: FROM mtl_parameters mp2
3022: WHERE mp2.organization_code = eeci.organization_code);
3027: FROM mtl_parameters mp1
3028: WHERE mp1.organization_code = eeri.organization_code)
3029: WHERE process_flag = 1
3030: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)
3031: AND (organization_id is null OR organization_id = FND_API.G_MISS_NUM)
3032: AND organization_code is not null
3033: AND exists (SELECT organization_code
3034: FROM mtl_parameters mp2
3035: WHERE mp2.organization_code = eeri.organization_code);
3040: FROM mtl_parameters mp1
3041: WHERE mp1.organization_code = erii.organization_code)
3042: WHERE process_flag = 1
3043: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)
3044: AND (organization_id is null OR organization_id = FND_API.G_MISS_NUM)
3045: AND organization_code is not null
3046: AND exists (SELECT organization_code
3047: FROM mtl_parameters mp2
3048: WHERE mp2.organization_code = erii.organization_code);
3054: FROM mtl_parameters mp1
3055: WHERE mp1.organization_code = bici.organization_code)
3056: WHERE process_flag = 1
3057: AND upper(transaction_type) in (G_Create, G_Delete, G_Update, G_Cancel)
3058: AND (organization_id is null OR organization_id = FND_API.G_MISS_NUM)
3059: AND interface_entity_type = 'ECO'
3060: AND organization_code is not null
3061: AND exists (SELECT organization_code
3062: FROM mtl_parameters mp2
3069: WHERE mp1.organization_code = bsci.organization_code)
3070: WHERE process_flag = 1
3071: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)
3072: AND interface_entity_type = 'ECO'
3073: AND (organization_id is null OR organization_id = FND_API.G_MISS_NUM)
3074: AND organization_code is not null
3075: AND exists (SELECT organization_code
3076: FROM mtl_parameters mp2
3077: WHERE mp2.organization_code = bsci.organization_code);
3083: WHERE mp1.organization_code = brdi.organization_code)
3084: WHERE process_flag = 1
3085: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)
3086: AND interface_entity_type = 'ECO'
3087: AND (organization_id is null OR organization_id = FND_API.G_MISS_NUM)
3088: AND organization_code is not null
3089: AND exists (SELECT organization_code
3090: FROM mtl_parameters mp2
3091: WHERE mp2.organization_code = brdi.organization_code);
3096: FROM mtl_parameters mp1
3097: WHERE mp1.organization_code = bosi.organization_code)
3098: WHERE process_flag = 1
3099: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)
3100: AND (organization_id is null OR organization_id = FND_API.G_MISS_NUM)
3101: AND organization_code is not null
3102: AND exists (SELECT organization_code
3103: FROM mtl_parameters mp2
3104: WHERE mp2.organization_code = bosi.organization_code);
3109: FROM mtl_parameters mp1
3110: WHERE mp1.organization_code = bori.organization_code)
3111: WHERE process_flag = 1
3112: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)
3113: AND (organization_id is null OR organization_id = FND_API.G_MISS_NUM)
3114: AND organization_code is not null
3115: AND exists (SELECT organization_code
3116: FROM mtl_parameters mp2
3117: WHERE mp2.organization_code = bori.organization_code);
3122: FROM mtl_parameters mp1
3123: WHERE mp1.organization_code = bsori.organization_code)
3124: WHERE process_flag = 1
3125: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)
3126: AND (organization_id is null OR organization_id = FND_API.G_MISS_NUM)
3127: AND organization_code is not null
3128: AND exists (SELECT organization_code
3129: FROM mtl_parameters mp2
3130: WHERE mp2.organization_code = bsori.organization_code);
3140: SET transaction_id = mtl_system_items_interface_s.nextval,
3141: transaction_type = UPPER(transaction_type)
3142: WHERE process_flag = 1
3143: AND (transaction_id is NULL
3144: OR transaction_id = FND_API.G_MISS_NUM)
3145: AND (p_all_org = 1
3146: OR
3147: (p_all_org = 2 AND organization_id = p_org_id));
3148:
3151: SET transaction_id = mtl_system_items_interface_s.nextval,
3152: transaction_type = UPPER(transaction_type)
3153: WHERE process_flag = 1
3154: AND (transaction_id is NULL
3155: OR transaction_id = FND_API.G_MISS_NUM)
3156: AND (p_all_org = 1
3157: OR
3158: (p_all_org = 2 AND organization_id = p_org_id));
3159:
3162: SET transaction_id = mtl_system_items_interface_s.nextval,
3163: transaction_type = UPPER(transaction_type)
3164: WHERE process_flag = 1
3165: AND (transaction_id is NULL
3166: OR transaction_id = FND_API.G_MISS_NUM)
3167: AND (p_all_org = 1
3168: OR
3169: (p_all_org = 2 AND organization_id = p_org_id));
3170:
3173: SET transaction_id = mtl_system_items_interface_s.nextval,
3174: transaction_type = UPPER(transaction_type)
3175: WHERE process_flag = 1
3176: AND (transaction_id is NULL
3177: OR transaction_id = FND_API.G_MISS_NUM)
3178: AND interface_entity_type = 'ECO'
3179: AND (p_all_org = 1
3180: OR
3181: (p_all_org = 2 AND organization_id = p_org_id));
3185: SET transaction_id = mtl_system_items_interface_s.nextval,
3186: transaction_type = UPPER(transaction_type)
3187: WHERE process_flag = 1
3188: AND (transaction_id is NULL
3189: OR transaction_id = FND_API.G_MISS_NUM)
3190: AND interface_entity_type = 'ECO'
3191: AND (p_all_org = 1
3192: OR
3193: (p_all_org = 2 AND organization_id = p_org_id));
3197: SET transaction_id = mtl_system_items_interface_s.nextval,
3198: transaction_type = UPPER(transaction_type)
3199: WHERE process_flag = 1
3200: AND (transaction_id is NULL
3201: OR transaction_id = FND_API.G_MISS_NUM)
3202: AND interface_entity_type = 'ECO'
3203: AND (p_all_org = 1
3204: OR
3205: (p_all_org = 2 AND organization_id = p_org_id));
3209: SET transaction_id = mtl_system_items_interface_s.nextval,
3210: transaction_type = UPPER(transaction_type)
3211: WHERE process_flag = 1
3212: AND (transaction_id is NULL
3213: OR transaction_id = FND_API.G_MISS_NUM)
3214: AND (p_all_org = 1
3215: OR
3216: (p_all_org = 2 AND organization_id = p_org_id));
3217:
3220: SET transaction_id = mtl_system_items_interface_s.nextval,
3221: transaction_type = UPPER(transaction_type)
3222: WHERE process_flag = 1
3223: AND (transaction_id is NULL
3224: OR transaction_id = FND_API.G_MISS_NUM)
3225: AND (p_all_org = 1
3226: OR
3227: (p_all_org = 2 AND organization_id = p_org_id));
3228:
3231: SET transaction_id = mtl_system_items_interface_s.nextval,
3232: transaction_type = UPPER(transaction_type)
3233: WHERE process_flag = 1
3234: AND (transaction_id is NULL
3235: OR transaction_id = FND_API.G_MISS_NUM)
3236: AND (p_all_org = 1
3237: OR
3238: (p_all_org = 2 AND organization_id = p_org_id));
3239:
3334: g_public_eco_rec.pk1_name :=c1rec.pk1_name ;
3335: g_public_eco_rec.pk2_name :=c1rec.pk2_name ;
3336: g_public_eco_rec.pk3_name :=c1rec.pk3_name ;
3337: g_public_eco_rec.plm_or_erp_change :=c1rec.plm_or_erp_change;
3338: if c1rec.plm_or_erp_change is null or c1rec.plm_or_erp_change = FND_API.G_MISS_CHAR then
3339: g_public_eco_rec.plm_or_erp_change :='ERP';
3340: end if;
3341: --11.5.10 Changes
3342: --For PLM change_name is mandatory
3339: g_public_eco_rec.plm_or_erp_change :='ERP';
3340: end if;
3341: --11.5.10 Changes
3342: --For PLM change_name is mandatory
3343: if c1rec.change_name IS NULL or c1rec.change_name = FND_API.G_MISS_CHAR
3344: then
3345: g_public_eco_rec.change_name := c1rec.change_notice;
3346: end if;
3347:
3363: --dbms_output.put_line('No ifce key - Call Public API for ECO record');
3364: Eng_Eco_Pub.Process_Eco (
3365: p_api_version_number => 1.0,
3366: p_init_msg_list => true,
3367: --p_commit => FND_API.G_FALSE,
3368: x_return_status => l_return_status,
3369: x_msg_count => l_msg_count,
3370: --x_msg_data => l_msg_data,
3371: p_ECO_rec => g_public_eco_rec,
3393: stmt_num := 14;
3394:
3395: Eng_Globals.Clear_Request_Table;
3396:
3397: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3398: stmt_num := 15;
3399: COMMIT;
3400: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
3401: stmt_num := 16;
3396:
3397: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3398: stmt_num := 15;
3399: COMMIT;
3400: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
3401: stmt_num := 16;
3402: ROLLBACK;
3403: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3404: stmt_num := 17;
3399: COMMIT;
3400: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
3401: stmt_num := 16;
3402: ROLLBACK;
3403: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3404: stmt_num := 17;
3405: ROLLBACK;
3406: stmt_num := 18;
3407: RAISE import_error;
3522: stmt_num := 36;
3523: Eng_Globals.Clear_Request_Table;
3524: stmt_num := 37;
3525:
3526: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3527: stmt_num := 38;
3528: COMMIT;
3529: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
3530: stmt_num := 46;
3525:
3526: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3527: stmt_num := 38;
3528: COMMIT;
3529: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
3530: stmt_num := 46;
3531: ROLLBACK;
3532: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3533: stmt_num := 55;
3528: COMMIT;
3529: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
3530: stmt_num := 46;
3531: ROLLBACK;
3532: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3533: stmt_num := 55;
3534: ROLLBACK;
3535: stmt_num := 56;
3536: RAISE import_error;
3658: --dbms_output.put_line('No ECO Headers - Call Public API with items starting hierarchy');
3659: Eng_Eco_Pub.Process_Eco (
3660: p_api_version_number => 1.0,
3661: p_init_msg_list => true,
3662: --p_commit => FND_API.G_FALSE,
3663: x_return_status => l_return_status,
3664: x_msg_count => l_msg_count,
3665: --x_msg_data => l_msg_data,
3666: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,
3686: stmt_num := 78;
3687: Eng_Globals.Clear_Request_Table;
3688: stmt_num := 79;
3689:
3690: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3691: stmt_num := 80;
3692: COMMIT;
3693: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
3694: stmt_num := 81;
3689:
3690: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3691: stmt_num := 80;
3692: COMMIT;
3693: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
3694: stmt_num := 81;
3695: ROLLBACK;
3696: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3697: stmt_num := 82;
3692: COMMIT;
3693: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
3694: stmt_num := 81;
3695: ROLLBACK;
3696: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3697: stmt_num := 82;
3698: ROLLBACK;
3699: stmt_num := 83;
3700: RAISE import_error;
3795: --dbms_output.put_line('No ECO Headers - Call Public API with revs starting hierarchy');
3796: Eng_Eco_Pub.Process_Eco (
3797: p_api_version_number => 1.0,
3798: p_init_msg_list => true,
3799: --p_commit => FND_API.G_FALSE,
3800: x_return_status => l_return_status,
3801: x_msg_count => l_msg_count,
3802: --x_msg_data => l_msg_data,
3803: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,
3825: stmt_num := 116;
3826: Eng_Globals.Clear_Request_Table;
3827: stmt_num := 117;
3828:
3829: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3830: stmt_num := 118;
3831: COMMIT;
3832: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
3833: stmt_num := 119;
3828:
3829: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3830: stmt_num := 118;
3831: COMMIT;
3832: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
3833: stmt_num := 119;
3834: ROLLBACK;
3835: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3836: stmt_num := 120;
3831: COMMIT;
3832: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
3833: stmt_num := 119;
3834: ROLLBACK;
3835: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3836: stmt_num := 120;
3837: ROLLBACK;
3838: stmt_num := 121;
3839: RAISE import_error;
3929: --dbms_output.put_line('No ECO Headers - Call Public API with comps starting hierarchy');
3930: Eng_Eco_Pub.Process_Eco (
3931: p_api_version_number => 1.0,
3932: p_init_msg_list => true,
3933: --p_commit => FND_API.G_FALSE,
3934: x_return_status => l_return_status,
3935: x_msg_count => l_msg_count,
3936: --x_msg_data => l_msg_data,
3937: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,
3959: stmt_num := 152;
3960: Eng_Globals.Clear_Request_Table;
3961: stmt_num := 153;
3962:
3963: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3964: stmt_num := 154;
3965: COMMIT;
3966: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
3967: stmt_num := 155;
3962:
3963: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3964: stmt_num := 154;
3965: COMMIT;
3966: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
3967: stmt_num := 155;
3968: ROLLBACK;
3969: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3970: stmt_num := 156;
3965: COMMIT;
3966: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
3967: stmt_num := 155;
3968: ROLLBACK;
3969: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3970: stmt_num := 156;
3971: ROLLBACK;
3972: stmt_num := 157;
3973: RAISE import_error;
4050: --dbms_output.put_line('No ECO Headers - Call Public API with desgs starting hierarchy');
4051: Eng_Eco_Pub.Process_Eco (
4052: p_api_version_number => 1.0,
4053: p_init_msg_list => true,
4054: --p_commit => FND_API.G_FALSE,
4055: x_return_status => l_return_status,
4056: x_msg_count => l_msg_count,
4057: --x_msg_data => l_msg_data,
4058: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,
4080: stmt_num := 182;
4081: Eng_Globals.Clear_Request_Table;
4082: stmt_num := 183;
4083:
4084: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4085: stmt_num := 184;
4086: COMMIT;
4087: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
4088: stmt_num := 185;
4083:
4084: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4085: stmt_num := 184;
4086: COMMIT;
4087: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
4088: stmt_num := 185;
4089: ROLLBACK;
4090: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4091: stmt_num := 186;
4086: COMMIT;
4087: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
4088: stmt_num := 185;
4089: ROLLBACK;
4090: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4091: stmt_num := 186;
4092: ROLLBACK;
4093: stmt_num := 187;
4094: RAISE import_error;
4167: --dbms_output.put_line('No ECO Headers - Call Public API with sbcs starting hierarchy');
4168: Eng_Eco_Pub.Process_Eco (
4169: p_api_version_number => 1.0,
4170: p_init_msg_list => true,
4171: --p_commit => FND_API.G_FALSE,
4172: x_return_status => l_return_status,
4173: x_msg_count => l_msg_count,
4174: --x_msg_data => l_msg_data,
4175: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,
4197: stmt_num := 208;
4198: Eng_Globals.Clear_Request_Table;
4199: stmt_num := 209;
4200:
4201: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4202: stmt_num := 210;
4203: COMMIT;
4204: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
4205: stmt_num := 211;
4200:
4201: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4202: stmt_num := 210;
4203: COMMIT;
4204: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
4205: stmt_num := 211;
4206: ROLLBACK;
4207: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4208: stmt_num := 212;
4203: COMMIT;
4204: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
4205: stmt_num := 211;
4206: ROLLBACK;
4207: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4208: stmt_num := 212;
4209: ROLLBACK;
4210: stmt_num := 213;
4211: RAISE import_error;
4315: Eng_Globals.Clear_Request_Table;
4316: stmt_num := 183;
4317:
4318: stmt_num := 184;
4319: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4320: stmt_num := 185;
4321: COMMIT;
4322: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
4323: stmt_num := 189;
4318: stmt_num := 184;
4319: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4320: stmt_num := 185;
4321: COMMIT;
4322: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
4323: stmt_num := 189;
4324: ROLLBACK;
4325: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4326: stmt_num := 194;
4321: COMMIT;
4322: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
4323: stmt_num := 189;
4324: ROLLBACK;
4325: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4326: stmt_num := 194;
4327: ROLLBACK;
4328: RAISE import_error;
4329: END IF;
4430: stmt_num := 182;
4431: Eng_Globals.Clear_Request_Table;
4432: stmt_num := 183;
4433:
4434: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4435: stmt_num := 185;
4436: COMMIT;
4437: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
4438: stmt_num := 189;
4433:
4434: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4435: stmt_num := 185;
4436: COMMIT;
4437: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
4438: stmt_num := 189;
4439: ROLLBACK;
4440: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4441: stmt_num := 194;
4436: COMMIT;
4437: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
4438: stmt_num := 189;
4439: ROLLBACK;
4440: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4441: stmt_num := 194;
4442: ROLLBACK;
4443: RAISE import_error;
4444: END IF;
4547: stmt_num := 182;
4548: Eng_Globals.Clear_Request_Table;
4549:
4550: stmt_num := 184;
4551: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4552: stmt_num := 185;
4553: COMMIT;
4554: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
4555: stmt_num := 189;
4550: stmt_num := 184;
4551: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4552: stmt_num := 185;
4553: COMMIT;
4554: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
4555: stmt_num := 189;
4556: ROLLBACK;
4557: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4558: stmt_num := 194;
4553: COMMIT;
4554: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
4555: stmt_num := 189;
4556: ROLLBACK;
4557: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4558: stmt_num := 194;
4559: ROLLBACK;
4560: RAISE import_error;
4561: END IF;
4624: --dbms_output.put_line('Call Public API for revision record');
4625: Eng_Eco_Pub.Process_Eco (
4626: p_api_version_number => 1.0,
4627: p_init_msg_list => true,
4628: --p_commit => FND_API.G_FALSE,
4629: x_return_status => l_return_status,
4630: x_msg_count => l_msg_count,
4631: --x_msg_data => l_msg_data,
4632: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,
4652: );
4653:
4654: Eng_Globals.Clear_Request_Table;
4655:
4656: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4657: stmt_num := 230;
4658: COMMIT;
4659: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
4660: stmt_num := 231;
4655:
4656: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4657: stmt_num := 230;
4658: COMMIT;
4659: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
4660: stmt_num := 231;
4661: ROLLBACK;
4662: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4663: stmt_num := 232;
4658: COMMIT;
4659: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
4660: stmt_num := 231;
4661: ROLLBACK;
4662: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4663: stmt_num := 232;
4664: ROLLBACK;
4665: stmt_num := 233;
4666: RAISE import_error;
4782: stmt_num := 245;
4783: Eng_Eco_Pub.Process_Eco (
4784: p_api_version_number => 1.0,
4785: p_init_msg_list => true,
4786: --p_commit => FND_API.G_FALSE,
4787: x_return_status => l_return_status,
4788: x_msg_count => l_msg_count,
4789: --x_msg_data => l_msg_data,
4790: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,
4812: stmt_num := 245;
4813: Eng_Globals.Clear_Request_Table;
4814: stmt_num := 246;
4815:
4816: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4817: stmt_num := 250;
4818: COMMIT;
4819: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
4820: stmt_num := 251;
4815:
4816: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4817: stmt_num := 250;
4818: COMMIT;
4819: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
4820: stmt_num := 251;
4821: ROLLBACK;
4822: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4823: stmt_num := 252;
4818: COMMIT;
4819: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
4820: stmt_num := 251;
4821: ROLLBACK;
4822: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4823: stmt_num := 252;
4824: ROLLBACK;
4825: stmt_num := 253;
4826: RAISE import_error;
4883: --dbms_output.put_line('Ifce key exists - Call Public API for item');
4884: Eng_Eco_Pub.Process_Eco (
4885: p_api_version_number => 1.0,
4886: p_init_msg_list => true,
4887: --p_commit => FND_API.G_FALSE,
4888: x_return_status => l_return_status,
4889: x_msg_count => l_msg_count,
4890: --x_msg_data => l_msg_data,
4891: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,
4913: stmt_num := 268;
4914: Eng_Globals.Clear_Request_Table;
4915: stmt_num := 269;
4916:
4917: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4918: stmt_num := 270;
4919: COMMIT;
4920: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
4921: stmt_num := 271;
4916:
4917: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4918: stmt_num := 270;
4919: COMMIT;
4920: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
4921: stmt_num := 271;
4922: ROLLBACK;
4923: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4924: stmt_num := 272;
4919: COMMIT;
4920: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
4921: stmt_num := 271;
4922: ROLLBACK;
4923: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4924: stmt_num := 272;
4925: ROLLBACK;
4926: stmt_num := 273;
4927: RAISE import_error;
5031: --dbms_output.put_line('No Items - Call Public API with comps starting hierarchy');
5032: Eng_Eco_Pub.Process_Eco (
5033: p_api_version_number => 1.0,
5034: p_init_msg_list => true,
5035: --p_commit => FND_API.G_FALSE,
5036: x_return_status => l_return_status,
5037: x_msg_count => l_msg_count,
5038: --x_msg_data => l_msg_data,
5039: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,
5061: stmt_num := 305;
5062: Eng_Globals.Clear_Request_Table;
5063: stmt_num := 306;
5064:
5065: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5066: stmt_num := 310;
5067: COMMIT;
5068: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
5069: stmt_num := 311;
5064:
5065: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5066: stmt_num := 310;
5067: COMMIT;
5068: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
5069: stmt_num := 311;
5070: ROLLBACK;
5071: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
5072: stmt_num := 312;
5067: COMMIT;
5068: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
5069: stmt_num := 311;
5070: ROLLBACK;
5071: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
5072: stmt_num := 312;
5073: ROLLBACK;
5074: stmt_num := 313;
5075: RAISE import_error;
5154: --dbms_output.put_line('No Items - Call Public API with desgs starting hierarchy');
5155: Eng_Eco_Pub.Process_Eco (
5156: p_api_version_number => 1.0,
5157: p_init_msg_list => true,
5158: --p_commit => FND_API.G_FALSE,
5159: x_return_status => l_return_status,
5160: x_msg_count => l_msg_count,
5161: --x_msg_data => l_msg_data,
5162: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,
5184: stmt_num := 335;
5185: Eng_Globals.Clear_Request_Table;
5186: stmt_num := 336;
5187:
5188: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5189: stmt_num := 340;
5190: COMMIT;
5191: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
5192: stmt_num := 341;
5187:
5188: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5189: stmt_num := 340;
5190: COMMIT;
5191: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
5192: stmt_num := 341;
5193: ROLLBACK;
5194: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
5195: stmt_num := 342;
5190: COMMIT;
5191: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
5192: stmt_num := 341;
5193: ROLLBACK;
5194: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
5195: stmt_num := 342;
5196: ROLLBACK;
5197: stmt_num := 343;
5198: RAISE import_error;
5272: --dbms_output.put_line('No Items - Call Public API with sbcs starting hierarchy');
5273: Eng_Eco_Pub.Process_Eco (
5274: p_api_version_number => 1.0,
5275: p_init_msg_list => true,
5276: --p_commit => FND_API.G_FALSE,
5277: x_return_status => l_return_status,
5278: x_msg_count => l_msg_count,
5279: --x_msg_data => l_msg_data,
5280: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,
5302: stmt_num := 361;
5303: Eng_Globals.Clear_Request_Table;
5304: stmt_num := 362;
5305:
5306: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5307: stmt_num := 370;
5308: COMMIT;
5309: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
5310: stmt_num := 371;
5305:
5306: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5307: stmt_num := 370;
5308: COMMIT;
5309: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
5310: stmt_num := 371;
5311: ROLLBACK;
5312: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
5313: stmt_num := 372;
5308: COMMIT;
5309: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
5310: stmt_num := 371;
5311: ROLLBACK;
5312: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
5313: stmt_num := 372;
5314: ROLLBACK;
5315: stmt_num := 373;
5316: RAISE import_error;
5446: stmt_num := 382.5;
5447: Eng_Eco_Pub.Process_Eco (
5448: p_api_version_number => 1.0,
5449: p_init_msg_list => true,
5450: --p_commit => FND_API.G_FALSE,
5451: x_return_status => l_return_status,
5452: x_msg_count => l_msg_count,
5453: --x_msg_data => l_msg_data,
5454: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,
5476: stmt_num := 383;
5477: Eng_Globals.Clear_Request_Table;
5478: stmt_num := 384;
5479:
5480: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5481: stmt_num := 390;
5482: COMMIT;
5483: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
5484: stmt_num := 391;
5479:
5480: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5481: stmt_num := 390;
5482: COMMIT;
5483: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
5484: stmt_num := 391;
5485: ROLLBACK;
5486: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
5487: stmt_num := 392;
5482: COMMIT;
5483: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
5484: stmt_num := 391;
5485: ROLLBACK;
5486: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
5487: stmt_num := 392;
5488: ROLLBACK;
5489: stmt_num := 393;
5490: RAISE import_error;
5533: --dbms_output.put_line('Ifce key exists - Call Public API for comp');
5534: Eng_Eco_Pub.Process_Eco (
5535: p_api_version_number => 1.0,
5536: p_init_msg_list => true,
5537: --p_commit => FND_API.G_FALSE,
5538: x_return_status => l_return_status,
5539: x_msg_count => l_msg_count,
5540: --x_msg_data => l_msg_data,
5541: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,
5563: stmt_num := 403;
5564: Eng_Globals.Clear_Request_Table;
5565: stmt_num := 404;
5566:
5567: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5568: stmt_num := 410;
5569: COMMIT;
5570: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
5571: stmt_num := 411;
5566:
5567: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5568: stmt_num := 410;
5569: COMMIT;
5570: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
5571: stmt_num := 411;
5572: ROLLBACK;
5573: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
5574: stmt_num := 412;
5569: COMMIT;
5570: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
5571: stmt_num := 411;
5572: ROLLBACK;
5573: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
5574: stmt_num := 412;
5575: ROLLBACK;
5576: stmt_num := 413;
5577: RAISE import_error;
5679: --dbms_output.put_line('No Comps - Call Public API with desgs starting hierarchy');
5680: Eng_Eco_Pub.Process_Eco (
5681: p_api_version_number => 1.0,
5682: p_init_msg_list => true,
5683: --p_commit => FND_API.G_FALSE,
5684: x_return_status => l_return_status,
5685: x_msg_count => l_msg_count,
5686: --x_msg_data => l_msg_data,
5687: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,
5709: stmt_num := 435;
5710: Eng_Globals.Clear_Request_Table;
5711: stmt_num := 436;
5712:
5713: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5714: stmt_num := 440;
5715: COMMIT;
5716: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
5717: stmt_num := 441;
5712:
5713: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5714: stmt_num := 440;
5715: COMMIT;
5716: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
5717: stmt_num := 441;
5718: ROLLBACK;
5719: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
5720: stmt_num := 442;
5715: COMMIT;
5716: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
5717: stmt_num := 441;
5718: ROLLBACK;
5719: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
5720: stmt_num := 442;
5721: ROLLBACK;
5722: stmt_num := 443;
5723: RAISE import_error;
5792: --dbms_output.put_line('No Comps - Call Public API with sbcs starting hierarchy');
5793: Eng_Eco_Pub.Process_Eco (
5794: p_api_version_number => 1.0,
5795: p_init_msg_list => true,
5796: --p_commit => FND_API.G_FALSE,
5797: x_return_status => l_return_status,
5798: x_msg_count => l_msg_count,
5799: --x_msg_data => l_msg_data,
5800: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,
5822: stmt_num := 460;
5823: Eng_Globals.Clear_Request_Table;
5824: stmt_num := 461;
5825:
5826: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5827: stmt_num := 470;
5828: COMMIT;
5829: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
5830: stmt_num := 471;
5825:
5826: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5827: stmt_num := 470;
5828: COMMIT;
5829: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
5830: stmt_num := 471;
5831: ROLLBACK;
5832: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
5833: stmt_num := 472;
5828: COMMIT;
5829: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
5830: stmt_num := 471;
5831: ROLLBACK;
5832: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
5833: stmt_num := 472;
5834: ROLLBACK;
5835: stmt_num := 473;
5836: RAISE import_error;
5913: --dbms_output.put_line('Call Public API for Reference Designator entity');
5914: Eng_Eco_Pub.Process_Eco (
5915: p_api_version_number => 1.0,
5916: p_init_msg_list => true,
5917: --p_commit => FND_API.G_FALSE,
5918: x_return_status => l_return_status,
5919: x_msg_count => l_msg_count,
5920: --x_msg_data => l_msg_data,
5921: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,
5943: stmt_num := 479;
5944: Eng_Globals.Clear_Request_Table;
5945: stmt_num := 480;
5946:
5947: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5948: stmt_num := 480;
5949: COMMIT;
5950: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
5951: stmt_num := 481;
5946:
5947: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5948: stmt_num := 480;
5949: COMMIT;
5950: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
5951: stmt_num := 481;
5952: ROLLBACK;
5953: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
5954: stmt_num := 482;
5949: COMMIT;
5950: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
5951: stmt_num := 481;
5952: ROLLBACK;
5953: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
5954: stmt_num := 482;
5955: ROLLBACK;
5956: stmt_num := 483;
5957: RAISE import_error;
6042: --dbms_output.put_line('Call Public API from Substitute Component entity');
6043: Eng_Eco_Pub.Process_Eco (
6044: p_api_version_number => 1.0,
6045: p_init_msg_list => true,
6046: --p_commit => FND_API.G_FALSE,
6047: x_return_status => l_return_status,
6048: x_msg_count => l_msg_count,
6049: --x_msg_data => l_msg_data,
6050: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,
6072: stmt_num := 498;
6073: Eng_Globals.Clear_Request_Table;
6074: stmt_num := 499;
6075:
6076: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
6077: stmt_num := 500;
6078: COMMIT;
6079: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
6080: stmt_num := 501;
6075:
6076: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
6077: stmt_num := 500;
6078: COMMIT;
6079: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
6080: stmt_num := 501;
6081: ROLLBACK;
6082: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
6083: stmt_num := 502;
6078: COMMIT;
6079: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
6080: stmt_num := 501;
6081: ROLLBACK;
6082: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
6083: stmt_num := 502;
6084: ROLLBACK;
6085: stmt_num := 503;
6086: RAISE import_error;
6475: stmt_num := 245;
6476: Eng_Eco_Pub.Process_Eco (
6477: p_api_version_number => 1.0,
6478: p_init_msg_list => true,
6479: --p_commit => FND_API.G_FALSE,
6480: x_return_status => l_return_status,
6481: x_msg_count => l_msg_count,
6482: --x_msg_data => l_msg_data,
6483: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,
6505: stmt_num := 245;
6506: Eng_Globals.Clear_Request_Table;
6507: stmt_num := 246;
6508:
6509: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
6510: stmt_num := 250;
6511: COMMIT;
6512: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
6513: stmt_num := 251;
6508:
6509: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
6510: stmt_num := 250;
6511: COMMIT;
6512: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
6513: stmt_num := 251;
6514: ROLLBACK;
6515: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
6516: stmt_num := 252;
6511: COMMIT;
6512: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
6513: stmt_num := 251;
6514: ROLLBACK;
6515: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
6516: stmt_num := 252;
6517: ROLLBACK;
6518: stmt_num := 253;
6519: RAISE import_error;
6521:
6522: stmt_num := 254;
6523: -- ******************** UPDATE PROCESSED ROWS **************************
6524:
6525: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
6526: l_process_flag := G_PF_SUCCESS;
6527: ELSE
6528: l_process_flag := G_PF_ERROR;
6529: END IF;