[Home] [Help]
973: PROCEDURE Update_Interface_Tables(p_return_status VARCHAR2)
974: IS
975: l_process_flag NUMBER;
976: BEGIN
977: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
978: l_process_flag := G_PF_SUCCESS;
979: ELSE
980: l_process_flag := G_PF_ERROR;
981: END IF;
3020: FROM mtl_parameters mp1
3021: WHERE mp1.organization_code = eeci.organization_code)
3022: WHERE process_flag = 1
3023: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)
3024: AND (organization_id is null OR organization_id = FND_API.G_MISS_NUM)
3025: AND organization_code is not null
3026: AND exists (SELECT organization_code
3027: FROM mtl_parameters mp2
3028: WHERE mp2.organization_code = eeci.organization_code);
3033: FROM mtl_parameters mp1
3034: WHERE mp1.organization_code = eeri.organization_code)
3035: WHERE process_flag = 1
3036: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)
3037: AND (organization_id is null OR organization_id = FND_API.G_MISS_NUM)
3038: AND organization_code is not null
3039: AND exists (SELECT organization_code
3040: FROM mtl_parameters mp2
3041: WHERE mp2.organization_code = eeri.organization_code);
3046: FROM mtl_parameters mp1
3047: WHERE mp1.organization_code = erii.organization_code)
3048: WHERE process_flag = 1
3049: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)
3050: AND (organization_id is null OR organization_id = FND_API.G_MISS_NUM)
3051: AND organization_code is not null
3052: AND exists (SELECT organization_code
3053: FROM mtl_parameters mp2
3054: WHERE mp2.organization_code = erii.organization_code);
3060: FROM mtl_parameters mp1
3061: WHERE mp1.organization_code = bici.organization_code)
3062: WHERE process_flag = 1
3063: AND upper(transaction_type) in (G_Create, G_Delete, G_Update, G_Cancel)
3064: AND (organization_id is null OR organization_id = FND_API.G_MISS_NUM)
3065: AND interface_entity_type = 'ECO'
3066: AND organization_code is not null
3067: AND exists (SELECT organization_code
3068: FROM mtl_parameters mp2
3075: WHERE mp1.organization_code = bsci.organization_code)
3076: WHERE process_flag = 1
3077: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)
3078: AND interface_entity_type = 'ECO'
3079: AND (organization_id is null OR organization_id = FND_API.G_MISS_NUM)
3080: AND organization_code is not null
3081: AND exists (SELECT organization_code
3082: FROM mtl_parameters mp2
3083: WHERE mp2.organization_code = bsci.organization_code);
3089: WHERE mp1.organization_code = brdi.organization_code)
3090: WHERE process_flag = 1
3091: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)
3092: AND interface_entity_type = 'ECO'
3093: AND (organization_id is null OR organization_id = FND_API.G_MISS_NUM)
3094: AND organization_code is not null
3095: AND exists (SELECT organization_code
3096: FROM mtl_parameters mp2
3097: WHERE mp2.organization_code = brdi.organization_code);
3102: FROM mtl_parameters mp1
3103: WHERE mp1.organization_code = bosi.organization_code)
3104: WHERE process_flag = 1
3105: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)
3106: AND (organization_id is null OR organization_id = FND_API.G_MISS_NUM)
3107: AND organization_code is not null
3108: AND exists (SELECT organization_code
3109: FROM mtl_parameters mp2
3110: WHERE mp2.organization_code = bosi.organization_code);
3115: FROM mtl_parameters mp1
3116: WHERE mp1.organization_code = bori.organization_code)
3117: WHERE process_flag = 1
3118: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)
3119: AND (organization_id is null OR organization_id = FND_API.G_MISS_NUM)
3120: AND organization_code is not null
3121: AND exists (SELECT organization_code
3122: FROM mtl_parameters mp2
3123: WHERE mp2.organization_code = bori.organization_code);
3128: FROM mtl_parameters mp1
3129: WHERE mp1.organization_code = bsori.organization_code)
3130: WHERE process_flag = 1
3131: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)
3132: AND (organization_id is null OR organization_id = FND_API.G_MISS_NUM)
3133: AND organization_code is not null
3134: AND exists (SELECT organization_code
3135: FROM mtl_parameters mp2
3136: WHERE mp2.organization_code = bsori.organization_code);
3146: SET transaction_id = mtl_system_items_interface_s.nextval,
3147: transaction_type = UPPER(transaction_type)
3148: WHERE process_flag = 1
3149: AND (transaction_id is NULL
3150: OR transaction_id = FND_API.G_MISS_NUM)
3151: AND (p_all_org = 1
3152: OR
3153: (p_all_org = 2 AND organization_id = p_org_id));
3154:
3157: SET transaction_id = mtl_system_items_interface_s.nextval,
3158: transaction_type = UPPER(transaction_type)
3159: WHERE process_flag = 1
3160: AND (transaction_id is NULL
3161: OR transaction_id = FND_API.G_MISS_NUM)
3162: AND (p_all_org = 1
3163: OR
3164: (p_all_org = 2 AND organization_id = p_org_id));
3165:
3168: SET transaction_id = mtl_system_items_interface_s.nextval,
3169: transaction_type = UPPER(transaction_type)
3170: WHERE process_flag = 1
3171: AND (transaction_id is NULL
3172: OR transaction_id = FND_API.G_MISS_NUM)
3173: AND (p_all_org = 1
3174: OR
3175: (p_all_org = 2 AND organization_id = p_org_id));
3176:
3179: SET transaction_id = mtl_system_items_interface_s.nextval,
3180: transaction_type = UPPER(transaction_type)
3181: WHERE process_flag = 1
3182: AND (transaction_id is NULL
3183: OR transaction_id = FND_API.G_MISS_NUM)
3184: AND interface_entity_type = 'ECO'
3185: AND (p_all_org = 1
3186: OR
3187: (p_all_org = 2 AND organization_id = p_org_id));
3191: SET transaction_id = mtl_system_items_interface_s.nextval,
3192: transaction_type = UPPER(transaction_type)
3193: WHERE process_flag = 1
3194: AND (transaction_id is NULL
3195: OR transaction_id = FND_API.G_MISS_NUM)
3196: AND interface_entity_type = 'ECO'
3197: AND (p_all_org = 1
3198: OR
3199: (p_all_org = 2 AND organization_id = p_org_id));
3203: SET transaction_id = mtl_system_items_interface_s.nextval,
3204: transaction_type = UPPER(transaction_type)
3205: WHERE process_flag = 1
3206: AND (transaction_id is NULL
3207: OR transaction_id = FND_API.G_MISS_NUM)
3208: AND interface_entity_type = 'ECO'
3209: AND (p_all_org = 1
3210: OR
3211: (p_all_org = 2 AND organization_id = p_org_id));
3215: SET transaction_id = mtl_system_items_interface_s.nextval,
3216: transaction_type = UPPER(transaction_type)
3217: WHERE process_flag = 1
3218: AND (transaction_id is NULL
3219: OR transaction_id = FND_API.G_MISS_NUM)
3220: AND (p_all_org = 1
3221: OR
3222: (p_all_org = 2 AND organization_id = p_org_id));
3223:
3226: SET transaction_id = mtl_system_items_interface_s.nextval,
3227: transaction_type = UPPER(transaction_type)
3228: WHERE process_flag = 1
3229: AND (transaction_id is NULL
3230: OR transaction_id = FND_API.G_MISS_NUM)
3231: AND (p_all_org = 1
3232: OR
3233: (p_all_org = 2 AND organization_id = p_org_id));
3234:
3237: SET transaction_id = mtl_system_items_interface_s.nextval,
3238: transaction_type = UPPER(transaction_type)
3239: WHERE process_flag = 1
3240: AND (transaction_id is NULL
3241: OR transaction_id = FND_API.G_MISS_NUM)
3242: AND (p_all_org = 1
3243: OR
3244: (p_all_org = 2 AND organization_id = p_org_id));
3245:
3340: g_public_eco_rec.pk1_name :=c1rec.pk1_name ;
3341: g_public_eco_rec.pk2_name :=c1rec.pk2_name ;
3342: g_public_eco_rec.pk3_name :=c1rec.pk3_name ;
3343: g_public_eco_rec.plm_or_erp_change :=c1rec.plm_or_erp_change;
3344: if c1rec.plm_or_erp_change is null or c1rec.plm_or_erp_change = FND_API.G_MISS_CHAR then
3345: g_public_eco_rec.plm_or_erp_change :='ERP';
3346: end if;
3347: --11.5.10 Changes
3348: --For PLM change_name is mandatory
3345: g_public_eco_rec.plm_or_erp_change :='ERP';
3346: end if;
3347: --11.5.10 Changes
3348: --For PLM change_name is mandatory
3349: if c1rec.change_name IS NULL or c1rec.change_name = FND_API.G_MISS_CHAR
3350: then
3351: g_public_eco_rec.change_name := c1rec.change_notice;
3352: end if;
3353:
3369: --dbms_output.put_line('No ifce key - Call Public API for ECO record');
3370: Eng_Eco_Pub.Process_Eco (
3371: p_api_version_number => 1.0,
3372: p_init_msg_list => true,
3373: --p_commit => FND_API.G_FALSE,
3374: x_return_status => l_return_status,
3375: x_msg_count => l_msg_count,
3376: --x_msg_data => l_msg_data,
3377: p_ECO_rec => g_public_eco_rec,
3399: stmt_num := 14;
3400:
3401: Eng_Globals.Clear_Request_Table;
3402:
3403: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3404: stmt_num := 15;
3405: COMMIT;
3406: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
3407: stmt_num := 16;
3402:
3403: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3404: stmt_num := 15;
3405: COMMIT;
3406: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
3407: stmt_num := 16;
3408: ROLLBACK;
3409: RETCODE := G_ERROR; /* Bug fix 9214078 */
3410: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3406: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
3407: stmt_num := 16;
3408: ROLLBACK;
3409: RETCODE := G_ERROR; /* Bug fix 9214078 */
3410: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3411: stmt_num := 17;
3412: ROLLBACK;
3413: stmt_num := 18;
3414: RAISE import_error;
3529: stmt_num := 36;
3530: Eng_Globals.Clear_Request_Table;
3531: stmt_num := 37;
3532:
3533: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3534: stmt_num := 38;
3535: COMMIT;
3536: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
3537: stmt_num := 46;
3532:
3533: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3534: stmt_num := 38;
3535: COMMIT;
3536: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
3537: stmt_num := 46;
3538: ROLLBACK;
3539: RETCODE := G_ERROR; /* Bug fix 9214078 */
3540: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3536: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
3537: stmt_num := 46;
3538: ROLLBACK;
3539: RETCODE := G_ERROR; /* Bug fix 9214078 */
3540: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3541: stmt_num := 55;
3542: ROLLBACK;
3543: stmt_num := 56;
3544: RAISE import_error;
3666: --dbms_output.put_line('No ECO Headers - Call Public API with items starting hierarchy');
3667: Eng_Eco_Pub.Process_Eco (
3668: p_api_version_number => 1.0,
3669: p_init_msg_list => true,
3670: --p_commit => FND_API.G_FALSE,
3671: x_return_status => l_return_status,
3672: x_msg_count => l_msg_count,
3673: --x_msg_data => l_msg_data,
3674: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,
3694: stmt_num := 78;
3695: Eng_Globals.Clear_Request_Table;
3696: stmt_num := 79;
3697:
3698: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3699: stmt_num := 80;
3700: COMMIT;
3701: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
3702: stmt_num := 81;
3697:
3698: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3699: stmt_num := 80;
3700: COMMIT;
3701: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
3702: stmt_num := 81;
3703: ROLLBACK;
3704: RETCODE := G_ERROR; /* Bug fix 9214078 */
3705: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3701: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
3702: stmt_num := 81;
3703: ROLLBACK;
3704: RETCODE := G_ERROR; /* Bug fix 9214078 */
3705: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3706: stmt_num := 82;
3707: ROLLBACK;
3708: stmt_num := 83;
3709: RAISE import_error;
3804: --dbms_output.put_line('No ECO Headers - Call Public API with revs starting hierarchy');
3805: Eng_Eco_Pub.Process_Eco (
3806: p_api_version_number => 1.0,
3807: p_init_msg_list => true,
3808: --p_commit => FND_API.G_FALSE,
3809: x_return_status => l_return_status,
3810: x_msg_count => l_msg_count,
3811: --x_msg_data => l_msg_data,
3812: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,
3834: stmt_num := 116;
3835: Eng_Globals.Clear_Request_Table;
3836: stmt_num := 117;
3837:
3838: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3839: stmt_num := 118;
3840: COMMIT;
3841: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
3842: stmt_num := 119;
3837:
3838: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3839: stmt_num := 118;
3840: COMMIT;
3841: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
3842: stmt_num := 119;
3843: ROLLBACK;
3844: RETCODE := G_ERROR; /* Bug fix 9214078 */
3845: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3841: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
3842: stmt_num := 119;
3843: ROLLBACK;
3844: RETCODE := G_ERROR; /* Bug fix 9214078 */
3845: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3846: stmt_num := 120;
3847: ROLLBACK;
3848: stmt_num := 121;
3849: RAISE import_error;
3939: --dbms_output.put_line('No ECO Headers - Call Public API with comps starting hierarchy');
3940: Eng_Eco_Pub.Process_Eco (
3941: p_api_version_number => 1.0,
3942: p_init_msg_list => true,
3943: --p_commit => FND_API.G_FALSE,
3944: x_return_status => l_return_status,
3945: x_msg_count => l_msg_count,
3946: --x_msg_data => l_msg_data,
3947: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,
3969: stmt_num := 152;
3970: Eng_Globals.Clear_Request_Table;
3971: stmt_num := 153;
3972:
3973: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3974: stmt_num := 154;
3975: COMMIT;
3976: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
3977: stmt_num := 155;
3972:
3973: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3974: stmt_num := 154;
3975: COMMIT;
3976: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
3977: stmt_num := 155;
3978: ROLLBACK;
3979: RETCODE := G_ERROR; /* Bug fix 9214078 */
3980: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3976: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
3977: stmt_num := 155;
3978: ROLLBACK;
3979: RETCODE := G_ERROR; /* Bug fix 9214078 */
3980: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3981: stmt_num := 156;
3982: ROLLBACK;
3983: stmt_num := 157;
3984: RAISE import_error;
4061: --dbms_output.put_line('No ECO Headers - Call Public API with desgs starting hierarchy');
4062: Eng_Eco_Pub.Process_Eco (
4063: p_api_version_number => 1.0,
4064: p_init_msg_list => true,
4065: --p_commit => FND_API.G_FALSE,
4066: x_return_status => l_return_status,
4067: x_msg_count => l_msg_count,
4068: --x_msg_data => l_msg_data,
4069: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,
4091: stmt_num := 182;
4092: Eng_Globals.Clear_Request_Table;
4093: stmt_num := 183;
4094:
4095: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4096: stmt_num := 184;
4097: COMMIT;
4098: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
4099: stmt_num := 185;
4094:
4095: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4096: stmt_num := 184;
4097: COMMIT;
4098: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
4099: stmt_num := 185;
4100: ROLLBACK;
4101: RETCODE := G_ERROR; /* Bug fix 9214078 */
4102: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4098: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
4099: stmt_num := 185;
4100: ROLLBACK;
4101: RETCODE := G_ERROR; /* Bug fix 9214078 */
4102: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4103: stmt_num := 186;
4104: ROLLBACK;
4105: stmt_num := 187;
4106: RAISE import_error;
4179: --dbms_output.put_line('No ECO Headers - Call Public API with sbcs starting hierarchy');
4180: Eng_Eco_Pub.Process_Eco (
4181: p_api_version_number => 1.0,
4182: p_init_msg_list => true,
4183: --p_commit => FND_API.G_FALSE,
4184: x_return_status => l_return_status,
4185: x_msg_count => l_msg_count,
4186: --x_msg_data => l_msg_data,
4187: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,
4209: stmt_num := 208;
4210: Eng_Globals.Clear_Request_Table;
4211: stmt_num := 209;
4212:
4213: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4214: stmt_num := 210;
4215: COMMIT;
4216: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
4217: stmt_num := 211;
4212:
4213: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4214: stmt_num := 210;
4215: COMMIT;
4216: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
4217: stmt_num := 211;
4218: ROLLBACK;
4219: RETCODE := G_ERROR; /* Bug fix 9214078 */
4220: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4216: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
4217: stmt_num := 211;
4218: ROLLBACK;
4219: RETCODE := G_ERROR; /* Bug fix 9214078 */
4220: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4221: stmt_num := 212;
4222: ROLLBACK;
4223: stmt_num := 213;
4224: RAISE import_error;
4328: Eng_Globals.Clear_Request_Table;
4329: stmt_num := 183;
4330:
4331: stmt_num := 184;
4332: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4333: stmt_num := 185;
4334: COMMIT;
4335: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
4336: stmt_num := 189;
4331: stmt_num := 184;
4332: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4333: stmt_num := 185;
4334: COMMIT;
4335: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
4336: stmt_num := 189;
4337: ROLLBACK;
4338: RETCODE := G_ERROR; /* Bug fix 9214078 */
4339: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4335: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
4336: stmt_num := 189;
4337: ROLLBACK;
4338: RETCODE := G_ERROR; /* Bug fix 9214078 */
4339: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4340: stmt_num := 194;
4341: ROLLBACK;
4342: RAISE import_error;
4343: END IF;
4444: stmt_num := 182;
4445: Eng_Globals.Clear_Request_Table;
4446: stmt_num := 183;
4447:
4448: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4449: stmt_num := 185;
4450: COMMIT;
4451: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
4452: stmt_num := 189;
4447:
4448: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4449: stmt_num := 185;
4450: COMMIT;
4451: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
4452: stmt_num := 189;
4453: ROLLBACK;
4454: RETCODE := G_ERROR; /* Bug fix 9214078 */
4455: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4451: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
4452: stmt_num := 189;
4453: ROLLBACK;
4454: RETCODE := G_ERROR; /* Bug fix 9214078 */
4455: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4456: stmt_num := 194;
4457: ROLLBACK;
4458: RAISE import_error;
4459: END IF;
4562: stmt_num := 182;
4563: Eng_Globals.Clear_Request_Table;
4564:
4565: stmt_num := 184;
4566: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4567: stmt_num := 185;
4568: COMMIT;
4569: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
4570: stmt_num := 189;
4565: stmt_num := 184;
4566: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4567: stmt_num := 185;
4568: COMMIT;
4569: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
4570: stmt_num := 189;
4571: ROLLBACK;
4572: RETCODE := G_ERROR; /* Bug fix 9214078 */
4573: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4569: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
4570: stmt_num := 189;
4571: ROLLBACK;
4572: RETCODE := G_ERROR; /* Bug fix 9214078 */
4573: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4574: stmt_num := 194;
4575: ROLLBACK;
4576: RAISE import_error;
4577: END IF;
4640: --dbms_output.put_line('Call Public API for revision record');
4641: Eng_Eco_Pub.Process_Eco (
4642: p_api_version_number => 1.0,
4643: p_init_msg_list => true,
4644: --p_commit => FND_API.G_FALSE,
4645: x_return_status => l_return_status,
4646: x_msg_count => l_msg_count,
4647: --x_msg_data => l_msg_data,
4648: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,
4668: );
4669:
4670: Eng_Globals.Clear_Request_Table;
4671:
4672: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4673: stmt_num := 230;
4674: COMMIT;
4675: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
4676: stmt_num := 231;
4671:
4672: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4673: stmt_num := 230;
4674: COMMIT;
4675: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
4676: stmt_num := 231;
4677: ROLLBACK;
4678: RETCODE := G_ERROR; /* Bug fix 9214078 */
4679: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4675: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
4676: stmt_num := 231;
4677: ROLLBACK;
4678: RETCODE := G_ERROR; /* Bug fix 9214078 */
4679: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4680: stmt_num := 232;
4681: ROLLBACK;
4682: stmt_num := 233;
4683: RAISE import_error;
4799: stmt_num := 245;
4800: Eng_Eco_Pub.Process_Eco (
4801: p_api_version_number => 1.0,
4802: p_init_msg_list => true,
4803: --p_commit => FND_API.G_FALSE,
4804: x_return_status => l_return_status,
4805: x_msg_count => l_msg_count,
4806: --x_msg_data => l_msg_data,
4807: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,
4829: stmt_num := 245;
4830: Eng_Globals.Clear_Request_Table;
4831: stmt_num := 246;
4832:
4833: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4834: stmt_num := 250;
4835: COMMIT;
4836: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
4837: stmt_num := 251;
4832:
4833: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4834: stmt_num := 250;
4835: COMMIT;
4836: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
4837: stmt_num := 251;
4838: ROLLBACK;
4839: RETCODE := G_ERROR; /* Bug fix 9214078 */
4840: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4836: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
4837: stmt_num := 251;
4838: ROLLBACK;
4839: RETCODE := G_ERROR; /* Bug fix 9214078 */
4840: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4841: stmt_num := 252;
4842: ROLLBACK;
4843: stmt_num := 253;
4844: RAISE import_error;
4901: --dbms_output.put_line('Ifce key exists - Call Public API for item');
4902: Eng_Eco_Pub.Process_Eco (
4903: p_api_version_number => 1.0,
4904: p_init_msg_list => true,
4905: --p_commit => FND_API.G_FALSE,
4906: x_return_status => l_return_status,
4907: x_msg_count => l_msg_count,
4908: --x_msg_data => l_msg_data,
4909: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,
4931: stmt_num := 268;
4932: Eng_Globals.Clear_Request_Table;
4933: stmt_num := 269;
4934:
4935: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4936: stmt_num := 270;
4937: COMMIT;
4938: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
4939: stmt_num := 271;
4934:
4935: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4936: stmt_num := 270;
4937: COMMIT;
4938: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
4939: stmt_num := 271;
4940: ROLLBACK;
4941: RETCODE := G_ERROR; /* Bug fix 9214078 */
4942: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4938: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
4939: stmt_num := 271;
4940: ROLLBACK;
4941: RETCODE := G_ERROR; /* Bug fix 9214078 */
4942: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4943: stmt_num := 272;
4944: ROLLBACK;
4945: stmt_num := 273;
4946: RAISE import_error;
5050: --dbms_output.put_line('No Items - Call Public API with comps starting hierarchy');
5051: Eng_Eco_Pub.Process_Eco (
5052: p_api_version_number => 1.0,
5053: p_init_msg_list => true,
5054: --p_commit => FND_API.G_FALSE,
5055: x_return_status => l_return_status,
5056: x_msg_count => l_msg_count,
5057: --x_msg_data => l_msg_data,
5058: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,
5080: stmt_num := 305;
5081: Eng_Globals.Clear_Request_Table;
5082: stmt_num := 306;
5083:
5084: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5085: stmt_num := 310;
5086: COMMIT;
5087: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
5088: stmt_num := 311;
5083:
5084: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5085: stmt_num := 310;
5086: COMMIT;
5087: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
5088: stmt_num := 311;
5089: ROLLBACK;
5090: RETCODE := G_ERROR; /* Bug fix 9214078 */
5091: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
5087: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
5088: stmt_num := 311;
5089: ROLLBACK;
5090: RETCODE := G_ERROR; /* Bug fix 9214078 */
5091: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
5092: stmt_num := 312;
5093: ROLLBACK;
5094: stmt_num := 313;
5095: RAISE import_error;
5174: --dbms_output.put_line('No Items - Call Public API with desgs starting hierarchy');
5175: Eng_Eco_Pub.Process_Eco (
5176: p_api_version_number => 1.0,
5177: p_init_msg_list => true,
5178: --p_commit => FND_API.G_FALSE,
5179: x_return_status => l_return_status,
5180: x_msg_count => l_msg_count,
5181: --x_msg_data => l_msg_data,
5182: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,
5204: stmt_num := 335;
5205: Eng_Globals.Clear_Request_Table;
5206: stmt_num := 336;
5207:
5208: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5209: stmt_num := 340;
5210: COMMIT;
5211: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
5212: stmt_num := 341;
5207:
5208: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5209: stmt_num := 340;
5210: COMMIT;
5211: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
5212: stmt_num := 341;
5213: ROLLBACK;
5214: RETCODE := G_ERROR; /* Bug fix 9214078 */
5215: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
5211: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
5212: stmt_num := 341;
5213: ROLLBACK;
5214: RETCODE := G_ERROR; /* Bug fix 9214078 */
5215: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
5216: stmt_num := 342;
5217: ROLLBACK;
5218: stmt_num := 343;
5219: RAISE import_error;
5293: --dbms_output.put_line('No Items - Call Public API with sbcs starting hierarchy');
5294: Eng_Eco_Pub.Process_Eco (
5295: p_api_version_number => 1.0,
5296: p_init_msg_list => true,
5297: --p_commit => FND_API.G_FALSE,
5298: x_return_status => l_return_status,
5299: x_msg_count => l_msg_count,
5300: --x_msg_data => l_msg_data,
5301: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,
5323: stmt_num := 361;
5324: Eng_Globals.Clear_Request_Table;
5325: stmt_num := 362;
5326:
5327: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5328: stmt_num := 370;
5329: COMMIT;
5330: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
5331: stmt_num := 371;
5326:
5327: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5328: stmt_num := 370;
5329: COMMIT;
5330: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
5331: stmt_num := 371;
5332: ROLLBACK;
5333: RETCODE := G_ERROR; /* Bug fix 9214078 */
5334: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
5330: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
5331: stmt_num := 371;
5332: ROLLBACK;
5333: RETCODE := G_ERROR; /* Bug fix 9214078 */
5334: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
5335: stmt_num := 372;
5336: ROLLBACK;
5337: stmt_num := 373;
5338: RAISE import_error;
5470: stmt_num := 382.5;
5471: Eng_Eco_Pub.Process_Eco (
5472: p_api_version_number => 1.0,
5473: p_init_msg_list => true,
5474: --p_commit => FND_API.G_FALSE,
5475: x_return_status => l_return_status,
5476: x_msg_count => l_msg_count,
5477: --x_msg_data => l_msg_data,
5478: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,
5500: stmt_num := 383;
5501: Eng_Globals.Clear_Request_Table;
5502: stmt_num := 384;
5503:
5504: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5505: stmt_num := 390;
5506: COMMIT;
5507: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
5508: stmt_num := 391;
5503:
5504: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5505: stmt_num := 390;
5506: COMMIT;
5507: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
5508: stmt_num := 391;
5509: ROLLBACK;
5510: RETCODE := G_ERROR; /* Bug fix 9214078 */
5511: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
5507: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
5508: stmt_num := 391;
5509: ROLLBACK;
5510: RETCODE := G_ERROR; /* Bug fix 9214078 */
5511: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
5512: stmt_num := 392;
5513: ROLLBACK;
5514: stmt_num := 393;
5515: RAISE import_error;
5558: --dbms_output.put_line('Ifce key exists - Call Public API for comp');
5559: Eng_Eco_Pub.Process_Eco (
5560: p_api_version_number => 1.0,
5561: p_init_msg_list => true,
5562: --p_commit => FND_API.G_FALSE,
5563: x_return_status => l_return_status,
5564: x_msg_count => l_msg_count,
5565: --x_msg_data => l_msg_data,
5566: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,
5588: stmt_num := 403;
5589: Eng_Globals.Clear_Request_Table;
5590: stmt_num := 404;
5591:
5592: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5593: stmt_num := 410;
5594: COMMIT;
5595: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
5596: stmt_num := 411;
5591:
5592: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5593: stmt_num := 410;
5594: COMMIT;
5595: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
5596: stmt_num := 411;
5597: ROLLBACK;
5598: RETCODE := G_ERROR; /* Bug fix 9214078 */
5599: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
5595: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
5596: stmt_num := 411;
5597: ROLLBACK;
5598: RETCODE := G_ERROR; /* Bug fix 9214078 */
5599: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
5600: stmt_num := 412;
5601: ROLLBACK;
5602: stmt_num := 413;
5603: RAISE import_error;
5705: --dbms_output.put_line('No Comps - Call Public API with desgs starting hierarchy');
5706: Eng_Eco_Pub.Process_Eco (
5707: p_api_version_number => 1.0,
5708: p_init_msg_list => true,
5709: --p_commit => FND_API.G_FALSE,
5710: x_return_status => l_return_status,
5711: x_msg_count => l_msg_count,
5712: --x_msg_data => l_msg_data,
5713: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,
5735: stmt_num := 435;
5736: Eng_Globals.Clear_Request_Table;
5737: stmt_num := 436;
5738:
5739: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5740: stmt_num := 440;
5741: COMMIT;
5742: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
5743: stmt_num := 441;
5738:
5739: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5740: stmt_num := 440;
5741: COMMIT;
5742: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
5743: stmt_num := 441;
5744: ROLLBACK;
5745: RETCODE := G_ERROR; /* Bug fix 9214078 */
5746: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
5742: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
5743: stmt_num := 441;
5744: ROLLBACK;
5745: RETCODE := G_ERROR; /* Bug fix 9214078 */
5746: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
5747: stmt_num := 442;
5748: ROLLBACK;
5749: stmt_num := 443;
5750: RAISE import_error;
5819: --dbms_output.put_line('No Comps - Call Public API with sbcs starting hierarchy');
5820: Eng_Eco_Pub.Process_Eco (
5821: p_api_version_number => 1.0,
5822: p_init_msg_list => true,
5823: --p_commit => FND_API.G_FALSE,
5824: x_return_status => l_return_status,
5825: x_msg_count => l_msg_count,
5826: --x_msg_data => l_msg_data,
5827: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,
5849: stmt_num := 460;
5850: Eng_Globals.Clear_Request_Table;
5851: stmt_num := 461;
5852:
5853: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5854: stmt_num := 470;
5855: COMMIT;
5856: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
5857: stmt_num := 471;
5852:
5853: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5854: stmt_num := 470;
5855: COMMIT;
5856: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
5857: stmt_num := 471;
5858: ROLLBACK;
5859: RETCODE := G_ERROR; /* Bug fix 9214078 */
5860: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
5856: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
5857: stmt_num := 471;
5858: ROLLBACK;
5859: RETCODE := G_ERROR; /* Bug fix 9214078 */
5860: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
5861: stmt_num := 472;
5862: ROLLBACK;
5863: stmt_num := 473;
5864: RAISE import_error;
5941: --dbms_output.put_line('Call Public API for Reference Designator entity');
5942: Eng_Eco_Pub.Process_Eco (
5943: p_api_version_number => 1.0,
5944: p_init_msg_list => true,
5945: --p_commit => FND_API.G_FALSE,
5946: x_return_status => l_return_status,
5947: x_msg_count => l_msg_count,
5948: --x_msg_data => l_msg_data,
5949: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,
5971: stmt_num := 479;
5972: Eng_Globals.Clear_Request_Table;
5973: stmt_num := 480;
5974:
5975: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5976: stmt_num := 480;
5977: COMMIT;
5978: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
5979: stmt_num := 481;
5974:
5975: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5976: stmt_num := 480;
5977: COMMIT;
5978: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
5979: stmt_num := 481;
5980: ROLLBACK;
5981: RETCODE := G_ERROR; /* Bug fix 9214078 */
5982: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
5978: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
5979: stmt_num := 481;
5980: ROLLBACK;
5981: RETCODE := G_ERROR; /* Bug fix 9214078 */
5982: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
5983: stmt_num := 482;
5984: ROLLBACK;
5985: stmt_num := 483;
5986: RAISE import_error;
6071: --dbms_output.put_line('Call Public API from Substitute Component entity');
6072: Eng_Eco_Pub.Process_Eco (
6073: p_api_version_number => 1.0,
6074: p_init_msg_list => true,
6075: --p_commit => FND_API.G_FALSE,
6076: x_return_status => l_return_status,
6077: x_msg_count => l_msg_count,
6078: --x_msg_data => l_msg_data,
6079: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,
6101: stmt_num := 498;
6102: Eng_Globals.Clear_Request_Table;
6103: stmt_num := 499;
6104:
6105: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
6106: stmt_num := 500;
6107: COMMIT;
6108: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
6109: stmt_num := 501;
6104:
6105: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
6106: stmt_num := 500;
6107: COMMIT;
6108: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
6109: stmt_num := 501;
6110: ROLLBACK;
6111: RETCODE := G_ERROR; /* Bug fix 9214078 */
6112: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
6108: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
6109: stmt_num := 501;
6110: ROLLBACK;
6111: RETCODE := G_ERROR; /* Bug fix 9214078 */
6112: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
6113: stmt_num := 502;
6114: ROLLBACK;
6115: stmt_num := 503;
6116: RAISE import_error;
6510: stmt_num := 245;
6511: Eng_Eco_Pub.Process_Eco (
6512: p_api_version_number => 1.0,
6513: p_init_msg_list => true,
6514: --p_commit => FND_API.G_FALSE,
6515: x_return_status => l_return_status,
6516: x_msg_count => l_msg_count,
6517: --x_msg_data => l_msg_data,
6518: p_ECO_rec => ENG_ECO_PUB.G_MISS_ECO_REC,
6540: stmt_num := 245;
6541: Eng_Globals.Clear_Request_Table;
6542: stmt_num := 246;
6543:
6544: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
6545: stmt_num := 250;
6546: COMMIT;
6547: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
6548: stmt_num := 251;
6543:
6544: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
6545: stmt_num := 250;
6546: COMMIT;
6547: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
6548: stmt_num := 251;
6549: ROLLBACK;
6550: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
6551: stmt_num := 252;
6546: COMMIT;
6547: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
6548: stmt_num := 251;
6549: ROLLBACK;
6550: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
6551: stmt_num := 252;
6552: ROLLBACK;
6553: stmt_num := 253;
6554: RAISE import_error;
6556:
6557: stmt_num := 254;
6558: -- ******************** UPDATE PROCESSED ROWS **************************
6559:
6560: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
6561: l_process_flag := G_PF_SUCCESS;
6562: ELSE
6563: l_process_flag := G_PF_ERROR;
6564: END IF;