[Home] [Help]
405: , 'MAIN'
406:
407: , SQLERRM);
408:
409: RAISE fnd_api.g_exc_unexpected_error;
410:
411:
412:
413: END Get_AppsSchemaName;
453: , 'CALL_FND_INSTALLATION.GET_APP_INFO'
454:
455: , 'IEC');
456:
457: RAISE fnd_api.g_exc_unexpected_error;
458:
459: END IF;
460:
461:
1815: WHEN OTHERS THEN
1816:
1817: Log('Get_ListName', 'MAIN');
1818:
1819: RAISE fnd_api.g_exc_unexpected_error;
1820:
1821: END Get_ListName;
1822:
1823:
1847: WHEN OTHERS THEN
1848:
1849: Log('Get_ScheduleName', 'MAIN');
1850:
1851: RAISE fnd_api.g_exc_unexpected_error;
1852:
1853: END Get_ScheduleName;
1854:
1855:
1879: WHEN OTHERS THEN
1880:
1881: Log('Get_ListName', 'MAIN');
1882:
1883: RAISE fnd_api.g_exc_unexpected_error;
1884:
1885: END Get_SubsetName;
1886:
1887:
1927: , SQLERRM
1928:
1929: );
1930:
1931: RAISE fnd_api.g_exc_unexpected_error;
1932:
1933: END;
1934:
1935:
1973: -- module
1974:
1975: Log('Get_SourceTypeView', 'MAIN');
1976:
1977: RAISE fnd_api.g_exc_unexpected_error;
1978:
1979: END;
1980:
1981:
2408: , SQLERRM
2409:
2410: );
2411:
2412: RAISE fnd_api.g_exc_unexpected_error;
2413:
2414: END;
2415:
2416:
2776: WHEN NO_DATA_FOUND THEN
2777:
2778: Log_TerritoryNotFound('Init_Rules', 'MAP_TERRITORY_CODE_TO_PHONE_COUNTRY_CODE', g_territory_code);
2779:
2780: RAISE fnd_api.g_exc_unexpected_error;
2781:
2782: WHEN TOO_MANY_ROWS THEN
2783:
2784: Log_TerritoryNotUnique('Init_Rules', 'MAP_TERRITORY_CODE_TO_PHONE_COUNTRY_CODE', g_territory_code);
2782: WHEN TOO_MANY_ROWS THEN
2783:
2784: Log_TerritoryNotUnique('Init_Rules', 'MAP_TERRITORY_CODE_TO_PHONE_COUNTRY_CODE', g_territory_code);
2785:
2786: RAISE fnd_api.g_exc_unexpected_error;
2787:
2788: END;
2789:
2790: END IF;
3062:
3063:
3064: EXCEPTION
3065:
3066: WHEN fnd_api.g_exc_error THEN
3067:
3068: RAISE;
3069:
3070: WHEN fnd_api.g_exc_unexpected_error THEN
3066: WHEN fnd_api.g_exc_error THEN
3067:
3068: RAISE;
3069:
3070: WHEN fnd_api.g_exc_unexpected_error THEN
3071:
3072: RAISE;
3073:
3074: WHEN OTHERS THEN
3080: , SQLERRM
3081:
3082: );
3083:
3084: RAISE fnd_api.g_exc_unexpected_error;
3085:
3086:
3087:
3088: END Init_Rules;
3260:
3261:
3262: EXCEPTION
3263:
3264: WHEN fnd_api.g_exc_error THEN
3265:
3266: RAISE;
3267:
3268: WHEN fnd_api.g_exc_unexpected_error THEN
3264: WHEN fnd_api.g_exc_error THEN
3265:
3266: RAISE;
3267:
3268: WHEN fnd_api.g_exc_unexpected_error THEN
3269:
3270: RAISE;
3271:
3272: WHEN OTHERS THEN
3278: , SQLERRM
3279:
3280: );
3281:
3282: RAISE fnd_api.g_exc_unexpected_error;
3283:
3284:
3285:
3286: END Update_ReportCounts;
3330: WHEN OTHERS THEN
3331:
3332: Log('UPDATE_STATUS', 'DO_IEC_STAT_UPD_VALIDATED', SQLERRM);
3333:
3334: RAISE fnd_api.g_exc_unexpected_error;
3335:
3336: END;
3337:
3338:
3372: WHEN OTHERS THEN
3373:
3374: Log('UPDATE_STATUS', 'DO_IEC_STAT_UPD_VALIDATING', SQLERRM);
3375:
3376: RAISE fnd_api.g_exc_unexpected_error;
3377:
3378: END;
3379:
3380:
3406: WHEN OTHERS THEN
3407:
3408: Log('UPDATE_STATUS', 'DO_IEC_STAT_UPD_FAILED_VALIDATION', SQLERRM);
3409:
3410: RAISE fnd_api.g_exc_unexpected_error;
3411:
3412: END;
3413:
3414: ELSE
3444: WHEN OTHERS THEN
3445:
3446: Log_StatusUpdateError('Update_Status', 'DO_MKT_STATUS_UPDATE', Get_ListName(p_list_id));
3447:
3448: RAISE fnd_api.g_exc_unexpected_error;
3449:
3450: END;
3451:
3452:
3454: COMMIT;
3455:
3456: EXCEPTION
3457:
3458: WHEN fnd_api.g_exc_error THEN
3459:
3460: ROLLBACK;
3461:
3462: IF p_status <> 'FAILED_VALIDATION' THEN
3464: RAISE;
3465:
3466: END IF;
3467:
3468: WHEN fnd_api.g_exc_unexpected_error THEN
3469:
3470: ROLLBACK;
3471:
3472: IF p_status <> 'FAILED_VALIDATION' THEN
3482: Log('UPDATE_STATUS', 'MAIN', SQLERRM);
3483:
3484: IF p_status <> 'FAILED_VALIDATION' THEN
3485:
3486: RAISE fnd_api.g_exc_unexpected_error;
3487:
3488: END IF;
3489:
3490:
3513: l_no_of_rows_in_list NUMBER;
3514: l_no_of_rows_active NUMBER;
3515:
3516: BEGIN
3517: l_init_msg_list :=FND_API.G_TRUE;
3518:
3519: IF(G_LISTHEADER_REC_INITIAL = 0 ) THEN
3520:
3521: l_listheader_rec.last_update_date := FND_API.g_miss_date;
3517: l_init_msg_list :=FND_API.G_TRUE;
3518:
3519: IF(G_LISTHEADER_REC_INITIAL = 0 ) THEN
3520:
3521: l_listheader_rec.last_update_date := FND_API.g_miss_date;
3522: l_listheader_rec.last_updated_by := FND_API.g_miss_num;
3523: l_listheader_rec.creation_date := FND_API.g_miss_date;
3524: l_listheader_rec.created_by := FND_API.g_miss_num;
3525: l_listheader_rec.last_update_login := FND_API.g_miss_num;
3518:
3519: IF(G_LISTHEADER_REC_INITIAL = 0 ) THEN
3520:
3521: l_listheader_rec.last_update_date := FND_API.g_miss_date;
3522: l_listheader_rec.last_updated_by := FND_API.g_miss_num;
3523: l_listheader_rec.creation_date := FND_API.g_miss_date;
3524: l_listheader_rec.created_by := FND_API.g_miss_num;
3525: l_listheader_rec.last_update_login := FND_API.g_miss_num;
3526: l_listheader_rec.object_version_number := FND_API.g_miss_num;
3519: IF(G_LISTHEADER_REC_INITIAL = 0 ) THEN
3520:
3521: l_listheader_rec.last_update_date := FND_API.g_miss_date;
3522: l_listheader_rec.last_updated_by := FND_API.g_miss_num;
3523: l_listheader_rec.creation_date := FND_API.g_miss_date;
3524: l_listheader_rec.created_by := FND_API.g_miss_num;
3525: l_listheader_rec.last_update_login := FND_API.g_miss_num;
3526: l_listheader_rec.object_version_number := FND_API.g_miss_num;
3527: l_listheader_rec.request_id := FND_API.g_miss_num;
3520:
3521: l_listheader_rec.last_update_date := FND_API.g_miss_date;
3522: l_listheader_rec.last_updated_by := FND_API.g_miss_num;
3523: l_listheader_rec.creation_date := FND_API.g_miss_date;
3524: l_listheader_rec.created_by := FND_API.g_miss_num;
3525: l_listheader_rec.last_update_login := FND_API.g_miss_num;
3526: l_listheader_rec.object_version_number := FND_API.g_miss_num;
3527: l_listheader_rec.request_id := FND_API.g_miss_num;
3528: l_listheader_rec.program_id := FND_API.g_miss_num;
3521: l_listheader_rec.last_update_date := FND_API.g_miss_date;
3522: l_listheader_rec.last_updated_by := FND_API.g_miss_num;
3523: l_listheader_rec.creation_date := FND_API.g_miss_date;
3524: l_listheader_rec.created_by := FND_API.g_miss_num;
3525: l_listheader_rec.last_update_login := FND_API.g_miss_num;
3526: l_listheader_rec.object_version_number := FND_API.g_miss_num;
3527: l_listheader_rec.request_id := FND_API.g_miss_num;
3528: l_listheader_rec.program_id := FND_API.g_miss_num;
3529: l_listheader_rec.program_application_id := FND_API.g_miss_num;
3522: l_listheader_rec.last_updated_by := FND_API.g_miss_num;
3523: l_listheader_rec.creation_date := FND_API.g_miss_date;
3524: l_listheader_rec.created_by := FND_API.g_miss_num;
3525: l_listheader_rec.last_update_login := FND_API.g_miss_num;
3526: l_listheader_rec.object_version_number := FND_API.g_miss_num;
3527: l_listheader_rec.request_id := FND_API.g_miss_num;
3528: l_listheader_rec.program_id := FND_API.g_miss_num;
3529: l_listheader_rec.program_application_id := FND_API.g_miss_num;
3530: l_listheader_rec.program_update_date := FND_API.g_miss_date;
3523: l_listheader_rec.creation_date := FND_API.g_miss_date;
3524: l_listheader_rec.created_by := FND_API.g_miss_num;
3525: l_listheader_rec.last_update_login := FND_API.g_miss_num;
3526: l_listheader_rec.object_version_number := FND_API.g_miss_num;
3527: l_listheader_rec.request_id := FND_API.g_miss_num;
3528: l_listheader_rec.program_id := FND_API.g_miss_num;
3529: l_listheader_rec.program_application_id := FND_API.g_miss_num;
3530: l_listheader_rec.program_update_date := FND_API.g_miss_date;
3531: l_listheader_rec.view_application_id := FND_API.g_miss_num;
3524: l_listheader_rec.created_by := FND_API.g_miss_num;
3525: l_listheader_rec.last_update_login := FND_API.g_miss_num;
3526: l_listheader_rec.object_version_number := FND_API.g_miss_num;
3527: l_listheader_rec.request_id := FND_API.g_miss_num;
3528: l_listheader_rec.program_id := FND_API.g_miss_num;
3529: l_listheader_rec.program_application_id := FND_API.g_miss_num;
3530: l_listheader_rec.program_update_date := FND_API.g_miss_date;
3531: l_listheader_rec.view_application_id := FND_API.g_miss_num;
3532: l_listheader_rec.list_name := FND_API.g_miss_char;
3525: l_listheader_rec.last_update_login := FND_API.g_miss_num;
3526: l_listheader_rec.object_version_number := FND_API.g_miss_num;
3527: l_listheader_rec.request_id := FND_API.g_miss_num;
3528: l_listheader_rec.program_id := FND_API.g_miss_num;
3529: l_listheader_rec.program_application_id := FND_API.g_miss_num;
3530: l_listheader_rec.program_update_date := FND_API.g_miss_date;
3531: l_listheader_rec.view_application_id := FND_API.g_miss_num;
3532: l_listheader_rec.list_name := FND_API.g_miss_char;
3533: l_listheader_rec.list_used_by_id := FND_API.g_miss_num;
3526: l_listheader_rec.object_version_number := FND_API.g_miss_num;
3527: l_listheader_rec.request_id := FND_API.g_miss_num;
3528: l_listheader_rec.program_id := FND_API.g_miss_num;
3529: l_listheader_rec.program_application_id := FND_API.g_miss_num;
3530: l_listheader_rec.program_update_date := FND_API.g_miss_date;
3531: l_listheader_rec.view_application_id := FND_API.g_miss_num;
3532: l_listheader_rec.list_name := FND_API.g_miss_char;
3533: l_listheader_rec.list_used_by_id := FND_API.g_miss_num;
3534: l_listheader_rec.arc_list_used_by := FND_API.g_miss_char;
3527: l_listheader_rec.request_id := FND_API.g_miss_num;
3528: l_listheader_rec.program_id := FND_API.g_miss_num;
3529: l_listheader_rec.program_application_id := FND_API.g_miss_num;
3530: l_listheader_rec.program_update_date := FND_API.g_miss_date;
3531: l_listheader_rec.view_application_id := FND_API.g_miss_num;
3532: l_listheader_rec.list_name := FND_API.g_miss_char;
3533: l_listheader_rec.list_used_by_id := FND_API.g_miss_num;
3534: l_listheader_rec.arc_list_used_by := FND_API.g_miss_char;
3535: l_listheader_rec.list_type := FND_API.g_miss_char;
3528: l_listheader_rec.program_id := FND_API.g_miss_num;
3529: l_listheader_rec.program_application_id := FND_API.g_miss_num;
3530: l_listheader_rec.program_update_date := FND_API.g_miss_date;
3531: l_listheader_rec.view_application_id := FND_API.g_miss_num;
3532: l_listheader_rec.list_name := FND_API.g_miss_char;
3533: l_listheader_rec.list_used_by_id := FND_API.g_miss_num;
3534: l_listheader_rec.arc_list_used_by := FND_API.g_miss_char;
3535: l_listheader_rec.list_type := FND_API.g_miss_char;
3536: l_listheader_rec.status_code := FND_API.g_miss_char;
3529: l_listheader_rec.program_application_id := FND_API.g_miss_num;
3530: l_listheader_rec.program_update_date := FND_API.g_miss_date;
3531: l_listheader_rec.view_application_id := FND_API.g_miss_num;
3532: l_listheader_rec.list_name := FND_API.g_miss_char;
3533: l_listheader_rec.list_used_by_id := FND_API.g_miss_num;
3534: l_listheader_rec.arc_list_used_by := FND_API.g_miss_char;
3535: l_listheader_rec.list_type := FND_API.g_miss_char;
3536: l_listheader_rec.status_code := FND_API.g_miss_char;
3537: l_listheader_rec.status_date := FND_API.g_miss_date;
3530: l_listheader_rec.program_update_date := FND_API.g_miss_date;
3531: l_listheader_rec.view_application_id := FND_API.g_miss_num;
3532: l_listheader_rec.list_name := FND_API.g_miss_char;
3533: l_listheader_rec.list_used_by_id := FND_API.g_miss_num;
3534: l_listheader_rec.arc_list_used_by := FND_API.g_miss_char;
3535: l_listheader_rec.list_type := FND_API.g_miss_char;
3536: l_listheader_rec.status_code := FND_API.g_miss_char;
3537: l_listheader_rec.status_date := FND_API.g_miss_date;
3538: l_listheader_rec.generation_type := FND_API.g_miss_char;
3531: l_listheader_rec.view_application_id := FND_API.g_miss_num;
3532: l_listheader_rec.list_name := FND_API.g_miss_char;
3533: l_listheader_rec.list_used_by_id := FND_API.g_miss_num;
3534: l_listheader_rec.arc_list_used_by := FND_API.g_miss_char;
3535: l_listheader_rec.list_type := FND_API.g_miss_char;
3536: l_listheader_rec.status_code := FND_API.g_miss_char;
3537: l_listheader_rec.status_date := FND_API.g_miss_date;
3538: l_listheader_rec.generation_type := FND_API.g_miss_char;
3539: l_listheader_rec.repeat_exclude_type := FND_API.g_miss_char;
3532: l_listheader_rec.list_name := FND_API.g_miss_char;
3533: l_listheader_rec.list_used_by_id := FND_API.g_miss_num;
3534: l_listheader_rec.arc_list_used_by := FND_API.g_miss_char;
3535: l_listheader_rec.list_type := FND_API.g_miss_char;
3536: l_listheader_rec.status_code := FND_API.g_miss_char;
3537: l_listheader_rec.status_date := FND_API.g_miss_date;
3538: l_listheader_rec.generation_type := FND_API.g_miss_char;
3539: l_listheader_rec.repeat_exclude_type := FND_API.g_miss_char;
3540: l_listheader_rec.row_selection_type := FND_API.g_miss_char;
3533: l_listheader_rec.list_used_by_id := FND_API.g_miss_num;
3534: l_listheader_rec.arc_list_used_by := FND_API.g_miss_char;
3535: l_listheader_rec.list_type := FND_API.g_miss_char;
3536: l_listheader_rec.status_code := FND_API.g_miss_char;
3537: l_listheader_rec.status_date := FND_API.g_miss_date;
3538: l_listheader_rec.generation_type := FND_API.g_miss_char;
3539: l_listheader_rec.repeat_exclude_type := FND_API.g_miss_char;
3540: l_listheader_rec.row_selection_type := FND_API.g_miss_char;
3541: l_listheader_rec.owner_user_id := FND_API.g_miss_num;
3534: l_listheader_rec.arc_list_used_by := FND_API.g_miss_char;
3535: l_listheader_rec.list_type := FND_API.g_miss_char;
3536: l_listheader_rec.status_code := FND_API.g_miss_char;
3537: l_listheader_rec.status_date := FND_API.g_miss_date;
3538: l_listheader_rec.generation_type := FND_API.g_miss_char;
3539: l_listheader_rec.repeat_exclude_type := FND_API.g_miss_char;
3540: l_listheader_rec.row_selection_type := FND_API.g_miss_char;
3541: l_listheader_rec.owner_user_id := FND_API.g_miss_num;
3542: l_listheader_rec.access_level := FND_API.g_miss_char;
3535: l_listheader_rec.list_type := FND_API.g_miss_char;
3536: l_listheader_rec.status_code := FND_API.g_miss_char;
3537: l_listheader_rec.status_date := FND_API.g_miss_date;
3538: l_listheader_rec.generation_type := FND_API.g_miss_char;
3539: l_listheader_rec.repeat_exclude_type := FND_API.g_miss_char;
3540: l_listheader_rec.row_selection_type := FND_API.g_miss_char;
3541: l_listheader_rec.owner_user_id := FND_API.g_miss_num;
3542: l_listheader_rec.access_level := FND_API.g_miss_char;
3543: l_listheader_rec.enable_log_flag :=FND_API.g_miss_char;
3536: l_listheader_rec.status_code := FND_API.g_miss_char;
3537: l_listheader_rec.status_date := FND_API.g_miss_date;
3538: l_listheader_rec.generation_type := FND_API.g_miss_char;
3539: l_listheader_rec.repeat_exclude_type := FND_API.g_miss_char;
3540: l_listheader_rec.row_selection_type := FND_API.g_miss_char;
3541: l_listheader_rec.owner_user_id := FND_API.g_miss_num;
3542: l_listheader_rec.access_level := FND_API.g_miss_char;
3543: l_listheader_rec.enable_log_flag :=FND_API.g_miss_char;
3544: l_listheader_rec.enable_word_replacement_flag := FND_API.g_miss_char;
3537: l_listheader_rec.status_date := FND_API.g_miss_date;
3538: l_listheader_rec.generation_type := FND_API.g_miss_char;
3539: l_listheader_rec.repeat_exclude_type := FND_API.g_miss_char;
3540: l_listheader_rec.row_selection_type := FND_API.g_miss_char;
3541: l_listheader_rec.owner_user_id := FND_API.g_miss_num;
3542: l_listheader_rec.access_level := FND_API.g_miss_char;
3543: l_listheader_rec.enable_log_flag :=FND_API.g_miss_char;
3544: l_listheader_rec.enable_word_replacement_flag := FND_API.g_miss_char;
3545: l_listheader_rec.enable_parallel_dml_flag := FND_API.g_miss_char;
3538: l_listheader_rec.generation_type := FND_API.g_miss_char;
3539: l_listheader_rec.repeat_exclude_type := FND_API.g_miss_char;
3540: l_listheader_rec.row_selection_type := FND_API.g_miss_char;
3541: l_listheader_rec.owner_user_id := FND_API.g_miss_num;
3542: l_listheader_rec.access_level := FND_API.g_miss_char;
3543: l_listheader_rec.enable_log_flag :=FND_API.g_miss_char;
3544: l_listheader_rec.enable_word_replacement_flag := FND_API.g_miss_char;
3545: l_listheader_rec.enable_parallel_dml_flag := FND_API.g_miss_char;
3546: l_listheader_rec.dedupe_during_generation_flag := FND_API.g_miss_char;
3539: l_listheader_rec.repeat_exclude_type := FND_API.g_miss_char;
3540: l_listheader_rec.row_selection_type := FND_API.g_miss_char;
3541: l_listheader_rec.owner_user_id := FND_API.g_miss_num;
3542: l_listheader_rec.access_level := FND_API.g_miss_char;
3543: l_listheader_rec.enable_log_flag :=FND_API.g_miss_char;
3544: l_listheader_rec.enable_word_replacement_flag := FND_API.g_miss_char;
3545: l_listheader_rec.enable_parallel_dml_flag := FND_API.g_miss_char;
3546: l_listheader_rec.dedupe_during_generation_flag := FND_API.g_miss_char;
3547: l_listheader_rec.generate_control_group_flag := FND_API.g_miss_char;
3540: l_listheader_rec.row_selection_type := FND_API.g_miss_char;
3541: l_listheader_rec.owner_user_id := FND_API.g_miss_num;
3542: l_listheader_rec.access_level := FND_API.g_miss_char;
3543: l_listheader_rec.enable_log_flag :=FND_API.g_miss_char;
3544: l_listheader_rec.enable_word_replacement_flag := FND_API.g_miss_char;
3545: l_listheader_rec.enable_parallel_dml_flag := FND_API.g_miss_char;
3546: l_listheader_rec.dedupe_during_generation_flag := FND_API.g_miss_char;
3547: l_listheader_rec.generate_control_group_flag := FND_API.g_miss_char;
3548: l_listheader_rec.last_generation_success_flag := FND_API.g_miss_char;
3541: l_listheader_rec.owner_user_id := FND_API.g_miss_num;
3542: l_listheader_rec.access_level := FND_API.g_miss_char;
3543: l_listheader_rec.enable_log_flag :=FND_API.g_miss_char;
3544: l_listheader_rec.enable_word_replacement_flag := FND_API.g_miss_char;
3545: l_listheader_rec.enable_parallel_dml_flag := FND_API.g_miss_char;
3546: l_listheader_rec.dedupe_during_generation_flag := FND_API.g_miss_char;
3547: l_listheader_rec.generate_control_group_flag := FND_API.g_miss_char;
3548: l_listheader_rec.last_generation_success_flag := FND_API.g_miss_char;
3549: l_listheader_rec.forecasted_start_date := FND_API.g_miss_date;
3542: l_listheader_rec.access_level := FND_API.g_miss_char;
3543: l_listheader_rec.enable_log_flag :=FND_API.g_miss_char;
3544: l_listheader_rec.enable_word_replacement_flag := FND_API.g_miss_char;
3545: l_listheader_rec.enable_parallel_dml_flag := FND_API.g_miss_char;
3546: l_listheader_rec.dedupe_during_generation_flag := FND_API.g_miss_char;
3547: l_listheader_rec.generate_control_group_flag := FND_API.g_miss_char;
3548: l_listheader_rec.last_generation_success_flag := FND_API.g_miss_char;
3549: l_listheader_rec.forecasted_start_date := FND_API.g_miss_date;
3550: l_listheader_rec.forecasted_end_date := FND_API.g_miss_date;
3543: l_listheader_rec.enable_log_flag :=FND_API.g_miss_char;
3544: l_listheader_rec.enable_word_replacement_flag := FND_API.g_miss_char;
3545: l_listheader_rec.enable_parallel_dml_flag := FND_API.g_miss_char;
3546: l_listheader_rec.dedupe_during_generation_flag := FND_API.g_miss_char;
3547: l_listheader_rec.generate_control_group_flag := FND_API.g_miss_char;
3548: l_listheader_rec.last_generation_success_flag := FND_API.g_miss_char;
3549: l_listheader_rec.forecasted_start_date := FND_API.g_miss_date;
3550: l_listheader_rec.forecasted_end_date := FND_API.g_miss_date;
3551: l_listheader_rec.actual_end_date := FND_API.g_miss_date;
3544: l_listheader_rec.enable_word_replacement_flag := FND_API.g_miss_char;
3545: l_listheader_rec.enable_parallel_dml_flag := FND_API.g_miss_char;
3546: l_listheader_rec.dedupe_during_generation_flag := FND_API.g_miss_char;
3547: l_listheader_rec.generate_control_group_flag := FND_API.g_miss_char;
3548: l_listheader_rec.last_generation_success_flag := FND_API.g_miss_char;
3549: l_listheader_rec.forecasted_start_date := FND_API.g_miss_date;
3550: l_listheader_rec.forecasted_end_date := FND_API.g_miss_date;
3551: l_listheader_rec.actual_end_date := FND_API.g_miss_date;
3552: l_listheader_rec.sent_out_date := FND_API.g_miss_date;
3545: l_listheader_rec.enable_parallel_dml_flag := FND_API.g_miss_char;
3546: l_listheader_rec.dedupe_during_generation_flag := FND_API.g_miss_char;
3547: l_listheader_rec.generate_control_group_flag := FND_API.g_miss_char;
3548: l_listheader_rec.last_generation_success_flag := FND_API.g_miss_char;
3549: l_listheader_rec.forecasted_start_date := FND_API.g_miss_date;
3550: l_listheader_rec.forecasted_end_date := FND_API.g_miss_date;
3551: l_listheader_rec.actual_end_date := FND_API.g_miss_date;
3552: l_listheader_rec.sent_out_date := FND_API.g_miss_date;
3553: l_listheader_rec.dedupe_start_date := FND_API.g_miss_date;
3546: l_listheader_rec.dedupe_during_generation_flag := FND_API.g_miss_char;
3547: l_listheader_rec.generate_control_group_flag := FND_API.g_miss_char;
3548: l_listheader_rec.last_generation_success_flag := FND_API.g_miss_char;
3549: l_listheader_rec.forecasted_start_date := FND_API.g_miss_date;
3550: l_listheader_rec.forecasted_end_date := FND_API.g_miss_date;
3551: l_listheader_rec.actual_end_date := FND_API.g_miss_date;
3552: l_listheader_rec.sent_out_date := FND_API.g_miss_date;
3553: l_listheader_rec.dedupe_start_date := FND_API.g_miss_date;
3554: l_listheader_rec.last_dedupe_date := FND_API.g_miss_date;
3547: l_listheader_rec.generate_control_group_flag := FND_API.g_miss_char;
3548: l_listheader_rec.last_generation_success_flag := FND_API.g_miss_char;
3549: l_listheader_rec.forecasted_start_date := FND_API.g_miss_date;
3550: l_listheader_rec.forecasted_end_date := FND_API.g_miss_date;
3551: l_listheader_rec.actual_end_date := FND_API.g_miss_date;
3552: l_listheader_rec.sent_out_date := FND_API.g_miss_date;
3553: l_listheader_rec.dedupe_start_date := FND_API.g_miss_date;
3554: l_listheader_rec.last_dedupe_date := FND_API.g_miss_date;
3555: l_listheader_rec.last_deduped_by_user_id := FND_API.g_miss_num;
3548: l_listheader_rec.last_generation_success_flag := FND_API.g_miss_char;
3549: l_listheader_rec.forecasted_start_date := FND_API.g_miss_date;
3550: l_listheader_rec.forecasted_end_date := FND_API.g_miss_date;
3551: l_listheader_rec.actual_end_date := FND_API.g_miss_date;
3552: l_listheader_rec.sent_out_date := FND_API.g_miss_date;
3553: l_listheader_rec.dedupe_start_date := FND_API.g_miss_date;
3554: l_listheader_rec.last_dedupe_date := FND_API.g_miss_date;
3555: l_listheader_rec.last_deduped_by_user_id := FND_API.g_miss_num;
3556: l_listheader_rec.workflow_item_key := FND_API.g_miss_num;
3549: l_listheader_rec.forecasted_start_date := FND_API.g_miss_date;
3550: l_listheader_rec.forecasted_end_date := FND_API.g_miss_date;
3551: l_listheader_rec.actual_end_date := FND_API.g_miss_date;
3552: l_listheader_rec.sent_out_date := FND_API.g_miss_date;
3553: l_listheader_rec.dedupe_start_date := FND_API.g_miss_date;
3554: l_listheader_rec.last_dedupe_date := FND_API.g_miss_date;
3555: l_listheader_rec.last_deduped_by_user_id := FND_API.g_miss_num;
3556: l_listheader_rec.workflow_item_key := FND_API.g_miss_num;
3557: l_listheader_rec.no_of_rows_duplicates := FND_API.g_miss_num;
3550: l_listheader_rec.forecasted_end_date := FND_API.g_miss_date;
3551: l_listheader_rec.actual_end_date := FND_API.g_miss_date;
3552: l_listheader_rec.sent_out_date := FND_API.g_miss_date;
3553: l_listheader_rec.dedupe_start_date := FND_API.g_miss_date;
3554: l_listheader_rec.last_dedupe_date := FND_API.g_miss_date;
3555: l_listheader_rec.last_deduped_by_user_id := FND_API.g_miss_num;
3556: l_listheader_rec.workflow_item_key := FND_API.g_miss_num;
3557: l_listheader_rec.no_of_rows_duplicates := FND_API.g_miss_num;
3558: l_listheader_rec.no_of_rows_min_requested := FND_API.g_miss_num;
3551: l_listheader_rec.actual_end_date := FND_API.g_miss_date;
3552: l_listheader_rec.sent_out_date := FND_API.g_miss_date;
3553: l_listheader_rec.dedupe_start_date := FND_API.g_miss_date;
3554: l_listheader_rec.last_dedupe_date := FND_API.g_miss_date;
3555: l_listheader_rec.last_deduped_by_user_id := FND_API.g_miss_num;
3556: l_listheader_rec.workflow_item_key := FND_API.g_miss_num;
3557: l_listheader_rec.no_of_rows_duplicates := FND_API.g_miss_num;
3558: l_listheader_rec.no_of_rows_min_requested := FND_API.g_miss_num;
3559: l_listheader_rec.no_of_rows_max_requested := FND_API.g_miss_num;
3552: l_listheader_rec.sent_out_date := FND_API.g_miss_date;
3553: l_listheader_rec.dedupe_start_date := FND_API.g_miss_date;
3554: l_listheader_rec.last_dedupe_date := FND_API.g_miss_date;
3555: l_listheader_rec.last_deduped_by_user_id := FND_API.g_miss_num;
3556: l_listheader_rec.workflow_item_key := FND_API.g_miss_num;
3557: l_listheader_rec.no_of_rows_duplicates := FND_API.g_miss_num;
3558: l_listheader_rec.no_of_rows_min_requested := FND_API.g_miss_num;
3559: l_listheader_rec.no_of_rows_max_requested := FND_API.g_miss_num;
3560: l_listheader_rec.no_of_rows_in_list := FND_API.g_miss_num;
3553: l_listheader_rec.dedupe_start_date := FND_API.g_miss_date;
3554: l_listheader_rec.last_dedupe_date := FND_API.g_miss_date;
3555: l_listheader_rec.last_deduped_by_user_id := FND_API.g_miss_num;
3556: l_listheader_rec.workflow_item_key := FND_API.g_miss_num;
3557: l_listheader_rec.no_of_rows_duplicates := FND_API.g_miss_num;
3558: l_listheader_rec.no_of_rows_min_requested := FND_API.g_miss_num;
3559: l_listheader_rec.no_of_rows_max_requested := FND_API.g_miss_num;
3560: l_listheader_rec.no_of_rows_in_list := FND_API.g_miss_num;
3561: l_listheader_rec.no_of_rows_in_ctrl_group := FND_API.g_miss_num;
3554: l_listheader_rec.last_dedupe_date := FND_API.g_miss_date;
3555: l_listheader_rec.last_deduped_by_user_id := FND_API.g_miss_num;
3556: l_listheader_rec.workflow_item_key := FND_API.g_miss_num;
3557: l_listheader_rec.no_of_rows_duplicates := FND_API.g_miss_num;
3558: l_listheader_rec.no_of_rows_min_requested := FND_API.g_miss_num;
3559: l_listheader_rec.no_of_rows_max_requested := FND_API.g_miss_num;
3560: l_listheader_rec.no_of_rows_in_list := FND_API.g_miss_num;
3561: l_listheader_rec.no_of_rows_in_ctrl_group := FND_API.g_miss_num;
3562: l_listheader_rec.no_of_rows_active := FND_API.g_miss_num;
3555: l_listheader_rec.last_deduped_by_user_id := FND_API.g_miss_num;
3556: l_listheader_rec.workflow_item_key := FND_API.g_miss_num;
3557: l_listheader_rec.no_of_rows_duplicates := FND_API.g_miss_num;
3558: l_listheader_rec.no_of_rows_min_requested := FND_API.g_miss_num;
3559: l_listheader_rec.no_of_rows_max_requested := FND_API.g_miss_num;
3560: l_listheader_rec.no_of_rows_in_list := FND_API.g_miss_num;
3561: l_listheader_rec.no_of_rows_in_ctrl_group := FND_API.g_miss_num;
3562: l_listheader_rec.no_of_rows_active := FND_API.g_miss_num;
3563: l_listheader_rec.no_of_rows_inactive := FND_API.g_miss_num;
3556: l_listheader_rec.workflow_item_key := FND_API.g_miss_num;
3557: l_listheader_rec.no_of_rows_duplicates := FND_API.g_miss_num;
3558: l_listheader_rec.no_of_rows_min_requested := FND_API.g_miss_num;
3559: l_listheader_rec.no_of_rows_max_requested := FND_API.g_miss_num;
3560: l_listheader_rec.no_of_rows_in_list := FND_API.g_miss_num;
3561: l_listheader_rec.no_of_rows_in_ctrl_group := FND_API.g_miss_num;
3562: l_listheader_rec.no_of_rows_active := FND_API.g_miss_num;
3563: l_listheader_rec.no_of_rows_inactive := FND_API.g_miss_num;
3564: l_listheader_rec.no_of_rows_manually_entered := FND_API.g_miss_num;
3557: l_listheader_rec.no_of_rows_duplicates := FND_API.g_miss_num;
3558: l_listheader_rec.no_of_rows_min_requested := FND_API.g_miss_num;
3559: l_listheader_rec.no_of_rows_max_requested := FND_API.g_miss_num;
3560: l_listheader_rec.no_of_rows_in_list := FND_API.g_miss_num;
3561: l_listheader_rec.no_of_rows_in_ctrl_group := FND_API.g_miss_num;
3562: l_listheader_rec.no_of_rows_active := FND_API.g_miss_num;
3563: l_listheader_rec.no_of_rows_inactive := FND_API.g_miss_num;
3564: l_listheader_rec.no_of_rows_manually_entered := FND_API.g_miss_num;
3565: l_listheader_rec.no_of_rows_do_not_call := FND_API.g_miss_num;
3558: l_listheader_rec.no_of_rows_min_requested := FND_API.g_miss_num;
3559: l_listheader_rec.no_of_rows_max_requested := FND_API.g_miss_num;
3560: l_listheader_rec.no_of_rows_in_list := FND_API.g_miss_num;
3561: l_listheader_rec.no_of_rows_in_ctrl_group := FND_API.g_miss_num;
3562: l_listheader_rec.no_of_rows_active := FND_API.g_miss_num;
3563: l_listheader_rec.no_of_rows_inactive := FND_API.g_miss_num;
3564: l_listheader_rec.no_of_rows_manually_entered := FND_API.g_miss_num;
3565: l_listheader_rec.no_of_rows_do_not_call := FND_API.g_miss_num;
3566: l_listheader_rec.no_of_rows_do_not_mail :=FND_API.g_miss_num;
3559: l_listheader_rec.no_of_rows_max_requested := FND_API.g_miss_num;
3560: l_listheader_rec.no_of_rows_in_list := FND_API.g_miss_num;
3561: l_listheader_rec.no_of_rows_in_ctrl_group := FND_API.g_miss_num;
3562: l_listheader_rec.no_of_rows_active := FND_API.g_miss_num;
3563: l_listheader_rec.no_of_rows_inactive := FND_API.g_miss_num;
3564: l_listheader_rec.no_of_rows_manually_entered := FND_API.g_miss_num;
3565: l_listheader_rec.no_of_rows_do_not_call := FND_API.g_miss_num;
3566: l_listheader_rec.no_of_rows_do_not_mail :=FND_API.g_miss_num;
3567: l_listheader_rec.no_of_rows_random := FND_API.g_miss_num;
3560: l_listheader_rec.no_of_rows_in_list := FND_API.g_miss_num;
3561: l_listheader_rec.no_of_rows_in_ctrl_group := FND_API.g_miss_num;
3562: l_listheader_rec.no_of_rows_active := FND_API.g_miss_num;
3563: l_listheader_rec.no_of_rows_inactive := FND_API.g_miss_num;
3564: l_listheader_rec.no_of_rows_manually_entered := FND_API.g_miss_num;
3565: l_listheader_rec.no_of_rows_do_not_call := FND_API.g_miss_num;
3566: l_listheader_rec.no_of_rows_do_not_mail :=FND_API.g_miss_num;
3567: l_listheader_rec.no_of_rows_random := FND_API.g_miss_num;
3568: l_listheader_rec.org_id := FND_API.g_miss_num;
3561: l_listheader_rec.no_of_rows_in_ctrl_group := FND_API.g_miss_num;
3562: l_listheader_rec.no_of_rows_active := FND_API.g_miss_num;
3563: l_listheader_rec.no_of_rows_inactive := FND_API.g_miss_num;
3564: l_listheader_rec.no_of_rows_manually_entered := FND_API.g_miss_num;
3565: l_listheader_rec.no_of_rows_do_not_call := FND_API.g_miss_num;
3566: l_listheader_rec.no_of_rows_do_not_mail :=FND_API.g_miss_num;
3567: l_listheader_rec.no_of_rows_random := FND_API.g_miss_num;
3568: l_listheader_rec.org_id := FND_API.g_miss_num;
3569: l_listheader_rec.main_gen_start_time := FND_API.g_miss_date;
3562: l_listheader_rec.no_of_rows_active := FND_API.g_miss_num;
3563: l_listheader_rec.no_of_rows_inactive := FND_API.g_miss_num;
3564: l_listheader_rec.no_of_rows_manually_entered := FND_API.g_miss_num;
3565: l_listheader_rec.no_of_rows_do_not_call := FND_API.g_miss_num;
3566: l_listheader_rec.no_of_rows_do_not_mail :=FND_API.g_miss_num;
3567: l_listheader_rec.no_of_rows_random := FND_API.g_miss_num;
3568: l_listheader_rec.org_id := FND_API.g_miss_num;
3569: l_listheader_rec.main_gen_start_time := FND_API.g_miss_date;
3570: l_listheader_rec.main_gen_end_time := FND_API.g_miss_date;
3563: l_listheader_rec.no_of_rows_inactive := FND_API.g_miss_num;
3564: l_listheader_rec.no_of_rows_manually_entered := FND_API.g_miss_num;
3565: l_listheader_rec.no_of_rows_do_not_call := FND_API.g_miss_num;
3566: l_listheader_rec.no_of_rows_do_not_mail :=FND_API.g_miss_num;
3567: l_listheader_rec.no_of_rows_random := FND_API.g_miss_num;
3568: l_listheader_rec.org_id := FND_API.g_miss_num;
3569: l_listheader_rec.main_gen_start_time := FND_API.g_miss_date;
3570: l_listheader_rec.main_gen_end_time := FND_API.g_miss_date;
3571: l_listheader_rec.main_random_nth_row_selection := FND_API.g_miss_num;
3564: l_listheader_rec.no_of_rows_manually_entered := FND_API.g_miss_num;
3565: l_listheader_rec.no_of_rows_do_not_call := FND_API.g_miss_num;
3566: l_listheader_rec.no_of_rows_do_not_mail :=FND_API.g_miss_num;
3567: l_listheader_rec.no_of_rows_random := FND_API.g_miss_num;
3568: l_listheader_rec.org_id := FND_API.g_miss_num;
3569: l_listheader_rec.main_gen_start_time := FND_API.g_miss_date;
3570: l_listheader_rec.main_gen_end_time := FND_API.g_miss_date;
3571: l_listheader_rec.main_random_nth_row_selection := FND_API.g_miss_num;
3572: l_listheader_rec.main_random_pct_row_selection := FND_API.g_miss_num;
3565: l_listheader_rec.no_of_rows_do_not_call := FND_API.g_miss_num;
3566: l_listheader_rec.no_of_rows_do_not_mail :=FND_API.g_miss_num;
3567: l_listheader_rec.no_of_rows_random := FND_API.g_miss_num;
3568: l_listheader_rec.org_id := FND_API.g_miss_num;
3569: l_listheader_rec.main_gen_start_time := FND_API.g_miss_date;
3570: l_listheader_rec.main_gen_end_time := FND_API.g_miss_date;
3571: l_listheader_rec.main_random_nth_row_selection := FND_API.g_miss_num;
3572: l_listheader_rec.main_random_pct_row_selection := FND_API.g_miss_num;
3573: l_listheader_rec.ctrl_random_nth_row_selection := FND_API.g_miss_num;
3566: l_listheader_rec.no_of_rows_do_not_mail :=FND_API.g_miss_num;
3567: l_listheader_rec.no_of_rows_random := FND_API.g_miss_num;
3568: l_listheader_rec.org_id := FND_API.g_miss_num;
3569: l_listheader_rec.main_gen_start_time := FND_API.g_miss_date;
3570: l_listheader_rec.main_gen_end_time := FND_API.g_miss_date;
3571: l_listheader_rec.main_random_nth_row_selection := FND_API.g_miss_num;
3572: l_listheader_rec.main_random_pct_row_selection := FND_API.g_miss_num;
3573: l_listheader_rec.ctrl_random_nth_row_selection := FND_API.g_miss_num;
3574: l_listheader_rec.ctrl_random_pct_row_selection := FND_API.g_miss_num;
3567: l_listheader_rec.no_of_rows_random := FND_API.g_miss_num;
3568: l_listheader_rec.org_id := FND_API.g_miss_num;
3569: l_listheader_rec.main_gen_start_time := FND_API.g_miss_date;
3570: l_listheader_rec.main_gen_end_time := FND_API.g_miss_date;
3571: l_listheader_rec.main_random_nth_row_selection := FND_API.g_miss_num;
3572: l_listheader_rec.main_random_pct_row_selection := FND_API.g_miss_num;
3573: l_listheader_rec.ctrl_random_nth_row_selection := FND_API.g_miss_num;
3574: l_listheader_rec.ctrl_random_pct_row_selection := FND_API.g_miss_num;
3575: l_listheader_rec.repeat_source_list_header_id := FND_API.g_miss_char;
3568: l_listheader_rec.org_id := FND_API.g_miss_num;
3569: l_listheader_rec.main_gen_start_time := FND_API.g_miss_date;
3570: l_listheader_rec.main_gen_end_time := FND_API.g_miss_date;
3571: l_listheader_rec.main_random_nth_row_selection := FND_API.g_miss_num;
3572: l_listheader_rec.main_random_pct_row_selection := FND_API.g_miss_num;
3573: l_listheader_rec.ctrl_random_nth_row_selection := FND_API.g_miss_num;
3574: l_listheader_rec.ctrl_random_pct_row_selection := FND_API.g_miss_num;
3575: l_listheader_rec.repeat_source_list_header_id := FND_API.g_miss_char;
3576: l_listheader_rec.result_text := FND_API.g_miss_char;
3569: l_listheader_rec.main_gen_start_time := FND_API.g_miss_date;
3570: l_listheader_rec.main_gen_end_time := FND_API.g_miss_date;
3571: l_listheader_rec.main_random_nth_row_selection := FND_API.g_miss_num;
3572: l_listheader_rec.main_random_pct_row_selection := FND_API.g_miss_num;
3573: l_listheader_rec.ctrl_random_nth_row_selection := FND_API.g_miss_num;
3574: l_listheader_rec.ctrl_random_pct_row_selection := FND_API.g_miss_num;
3575: l_listheader_rec.repeat_source_list_header_id := FND_API.g_miss_char;
3576: l_listheader_rec.result_text := FND_API.g_miss_char;
3577: l_listheader_rec.keywords := FND_API.g_miss_char;
3570: l_listheader_rec.main_gen_end_time := FND_API.g_miss_date;
3571: l_listheader_rec.main_random_nth_row_selection := FND_API.g_miss_num;
3572: l_listheader_rec.main_random_pct_row_selection := FND_API.g_miss_num;
3573: l_listheader_rec.ctrl_random_nth_row_selection := FND_API.g_miss_num;
3574: l_listheader_rec.ctrl_random_pct_row_selection := FND_API.g_miss_num;
3575: l_listheader_rec.repeat_source_list_header_id := FND_API.g_miss_char;
3576: l_listheader_rec.result_text := FND_API.g_miss_char;
3577: l_listheader_rec.keywords := FND_API.g_miss_char;
3578: l_listheader_rec.description := FND_API.g_miss_char;
3571: l_listheader_rec.main_random_nth_row_selection := FND_API.g_miss_num;
3572: l_listheader_rec.main_random_pct_row_selection := FND_API.g_miss_num;
3573: l_listheader_rec.ctrl_random_nth_row_selection := FND_API.g_miss_num;
3574: l_listheader_rec.ctrl_random_pct_row_selection := FND_API.g_miss_num;
3575: l_listheader_rec.repeat_source_list_header_id := FND_API.g_miss_char;
3576: l_listheader_rec.result_text := FND_API.g_miss_char;
3577: l_listheader_rec.keywords := FND_API.g_miss_char;
3578: l_listheader_rec.description := FND_API.g_miss_char;
3579: l_listheader_rec.list_priority := FND_API.g_miss_num;
3572: l_listheader_rec.main_random_pct_row_selection := FND_API.g_miss_num;
3573: l_listheader_rec.ctrl_random_nth_row_selection := FND_API.g_miss_num;
3574: l_listheader_rec.ctrl_random_pct_row_selection := FND_API.g_miss_num;
3575: l_listheader_rec.repeat_source_list_header_id := FND_API.g_miss_char;
3576: l_listheader_rec.result_text := FND_API.g_miss_char;
3577: l_listheader_rec.keywords := FND_API.g_miss_char;
3578: l_listheader_rec.description := FND_API.g_miss_char;
3579: l_listheader_rec.list_priority := FND_API.g_miss_num;
3580: l_listheader_rec.assign_person_id := FND_API.g_miss_num;
3573: l_listheader_rec.ctrl_random_nth_row_selection := FND_API.g_miss_num;
3574: l_listheader_rec.ctrl_random_pct_row_selection := FND_API.g_miss_num;
3575: l_listheader_rec.repeat_source_list_header_id := FND_API.g_miss_char;
3576: l_listheader_rec.result_text := FND_API.g_miss_char;
3577: l_listheader_rec.keywords := FND_API.g_miss_char;
3578: l_listheader_rec.description := FND_API.g_miss_char;
3579: l_listheader_rec.list_priority := FND_API.g_miss_num;
3580: l_listheader_rec.assign_person_id := FND_API.g_miss_num;
3581: l_listheader_rec.list_source := FND_API.g_miss_char;
3574: l_listheader_rec.ctrl_random_pct_row_selection := FND_API.g_miss_num;
3575: l_listheader_rec.repeat_source_list_header_id := FND_API.g_miss_char;
3576: l_listheader_rec.result_text := FND_API.g_miss_char;
3577: l_listheader_rec.keywords := FND_API.g_miss_char;
3578: l_listheader_rec.description := FND_API.g_miss_char;
3579: l_listheader_rec.list_priority := FND_API.g_miss_num;
3580: l_listheader_rec.assign_person_id := FND_API.g_miss_num;
3581: l_listheader_rec.list_source := FND_API.g_miss_char;
3582: l_listheader_rec.list_source_type := FND_API.g_miss_char;
3575: l_listheader_rec.repeat_source_list_header_id := FND_API.g_miss_char;
3576: l_listheader_rec.result_text := FND_API.g_miss_char;
3577: l_listheader_rec.keywords := FND_API.g_miss_char;
3578: l_listheader_rec.description := FND_API.g_miss_char;
3579: l_listheader_rec.list_priority := FND_API.g_miss_num;
3580: l_listheader_rec.assign_person_id := FND_API.g_miss_num;
3581: l_listheader_rec.list_source := FND_API.g_miss_char;
3582: l_listheader_rec.list_source_type := FND_API.g_miss_char;
3583: l_listheader_rec.list_online_flag := FND_API.g_miss_char;
3576: l_listheader_rec.result_text := FND_API.g_miss_char;
3577: l_listheader_rec.keywords := FND_API.g_miss_char;
3578: l_listheader_rec.description := FND_API.g_miss_char;
3579: l_listheader_rec.list_priority := FND_API.g_miss_num;
3580: l_listheader_rec.assign_person_id := FND_API.g_miss_num;
3581: l_listheader_rec.list_source := FND_API.g_miss_char;
3582: l_listheader_rec.list_source_type := FND_API.g_miss_char;
3583: l_listheader_rec.list_online_flag := FND_API.g_miss_char;
3584: l_listheader_rec.random_list_id := FND_API.g_miss_num;
3577: l_listheader_rec.keywords := FND_API.g_miss_char;
3578: l_listheader_rec.description := FND_API.g_miss_char;
3579: l_listheader_rec.list_priority := FND_API.g_miss_num;
3580: l_listheader_rec.assign_person_id := FND_API.g_miss_num;
3581: l_listheader_rec.list_source := FND_API.g_miss_char;
3582: l_listheader_rec.list_source_type := FND_API.g_miss_char;
3583: l_listheader_rec.list_online_flag := FND_API.g_miss_char;
3584: l_listheader_rec.random_list_id := FND_API.g_miss_num;
3585: l_listheader_rec.enabled_flag := FND_API.g_miss_char;
3578: l_listheader_rec.description := FND_API.g_miss_char;
3579: l_listheader_rec.list_priority := FND_API.g_miss_num;
3580: l_listheader_rec.assign_person_id := FND_API.g_miss_num;
3581: l_listheader_rec.list_source := FND_API.g_miss_char;
3582: l_listheader_rec.list_source_type := FND_API.g_miss_char;
3583: l_listheader_rec.list_online_flag := FND_API.g_miss_char;
3584: l_listheader_rec.random_list_id := FND_API.g_miss_num;
3585: l_listheader_rec.enabled_flag := FND_API.g_miss_char;
3586: l_listheader_rec.assigned_to := FND_API.g_miss_num;
3579: l_listheader_rec.list_priority := FND_API.g_miss_num;
3580: l_listheader_rec.assign_person_id := FND_API.g_miss_num;
3581: l_listheader_rec.list_source := FND_API.g_miss_char;
3582: l_listheader_rec.list_source_type := FND_API.g_miss_char;
3583: l_listheader_rec.list_online_flag := FND_API.g_miss_char;
3584: l_listheader_rec.random_list_id := FND_API.g_miss_num;
3585: l_listheader_rec.enabled_flag := FND_API.g_miss_char;
3586: l_listheader_rec.assigned_to := FND_API.g_miss_num;
3587: l_listheader_rec.query_id := FND_API.g_miss_num;
3580: l_listheader_rec.assign_person_id := FND_API.g_miss_num;
3581: l_listheader_rec.list_source := FND_API.g_miss_char;
3582: l_listheader_rec.list_source_type := FND_API.g_miss_char;
3583: l_listheader_rec.list_online_flag := FND_API.g_miss_char;
3584: l_listheader_rec.random_list_id := FND_API.g_miss_num;
3585: l_listheader_rec.enabled_flag := FND_API.g_miss_char;
3586: l_listheader_rec.assigned_to := FND_API.g_miss_num;
3587: l_listheader_rec.query_id := FND_API.g_miss_num;
3588: l_listheader_rec.owner_person_id := FND_API.g_miss_num;
3581: l_listheader_rec.list_source := FND_API.g_miss_char;
3582: l_listheader_rec.list_source_type := FND_API.g_miss_char;
3583: l_listheader_rec.list_online_flag := FND_API.g_miss_char;
3584: l_listheader_rec.random_list_id := FND_API.g_miss_num;
3585: l_listheader_rec.enabled_flag := FND_API.g_miss_char;
3586: l_listheader_rec.assigned_to := FND_API.g_miss_num;
3587: l_listheader_rec.query_id := FND_API.g_miss_num;
3588: l_listheader_rec.owner_person_id := FND_API.g_miss_num;
3589: l_listheader_rec.archived_by := FND_API.g_miss_num;
3582: l_listheader_rec.list_source_type := FND_API.g_miss_char;
3583: l_listheader_rec.list_online_flag := FND_API.g_miss_char;
3584: l_listheader_rec.random_list_id := FND_API.g_miss_num;
3585: l_listheader_rec.enabled_flag := FND_API.g_miss_char;
3586: l_listheader_rec.assigned_to := FND_API.g_miss_num;
3587: l_listheader_rec.query_id := FND_API.g_miss_num;
3588: l_listheader_rec.owner_person_id := FND_API.g_miss_num;
3589: l_listheader_rec.archived_by := FND_API.g_miss_num;
3590: l_listheader_rec.archived_date := FND_API.g_miss_date;
3583: l_listheader_rec.list_online_flag := FND_API.g_miss_char;
3584: l_listheader_rec.random_list_id := FND_API.g_miss_num;
3585: l_listheader_rec.enabled_flag := FND_API.g_miss_char;
3586: l_listheader_rec.assigned_to := FND_API.g_miss_num;
3587: l_listheader_rec.query_id := FND_API.g_miss_num;
3588: l_listheader_rec.owner_person_id := FND_API.g_miss_num;
3589: l_listheader_rec.archived_by := FND_API.g_miss_num;
3590: l_listheader_rec.archived_date := FND_API.g_miss_date;
3591: l_listheader_rec.attribute_category := FND_API.g_miss_char;
3584: l_listheader_rec.random_list_id := FND_API.g_miss_num;
3585: l_listheader_rec.enabled_flag := FND_API.g_miss_char;
3586: l_listheader_rec.assigned_to := FND_API.g_miss_num;
3587: l_listheader_rec.query_id := FND_API.g_miss_num;
3588: l_listheader_rec.owner_person_id := FND_API.g_miss_num;
3589: l_listheader_rec.archived_by := FND_API.g_miss_num;
3590: l_listheader_rec.archived_date := FND_API.g_miss_date;
3591: l_listheader_rec.attribute_category := FND_API.g_miss_char;
3592: l_listheader_rec.attribute1 := FND_API.g_miss_char;
3585: l_listheader_rec.enabled_flag := FND_API.g_miss_char;
3586: l_listheader_rec.assigned_to := FND_API.g_miss_num;
3587: l_listheader_rec.query_id := FND_API.g_miss_num;
3588: l_listheader_rec.owner_person_id := FND_API.g_miss_num;
3589: l_listheader_rec.archived_by := FND_API.g_miss_num;
3590: l_listheader_rec.archived_date := FND_API.g_miss_date;
3591: l_listheader_rec.attribute_category := FND_API.g_miss_char;
3592: l_listheader_rec.attribute1 := FND_API.g_miss_char;
3593: l_listheader_rec.attribute2 := FND_API.g_miss_char;
3586: l_listheader_rec.assigned_to := FND_API.g_miss_num;
3587: l_listheader_rec.query_id := FND_API.g_miss_num;
3588: l_listheader_rec.owner_person_id := FND_API.g_miss_num;
3589: l_listheader_rec.archived_by := FND_API.g_miss_num;
3590: l_listheader_rec.archived_date := FND_API.g_miss_date;
3591: l_listheader_rec.attribute_category := FND_API.g_miss_char;
3592: l_listheader_rec.attribute1 := FND_API.g_miss_char;
3593: l_listheader_rec.attribute2 := FND_API.g_miss_char;
3594: l_listheader_rec.attribute3 := FND_API.g_miss_char;
3587: l_listheader_rec.query_id := FND_API.g_miss_num;
3588: l_listheader_rec.owner_person_id := FND_API.g_miss_num;
3589: l_listheader_rec.archived_by := FND_API.g_miss_num;
3590: l_listheader_rec.archived_date := FND_API.g_miss_date;
3591: l_listheader_rec.attribute_category := FND_API.g_miss_char;
3592: l_listheader_rec.attribute1 := FND_API.g_miss_char;
3593: l_listheader_rec.attribute2 := FND_API.g_miss_char;
3594: l_listheader_rec.attribute3 := FND_API.g_miss_char;
3595: l_listheader_rec.attribute4 := FND_API.g_miss_char;
3588: l_listheader_rec.owner_person_id := FND_API.g_miss_num;
3589: l_listheader_rec.archived_by := FND_API.g_miss_num;
3590: l_listheader_rec.archived_date := FND_API.g_miss_date;
3591: l_listheader_rec.attribute_category := FND_API.g_miss_char;
3592: l_listheader_rec.attribute1 := FND_API.g_miss_char;
3593: l_listheader_rec.attribute2 := FND_API.g_miss_char;
3594: l_listheader_rec.attribute3 := FND_API.g_miss_char;
3595: l_listheader_rec.attribute4 := FND_API.g_miss_char;
3596: l_listheader_rec.attribute5 := FND_API.g_miss_char;
3589: l_listheader_rec.archived_by := FND_API.g_miss_num;
3590: l_listheader_rec.archived_date := FND_API.g_miss_date;
3591: l_listheader_rec.attribute_category := FND_API.g_miss_char;
3592: l_listheader_rec.attribute1 := FND_API.g_miss_char;
3593: l_listheader_rec.attribute2 := FND_API.g_miss_char;
3594: l_listheader_rec.attribute3 := FND_API.g_miss_char;
3595: l_listheader_rec.attribute4 := FND_API.g_miss_char;
3596: l_listheader_rec.attribute5 := FND_API.g_miss_char;
3597: l_listheader_rec.attribute6 := FND_API.g_miss_char;
3590: l_listheader_rec.archived_date := FND_API.g_miss_date;
3591: l_listheader_rec.attribute_category := FND_API.g_miss_char;
3592: l_listheader_rec.attribute1 := FND_API.g_miss_char;
3593: l_listheader_rec.attribute2 := FND_API.g_miss_char;
3594: l_listheader_rec.attribute3 := FND_API.g_miss_char;
3595: l_listheader_rec.attribute4 := FND_API.g_miss_char;
3596: l_listheader_rec.attribute5 := FND_API.g_miss_char;
3597: l_listheader_rec.attribute6 := FND_API.g_miss_char;
3598: l_listheader_rec.attribute7 := FND_API.g_miss_char;
3591: l_listheader_rec.attribute_category := FND_API.g_miss_char;
3592: l_listheader_rec.attribute1 := FND_API.g_miss_char;
3593: l_listheader_rec.attribute2 := FND_API.g_miss_char;
3594: l_listheader_rec.attribute3 := FND_API.g_miss_char;
3595: l_listheader_rec.attribute4 := FND_API.g_miss_char;
3596: l_listheader_rec.attribute5 := FND_API.g_miss_char;
3597: l_listheader_rec.attribute6 := FND_API.g_miss_char;
3598: l_listheader_rec.attribute7 := FND_API.g_miss_char;
3599: l_listheader_rec.attribute8 := FND_API.g_miss_char;
3592: l_listheader_rec.attribute1 := FND_API.g_miss_char;
3593: l_listheader_rec.attribute2 := FND_API.g_miss_char;
3594: l_listheader_rec.attribute3 := FND_API.g_miss_char;
3595: l_listheader_rec.attribute4 := FND_API.g_miss_char;
3596: l_listheader_rec.attribute5 := FND_API.g_miss_char;
3597: l_listheader_rec.attribute6 := FND_API.g_miss_char;
3598: l_listheader_rec.attribute7 := FND_API.g_miss_char;
3599: l_listheader_rec.attribute8 := FND_API.g_miss_char;
3600: l_listheader_rec.attribute9 := FND_API.g_miss_char;
3593: l_listheader_rec.attribute2 := FND_API.g_miss_char;
3594: l_listheader_rec.attribute3 := FND_API.g_miss_char;
3595: l_listheader_rec.attribute4 := FND_API.g_miss_char;
3596: l_listheader_rec.attribute5 := FND_API.g_miss_char;
3597: l_listheader_rec.attribute6 := FND_API.g_miss_char;
3598: l_listheader_rec.attribute7 := FND_API.g_miss_char;
3599: l_listheader_rec.attribute8 := FND_API.g_miss_char;
3600: l_listheader_rec.attribute9 := FND_API.g_miss_char;
3601: l_listheader_rec.attribute10 := FND_API.g_miss_char;
3594: l_listheader_rec.attribute3 := FND_API.g_miss_char;
3595: l_listheader_rec.attribute4 := FND_API.g_miss_char;
3596: l_listheader_rec.attribute5 := FND_API.g_miss_char;
3597: l_listheader_rec.attribute6 := FND_API.g_miss_char;
3598: l_listheader_rec.attribute7 := FND_API.g_miss_char;
3599: l_listheader_rec.attribute8 := FND_API.g_miss_char;
3600: l_listheader_rec.attribute9 := FND_API.g_miss_char;
3601: l_listheader_rec.attribute10 := FND_API.g_miss_char;
3602: l_listheader_rec.attribute11 := FND_API.g_miss_char;
3595: l_listheader_rec.attribute4 := FND_API.g_miss_char;
3596: l_listheader_rec.attribute5 := FND_API.g_miss_char;
3597: l_listheader_rec.attribute6 := FND_API.g_miss_char;
3598: l_listheader_rec.attribute7 := FND_API.g_miss_char;
3599: l_listheader_rec.attribute8 := FND_API.g_miss_char;
3600: l_listheader_rec.attribute9 := FND_API.g_miss_char;
3601: l_listheader_rec.attribute10 := FND_API.g_miss_char;
3602: l_listheader_rec.attribute11 := FND_API.g_miss_char;
3603: l_listheader_rec.attribute12 := FND_API.g_miss_char;
3596: l_listheader_rec.attribute5 := FND_API.g_miss_char;
3597: l_listheader_rec.attribute6 := FND_API.g_miss_char;
3598: l_listheader_rec.attribute7 := FND_API.g_miss_char;
3599: l_listheader_rec.attribute8 := FND_API.g_miss_char;
3600: l_listheader_rec.attribute9 := FND_API.g_miss_char;
3601: l_listheader_rec.attribute10 := FND_API.g_miss_char;
3602: l_listheader_rec.attribute11 := FND_API.g_miss_char;
3603: l_listheader_rec.attribute12 := FND_API.g_miss_char;
3604: l_listheader_rec.attribute13 := FND_API.g_miss_char;
3597: l_listheader_rec.attribute6 := FND_API.g_miss_char;
3598: l_listheader_rec.attribute7 := FND_API.g_miss_char;
3599: l_listheader_rec.attribute8 := FND_API.g_miss_char;
3600: l_listheader_rec.attribute9 := FND_API.g_miss_char;
3601: l_listheader_rec.attribute10 := FND_API.g_miss_char;
3602: l_listheader_rec.attribute11 := FND_API.g_miss_char;
3603: l_listheader_rec.attribute12 := FND_API.g_miss_char;
3604: l_listheader_rec.attribute13 := FND_API.g_miss_char;
3605: l_listheader_rec.attribute14 := FND_API.g_miss_char;
3598: l_listheader_rec.attribute7 := FND_API.g_miss_char;
3599: l_listheader_rec.attribute8 := FND_API.g_miss_char;
3600: l_listheader_rec.attribute9 := FND_API.g_miss_char;
3601: l_listheader_rec.attribute10 := FND_API.g_miss_char;
3602: l_listheader_rec.attribute11 := FND_API.g_miss_char;
3603: l_listheader_rec.attribute12 := FND_API.g_miss_char;
3604: l_listheader_rec.attribute13 := FND_API.g_miss_char;
3605: l_listheader_rec.attribute14 := FND_API.g_miss_char;
3606: l_listheader_rec.attribute15 := FND_API.g_miss_char;
3599: l_listheader_rec.attribute8 := FND_API.g_miss_char;
3600: l_listheader_rec.attribute9 := FND_API.g_miss_char;
3601: l_listheader_rec.attribute10 := FND_API.g_miss_char;
3602: l_listheader_rec.attribute11 := FND_API.g_miss_char;
3603: l_listheader_rec.attribute12 := FND_API.g_miss_char;
3604: l_listheader_rec.attribute13 := FND_API.g_miss_char;
3605: l_listheader_rec.attribute14 := FND_API.g_miss_char;
3606: l_listheader_rec.attribute15 := FND_API.g_miss_char;
3607: l_listheader_rec.timezone_id := FND_API.g_miss_num;
3600: l_listheader_rec.attribute9 := FND_API.g_miss_char;
3601: l_listheader_rec.attribute10 := FND_API.g_miss_char;
3602: l_listheader_rec.attribute11 := FND_API.g_miss_char;
3603: l_listheader_rec.attribute12 := FND_API.g_miss_char;
3604: l_listheader_rec.attribute13 := FND_API.g_miss_char;
3605: l_listheader_rec.attribute14 := FND_API.g_miss_char;
3606: l_listheader_rec.attribute15 := FND_API.g_miss_char;
3607: l_listheader_rec.timezone_id := FND_API.g_miss_num;
3608: l_listheader_rec.user_entered_start_time := FND_API.g_miss_date;
3601: l_listheader_rec.attribute10 := FND_API.g_miss_char;
3602: l_listheader_rec.attribute11 := FND_API.g_miss_char;
3603: l_listheader_rec.attribute12 := FND_API.g_miss_char;
3604: l_listheader_rec.attribute13 := FND_API.g_miss_char;
3605: l_listheader_rec.attribute14 := FND_API.g_miss_char;
3606: l_listheader_rec.attribute15 := FND_API.g_miss_char;
3607: l_listheader_rec.timezone_id := FND_API.g_miss_num;
3608: l_listheader_rec.user_entered_start_time := FND_API.g_miss_date;
3609: l_listheader_rec.user_status_id := FND_API.g_miss_num;
3602: l_listheader_rec.attribute11 := FND_API.g_miss_char;
3603: l_listheader_rec.attribute12 := FND_API.g_miss_char;
3604: l_listheader_rec.attribute13 := FND_API.g_miss_char;
3605: l_listheader_rec.attribute14 := FND_API.g_miss_char;
3606: l_listheader_rec.attribute15 := FND_API.g_miss_char;
3607: l_listheader_rec.timezone_id := FND_API.g_miss_num;
3608: l_listheader_rec.user_entered_start_time := FND_API.g_miss_date;
3609: l_listheader_rec.user_status_id := FND_API.g_miss_num;
3610: l_listheader_rec.quantum := FND_API.g_miss_num;
3603: l_listheader_rec.attribute12 := FND_API.g_miss_char;
3604: l_listheader_rec.attribute13 := FND_API.g_miss_char;
3605: l_listheader_rec.attribute14 := FND_API.g_miss_char;
3606: l_listheader_rec.attribute15 := FND_API.g_miss_char;
3607: l_listheader_rec.timezone_id := FND_API.g_miss_num;
3608: l_listheader_rec.user_entered_start_time := FND_API.g_miss_date;
3609: l_listheader_rec.user_status_id := FND_API.g_miss_num;
3610: l_listheader_rec.quantum := FND_API.g_miss_num;
3611: l_listheader_rec.release_control_alg_id := FND_API.g_miss_num;
3604: l_listheader_rec.attribute13 := FND_API.g_miss_char;
3605: l_listheader_rec.attribute14 := FND_API.g_miss_char;
3606: l_listheader_rec.attribute15 := FND_API.g_miss_char;
3607: l_listheader_rec.timezone_id := FND_API.g_miss_num;
3608: l_listheader_rec.user_entered_start_time := FND_API.g_miss_date;
3609: l_listheader_rec.user_status_id := FND_API.g_miss_num;
3610: l_listheader_rec.quantum := FND_API.g_miss_num;
3611: l_listheader_rec.release_control_alg_id := FND_API.g_miss_num;
3612: l_listheader_rec.dialing_method := FND_API.g_miss_char;
3605: l_listheader_rec.attribute14 := FND_API.g_miss_char;
3606: l_listheader_rec.attribute15 := FND_API.g_miss_char;
3607: l_listheader_rec.timezone_id := FND_API.g_miss_num;
3608: l_listheader_rec.user_entered_start_time := FND_API.g_miss_date;
3609: l_listheader_rec.user_status_id := FND_API.g_miss_num;
3610: l_listheader_rec.quantum := FND_API.g_miss_num;
3611: l_listheader_rec.release_control_alg_id := FND_API.g_miss_num;
3612: l_listheader_rec.dialing_method := FND_API.g_miss_char;
3613: l_listheader_rec.calling_calendar_id := FND_API.g_miss_num;
3606: l_listheader_rec.attribute15 := FND_API.g_miss_char;
3607: l_listheader_rec.timezone_id := FND_API.g_miss_num;
3608: l_listheader_rec.user_entered_start_time := FND_API.g_miss_date;
3609: l_listheader_rec.user_status_id := FND_API.g_miss_num;
3610: l_listheader_rec.quantum := FND_API.g_miss_num;
3611: l_listheader_rec.release_control_alg_id := FND_API.g_miss_num;
3612: l_listheader_rec.dialing_method := FND_API.g_miss_char;
3613: l_listheader_rec.calling_calendar_id := FND_API.g_miss_num;
3614: l_listheader_rec.release_strategy := FND_API.g_miss_char;
3607: l_listheader_rec.timezone_id := FND_API.g_miss_num;
3608: l_listheader_rec.user_entered_start_time := FND_API.g_miss_date;
3609: l_listheader_rec.user_status_id := FND_API.g_miss_num;
3610: l_listheader_rec.quantum := FND_API.g_miss_num;
3611: l_listheader_rec.release_control_alg_id := FND_API.g_miss_num;
3612: l_listheader_rec.dialing_method := FND_API.g_miss_char;
3613: l_listheader_rec.calling_calendar_id := FND_API.g_miss_num;
3614: l_listheader_rec.release_strategy := FND_API.g_miss_char;
3615: l_listheader_rec.custom_setup_id := FND_API.g_miss_num;
3608: l_listheader_rec.user_entered_start_time := FND_API.g_miss_date;
3609: l_listheader_rec.user_status_id := FND_API.g_miss_num;
3610: l_listheader_rec.quantum := FND_API.g_miss_num;
3611: l_listheader_rec.release_control_alg_id := FND_API.g_miss_num;
3612: l_listheader_rec.dialing_method := FND_API.g_miss_char;
3613: l_listheader_rec.calling_calendar_id := FND_API.g_miss_num;
3614: l_listheader_rec.release_strategy := FND_API.g_miss_char;
3615: l_listheader_rec.custom_setup_id := FND_API.g_miss_num;
3616: l_listheader_rec.country := FND_API.g_miss_num;
3609: l_listheader_rec.user_status_id := FND_API.g_miss_num;
3610: l_listheader_rec.quantum := FND_API.g_miss_num;
3611: l_listheader_rec.release_control_alg_id := FND_API.g_miss_num;
3612: l_listheader_rec.dialing_method := FND_API.g_miss_char;
3613: l_listheader_rec.calling_calendar_id := FND_API.g_miss_num;
3614: l_listheader_rec.release_strategy := FND_API.g_miss_char;
3615: l_listheader_rec.custom_setup_id := FND_API.g_miss_num;
3616: l_listheader_rec.country := FND_API.g_miss_num;
3617: l_listheader_rec.callback_priority_flag := FND_API.g_miss_char;
3610: l_listheader_rec.quantum := FND_API.g_miss_num;
3611: l_listheader_rec.release_control_alg_id := FND_API.g_miss_num;
3612: l_listheader_rec.dialing_method := FND_API.g_miss_char;
3613: l_listheader_rec.calling_calendar_id := FND_API.g_miss_num;
3614: l_listheader_rec.release_strategy := FND_API.g_miss_char;
3615: l_listheader_rec.custom_setup_id := FND_API.g_miss_num;
3616: l_listheader_rec.country := FND_API.g_miss_num;
3617: l_listheader_rec.callback_priority_flag := FND_API.g_miss_char;
3618: l_listheader_rec.call_center_ready_flag := FND_API.g_miss_char;
3611: l_listheader_rec.release_control_alg_id := FND_API.g_miss_num;
3612: l_listheader_rec.dialing_method := FND_API.g_miss_char;
3613: l_listheader_rec.calling_calendar_id := FND_API.g_miss_num;
3614: l_listheader_rec.release_strategy := FND_API.g_miss_char;
3615: l_listheader_rec.custom_setup_id := FND_API.g_miss_num;
3616: l_listheader_rec.country := FND_API.g_miss_num;
3617: l_listheader_rec.callback_priority_flag := FND_API.g_miss_char;
3618: l_listheader_rec.call_center_ready_flag := FND_API.g_miss_char;
3619: l_listheader_rec.language := FND_API.g_miss_char;
3612: l_listheader_rec.dialing_method := FND_API.g_miss_char;
3613: l_listheader_rec.calling_calendar_id := FND_API.g_miss_num;
3614: l_listheader_rec.release_strategy := FND_API.g_miss_char;
3615: l_listheader_rec.custom_setup_id := FND_API.g_miss_num;
3616: l_listheader_rec.country := FND_API.g_miss_num;
3617: l_listheader_rec.callback_priority_flag := FND_API.g_miss_char;
3618: l_listheader_rec.call_center_ready_flag := FND_API.g_miss_char;
3619: l_listheader_rec.language := FND_API.g_miss_char;
3620: l_listheader_rec.purge_flag := FND_API.g_miss_char;
3613: l_listheader_rec.calling_calendar_id := FND_API.g_miss_num;
3614: l_listheader_rec.release_strategy := FND_API.g_miss_char;
3615: l_listheader_rec.custom_setup_id := FND_API.g_miss_num;
3616: l_listheader_rec.country := FND_API.g_miss_num;
3617: l_listheader_rec.callback_priority_flag := FND_API.g_miss_char;
3618: l_listheader_rec.call_center_ready_flag := FND_API.g_miss_char;
3619: l_listheader_rec.language := FND_API.g_miss_char;
3620: l_listheader_rec.purge_flag := FND_API.g_miss_char;
3621: l_listheader_rec.public_flag := FND_API.g_miss_char;
3614: l_listheader_rec.release_strategy := FND_API.g_miss_char;
3615: l_listheader_rec.custom_setup_id := FND_API.g_miss_num;
3616: l_listheader_rec.country := FND_API.g_miss_num;
3617: l_listheader_rec.callback_priority_flag := FND_API.g_miss_char;
3618: l_listheader_rec.call_center_ready_flag := FND_API.g_miss_char;
3619: l_listheader_rec.language := FND_API.g_miss_char;
3620: l_listheader_rec.purge_flag := FND_API.g_miss_char;
3621: l_listheader_rec.public_flag := FND_API.g_miss_char;
3622: l_listheader_rec.list_category := FND_API.g_miss_char;
3615: l_listheader_rec.custom_setup_id := FND_API.g_miss_num;
3616: l_listheader_rec.country := FND_API.g_miss_num;
3617: l_listheader_rec.callback_priority_flag := FND_API.g_miss_char;
3618: l_listheader_rec.call_center_ready_flag := FND_API.g_miss_char;
3619: l_listheader_rec.language := FND_API.g_miss_char;
3620: l_listheader_rec.purge_flag := FND_API.g_miss_char;
3621: l_listheader_rec.public_flag := FND_API.g_miss_char;
3622: l_listheader_rec.list_category := FND_API.g_miss_char;
3623: l_listheader_rec.quota := FND_API.g_miss_num;
3616: l_listheader_rec.country := FND_API.g_miss_num;
3617: l_listheader_rec.callback_priority_flag := FND_API.g_miss_char;
3618: l_listheader_rec.call_center_ready_flag := FND_API.g_miss_char;
3619: l_listheader_rec.language := FND_API.g_miss_char;
3620: l_listheader_rec.purge_flag := FND_API.g_miss_char;
3621: l_listheader_rec.public_flag := FND_API.g_miss_char;
3622: l_listheader_rec.list_category := FND_API.g_miss_char;
3623: l_listheader_rec.quota := FND_API.g_miss_num;
3624: l_listheader_rec.quota_reset := FND_API.g_miss_num;
3617: l_listheader_rec.callback_priority_flag := FND_API.g_miss_char;
3618: l_listheader_rec.call_center_ready_flag := FND_API.g_miss_char;
3619: l_listheader_rec.language := FND_API.g_miss_char;
3620: l_listheader_rec.purge_flag := FND_API.g_miss_char;
3621: l_listheader_rec.public_flag := FND_API.g_miss_char;
3622: l_listheader_rec.list_category := FND_API.g_miss_char;
3623: l_listheader_rec.quota := FND_API.g_miss_num;
3624: l_listheader_rec.quota_reset := FND_API.g_miss_num;
3625: l_listheader_rec.recycling_alg_id := FND_API.g_miss_num;
3618: l_listheader_rec.call_center_ready_flag := FND_API.g_miss_char;
3619: l_listheader_rec.language := FND_API.g_miss_char;
3620: l_listheader_rec.purge_flag := FND_API.g_miss_char;
3621: l_listheader_rec.public_flag := FND_API.g_miss_char;
3622: l_listheader_rec.list_category := FND_API.g_miss_char;
3623: l_listheader_rec.quota := FND_API.g_miss_num;
3624: l_listheader_rec.quota_reset := FND_API.g_miss_num;
3625: l_listheader_rec.recycling_alg_id := FND_API.g_miss_num;
3626: l_listheader_rec.source_lang := FND_API.g_miss_char;
3619: l_listheader_rec.language := FND_API.g_miss_char;
3620: l_listheader_rec.purge_flag := FND_API.g_miss_char;
3621: l_listheader_rec.public_flag := FND_API.g_miss_char;
3622: l_listheader_rec.list_category := FND_API.g_miss_char;
3623: l_listheader_rec.quota := FND_API.g_miss_num;
3624: l_listheader_rec.quota_reset := FND_API.g_miss_num;
3625: l_listheader_rec.recycling_alg_id := FND_API.g_miss_num;
3626: l_listheader_rec.source_lang := FND_API.g_miss_char;
3627:
3620: l_listheader_rec.purge_flag := FND_API.g_miss_char;
3621: l_listheader_rec.public_flag := FND_API.g_miss_char;
3622: l_listheader_rec.list_category := FND_API.g_miss_char;
3623: l_listheader_rec.quota := FND_API.g_miss_num;
3624: l_listheader_rec.quota_reset := FND_API.g_miss_num;
3625: l_listheader_rec.recycling_alg_id := FND_API.g_miss_num;
3626: l_listheader_rec.source_lang := FND_API.g_miss_char;
3627:
3628: G_LISTHEADER_REC_INITIAL := 1;
3621: l_listheader_rec.public_flag := FND_API.g_miss_char;
3622: l_listheader_rec.list_category := FND_API.g_miss_char;
3623: l_listheader_rec.quota := FND_API.g_miss_num;
3624: l_listheader_rec.quota_reset := FND_API.g_miss_num;
3625: l_listheader_rec.recycling_alg_id := FND_API.g_miss_num;
3626: l_listheader_rec.source_lang := FND_API.g_miss_char;
3627:
3628: G_LISTHEADER_REC_INITIAL := 1;
3629: END IF;
3622: l_listheader_rec.list_category := FND_API.g_miss_char;
3623: l_listheader_rec.quota := FND_API.g_miss_num;
3624: l_listheader_rec.quota_reset := FND_API.g_miss_num;
3625: l_listheader_rec.recycling_alg_id := FND_API.g_miss_num;
3626: l_listheader_rec.source_lang := FND_API.g_miss_char;
3627:
3628: G_LISTHEADER_REC_INITIAL := 1;
3629: END IF;
3630:
3641: x_msg_count => l_msg_count,
3642: x_msg_data => l_msg_data,
3643: p_listheader_rec => l_listheader_rec);
3644:
3645: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3646: Log_msg('AMS_LISTHEADER_PUB.Update_ListHeader', l_msg_data);
3647: END IF;
3648:
3649: /*
3676: , SQLERRM
3677:
3678: );
3679:
3680: RAISE fnd_api.g_exc_unexpected_error;
3681:
3682:
3683:
3684: END Update_AmsListHeaderCounts;
3736: );
3737:
3738: ROLLBACK;
3739:
3740: RAISE fnd_api.g_exc_unexpected_error;
3741:
3742:
3743:
3744: END Update_MoveEntriesStatusCounts;
4000: );
4001:
4002: ROLLBACK;
4003:
4004: RAISE fnd_api.g_exc_unexpected_error;
4005:
4006:
4007:
4008: END Update_MoveEntriesStatus;
4056: IF l_count = 0 THEN
4057:
4058: Log_ListRtInfoDNE('Update_PurgeStatus', 'CHECK_LIST_RT_INFO', Get_ScheduleName(p_schedule_id));
4059:
4060: RAISE fnd_api.g_exc_error;
4061:
4062: END IF;
4063:
4064:
4086: WHEN OTHERS THEN
4087:
4088: Log_StatusUpdateError('Update_PurgeStatus', 'DO_MKT_STATUS_UPDATE', Get_ListName(p_list_id));
4089:
4090: RAISE fnd_api.g_exc_unexpected_error;
4091:
4092: END;
4093:
4094:
4096: COMMIT;
4097:
4098: EXCEPTION
4099:
4100: WHEN fnd_api.g_exc_error THEN
4101:
4102: ROLLBACK;
4103:
4104: IF p_status <> 'FAILED_VALIDATION' THEN
4106: RAISE;
4107:
4108: END IF;
4109:
4110: WHEN fnd_api.g_exc_unexpected_error THEN
4111:
4112: ROLLBACK;
4113:
4114: IF p_status <> 'FAILED_VALIDATION' THEN
4124: Log('UPDATE_STATUS', 'MAIN', SQLERRM);
4125:
4126: IF p_status <> 'FAILED_VALIDATION' THEN
4127:
4128: RAISE fnd_api.g_exc_unexpected_error;
4129:
4130: END IF;
4131:
4132:
4212: IF SQLCODE = -904 THEN
4213:
4214: Log_MissingSourceTypeColumns(p_list_id, p_source_type_view, Get_SourceType(p_list_id), 'UPDATE_AMS_LIST_ENTRIES', 'UPDATE_LIST_ENTRIES');
4215:
4216: RAISE fnd_api.g_exc_unexpected_error;
4217:
4218: ELSE
4219:
4220: Log( 'Update_AmsListEntries'
4224: , SQLERRM
4225:
4226: );
4227:
4228: RAISE fnd_api.g_exc_unexpected_error;
4229:
4230: END IF;
4231:
4232: END Update_AmsListEntries;
4320: , SQLERRM
4321:
4322: );
4323:
4324: RAISE fnd_api.g_exc_unexpected_error;
4325:
4326: END;
4327:
4328:
4362: , SQLERRM
4363:
4364: );
4365:
4366: RAISE fnd_api.g_exc_unexpected_error;
4367:
4368: END;
4369:
4370:
4460: , SQLERRM
4461:
4462: );
4463:
4464: RAISE fnd_api.g_exc_unexpected_error;
4465:
4466: END;
4467:
4468:
4468:
4469:
4470: EXCEPTION
4471:
4472: WHEN fnd_api.g_exc_error THEN
4473:
4474: ROLLBACK;
4475:
4476: RAISE;
4474: ROLLBACK;
4475:
4476: RAISE;
4477:
4478: WHEN fnd_api.g_exc_unexpected_error THEN
4479:
4480: ROLLBACK;
4481:
4482: RAISE;
4492: , SQLERRM
4493:
4494: );
4495:
4496: RAISE fnd_api.g_exc_unexpected_error;
4497:
4498:
4499:
4500: END Update_ValidationReportDetails;
5042: , SQLERRM
5043:
5044: );
5045:
5046: RAISE fnd_api.g_exc_unexpected_error;
5047:
5048:
5049:
5050: END Update_CallableZones;
5098: , SQLERRM
5099:
5100: );
5101:
5102: RAISE fnd_api.g_exc_unexpected_error;
5103:
5104:
5105:
5106: END Incr_RecordsLoadedCounts;
5146: , SQLERRM
5147:
5148: );
5149:
5150: RAISE fnd_api.g_exc_unexpected_error;
5151:
5152:
5153:
5154: END Incr_CallableZoneCounts;
5194: , SQLERRM
5195:
5196: );
5197:
5198: RAISE fnd_api.g_exc_unexpected_error;
5199:
5200:
5201:
5202: END Incr_CallableZoneCounts_Cache;
5320: , SQLERRM
5321:
5322: );
5323:
5324: RAISE fnd_api.g_exc_unexpected_error;
5325:
5326:
5327:
5328: END Get_CallableZoneDetail;
5418: , SQLERRM
5419:
5420: );
5421:
5422: RAISE fnd_api.g_exc_unexpected_error;
5423:
5424:
5425:
5426: END Get_CallableZoneDetail_Cache;
5606: , SQLERRM
5607:
5608: );
5609:
5610: RAISE fnd_api.g_exc_unexpected_error;
5611:
5612:
5613:
5614: END Purge_CallableZones;
5728: , SQLERRM
5729:
5730: );
5731:
5732: RAISE fnd_api.g_exc_unexpected_error;
5733:
5734: END;
5735:
5736:
5768: , SQLERRM
5769:
5770: );
5771:
5772: RAISE fnd_api.g_exc_unexpected_error;
5773:
5774: END;
5775:
5776:
5926: , SQLERRM
5927:
5928: );
5929:
5930: RAISE fnd_api.g_exc_unexpected_error;
5931:
5932: END;
5933:
5934:
5934:
5935:
5936: EXCEPTION
5937:
5938: WHEN fnd_api.g_exc_error THEN
5939:
5940: RAISE;
5941:
5942: WHEN fnd_api.g_exc_unexpected_error THEN
5938: WHEN fnd_api.g_exc_error THEN
5939:
5940: RAISE;
5941:
5942: WHEN fnd_api.g_exc_unexpected_error THEN
5943:
5944: RAISE;
5945:
5946: WHEN OTHERS THEN
5952: , SQLERRM
5953:
5954: );
5955:
5956: RAISE fnd_api.g_exc_unexpected_error;
5957:
5958:
5959:
5960: END Update_IecReturnEntries;
6072: , l_return_code);
6073:
6074:
6075:
6076: IF l_return_code <> FND_API.G_RET_STS_SUCCESS THEN
6077:
6078: Log_GetSubsetViewError('Init_SubsetRtInfo', 'GET_SUBSET_VIEW', Get_SubsetName(l_subset_id), Get_ListName(p_list_id));
6079:
6080: RAISE fnd_api.g_exc_unexpected_error;
6076: IF l_return_code <> FND_API.G_RET_STS_SUCCESS THEN
6077:
6078: Log_GetSubsetViewError('Init_SubsetRtInfo', 'GET_SUBSET_VIEW', Get_SubsetName(l_subset_id), Get_ListName(p_list_id));
6079:
6080: RAISE fnd_api.g_exc_unexpected_error;
6081:
6082: END IF;
6083:
6084:
6140: , l_return_code);
6141:
6142:
6143:
6144: IF l_return_code <> FND_API.G_RET_STS_SUCCESS THEN
6145:
6146: Log_GetSubsetViewError('Init_SubsetRtInfo', 'GET_SUBSET_VIEW', Get_SubsetName(l_subset_id), Get_ListName(p_list_id));
6147:
6148: Log('Init_SubsetRtInfo', 'GET_SUBSET_VIEW');
6146: Log_GetSubsetViewError('Init_SubsetRtInfo', 'GET_SUBSET_VIEW', Get_SubsetName(l_subset_id), Get_ListName(p_list_id));
6147:
6148: Log('Init_SubsetRtInfo', 'GET_SUBSET_VIEW');
6149:
6150: RAISE fnd_api.g_exc_unexpected_error;
6151:
6152: END IF;
6153:
6154:
6164:
6165:
6166: EXCEPTION
6167:
6168: WHEN fnd_api.g_exc_error THEN
6169:
6170: RAISE;
6171:
6172: WHEN fnd_api.g_exc_unexpected_error THEN
6168: WHEN fnd_api.g_exc_error THEN
6169:
6170: RAISE;
6171:
6172: WHEN fnd_api.g_exc_unexpected_error THEN
6173:
6174: RAISE;
6175:
6176: WHEN OTHERS THEN
6182: , SQLERRM
6183:
6184: );
6185:
6186: RAISE fnd_api.g_exc_unexpected_error;
6187:
6188:
6189:
6190: END Init_SubsetRtInfo;
6248: ELSE
6249:
6250: Log_SubsetViewDoesNotExist('Partition_SubsetEntries', 'ASSIGN_ENTRIES_TO_SUBSET', Get_SubsetName(p_subset_id_col(i)), Get_ListName(p_list_id));
6251:
6252: RAISE fnd_api.g_exc_unexpected_error;
6253:
6254: END IF;
6255:
6256:
6312:
6313:
6314: EXCEPTION
6315:
6316: WHEN fnd_api.g_exc_error THEN
6317:
6318: RAISE;
6319:
6320: WHEN fnd_api.g_exc_unexpected_error THEN
6316: WHEN fnd_api.g_exc_error THEN
6317:
6318: RAISE;
6319:
6320: WHEN fnd_api.g_exc_unexpected_error THEN
6321:
6322: RAISE;
6323:
6324: WHEN OTHERS THEN
6330: , SQLERRM
6331:
6332: );
6333:
6334: RAISE fnd_api.g_exc_unexpected_error;
6335:
6336:
6337:
6338: END Partition_SubsetEntries;
6410:
6411:
6412: EXCEPTION
6413:
6414: WHEN fnd_api.g_exc_error THEN
6415:
6416: RAISE;
6417:
6418: WHEN fnd_api.g_exc_unexpected_error THEN
6414: WHEN fnd_api.g_exc_error THEN
6415:
6416: RAISE;
6417:
6418: WHEN fnd_api.g_exc_unexpected_error THEN
6419:
6420: RAISE;
6421:
6422: WHEN OTHERS THEN
6428: , SQLERRM
6429:
6430: );
6431:
6432: RAISE fnd_api.g_exc_unexpected_error;
6433:
6434:
6435:
6436: END Parse_Country_Code;
6550: , SQLERRM
6551:
6552: );
6553:
6554: RAISE fnd_api.g_exc_unexpected_error;
6555:
6556: END;
6557:
6558:
6618: , SQLERRM
6619:
6620: );
6621:
6622: RAISE fnd_api.g_exc_unexpected_error;
6623:
6624: END;
6625:
6626:
6706: , SQLERRM
6707:
6708: );
6709:
6710: RAISE fnd_api.g_exc_unexpected_error;
6711:
6712: END;
6713:
6714: END IF;
6752:
6753:
6754: EXCEPTION
6755:
6756: WHEN fnd_api.g_exc_error THEN
6757:
6758: RAISE;
6759:
6760: WHEN fnd_api.g_exc_unexpected_error THEN
6756: WHEN fnd_api.g_exc_error THEN
6757:
6758: RAISE;
6759:
6760: WHEN fnd_api.g_exc_unexpected_error THEN
6761:
6762: RAISE;
6763:
6764: WHEN OTHERS THEN
6770: , SQLERRM
6771:
6772: );
6773:
6774: RAISE fnd_api.g_exc_unexpected_error;
6775:
6776:
6777:
6778: END Parse_Area_Code;
6808: , SQLERRM
6809:
6810: );
6811:
6812: RAISE fnd_api.g_exc_unexpected_error;
6813:
6814:
6815:
6816: END Create_Canonical_Number;
6908: , SQLERRM
6909:
6910: );
6911:
6912: RAISE fnd_api.g_exc_unexpected_error;
6913:
6914: END;
6915:
6916: END IF;
6918:
6919:
6920: EXCEPTION
6921:
6922: WHEN fnd_api.g_exc_error THEN
6923:
6924: RAISE;
6925:
6926: WHEN fnd_api.g_exc_unexpected_error THEN
6922: WHEN fnd_api.g_exc_error THEN
6923:
6924: RAISE;
6925:
6926: WHEN fnd_api.g_exc_unexpected_error THEN
6927:
6928: RAISE;
6929:
6930: WHEN OTHERS THEN
6936: , SQLERRM
6937:
6938: );
6939:
6940: RAISE fnd_api.g_exc_unexpected_error;
6941:
6942:
6943:
6944: END Get_Territory_Code;
7022: , SQLERRM
7023:
7024: );
7025:
7026: RAISE fnd_api.g_exc_unexpected_error;
7027:
7028: END;
7029:
7030:
7068: , SQLERRM
7069:
7070: );
7071:
7072: RAISE fnd_api.g_exc_unexpected_error;
7073:
7074: END;
7075:
7076: END IF;
7140: , SQLERRM
7141:
7142: );
7143:
7144: RAISE fnd_api.g_exc_unexpected_error;
7145:
7146: END;
7147:
7148:
7252: , SQLERRM
7253:
7254: );
7255:
7256: RAISE fnd_api.g_exc_unexpected_error;
7257:
7258: END;
7259:
7260: END IF;
7282:
7283:
7284: EXCEPTION
7285:
7286: WHEN fnd_api.g_exc_error THEN
7287:
7288: RAISE;
7289:
7290: WHEN fnd_api.g_exc_unexpected_error THEN
7286: WHEN fnd_api.g_exc_error THEN
7287:
7288: RAISE;
7289:
7290: WHEN fnd_api.g_exc_unexpected_error THEN
7291:
7292: RAISE;
7293:
7294: WHEN OTHERS THEN
7300: , SQLERRM
7301:
7302: );
7303:
7304: RAISE fnd_api.g_exc_unexpected_error;
7305:
7306:
7307:
7308: END Get_Timezone_Id;
7438:
7439:
7440: EXCEPTION
7441:
7442: WHEN fnd_api.g_exc_error THEN
7443:
7444: RAISE;
7445:
7446: WHEN fnd_api.g_exc_unexpected_error THEN
7442: WHEN fnd_api.g_exc_error THEN
7443:
7444: RAISE;
7445:
7446: WHEN fnd_api.g_exc_unexpected_error THEN
7447:
7448: RAISE;
7449:
7450: WHEN OTHERS THEN
7456: , SQLERRM
7457:
7458: );
7459:
7460: RAISE fnd_api.g_exc_unexpected_error;
7461:
7462:
7463:
7464: END Validate_Canonical_Number;
7574:
7575:
7576: EXCEPTION
7577:
7578: WHEN fnd_api.g_exc_error THEN
7579:
7580: RAISE;
7581:
7582: WHEN fnd_api.g_exc_unexpected_error THEN
7578: WHEN fnd_api.g_exc_error THEN
7579:
7580: RAISE;
7581:
7582: WHEN fnd_api.g_exc_unexpected_error THEN
7583:
7584: RAISE;
7585:
7586: WHEN OTHERS THEN
7592: , SQLERRM
7593:
7594: );
7595:
7596: RAISE fnd_api.g_exc_unexpected_error;
7597:
7598:
7599:
7600: END Validate_Non_Canonical_Number;
7750:
7751:
7752: EXCEPTION
7753:
7754: WHEN fnd_api.g_exc_error THEN
7755:
7756: RAISE;
7757:
7758: WHEN fnd_api.g_exc_unexpected_error THEN
7754: WHEN fnd_api.g_exc_error THEN
7755:
7756: RAISE;
7757:
7758: WHEN fnd_api.g_exc_unexpected_error THEN
7759:
7760: RAISE;
7761:
7762: WHEN OTHERS THEN
7768: , SQLERRM
7769:
7770: );
7771:
7772: RAISE fnd_api.g_exc_unexpected_error;
7773:
7774:
7775:
7776: END Validate_Composite_Number;
8068: , l_msg_data
8069:
8070: );
8071:
8072: RAISE fnd_api.g_exc_unexpected_error;
8073:
8074: END IF;
8075:
8076:
8140:
8141:
8142: EXCEPTION
8143:
8144: WHEN fnd_api.g_exc_error THEN
8145:
8146: RAISE;
8147:
8148: WHEN fnd_api.g_exc_unexpected_error THEN
8144: WHEN fnd_api.g_exc_error THEN
8145:
8146: RAISE;
8147:
8148: WHEN fnd_api.g_exc_unexpected_error THEN
8149:
8150: RAISE;
8151:
8152: WHEN OTHERS THEN
8158: , SQLERRM
8159:
8160: );
8161:
8162: RAISE fnd_api.g_exc_unexpected_error;
8163:
8164:
8165:
8166: END Validate_ContactPointRecord;
8260:
8261:
8262: EXCEPTION
8263:
8264: WHEN fnd_api.g_exc_error OR fnd_api.g_exc_unexpected_error THEN
8265:
8266: RAISE;
8267:
8268: WHEN OTHERS THEN
8274: , SQLERRM
8275:
8276: );
8277:
8278: RAISE fnd_api.g_exc_unexpected_error;
8279:
8280:
8281:
8282: END Validate_List_Entry;
8440: , SQLERRM
8441:
8442: );
8443:
8444: RAISE fnd_api.g_exc_unexpected_error;
8445:
8446:
8447:
8448: END Remove_Entries_Pvt;
8570: , SQLERRM
8571:
8572: );
8573:
8574: RAISE fnd_api.g_exc_unexpected_error;
8575:
8576:
8577:
8578: END Remove_DeletedRecords;
8676: THEN
8677:
8678: Log_PurgeListStatusInvMsg('Purge_ScheduleEntries_Pvt','CHECK_SCHEDULE_STATUS', Get_ScheduleName(p_schedule_id));
8679:
8680: RAISE fnd_api.g_exc_error;
8681:
8682: END IF;
8683:
8684:
8792:
8793:
8794: EXCEPTION
8795:
8796: WHEN fnd_api.g_exc_error THEN
8797:
8798: ROLLBACK TO purge_schedule_entries;
8799:
8800: -- Update_PurgeStatus(l_list_id, p_schedule_id, 'FAILED_PURGE', l_api_initiated);
8802: Update_PurgeStatus(l_list_id, p_schedule_id, l_status_code, l_api_initiated);
8803:
8804: RAISE_APPLICATION_ERROR(-20999, Get_TranslatedErrorMessage);
8805:
8806: WHEN fnd_api.g_exc_unexpected_error THEN
8807:
8808: ROLLBACK TO purge_schedule_entries;
8809:
8810: -- Update_PurgeStatus(l_list_id, p_schedule_id, 'FAILED_PURGE', l_api_initiated);
8852: IS
8853:
8854: BEGIN
8855:
8856: x_return_status := FND_API.G_RET_STS_SUCCESS;
8857:
8858:
8859:
8860: Purge_ScheduleEntries_Pvt
8874: WHEN OTHERS THEN
8875:
8876: FND_MSG_PUB.ADD;
8877:
8878: x_return_status := FND_API.G_RET_STS_ERROR;
8879:
8880: END Purge_ScheduleEntries_Pub;
8881:
8882:
9218: END IF;
9219:
9220: EXCEPTION
9221:
9222: WHEN fnd_api.g_exc_error THEN
9223:
9224: GOTO Next_List_Entry;
9225:
9226: WHEN fnd_api.g_exc_unexpected_error THEN
9222: WHEN fnd_api.g_exc_error THEN
9223:
9224: GOTO Next_List_Entry;
9225:
9226: WHEN fnd_api.g_exc_unexpected_error THEN
9227:
9228: GOTO Next_List_Entry;
9229:
9230: WHEN OTHERS THEN
9720:
9721:
9722: EXCEPTION
9723:
9724: WHEN fnd_api.g_exc_error THEN
9725:
9726: RAISE;
9727:
9728: WHEN fnd_api.g_exc_unexpected_error THEN
9724: WHEN fnd_api.g_exc_error THEN
9725:
9726: RAISE;
9727:
9728: WHEN fnd_api.g_exc_unexpected_error THEN
9729:
9730: RAISE;
9731:
9732: WHEN OTHERS THEN
9738: , SQLERRM
9739:
9740: );
9741:
9742: RAISE fnd_api.g_exc_unexpected_error;
9743:
9744:
9745:
9746: END Validate_List_Pvt;
9792: , SQLERRM
9793:
9794: );
9795:
9796: RAISE fnd_api.g_exc_unexpected_error;
9797:
9798: END;
9799:
9800:
9832: WHEN OTHERS THEN
9833:
9834: Log('Get_ScheduleId', 'MAIN');
9835:
9836: RAISE fnd_api.g_exc_unexpected_error;
9837:
9838:
9839:
9840: END Get_ScheduleId;
9882: , SQLERRM
9883:
9884: );
9885:
9886: RAISE fnd_api.g_exc_unexpected_error;
9887:
9888: END;
9889:
9890:
9960: );
9961:
9962: ROLLBACK;
9963:
9964: RAISE fnd_api.g_exc_unexpected_error;
9965:
9966: END Validate_List_Pre;
9967:
9968:
10000: );
10001:
10002: ROLLBACK;
10003:
10004: RAISE fnd_api.g_exc_unexpected_error;
10005:
10006: END Validate_List_Post;
10007:
10008:
10793: BEGIN
10794:
10795:
10796:
10797: x_return_code := FND_API.G_RET_STS_SUCCESS;
10798:
10799:
10800:
10801: -- Setup logging information
10829: -- Check to see if all entries are assigned to the list's source type
10830:
10831: IF NOT Verify_EntrySourceTypes(p_list_id) THEN
10832:
10833: RAISE fnd_api.g_exc_error;
10834:
10835: END IF;
10836:
10837:
10915: IF SQLCODE = -904 THEN
10916:
10917: Log_MissingSourceTypeColumns(p_list_id, l_source_type_view, Get_SourceType(p_list_id), 'VALIDATE_LIST', 'SELECT_ENTRIES_FOR_VALIDATION');
10918:
10919: RAISE fnd_api.g_exc_error;
10920:
10921: ELSE
10922:
10923: RAISE;
11002:
11003:
11004: EXCEPTION
11005:
11006: WHEN fnd_api.g_exc_error THEN
11007:
11008: x_return_code := FND_API.G_RET_STS_ERROR;
11009:
11010: ROLLBACK;
11004: EXCEPTION
11005:
11006: WHEN fnd_api.g_exc_error THEN
11007:
11008: x_return_code := FND_API.G_RET_STS_ERROR;
11009:
11010: ROLLBACK;
11011:
11012: Validate_List_Post(p_list_id);
11016: Insert_ValidationHistoryRec(p_list_id);
11017:
11018: RAISE_APPLICATION_ERROR(-20999, Get_TranslatedErrorMessage);
11019:
11020: WHEN fnd_api.g_exc_unexpected_error THEN
11021:
11022: x_return_code := FND_API.G_RET_STS_ERROR;
11023:
11024: ROLLBACK;
11018: RAISE_APPLICATION_ERROR(-20999, Get_TranslatedErrorMessage);
11019:
11020: WHEN fnd_api.g_exc_unexpected_error THEN
11021:
11022: x_return_code := FND_API.G_RET_STS_ERROR;
11023:
11024: ROLLBACK;
11025:
11026: Validate_List_Post(p_list_id);
11040: , SQLERRM
11041:
11042: );
11043:
11044: x_return_code := FND_API.G_RET_STS_ERROR;
11045:
11046: ROLLBACK;
11047:
11048: Validate_List_Post(p_list_id);
11073: l_msg_count NUMBER;
11074: l_msg_data VARCHAR2(2000);
11075: l_listentry_rec AMS_LISTENTRY_PVT.entry_rec_type;
11076: BEGIN
11077: l_init_msg_list :=FND_API.G_TRUE;
11078:
11079: x_to_list_entry_id_col := SYSTEM.number_tbl_type();
11080:
11081: x_to_list_entry_id_col.EXTEND(p_from_list_entry_id_col.COUNT);
11261: x_msg_data => l_msg_data,
11262: p_entry_rec => l_listentry_rec,
11263: x_entry_id => x_to_list_entry_id_col(i) );
11264:
11265: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
11266: Log_msg('AMS_LISTENTRY_PUB.create_listentry', l_msg_data);
11267: END IF;
11268: END LOOP;
11269: /*
11438: , SQLERRM
11439:
11440: );
11441:
11442: RAISE fnd_api.g_exc_unexpected_error;
11443:
11444:
11445:
11446: END Copy_AmsListEntries;
11668: , SQLERRM
11669:
11670: );
11671:
11672: RAISE fnd_api.g_exc_unexpected_error;
11673:
11674:
11675:
11676: END Mark_EntriesDoNotUse;
11904: , SQLERRM
11905:
11906: );
11907:
11908: RAISE fnd_api.g_exc_unexpected_error;
11909:
11910:
11911:
11912: END Move_CallHistory;
11990: EXCEPTION
11991: WHEN OTHERS THEN
11992: IF SQLCODE = -904 THEN
11993: Log_MissingSourceTypeColumns(p_list_id, l_source_type_view, Get_SourceType(p_list_id), 'LOAD_ENTRIES_PVT', 'SELECT_ENTRIES_FOR_LOAD');
11994: RAISE fnd_api.g_exc_error;
11995: ELSE
11996: RAISE;
11997: END IF;
11998: END;
12024:
12025:
12026: EXCEPTION
12027:
12028: WHEN fnd_api.g_exc_error THEN
12029:
12030: RAISE;
12031:
12032: WHEN OTHERS THEN
12038: , SQLERRM
12039:
12040: );
12041:
12042: RAISE fnd_api.g_exc_unexpected_error;
12043:
12044:
12045:
12046: END Load_Entries_Pvt;
12132: l_msg_count NUMBER;
12133: l_msg_data VARCHAR2(2000);
12134: l_listentry_rec AMS_LISTENTRY_PVT.entry_rec_type;
12135: BEGIN
12136: l_init_msg_list :=FND_API.G_TRUE;
12137:
12138: -- Update duplicate records in ams list entries
12139:
12140: -- From Source List to Destination List
12489: l_listentry_rec.col299 := v_listentryrec.col299;
12490: l_listentry_rec.col300 := v_listentryrec.col300;
12491: l_listentry_rec.address_line1 := v_listentryrec.address_line1;
12492: l_listentry_rec.address_line2 := v_listentryrec.address_line2;
12493: l_listentry_rec.callback_flag := FND_API.g_miss_char;
12494: l_listentry_rec.city := v_listentryrec.city;
12495: l_listentry_rec.country := v_listentryrec.country;
12496: l_listentry_rec.do_not_use_flag := FND_API.g_miss_char;
12497: l_listentry_rec.do_not_use_reason := FND_API.g_miss_char;
12492: l_listentry_rec.address_line2 := v_listentryrec.address_line2;
12493: l_listentry_rec.callback_flag := FND_API.g_miss_char;
12494: l_listentry_rec.city := v_listentryrec.city;
12495: l_listentry_rec.country := v_listentryrec.country;
12496: l_listentry_rec.do_not_use_flag := FND_API.g_miss_char;
12497: l_listentry_rec.do_not_use_reason := FND_API.g_miss_char;
12498: l_listentry_rec.email_address := v_listentryrec.email_address;
12499: l_listentry_rec.fax := v_listentryrec.fax;
12500: l_listentry_rec.phone := v_listentryrec.phone;
12493: l_listentry_rec.callback_flag := FND_API.g_miss_char;
12494: l_listentry_rec.city := v_listentryrec.city;
12495: l_listentry_rec.country := v_listentryrec.country;
12496: l_listentry_rec.do_not_use_flag := FND_API.g_miss_char;
12497: l_listentry_rec.do_not_use_reason := FND_API.g_miss_char;
12498: l_listentry_rec.email_address := v_listentryrec.email_address;
12499: l_listentry_rec.fax := v_listentryrec.fax;
12500: l_listentry_rec.phone := v_listentryrec.phone;
12501: l_listentry_rec.record_out_flag := FND_API.g_miss_char;
12497: l_listentry_rec.do_not_use_reason := FND_API.g_miss_char;
12498: l_listentry_rec.email_address := v_listentryrec.email_address;
12499: l_listentry_rec.fax := v_listentryrec.fax;
12500: l_listentry_rec.phone := v_listentryrec.phone;
12501: l_listentry_rec.record_out_flag := FND_API.g_miss_char;
12502: l_listentry_rec.state := v_listentryrec.state;
12503: l_listentry_rec.suffix := v_listentryrec.suffix;
12504: l_listentry_rec.title := v_listentryrec.title;
12505: l_listentry_rec.usage_restriction := FND_API.g_miss_char;
12501: l_listentry_rec.record_out_flag := FND_API.g_miss_char;
12502: l_listentry_rec.state := v_listentryrec.state;
12503: l_listentry_rec.suffix := v_listentryrec.suffix;
12504: l_listentry_rec.title := v_listentryrec.title;
12505: l_listentry_rec.usage_restriction := FND_API.g_miss_char;
12506: l_listentry_rec.zipcode := v_listentryrec.zipcode;
12507: l_listentry_rec.curr_cp_country_code := FND_API.g_miss_char;
12508: l_listentry_rec.curr_cp_phone_number := FND_API.g_miss_char;
12509: l_listentry_rec.curr_cp_raw_phone_number := FND_API.g_miss_char;
12503: l_listentry_rec.suffix := v_listentryrec.suffix;
12504: l_listentry_rec.title := v_listentryrec.title;
12505: l_listentry_rec.usage_restriction := FND_API.g_miss_char;
12506: l_listentry_rec.zipcode := v_listentryrec.zipcode;
12507: l_listentry_rec.curr_cp_country_code := FND_API.g_miss_char;
12508: l_listentry_rec.curr_cp_phone_number := FND_API.g_miss_char;
12509: l_listentry_rec.curr_cp_raw_phone_number := FND_API.g_miss_char;
12510: l_listentry_rec.curr_cp_area_code := FND_API.g_miss_num;
12511: l_listentry_rec.curr_cp_id := FND_API.g_miss_num;
12504: l_listentry_rec.title := v_listentryrec.title;
12505: l_listentry_rec.usage_restriction := FND_API.g_miss_char;
12506: l_listentry_rec.zipcode := v_listentryrec.zipcode;
12507: l_listentry_rec.curr_cp_country_code := FND_API.g_miss_char;
12508: l_listentry_rec.curr_cp_phone_number := FND_API.g_miss_char;
12509: l_listentry_rec.curr_cp_raw_phone_number := FND_API.g_miss_char;
12510: l_listentry_rec.curr_cp_area_code := FND_API.g_miss_num;
12511: l_listentry_rec.curr_cp_id := FND_API.g_miss_num;
12512: l_listentry_rec.curr_cp_index := FND_API.g_miss_num;
12505: l_listentry_rec.usage_restriction := FND_API.g_miss_char;
12506: l_listentry_rec.zipcode := v_listentryrec.zipcode;
12507: l_listentry_rec.curr_cp_country_code := FND_API.g_miss_char;
12508: l_listentry_rec.curr_cp_phone_number := FND_API.g_miss_char;
12509: l_listentry_rec.curr_cp_raw_phone_number := FND_API.g_miss_char;
12510: l_listentry_rec.curr_cp_area_code := FND_API.g_miss_num;
12511: l_listentry_rec.curr_cp_id := FND_API.g_miss_num;
12512: l_listentry_rec.curr_cp_index := FND_API.g_miss_num;
12513: l_listentry_rec.curr_cp_time_zone := FND_API.g_miss_num;
12506: l_listentry_rec.zipcode := v_listentryrec.zipcode;
12507: l_listentry_rec.curr_cp_country_code := FND_API.g_miss_char;
12508: l_listentry_rec.curr_cp_phone_number := FND_API.g_miss_char;
12509: l_listentry_rec.curr_cp_raw_phone_number := FND_API.g_miss_char;
12510: l_listentry_rec.curr_cp_area_code := FND_API.g_miss_num;
12511: l_listentry_rec.curr_cp_id := FND_API.g_miss_num;
12512: l_listentry_rec.curr_cp_index := FND_API.g_miss_num;
12513: l_listentry_rec.curr_cp_time_zone := FND_API.g_miss_num;
12514: l_listentry_rec.curr_cp_time_zone_aux := FND_API.g_miss_num;
12507: l_listentry_rec.curr_cp_country_code := FND_API.g_miss_char;
12508: l_listentry_rec.curr_cp_phone_number := FND_API.g_miss_char;
12509: l_listentry_rec.curr_cp_raw_phone_number := FND_API.g_miss_char;
12510: l_listentry_rec.curr_cp_area_code := FND_API.g_miss_num;
12511: l_listentry_rec.curr_cp_id := FND_API.g_miss_num;
12512: l_listentry_rec.curr_cp_index := FND_API.g_miss_num;
12513: l_listentry_rec.curr_cp_time_zone := FND_API.g_miss_num;
12514: l_listentry_rec.curr_cp_time_zone_aux := FND_API.g_miss_num;
12515: l_listentry_rec.imp_source_line_id := v_listentryrec.imp_source_line_id;
12508: l_listentry_rec.curr_cp_phone_number := FND_API.g_miss_char;
12509: l_listentry_rec.curr_cp_raw_phone_number := FND_API.g_miss_char;
12510: l_listentry_rec.curr_cp_area_code := FND_API.g_miss_num;
12511: l_listentry_rec.curr_cp_id := FND_API.g_miss_num;
12512: l_listentry_rec.curr_cp_index := FND_API.g_miss_num;
12513: l_listentry_rec.curr_cp_time_zone := FND_API.g_miss_num;
12514: l_listentry_rec.curr_cp_time_zone_aux := FND_API.g_miss_num;
12515: l_listentry_rec.imp_source_line_id := v_listentryrec.imp_source_line_id;
12516: l_listentry_rec.next_call_time := FND_API.g_miss_date;
12509: l_listentry_rec.curr_cp_raw_phone_number := FND_API.g_miss_char;
12510: l_listentry_rec.curr_cp_area_code := FND_API.g_miss_num;
12511: l_listentry_rec.curr_cp_id := FND_API.g_miss_num;
12512: l_listentry_rec.curr_cp_index := FND_API.g_miss_num;
12513: l_listentry_rec.curr_cp_time_zone := FND_API.g_miss_num;
12514: l_listentry_rec.curr_cp_time_zone_aux := FND_API.g_miss_num;
12515: l_listentry_rec.imp_source_line_id := v_listentryrec.imp_source_line_id;
12516: l_listentry_rec.next_call_time := FND_API.g_miss_date;
12517: l_listentry_rec.record_release_time := FND_API.g_miss_date;
12510: l_listentry_rec.curr_cp_area_code := FND_API.g_miss_num;
12511: l_listentry_rec.curr_cp_id := FND_API.g_miss_num;
12512: l_listentry_rec.curr_cp_index := FND_API.g_miss_num;
12513: l_listentry_rec.curr_cp_time_zone := FND_API.g_miss_num;
12514: l_listentry_rec.curr_cp_time_zone_aux := FND_API.g_miss_num;
12515: l_listentry_rec.imp_source_line_id := v_listentryrec.imp_source_line_id;
12516: l_listentry_rec.next_call_time := FND_API.g_miss_date;
12517: l_listentry_rec.record_release_time := FND_API.g_miss_date;
12518: l_listentry_rec.party_id := v_listentryrec.party_id;
12512: l_listentry_rec.curr_cp_index := FND_API.g_miss_num;
12513: l_listentry_rec.curr_cp_time_zone := FND_API.g_miss_num;
12514: l_listentry_rec.curr_cp_time_zone_aux := FND_API.g_miss_num;
12515: l_listentry_rec.imp_source_line_id := v_listentryrec.imp_source_line_id;
12516: l_listentry_rec.next_call_time := FND_API.g_miss_date;
12517: l_listentry_rec.record_release_time := FND_API.g_miss_date;
12518: l_listentry_rec.party_id := v_listentryrec.party_id;
12519: l_listentry_rec.parent_party_id := v_listentryrec.parent_party_id;
12520:
12513: l_listentry_rec.curr_cp_time_zone := FND_API.g_miss_num;
12514: l_listentry_rec.curr_cp_time_zone_aux := FND_API.g_miss_num;
12515: l_listentry_rec.imp_source_line_id := v_listentryrec.imp_source_line_id;
12516: l_listentry_rec.next_call_time := FND_API.g_miss_date;
12517: l_listentry_rec.record_release_time := FND_API.g_miss_date;
12518: l_listentry_rec.party_id := v_listentryrec.party_id;
12519: l_listentry_rec.parent_party_id := v_listentryrec.parent_party_id;
12520:
12521: AMS_LISTENTRY_PUB.update_listentry(
12525: x_msg_count => l_msg_count,
12526: x_msg_data => l_msg_data,
12527: p_entry_rec => l_listentry_rec);
12528:
12529: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
12530: Log_msg('AMS_LISTENTRY_PUB.update_listentry', l_msg_data);
12531: END IF;
12532:
12533: UPDATE AMS_LIST_ENTRIES
12728: );
12729:
12730: EXCEPTION
12731:
12732: WHEN fnd_api.g_exc_error THEN
12733:
12734: RAISE;
12735:
12736: WHEN fnd_api.g_exc_unexpected_error THEN
12732: WHEN fnd_api.g_exc_error THEN
12733:
12734: RAISE;
12735:
12736: WHEN fnd_api.g_exc_unexpected_error THEN
12737:
12738: RAISE;
12739:
12740: WHEN OTHERS THEN
12746: , SQLERRM
12747:
12748: );
12749:
12750: RAISE fnd_api.g_exc_unexpected_error;
12751:
12752:
12753:
12754: END Update_DuplicateEntries;
12851: , SQLERRM
12852:
12853: );
12854:
12855: RAISE fnd_api.g_exc_unexpected_error;
12856:
12857:
12858:
12859: END Log_DuplicateEntries;
13022:
13023:
13024: EXCEPTION
13025:
13026: WHEN fnd_api.g_exc_error THEN
13027:
13028: RAISE_APPLICATION_ERROR(-20999, Get_TranslatedErrorMessage);
13029:
13030: WHEN fnd_api.g_exc_unexpected_error THEN
13026: WHEN fnd_api.g_exc_error THEN
13027:
13028: RAISE_APPLICATION_ERROR(-20999, Get_TranslatedErrorMessage);
13029:
13030: WHEN fnd_api.g_exc_unexpected_error THEN
13031:
13032: RAISE_APPLICATION_ERROR(-20999, Get_TranslatedErrorMessage);
13033:
13034:
13113: BEGIN
13114:
13115:
13116:
13117: x_return_status := FND_API.G_RET_STS_SUCCESS;
13118:
13119:
13120:
13121: SAVEPOINT move_entry;
13131: IF p_src_schedule_id IS NULL THEN
13132:
13133: Log_CopySrcListNullMsg('Move_ScheduleEntries_Pub','CHECK_SRC_SCHED_NULL', Get_ScheduleName(p_src_schedule_id), Get_ScheduleName(p_dest_schedule_id));
13134:
13135: RAISE fnd_api.g_exc_error;
13136:
13137: END IF;
13138:
13139:
13141: IF p_dest_schedule_id IS NULL THEN
13142:
13143: Log_CopyDestListNullMsg('Move_ScheduleEntries_Pub','CHECK_DEST_SCHED_NULL', Get_ScheduleName(p_src_schedule_id), Get_ScheduleName(p_dest_schedule_id));
13144:
13145: RAISE fnd_api.g_exc_error;
13146:
13147: END IF;
13148:
13149:
13215: IF l_call_center_ready_flag <> 'Y' THEN
13216:
13217: Log_CopySrcListNotCCRMsg('Move_ScheduleEntries_Pub','CHECK_SRC_SCHED_CCR', Get_ScheduleName(p_src_schedule_id), Get_ScheduleName(p_dest_schedule_id));
13218:
13219: RAISE fnd_api.g_exc_error;
13220:
13221: END IF;
13222:
13223: IF l_validated_once_flag <> 'Y' THEN
13223: IF l_validated_once_flag <> 'Y' THEN
13224:
13225: Log_CopySrcListNotValMsg('Move_ScheduleEntries_Pub','CHECK_SRC_SCHED_VAL_ONCE', Get_ScheduleName(p_src_schedule_id), Get_ScheduleName(p_dest_schedule_id));
13226:
13227: RAISE fnd_api.g_exc_error;
13228:
13229: END IF;
13230:
13231: -- not sure if we can do a move unless the list is stopped
13241: THEN
13242:
13243: Log_CopySrcListInvalidStatMsg('Move_ScheduleEntries_Pub','CHECK_SRC_SCHED_STATUS', Get_ScheduleName(p_src_schedule_id), Get_ScheduleName(p_dest_schedule_id));
13244:
13245: RAISE fnd_api.g_exc_error;
13246:
13247: END IF;
13248:
13249:
13279: IF l_call_center_ready_flag <> 'Y' THEN
13280:
13281: Log_CopyDestListNotCCRMsg('Move_ScheduleEntries_Pub','CHECK_DEST_SCHED_CCR', Get_ScheduleName(p_src_schedule_id), Get_ScheduleName(p_dest_schedule_id));
13282:
13283: RAISE fnd_api.g_exc_error;
13284:
13285: END IF;
13286:
13287: IF l_validated_once_flag <> 'Y' THEN
13287: IF l_validated_once_flag <> 'Y' THEN
13288:
13289: Log_CopyDestListNotValMsg('Move_ScheduleEntries_Pub','CHECK_DEST_SCHED_VAL_ONCE', Get_ScheduleName(p_src_schedule_id), Get_ScheduleName(p_dest_schedule_id));
13290:
13291: RAISE fnd_api.g_exc_error;
13292:
13293: END IF;
13294:
13295: -- maybe want to ensure that list is shut down
13303: THEN
13304:
13305: Log_CopyDestListInvalidStaMsg('Move_ScheduleEntries_Pub','CHECK_DEST_SCHED_STATUS', Get_ScheduleName(p_src_schedule_id), Get_ScheduleName(p_dest_schedule_id));
13306:
13307: RAISE fnd_api.g_exc_error;
13308:
13309: END IF;
13310:
13311:
13443: WHEN OTHERS THEN
13444:
13445: FND_MSG_PUB.ADD;
13446:
13447: x_return_status := FND_API.G_RET_STS_ERROR;
13448:
13449:
13450:
13451: END Move_ScheduleEntries_Pub;
13551: IF p_from_list_id IS NULL THEN
13552:
13553: Log_CopySrcListNullMsg('Copy_ScheduleEntries_Pvt','CHECK_SRC_SCHED_NULL', Get_ScheduleName(p_from_schedule_id), Get_ScheduleName(p_to_schedule_id));
13554:
13555: RAISE fnd_api.g_exc_error;
13556:
13557: END IF;
13558:
13559:
13561: IF p_to_list_id IS NULL THEN
13562:
13563: Log_CopyDestListNullMsg('Copy_ScheduleEntries_Pvt','CHECK_DEST_SCHED_NULL', Get_ScheduleName(p_from_schedule_id), Get_ScheduleName(p_to_schedule_id));
13564:
13565: RAISE fnd_api.g_exc_error;
13566:
13567: END IF;
13568:
13569:
13619: IF l_call_center_ready_flag <> 'Y' THEN
13620:
13621: Log_CopySrcListNotCCRMsg('Copy_ScheduleEntries_Pvt','CHECK_SRC_SCHED_CCR', Get_ScheduleName(p_from_schedule_id), Get_ScheduleName(p_to_schedule_id));
13622:
13623: RAISE fnd_api.g_exc_error;
13624:
13625: END IF;
13626:
13627: IF l_validated_once_flag <> 'Y' THEN
13627: IF l_validated_once_flag <> 'Y' THEN
13628:
13629: Log_CopySrcListNotValMsg('Copy_ScheduleEntries_Pvt','CHECK_SRC_SCHED_VAL_ONCE', Get_ScheduleName(p_from_schedule_id), Get_ScheduleName(p_to_schedule_id));
13630:
13631: RAISE fnd_api.g_exc_error;
13632:
13633: END IF;
13634:
13635: IF l_status_code <> 'ACTIVE' AND
13641: THEN
13642:
13643: Log_CopySrcListInvalidStatMsg('Copy_ScheduleEntries_Pvt','CHECK_SRC_SCHED_STATUS', Get_ScheduleName(p_from_schedule_id), Get_ScheduleName(p_to_schedule_id));
13644:
13645: RAISE fnd_api.g_exc_error;
13646:
13647: END IF;
13648:
13649:
13679: IF l_call_center_ready_flag <> 'Y' THEN
13680:
13681: Log_CopyDestListNotCCRMsg('Copy_ScheduleEntries_Pvt','CHECK_DEST_SCHED_CCR', Get_ScheduleName(p_from_schedule_id), Get_ScheduleName(p_to_schedule_id));
13682:
13683: RAISE fnd_api.g_exc_error;
13684:
13685: END IF;
13686:
13687: IF l_validated_once_flag <> 'Y' THEN
13687: IF l_validated_once_flag <> 'Y' THEN
13688:
13689: Log_CopyDestListNotValMsg('Copy_ScheduleEntries_Pvt','CHECK_DEST_SCHED_VAL_ONCE', Get_ScheduleName(p_from_schedule_id), Get_ScheduleName(p_to_schedule_id));
13690:
13691: RAISE fnd_api.g_exc_error;
13692:
13693: END IF;
13694:
13695: IF l_status_code <> 'ACTIVE' AND
13701: THEN
13702:
13703: Log_CopyDestListInvalidStaMsg('Copy_ScheduleEntries_Pvt','CHECK_DEST_SCHED_STATUS', Get_ScheduleName(p_from_schedule_id), Get_ScheduleName(p_to_schedule_id));
13704:
13705: RAISE fnd_api.g_exc_error;
13706:
13707: END IF;
13708:
13709:
13831:
13832:
13833: EXCEPTION
13834:
13835: WHEN fnd_api.g_exc_error THEN
13836:
13837: ROLLBACK TO move_entry;
13838:
13839: Update_MoveEntriesStatus(p_from_list_id, p_to_list_id, 'FAILED_MOVE', l_api_initiated);
13839: Update_MoveEntriesStatus(p_from_list_id, p_to_list_id, 'FAILED_MOVE', l_api_initiated);
13840:
13841: RAISE_APPLICATION_ERROR(-20999, Get_TranslatedErrorMessage);
13842:
13843: WHEN fnd_api.g_exc_unexpected_error THEN
13844:
13845: ROLLBACK TO move_entry;
13846:
13847: Update_MoveEntriesStatus(p_from_list_id, p_to_list_id, 'FAILED_MOVE', l_api_initiated);
13893: BEGIN
13894:
13895:
13896:
13897: x_return_status := FND_API.G_RET_STS_SUCCESS;
13898:
13899:
13900:
13901: IF p_src_schedule_id IS NULL THEN
13901: IF p_src_schedule_id IS NULL THEN
13902:
13903: Log_CopySrcListNullMsg('Copy_ScheduleEntries_Pub','CHECK_SRC_SCHED_NULL', Get_ScheduleName(p_src_schedule_id), Get_ScheduleName(p_dest_schedule_id));
13904:
13905: RAISE fnd_api.g_exc_error;
13906:
13907: END IF;
13908:
13909:
13911: IF p_dest_schedule_id IS NULL THEN
13912:
13913: Log_CopyDestListNullMsg('Copy_ScheduleEntries_Pub','CHECK_DEST_SCHED_NULL', Get_ScheduleName(p_src_schedule_id), Get_ScheduleName(p_dest_schedule_id));
13914:
13915: RAISE fnd_api.g_exc_error;
13916:
13917: END IF;
13918:
13919:
13935: , 'GET_LIST_HEADER_ID'
13936:
13937: );
13938:
13939: RAISE fnd_api.g_exc_error;
13940:
13941: END;
13942:
13943:
13965: WHEN OTHERS THEN
13966:
13967: FND_MSG_PUB.ADD;
13968:
13969: x_return_status := FND_API.G_RET_STS_ERROR;
13970:
13971:
13972:
13973: END Copy_ScheduleEntries_Pub;
14055:
14056:
14057: EXCEPTION
14058:
14059: WHEN fnd_api.g_exc_error THEN
14060:
14061: ROLLBACK TO load_entry;
14062:
14063: Truncate_Temporary_Tables;
14063: Truncate_Temporary_Tables;
14064:
14065: RAISE_APPLICATION_ERROR(-20999, Get_TranslatedErrorMessage);
14066:
14067: WHEN fnd_api.g_exc_unexpected_error THEN
14068:
14069: ROLLBACK TO load_entry;
14070:
14071: Truncate_Temporary_Tables;
14121:
14122:
14123: EXCEPTION
14124:
14125: WHEN fnd_api.g_exc_error THEN
14126:
14127: ROLLBACK TO load_entry;
14128:
14129: Truncate_Temporary_Tables;
14129: Truncate_Temporary_Tables;
14130:
14131: RAISE_APPLICATION_ERROR(-20999, Get_TranslatedErrorMessage);
14132:
14133: WHEN fnd_api.g_exc_unexpected_error THEN
14134:
14135: ROLLBACK TO load_entry;
14136:
14137: Truncate_Temporary_Tables;
14182: l_msg_count NUMBER;
14183: l_msg_data VARCHAR2(2000);
14184: l_listentry_rec AMS_LISTENTRY_PVT.entry_rec_type;
14185: BEGIN
14186: l_init_msg_list :=FND_API.G_TRUE;
14187:
14188: IF p_party_id IS NOT NULL THEN
14189:
14190: l_listentry_rec.LIST_HEADER_ID := p_list_id;
14233: x_msg_data => l_msg_data,
14234: p_entry_rec => l_listentry_rec,
14235: x_entry_id => x_list_entry_id );
14236:
14237: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
14238: Log_msg('AMS_LISTENTRY_PUB.create_listentry', l_msg_data);
14239: END IF;
14240:
14241: /*
14368: , SQLERRM
14369:
14370: );
14371:
14372: RAISE fnd_api.g_exc_unexpected_error;
14373:
14374:
14375:
14376: END Insert_AmsListEntries;
14456: , SQLERRM
14457:
14458: );
14459:
14460: RAISE fnd_api.g_exc_unexpected_error;
14461:
14462:
14463:
14464: END Update_AmsListEntries;
15046:
15047:
15048: EXCEPTION
15049:
15050: WHEN fnd_api.g_exc_error THEN
15051:
15052: RAISE;
15053:
15054: WHEN fnd_api.g_exc_unexpected_error THEN
15050: WHEN fnd_api.g_exc_error THEN
15051:
15052: RAISE;
15053:
15054: WHEN fnd_api.g_exc_unexpected_error THEN
15055:
15056: RAISE;
15057:
15058: WHEN OTHERS THEN
15064: , SQLERRM
15065:
15066: );
15067:
15068: RAISE fnd_api.g_exc_unexpected_error;
15069:
15070: END Create_NewEntry;
15071:
15072:
15122: , SQLERRM
15123:
15124: );
15125:
15126: RAISE fnd_api.g_exc_unexpected_error;
15127:
15128: END Get_ValidationFailureCode;
15129:
15130:
15184: , SQLERRM
15185:
15186: );
15187:
15188: RAISE fnd_api.g_exc_unexpected_error;
15189:
15190: END Update_CallbackTime;
15191:
15192:
15398:
15399:
15400: EXCEPTION
15401:
15402: WHEN fnd_api.g_exc_error THEN
15403:
15404: ROLLBACK;
15405:
15406: RAISE;
15404: ROLLBACK;
15405:
15406: RAISE;
15407:
15408: WHEN fnd_api.g_exc_unexpected_error THEN
15409:
15410: ROLLBACK;
15411:
15412: RAISE;
15422: );
15423:
15424: ROLLBACK;
15425:
15426: RAISE fnd_api.g_exc_unexpected_error;
15427:
15428: END Add_Record_To_List_Pvt;
15429:
15430:
15650:
15651:
15652: HZ_CONTACT_POINT_V2PUB.update_phone_contact_point
15653:
15654: ( fnd_api.g_true -- init msg list
15655:
15656: , l_contact_point_rec
15657:
15658: , l_phone_rec
15676: -- a log and stop the update list procedure.
15677:
15678: ----------------------------------------------------------------
15679:
15680: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
15681:
15682: BEGIN
15683:
15684: -- Get Marketing API Error Message
15684: -- Get Marketing API Error Message
15685:
15686: FOR i IN 1..FND_MSG_PUB.count_msg LOOP
15687:
15688: l_msg_data := LTRIM(RTRIM(FND_MSG_PUB.GET(i, FND_API.G_FALSE)));
15689:
15690: IF (NVL(LENGTH(l_error_msg), 0) + NVL(LENGTH(l_msg_data), 0) < 1000) THEN
15691:
15692: l_error_msg := l_error_msg || l_msg_data;
15718: );
15719:
15720:
15721:
15722: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
15723:
15724: RAISE FND_API.G_EXC_ERROR;
15725:
15726: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
15720:
15721:
15722: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
15723:
15724: RAISE FND_API.G_EXC_ERROR;
15725:
15726: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
15727:
15728: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
15722: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
15723:
15724: RAISE FND_API.G_EXC_ERROR;
15725:
15726: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
15727:
15728: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
15729:
15730: END IF;
15724: RAISE FND_API.G_EXC_ERROR;
15725:
15726: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
15727:
15728: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
15729:
15730: END IF;
15731:
15732: END IF;
15774: IF SQLCODE = -904 THEN
15775:
15776: Log_MissingSourceTypeColumns(p_list_id, l_source_type_view, Get_SourceType(p_list_id), 'Update_ContactPoint', 'UPDATE_AMS_LIST_ENTRIES');
15777:
15778: RAISE fnd_api.g_exc_unexpected_error;
15779:
15780: ELSE
15781:
15782: Log( 'Update_ContactPoint'
15786: , SQLERRM
15787:
15788: );
15789:
15790: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
15791:
15792: END IF;
15793:
15794: END;
15956: BEGIN
15957:
15958:
15959:
15960: x_return_code := FND_API.G_RET_STS_SUCCESS;
15961:
15962:
15963:
15964: SAVEPOINT subset_transition;
16194: g_error_msg := 'Source type view ' || p_source_type_v || ' is missing at least one of the following columns: ' ||
16195:
16196: 'REASON_CODE_S1, REASON_CODE_S2, REASON_CODE_S3, REASON_CODE_S4, REASON_CODE_S5, REASON_CODE_S6';
16197:
16198: RAISE fnd_api.g_exc_unexpected_error;
16199:
16200: ELSE
16201:
16202: RAISE;
16680:
16681:
16682: EXCEPTION
16683:
16684: WHEN fnd_api.g_exc_unexpected_error THEN
16685:
16686: x_return_code := FND_API.G_RET_STS_ERROR;
16687:
16688: ROLLBACK TO subset_transition;
16682: EXCEPTION
16683:
16684: WHEN fnd_api.g_exc_unexpected_error THEN
16685:
16686: x_return_code := FND_API.G_RET_STS_ERROR;
16687:
16688: ROLLBACK TO subset_transition;
16689:
16690: Truncate_Temporary_Tables;
16692: RAISE_APPLICATION_ERROR(-20999, g_error_msg);
16693:
16694: WHEN OTHERS THEN
16695:
16696: x_return_code := FND_API.G_RET_STS_ERROR;
16697:
16698: Log( 'SubsetTransition_list'
16699:
16700: , 'MAIN'