[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:
1797: WHEN OTHERS THEN
1798:
1799: Log('Get_ListName', 'MAIN');
1800:
1801: RAISE fnd_api.g_exc_unexpected_error;
1802:
1803: END Get_ListName;
1804:
1805:
1829: WHEN OTHERS THEN
1830:
1831: Log('Get_ScheduleName', 'MAIN');
1832:
1833: RAISE fnd_api.g_exc_unexpected_error;
1834:
1835: END Get_ScheduleName;
1836:
1837:
1861: WHEN OTHERS THEN
1862:
1863: Log('Get_ListName', 'MAIN');
1864:
1865: RAISE fnd_api.g_exc_unexpected_error;
1866:
1867: END Get_SubsetName;
1868:
1869:
1909: , SQLERRM
1910:
1911: );
1912:
1913: RAISE fnd_api.g_exc_unexpected_error;
1914:
1915: END;
1916:
1917:
1955: -- module
1956:
1957: Log('Get_SourceTypeView', 'MAIN');
1958:
1959: RAISE fnd_api.g_exc_unexpected_error;
1960:
1961: END;
1962:
1963:
2386: , SQLERRM
2387:
2388: );
2389:
2390: RAISE fnd_api.g_exc_unexpected_error;
2391:
2392: END;
2393:
2394:
2754: WHEN NO_DATA_FOUND THEN
2755:
2756: Log_TerritoryNotFound('Init_Rules', 'MAP_TERRITORY_CODE_TO_PHONE_COUNTRY_CODE', g_territory_code);
2757:
2758: RAISE fnd_api.g_exc_unexpected_error;
2759:
2760: WHEN TOO_MANY_ROWS THEN
2761:
2762: Log_TerritoryNotUnique('Init_Rules', 'MAP_TERRITORY_CODE_TO_PHONE_COUNTRY_CODE', g_territory_code);
2760: WHEN TOO_MANY_ROWS THEN
2761:
2762: Log_TerritoryNotUnique('Init_Rules', 'MAP_TERRITORY_CODE_TO_PHONE_COUNTRY_CODE', g_territory_code);
2763:
2764: RAISE fnd_api.g_exc_unexpected_error;
2765:
2766: END;
2767:
2768: END IF;
3040:
3041:
3042: EXCEPTION
3043:
3044: WHEN fnd_api.g_exc_error THEN
3045:
3046: RAISE;
3047:
3048: WHEN fnd_api.g_exc_unexpected_error THEN
3044: WHEN fnd_api.g_exc_error THEN
3045:
3046: RAISE;
3047:
3048: WHEN fnd_api.g_exc_unexpected_error THEN
3049:
3050: RAISE;
3051:
3052: WHEN OTHERS THEN
3058: , SQLERRM
3059:
3060: );
3061:
3062: RAISE fnd_api.g_exc_unexpected_error;
3063:
3064:
3065:
3066: END Init_Rules;
3238:
3239:
3240: EXCEPTION
3241:
3242: WHEN fnd_api.g_exc_error THEN
3243:
3244: RAISE;
3245:
3246: WHEN fnd_api.g_exc_unexpected_error THEN
3242: WHEN fnd_api.g_exc_error THEN
3243:
3244: RAISE;
3245:
3246: WHEN fnd_api.g_exc_unexpected_error THEN
3247:
3248: RAISE;
3249:
3250: WHEN OTHERS THEN
3256: , SQLERRM
3257:
3258: );
3259:
3260: RAISE fnd_api.g_exc_unexpected_error;
3261:
3262:
3263:
3264: END Update_ReportCounts;
3308: WHEN OTHERS THEN
3309:
3310: Log('UPDATE_STATUS', 'DO_IEC_STAT_UPD_VALIDATED', SQLERRM);
3311:
3312: RAISE fnd_api.g_exc_unexpected_error;
3313:
3314: END;
3315:
3316:
3350: WHEN OTHERS THEN
3351:
3352: Log('UPDATE_STATUS', 'DO_IEC_STAT_UPD_VALIDATING', SQLERRM);
3353:
3354: RAISE fnd_api.g_exc_unexpected_error;
3355:
3356: END;
3357:
3358:
3384: WHEN OTHERS THEN
3385:
3386: Log('UPDATE_STATUS', 'DO_IEC_STAT_UPD_FAILED_VALIDATION', SQLERRM);
3387:
3388: RAISE fnd_api.g_exc_unexpected_error;
3389:
3390: END;
3391:
3392: ELSE
3422: WHEN OTHERS THEN
3423:
3424: Log_StatusUpdateError('Update_Status', 'DO_MKT_STATUS_UPDATE', Get_ListName(p_list_id));
3425:
3426: RAISE fnd_api.g_exc_unexpected_error;
3427:
3428: END;
3429:
3430:
3432: COMMIT;
3433:
3434: EXCEPTION
3435:
3436: WHEN fnd_api.g_exc_error THEN
3437:
3438: ROLLBACK;
3439:
3440: IF p_status <> 'FAILED_VALIDATION' THEN
3442: RAISE;
3443:
3444: END IF;
3445:
3446: WHEN fnd_api.g_exc_unexpected_error THEN
3447:
3448: ROLLBACK;
3449:
3450: IF p_status <> 'FAILED_VALIDATION' THEN
3460: Log('UPDATE_STATUS', 'MAIN', SQLERRM);
3461:
3462: IF p_status <> 'FAILED_VALIDATION' THEN
3463:
3464: RAISE fnd_api.g_exc_unexpected_error;
3465:
3466: END IF;
3467:
3468:
3491: l_no_of_rows_in_list NUMBER;
3492: l_no_of_rows_active NUMBER;
3493:
3494: BEGIN
3495: l_init_msg_list :=FND_API.G_TRUE;
3496:
3497: IF(G_LISTHEADER_REC_INITIAL = 0 ) THEN
3498:
3499: l_listheader_rec.last_update_date := FND_API.g_miss_date;
3495: l_init_msg_list :=FND_API.G_TRUE;
3496:
3497: IF(G_LISTHEADER_REC_INITIAL = 0 ) THEN
3498:
3499: l_listheader_rec.last_update_date := FND_API.g_miss_date;
3500: l_listheader_rec.last_updated_by := FND_API.g_miss_num;
3501: l_listheader_rec.creation_date := FND_API.g_miss_date;
3502: l_listheader_rec.created_by := FND_API.g_miss_num;
3503: l_listheader_rec.last_update_login := FND_API.g_miss_num;
3496:
3497: IF(G_LISTHEADER_REC_INITIAL = 0 ) THEN
3498:
3499: l_listheader_rec.last_update_date := FND_API.g_miss_date;
3500: l_listheader_rec.last_updated_by := FND_API.g_miss_num;
3501: l_listheader_rec.creation_date := FND_API.g_miss_date;
3502: l_listheader_rec.created_by := FND_API.g_miss_num;
3503: l_listheader_rec.last_update_login := FND_API.g_miss_num;
3504: l_listheader_rec.object_version_number := FND_API.g_miss_num;
3497: IF(G_LISTHEADER_REC_INITIAL = 0 ) THEN
3498:
3499: l_listheader_rec.last_update_date := FND_API.g_miss_date;
3500: l_listheader_rec.last_updated_by := FND_API.g_miss_num;
3501: l_listheader_rec.creation_date := FND_API.g_miss_date;
3502: l_listheader_rec.created_by := FND_API.g_miss_num;
3503: l_listheader_rec.last_update_login := FND_API.g_miss_num;
3504: l_listheader_rec.object_version_number := FND_API.g_miss_num;
3505: l_listheader_rec.request_id := FND_API.g_miss_num;
3498:
3499: l_listheader_rec.last_update_date := FND_API.g_miss_date;
3500: l_listheader_rec.last_updated_by := FND_API.g_miss_num;
3501: l_listheader_rec.creation_date := FND_API.g_miss_date;
3502: l_listheader_rec.created_by := FND_API.g_miss_num;
3503: l_listheader_rec.last_update_login := FND_API.g_miss_num;
3504: l_listheader_rec.object_version_number := FND_API.g_miss_num;
3505: l_listheader_rec.request_id := FND_API.g_miss_num;
3506: l_listheader_rec.program_id := FND_API.g_miss_num;
3499: l_listheader_rec.last_update_date := FND_API.g_miss_date;
3500: l_listheader_rec.last_updated_by := FND_API.g_miss_num;
3501: l_listheader_rec.creation_date := FND_API.g_miss_date;
3502: l_listheader_rec.created_by := FND_API.g_miss_num;
3503: l_listheader_rec.last_update_login := FND_API.g_miss_num;
3504: l_listheader_rec.object_version_number := FND_API.g_miss_num;
3505: l_listheader_rec.request_id := FND_API.g_miss_num;
3506: l_listheader_rec.program_id := FND_API.g_miss_num;
3507: l_listheader_rec.program_application_id := FND_API.g_miss_num;
3500: l_listheader_rec.last_updated_by := FND_API.g_miss_num;
3501: l_listheader_rec.creation_date := FND_API.g_miss_date;
3502: l_listheader_rec.created_by := FND_API.g_miss_num;
3503: l_listheader_rec.last_update_login := FND_API.g_miss_num;
3504: l_listheader_rec.object_version_number := FND_API.g_miss_num;
3505: l_listheader_rec.request_id := FND_API.g_miss_num;
3506: l_listheader_rec.program_id := FND_API.g_miss_num;
3507: l_listheader_rec.program_application_id := FND_API.g_miss_num;
3508: l_listheader_rec.program_update_date := FND_API.g_miss_date;
3501: l_listheader_rec.creation_date := FND_API.g_miss_date;
3502: l_listheader_rec.created_by := FND_API.g_miss_num;
3503: l_listheader_rec.last_update_login := FND_API.g_miss_num;
3504: l_listheader_rec.object_version_number := FND_API.g_miss_num;
3505: l_listheader_rec.request_id := FND_API.g_miss_num;
3506: l_listheader_rec.program_id := FND_API.g_miss_num;
3507: l_listheader_rec.program_application_id := FND_API.g_miss_num;
3508: l_listheader_rec.program_update_date := FND_API.g_miss_date;
3509: l_listheader_rec.view_application_id := FND_API.g_miss_num;
3502: l_listheader_rec.created_by := FND_API.g_miss_num;
3503: l_listheader_rec.last_update_login := FND_API.g_miss_num;
3504: l_listheader_rec.object_version_number := FND_API.g_miss_num;
3505: l_listheader_rec.request_id := FND_API.g_miss_num;
3506: l_listheader_rec.program_id := FND_API.g_miss_num;
3507: l_listheader_rec.program_application_id := FND_API.g_miss_num;
3508: l_listheader_rec.program_update_date := FND_API.g_miss_date;
3509: l_listheader_rec.view_application_id := FND_API.g_miss_num;
3510: l_listheader_rec.list_name := FND_API.g_miss_char;
3503: l_listheader_rec.last_update_login := FND_API.g_miss_num;
3504: l_listheader_rec.object_version_number := FND_API.g_miss_num;
3505: l_listheader_rec.request_id := FND_API.g_miss_num;
3506: l_listheader_rec.program_id := FND_API.g_miss_num;
3507: l_listheader_rec.program_application_id := FND_API.g_miss_num;
3508: l_listheader_rec.program_update_date := FND_API.g_miss_date;
3509: l_listheader_rec.view_application_id := FND_API.g_miss_num;
3510: l_listheader_rec.list_name := FND_API.g_miss_char;
3511: l_listheader_rec.list_used_by_id := FND_API.g_miss_num;
3504: l_listheader_rec.object_version_number := FND_API.g_miss_num;
3505: l_listheader_rec.request_id := FND_API.g_miss_num;
3506: l_listheader_rec.program_id := FND_API.g_miss_num;
3507: l_listheader_rec.program_application_id := FND_API.g_miss_num;
3508: l_listheader_rec.program_update_date := FND_API.g_miss_date;
3509: l_listheader_rec.view_application_id := FND_API.g_miss_num;
3510: l_listheader_rec.list_name := FND_API.g_miss_char;
3511: l_listheader_rec.list_used_by_id := FND_API.g_miss_num;
3512: l_listheader_rec.arc_list_used_by := FND_API.g_miss_char;
3505: l_listheader_rec.request_id := FND_API.g_miss_num;
3506: l_listheader_rec.program_id := FND_API.g_miss_num;
3507: l_listheader_rec.program_application_id := FND_API.g_miss_num;
3508: l_listheader_rec.program_update_date := FND_API.g_miss_date;
3509: l_listheader_rec.view_application_id := FND_API.g_miss_num;
3510: l_listheader_rec.list_name := FND_API.g_miss_char;
3511: l_listheader_rec.list_used_by_id := FND_API.g_miss_num;
3512: l_listheader_rec.arc_list_used_by := FND_API.g_miss_char;
3513: l_listheader_rec.list_type := FND_API.g_miss_char;
3506: l_listheader_rec.program_id := FND_API.g_miss_num;
3507: l_listheader_rec.program_application_id := FND_API.g_miss_num;
3508: l_listheader_rec.program_update_date := FND_API.g_miss_date;
3509: l_listheader_rec.view_application_id := FND_API.g_miss_num;
3510: l_listheader_rec.list_name := FND_API.g_miss_char;
3511: l_listheader_rec.list_used_by_id := FND_API.g_miss_num;
3512: l_listheader_rec.arc_list_used_by := FND_API.g_miss_char;
3513: l_listheader_rec.list_type := FND_API.g_miss_char;
3514: l_listheader_rec.status_code := FND_API.g_miss_char;
3507: l_listheader_rec.program_application_id := FND_API.g_miss_num;
3508: l_listheader_rec.program_update_date := FND_API.g_miss_date;
3509: l_listheader_rec.view_application_id := FND_API.g_miss_num;
3510: l_listheader_rec.list_name := FND_API.g_miss_char;
3511: l_listheader_rec.list_used_by_id := FND_API.g_miss_num;
3512: l_listheader_rec.arc_list_used_by := FND_API.g_miss_char;
3513: l_listheader_rec.list_type := FND_API.g_miss_char;
3514: l_listheader_rec.status_code := FND_API.g_miss_char;
3515: l_listheader_rec.status_date := FND_API.g_miss_date;
3508: l_listheader_rec.program_update_date := FND_API.g_miss_date;
3509: l_listheader_rec.view_application_id := FND_API.g_miss_num;
3510: l_listheader_rec.list_name := FND_API.g_miss_char;
3511: l_listheader_rec.list_used_by_id := FND_API.g_miss_num;
3512: l_listheader_rec.arc_list_used_by := FND_API.g_miss_char;
3513: l_listheader_rec.list_type := FND_API.g_miss_char;
3514: l_listheader_rec.status_code := FND_API.g_miss_char;
3515: l_listheader_rec.status_date := FND_API.g_miss_date;
3516: l_listheader_rec.generation_type := FND_API.g_miss_char;
3509: l_listheader_rec.view_application_id := FND_API.g_miss_num;
3510: l_listheader_rec.list_name := FND_API.g_miss_char;
3511: l_listheader_rec.list_used_by_id := FND_API.g_miss_num;
3512: l_listheader_rec.arc_list_used_by := FND_API.g_miss_char;
3513: l_listheader_rec.list_type := FND_API.g_miss_char;
3514: l_listheader_rec.status_code := FND_API.g_miss_char;
3515: l_listheader_rec.status_date := FND_API.g_miss_date;
3516: l_listheader_rec.generation_type := FND_API.g_miss_char;
3517: l_listheader_rec.repeat_exclude_type := FND_API.g_miss_char;
3510: l_listheader_rec.list_name := FND_API.g_miss_char;
3511: l_listheader_rec.list_used_by_id := FND_API.g_miss_num;
3512: l_listheader_rec.arc_list_used_by := FND_API.g_miss_char;
3513: l_listheader_rec.list_type := FND_API.g_miss_char;
3514: l_listheader_rec.status_code := FND_API.g_miss_char;
3515: l_listheader_rec.status_date := FND_API.g_miss_date;
3516: l_listheader_rec.generation_type := FND_API.g_miss_char;
3517: l_listheader_rec.repeat_exclude_type := FND_API.g_miss_char;
3518: l_listheader_rec.row_selection_type := FND_API.g_miss_char;
3511: l_listheader_rec.list_used_by_id := FND_API.g_miss_num;
3512: l_listheader_rec.arc_list_used_by := FND_API.g_miss_char;
3513: l_listheader_rec.list_type := FND_API.g_miss_char;
3514: l_listheader_rec.status_code := FND_API.g_miss_char;
3515: l_listheader_rec.status_date := FND_API.g_miss_date;
3516: l_listheader_rec.generation_type := FND_API.g_miss_char;
3517: l_listheader_rec.repeat_exclude_type := FND_API.g_miss_char;
3518: l_listheader_rec.row_selection_type := FND_API.g_miss_char;
3519: l_listheader_rec.owner_user_id := FND_API.g_miss_num;
3512: l_listheader_rec.arc_list_used_by := FND_API.g_miss_char;
3513: l_listheader_rec.list_type := FND_API.g_miss_char;
3514: l_listheader_rec.status_code := FND_API.g_miss_char;
3515: l_listheader_rec.status_date := FND_API.g_miss_date;
3516: l_listheader_rec.generation_type := FND_API.g_miss_char;
3517: l_listheader_rec.repeat_exclude_type := FND_API.g_miss_char;
3518: l_listheader_rec.row_selection_type := FND_API.g_miss_char;
3519: l_listheader_rec.owner_user_id := FND_API.g_miss_num;
3520: l_listheader_rec.access_level := FND_API.g_miss_char;
3513: l_listheader_rec.list_type := FND_API.g_miss_char;
3514: l_listheader_rec.status_code := FND_API.g_miss_char;
3515: l_listheader_rec.status_date := FND_API.g_miss_date;
3516: l_listheader_rec.generation_type := FND_API.g_miss_char;
3517: l_listheader_rec.repeat_exclude_type := FND_API.g_miss_char;
3518: l_listheader_rec.row_selection_type := FND_API.g_miss_char;
3519: l_listheader_rec.owner_user_id := FND_API.g_miss_num;
3520: l_listheader_rec.access_level := FND_API.g_miss_char;
3521: l_listheader_rec.enable_log_flag :=FND_API.g_miss_char;
3514: l_listheader_rec.status_code := FND_API.g_miss_char;
3515: l_listheader_rec.status_date := FND_API.g_miss_date;
3516: l_listheader_rec.generation_type := FND_API.g_miss_char;
3517: l_listheader_rec.repeat_exclude_type := FND_API.g_miss_char;
3518: l_listheader_rec.row_selection_type := FND_API.g_miss_char;
3519: l_listheader_rec.owner_user_id := FND_API.g_miss_num;
3520: l_listheader_rec.access_level := FND_API.g_miss_char;
3521: l_listheader_rec.enable_log_flag :=FND_API.g_miss_char;
3522: l_listheader_rec.enable_word_replacement_flag := FND_API.g_miss_char;
3515: l_listheader_rec.status_date := FND_API.g_miss_date;
3516: l_listheader_rec.generation_type := FND_API.g_miss_char;
3517: l_listheader_rec.repeat_exclude_type := FND_API.g_miss_char;
3518: l_listheader_rec.row_selection_type := FND_API.g_miss_char;
3519: l_listheader_rec.owner_user_id := FND_API.g_miss_num;
3520: l_listheader_rec.access_level := FND_API.g_miss_char;
3521: l_listheader_rec.enable_log_flag :=FND_API.g_miss_char;
3522: l_listheader_rec.enable_word_replacement_flag := FND_API.g_miss_char;
3523: l_listheader_rec.enable_parallel_dml_flag := FND_API.g_miss_char;
3516: l_listheader_rec.generation_type := FND_API.g_miss_char;
3517: l_listheader_rec.repeat_exclude_type := FND_API.g_miss_char;
3518: l_listheader_rec.row_selection_type := FND_API.g_miss_char;
3519: l_listheader_rec.owner_user_id := FND_API.g_miss_num;
3520: l_listheader_rec.access_level := FND_API.g_miss_char;
3521: l_listheader_rec.enable_log_flag :=FND_API.g_miss_char;
3522: l_listheader_rec.enable_word_replacement_flag := FND_API.g_miss_char;
3523: l_listheader_rec.enable_parallel_dml_flag := FND_API.g_miss_char;
3524: l_listheader_rec.dedupe_during_generation_flag := FND_API.g_miss_char;
3517: l_listheader_rec.repeat_exclude_type := FND_API.g_miss_char;
3518: l_listheader_rec.row_selection_type := FND_API.g_miss_char;
3519: l_listheader_rec.owner_user_id := FND_API.g_miss_num;
3520: l_listheader_rec.access_level := FND_API.g_miss_char;
3521: l_listheader_rec.enable_log_flag :=FND_API.g_miss_char;
3522: l_listheader_rec.enable_word_replacement_flag := FND_API.g_miss_char;
3523: l_listheader_rec.enable_parallel_dml_flag := FND_API.g_miss_char;
3524: l_listheader_rec.dedupe_during_generation_flag := FND_API.g_miss_char;
3525: l_listheader_rec.generate_control_group_flag := FND_API.g_miss_char;
3518: l_listheader_rec.row_selection_type := FND_API.g_miss_char;
3519: l_listheader_rec.owner_user_id := FND_API.g_miss_num;
3520: l_listheader_rec.access_level := FND_API.g_miss_char;
3521: l_listheader_rec.enable_log_flag :=FND_API.g_miss_char;
3522: l_listheader_rec.enable_word_replacement_flag := FND_API.g_miss_char;
3523: l_listheader_rec.enable_parallel_dml_flag := FND_API.g_miss_char;
3524: l_listheader_rec.dedupe_during_generation_flag := FND_API.g_miss_char;
3525: l_listheader_rec.generate_control_group_flag := FND_API.g_miss_char;
3526: l_listheader_rec.last_generation_success_flag := FND_API.g_miss_char;
3519: l_listheader_rec.owner_user_id := FND_API.g_miss_num;
3520: l_listheader_rec.access_level := FND_API.g_miss_char;
3521: l_listheader_rec.enable_log_flag :=FND_API.g_miss_char;
3522: l_listheader_rec.enable_word_replacement_flag := FND_API.g_miss_char;
3523: l_listheader_rec.enable_parallel_dml_flag := FND_API.g_miss_char;
3524: l_listheader_rec.dedupe_during_generation_flag := FND_API.g_miss_char;
3525: l_listheader_rec.generate_control_group_flag := FND_API.g_miss_char;
3526: l_listheader_rec.last_generation_success_flag := FND_API.g_miss_char;
3527: l_listheader_rec.forecasted_start_date := FND_API.g_miss_date;
3520: l_listheader_rec.access_level := FND_API.g_miss_char;
3521: l_listheader_rec.enable_log_flag :=FND_API.g_miss_char;
3522: l_listheader_rec.enable_word_replacement_flag := FND_API.g_miss_char;
3523: l_listheader_rec.enable_parallel_dml_flag := FND_API.g_miss_char;
3524: l_listheader_rec.dedupe_during_generation_flag := FND_API.g_miss_char;
3525: l_listheader_rec.generate_control_group_flag := FND_API.g_miss_char;
3526: l_listheader_rec.last_generation_success_flag := FND_API.g_miss_char;
3527: l_listheader_rec.forecasted_start_date := FND_API.g_miss_date;
3528: l_listheader_rec.forecasted_end_date := FND_API.g_miss_date;
3521: l_listheader_rec.enable_log_flag :=FND_API.g_miss_char;
3522: l_listheader_rec.enable_word_replacement_flag := FND_API.g_miss_char;
3523: l_listheader_rec.enable_parallel_dml_flag := FND_API.g_miss_char;
3524: l_listheader_rec.dedupe_during_generation_flag := FND_API.g_miss_char;
3525: l_listheader_rec.generate_control_group_flag := FND_API.g_miss_char;
3526: l_listheader_rec.last_generation_success_flag := FND_API.g_miss_char;
3527: l_listheader_rec.forecasted_start_date := FND_API.g_miss_date;
3528: l_listheader_rec.forecasted_end_date := FND_API.g_miss_date;
3529: l_listheader_rec.actual_end_date := FND_API.g_miss_date;
3522: l_listheader_rec.enable_word_replacement_flag := FND_API.g_miss_char;
3523: l_listheader_rec.enable_parallel_dml_flag := FND_API.g_miss_char;
3524: l_listheader_rec.dedupe_during_generation_flag := FND_API.g_miss_char;
3525: l_listheader_rec.generate_control_group_flag := FND_API.g_miss_char;
3526: l_listheader_rec.last_generation_success_flag := FND_API.g_miss_char;
3527: l_listheader_rec.forecasted_start_date := FND_API.g_miss_date;
3528: l_listheader_rec.forecasted_end_date := FND_API.g_miss_date;
3529: l_listheader_rec.actual_end_date := FND_API.g_miss_date;
3530: l_listheader_rec.sent_out_date := FND_API.g_miss_date;
3523: l_listheader_rec.enable_parallel_dml_flag := FND_API.g_miss_char;
3524: l_listheader_rec.dedupe_during_generation_flag := FND_API.g_miss_char;
3525: l_listheader_rec.generate_control_group_flag := FND_API.g_miss_char;
3526: l_listheader_rec.last_generation_success_flag := FND_API.g_miss_char;
3527: l_listheader_rec.forecasted_start_date := FND_API.g_miss_date;
3528: l_listheader_rec.forecasted_end_date := FND_API.g_miss_date;
3529: l_listheader_rec.actual_end_date := FND_API.g_miss_date;
3530: l_listheader_rec.sent_out_date := FND_API.g_miss_date;
3531: l_listheader_rec.dedupe_start_date := FND_API.g_miss_date;
3524: l_listheader_rec.dedupe_during_generation_flag := FND_API.g_miss_char;
3525: l_listheader_rec.generate_control_group_flag := FND_API.g_miss_char;
3526: l_listheader_rec.last_generation_success_flag := FND_API.g_miss_char;
3527: l_listheader_rec.forecasted_start_date := FND_API.g_miss_date;
3528: l_listheader_rec.forecasted_end_date := FND_API.g_miss_date;
3529: l_listheader_rec.actual_end_date := FND_API.g_miss_date;
3530: l_listheader_rec.sent_out_date := FND_API.g_miss_date;
3531: l_listheader_rec.dedupe_start_date := FND_API.g_miss_date;
3532: l_listheader_rec.last_dedupe_date := FND_API.g_miss_date;
3525: l_listheader_rec.generate_control_group_flag := FND_API.g_miss_char;
3526: l_listheader_rec.last_generation_success_flag := FND_API.g_miss_char;
3527: l_listheader_rec.forecasted_start_date := FND_API.g_miss_date;
3528: l_listheader_rec.forecasted_end_date := FND_API.g_miss_date;
3529: l_listheader_rec.actual_end_date := FND_API.g_miss_date;
3530: l_listheader_rec.sent_out_date := FND_API.g_miss_date;
3531: l_listheader_rec.dedupe_start_date := FND_API.g_miss_date;
3532: l_listheader_rec.last_dedupe_date := FND_API.g_miss_date;
3533: l_listheader_rec.last_deduped_by_user_id := FND_API.g_miss_num;
3526: l_listheader_rec.last_generation_success_flag := FND_API.g_miss_char;
3527: l_listheader_rec.forecasted_start_date := FND_API.g_miss_date;
3528: l_listheader_rec.forecasted_end_date := FND_API.g_miss_date;
3529: l_listheader_rec.actual_end_date := FND_API.g_miss_date;
3530: l_listheader_rec.sent_out_date := FND_API.g_miss_date;
3531: l_listheader_rec.dedupe_start_date := FND_API.g_miss_date;
3532: l_listheader_rec.last_dedupe_date := FND_API.g_miss_date;
3533: l_listheader_rec.last_deduped_by_user_id := FND_API.g_miss_num;
3534: l_listheader_rec.workflow_item_key := FND_API.g_miss_num;
3527: l_listheader_rec.forecasted_start_date := FND_API.g_miss_date;
3528: l_listheader_rec.forecasted_end_date := FND_API.g_miss_date;
3529: l_listheader_rec.actual_end_date := FND_API.g_miss_date;
3530: l_listheader_rec.sent_out_date := FND_API.g_miss_date;
3531: l_listheader_rec.dedupe_start_date := FND_API.g_miss_date;
3532: l_listheader_rec.last_dedupe_date := FND_API.g_miss_date;
3533: l_listheader_rec.last_deduped_by_user_id := FND_API.g_miss_num;
3534: l_listheader_rec.workflow_item_key := FND_API.g_miss_num;
3535: l_listheader_rec.no_of_rows_duplicates := FND_API.g_miss_num;
3528: l_listheader_rec.forecasted_end_date := FND_API.g_miss_date;
3529: l_listheader_rec.actual_end_date := FND_API.g_miss_date;
3530: l_listheader_rec.sent_out_date := FND_API.g_miss_date;
3531: l_listheader_rec.dedupe_start_date := FND_API.g_miss_date;
3532: l_listheader_rec.last_dedupe_date := FND_API.g_miss_date;
3533: l_listheader_rec.last_deduped_by_user_id := FND_API.g_miss_num;
3534: l_listheader_rec.workflow_item_key := FND_API.g_miss_num;
3535: l_listheader_rec.no_of_rows_duplicates := FND_API.g_miss_num;
3536: l_listheader_rec.no_of_rows_min_requested := FND_API.g_miss_num;
3529: l_listheader_rec.actual_end_date := FND_API.g_miss_date;
3530: l_listheader_rec.sent_out_date := FND_API.g_miss_date;
3531: l_listheader_rec.dedupe_start_date := FND_API.g_miss_date;
3532: l_listheader_rec.last_dedupe_date := FND_API.g_miss_date;
3533: l_listheader_rec.last_deduped_by_user_id := FND_API.g_miss_num;
3534: l_listheader_rec.workflow_item_key := FND_API.g_miss_num;
3535: l_listheader_rec.no_of_rows_duplicates := FND_API.g_miss_num;
3536: l_listheader_rec.no_of_rows_min_requested := FND_API.g_miss_num;
3537: l_listheader_rec.no_of_rows_max_requested := FND_API.g_miss_num;
3530: l_listheader_rec.sent_out_date := FND_API.g_miss_date;
3531: l_listheader_rec.dedupe_start_date := FND_API.g_miss_date;
3532: l_listheader_rec.last_dedupe_date := FND_API.g_miss_date;
3533: l_listheader_rec.last_deduped_by_user_id := FND_API.g_miss_num;
3534: l_listheader_rec.workflow_item_key := FND_API.g_miss_num;
3535: l_listheader_rec.no_of_rows_duplicates := FND_API.g_miss_num;
3536: l_listheader_rec.no_of_rows_min_requested := FND_API.g_miss_num;
3537: l_listheader_rec.no_of_rows_max_requested := FND_API.g_miss_num;
3538: l_listheader_rec.no_of_rows_in_list := FND_API.g_miss_num;
3531: l_listheader_rec.dedupe_start_date := FND_API.g_miss_date;
3532: l_listheader_rec.last_dedupe_date := FND_API.g_miss_date;
3533: l_listheader_rec.last_deduped_by_user_id := FND_API.g_miss_num;
3534: l_listheader_rec.workflow_item_key := FND_API.g_miss_num;
3535: l_listheader_rec.no_of_rows_duplicates := FND_API.g_miss_num;
3536: l_listheader_rec.no_of_rows_min_requested := FND_API.g_miss_num;
3537: l_listheader_rec.no_of_rows_max_requested := FND_API.g_miss_num;
3538: l_listheader_rec.no_of_rows_in_list := FND_API.g_miss_num;
3539: l_listheader_rec.no_of_rows_in_ctrl_group := FND_API.g_miss_num;
3532: l_listheader_rec.last_dedupe_date := FND_API.g_miss_date;
3533: l_listheader_rec.last_deduped_by_user_id := FND_API.g_miss_num;
3534: l_listheader_rec.workflow_item_key := FND_API.g_miss_num;
3535: l_listheader_rec.no_of_rows_duplicates := FND_API.g_miss_num;
3536: l_listheader_rec.no_of_rows_min_requested := FND_API.g_miss_num;
3537: l_listheader_rec.no_of_rows_max_requested := FND_API.g_miss_num;
3538: l_listheader_rec.no_of_rows_in_list := FND_API.g_miss_num;
3539: l_listheader_rec.no_of_rows_in_ctrl_group := FND_API.g_miss_num;
3540: l_listheader_rec.no_of_rows_active := FND_API.g_miss_num;
3533: l_listheader_rec.last_deduped_by_user_id := FND_API.g_miss_num;
3534: l_listheader_rec.workflow_item_key := FND_API.g_miss_num;
3535: l_listheader_rec.no_of_rows_duplicates := FND_API.g_miss_num;
3536: l_listheader_rec.no_of_rows_min_requested := FND_API.g_miss_num;
3537: l_listheader_rec.no_of_rows_max_requested := FND_API.g_miss_num;
3538: l_listheader_rec.no_of_rows_in_list := FND_API.g_miss_num;
3539: l_listheader_rec.no_of_rows_in_ctrl_group := FND_API.g_miss_num;
3540: l_listheader_rec.no_of_rows_active := FND_API.g_miss_num;
3541: l_listheader_rec.no_of_rows_inactive := FND_API.g_miss_num;
3534: l_listheader_rec.workflow_item_key := FND_API.g_miss_num;
3535: l_listheader_rec.no_of_rows_duplicates := FND_API.g_miss_num;
3536: l_listheader_rec.no_of_rows_min_requested := FND_API.g_miss_num;
3537: l_listheader_rec.no_of_rows_max_requested := FND_API.g_miss_num;
3538: l_listheader_rec.no_of_rows_in_list := FND_API.g_miss_num;
3539: l_listheader_rec.no_of_rows_in_ctrl_group := FND_API.g_miss_num;
3540: l_listheader_rec.no_of_rows_active := FND_API.g_miss_num;
3541: l_listheader_rec.no_of_rows_inactive := FND_API.g_miss_num;
3542: l_listheader_rec.no_of_rows_manually_entered := FND_API.g_miss_num;
3535: l_listheader_rec.no_of_rows_duplicates := FND_API.g_miss_num;
3536: l_listheader_rec.no_of_rows_min_requested := FND_API.g_miss_num;
3537: l_listheader_rec.no_of_rows_max_requested := FND_API.g_miss_num;
3538: l_listheader_rec.no_of_rows_in_list := FND_API.g_miss_num;
3539: l_listheader_rec.no_of_rows_in_ctrl_group := FND_API.g_miss_num;
3540: l_listheader_rec.no_of_rows_active := FND_API.g_miss_num;
3541: l_listheader_rec.no_of_rows_inactive := FND_API.g_miss_num;
3542: l_listheader_rec.no_of_rows_manually_entered := FND_API.g_miss_num;
3543: l_listheader_rec.no_of_rows_do_not_call := FND_API.g_miss_num;
3536: l_listheader_rec.no_of_rows_min_requested := FND_API.g_miss_num;
3537: l_listheader_rec.no_of_rows_max_requested := FND_API.g_miss_num;
3538: l_listheader_rec.no_of_rows_in_list := FND_API.g_miss_num;
3539: l_listheader_rec.no_of_rows_in_ctrl_group := FND_API.g_miss_num;
3540: l_listheader_rec.no_of_rows_active := FND_API.g_miss_num;
3541: l_listheader_rec.no_of_rows_inactive := FND_API.g_miss_num;
3542: l_listheader_rec.no_of_rows_manually_entered := FND_API.g_miss_num;
3543: l_listheader_rec.no_of_rows_do_not_call := FND_API.g_miss_num;
3544: l_listheader_rec.no_of_rows_do_not_mail :=FND_API.g_miss_num;
3537: l_listheader_rec.no_of_rows_max_requested := FND_API.g_miss_num;
3538: l_listheader_rec.no_of_rows_in_list := FND_API.g_miss_num;
3539: l_listheader_rec.no_of_rows_in_ctrl_group := FND_API.g_miss_num;
3540: l_listheader_rec.no_of_rows_active := FND_API.g_miss_num;
3541: l_listheader_rec.no_of_rows_inactive := FND_API.g_miss_num;
3542: l_listheader_rec.no_of_rows_manually_entered := FND_API.g_miss_num;
3543: l_listheader_rec.no_of_rows_do_not_call := FND_API.g_miss_num;
3544: l_listheader_rec.no_of_rows_do_not_mail :=FND_API.g_miss_num;
3545: l_listheader_rec.no_of_rows_random := FND_API.g_miss_num;
3538: l_listheader_rec.no_of_rows_in_list := FND_API.g_miss_num;
3539: l_listheader_rec.no_of_rows_in_ctrl_group := FND_API.g_miss_num;
3540: l_listheader_rec.no_of_rows_active := FND_API.g_miss_num;
3541: l_listheader_rec.no_of_rows_inactive := FND_API.g_miss_num;
3542: l_listheader_rec.no_of_rows_manually_entered := FND_API.g_miss_num;
3543: l_listheader_rec.no_of_rows_do_not_call := FND_API.g_miss_num;
3544: l_listheader_rec.no_of_rows_do_not_mail :=FND_API.g_miss_num;
3545: l_listheader_rec.no_of_rows_random := FND_API.g_miss_num;
3546: l_listheader_rec.org_id := FND_API.g_miss_num;
3539: l_listheader_rec.no_of_rows_in_ctrl_group := FND_API.g_miss_num;
3540: l_listheader_rec.no_of_rows_active := FND_API.g_miss_num;
3541: l_listheader_rec.no_of_rows_inactive := FND_API.g_miss_num;
3542: l_listheader_rec.no_of_rows_manually_entered := FND_API.g_miss_num;
3543: l_listheader_rec.no_of_rows_do_not_call := FND_API.g_miss_num;
3544: l_listheader_rec.no_of_rows_do_not_mail :=FND_API.g_miss_num;
3545: l_listheader_rec.no_of_rows_random := FND_API.g_miss_num;
3546: l_listheader_rec.org_id := FND_API.g_miss_num;
3547: l_listheader_rec.main_gen_start_time := FND_API.g_miss_date;
3540: l_listheader_rec.no_of_rows_active := FND_API.g_miss_num;
3541: l_listheader_rec.no_of_rows_inactive := FND_API.g_miss_num;
3542: l_listheader_rec.no_of_rows_manually_entered := FND_API.g_miss_num;
3543: l_listheader_rec.no_of_rows_do_not_call := FND_API.g_miss_num;
3544: l_listheader_rec.no_of_rows_do_not_mail :=FND_API.g_miss_num;
3545: l_listheader_rec.no_of_rows_random := FND_API.g_miss_num;
3546: l_listheader_rec.org_id := FND_API.g_miss_num;
3547: l_listheader_rec.main_gen_start_time := FND_API.g_miss_date;
3548: l_listheader_rec.main_gen_end_time := FND_API.g_miss_date;
3541: l_listheader_rec.no_of_rows_inactive := FND_API.g_miss_num;
3542: l_listheader_rec.no_of_rows_manually_entered := FND_API.g_miss_num;
3543: l_listheader_rec.no_of_rows_do_not_call := FND_API.g_miss_num;
3544: l_listheader_rec.no_of_rows_do_not_mail :=FND_API.g_miss_num;
3545: l_listheader_rec.no_of_rows_random := FND_API.g_miss_num;
3546: l_listheader_rec.org_id := FND_API.g_miss_num;
3547: l_listheader_rec.main_gen_start_time := FND_API.g_miss_date;
3548: l_listheader_rec.main_gen_end_time := FND_API.g_miss_date;
3549: l_listheader_rec.main_random_nth_row_selection := FND_API.g_miss_num;
3542: l_listheader_rec.no_of_rows_manually_entered := FND_API.g_miss_num;
3543: l_listheader_rec.no_of_rows_do_not_call := FND_API.g_miss_num;
3544: l_listheader_rec.no_of_rows_do_not_mail :=FND_API.g_miss_num;
3545: l_listheader_rec.no_of_rows_random := FND_API.g_miss_num;
3546: l_listheader_rec.org_id := FND_API.g_miss_num;
3547: l_listheader_rec.main_gen_start_time := FND_API.g_miss_date;
3548: l_listheader_rec.main_gen_end_time := FND_API.g_miss_date;
3549: l_listheader_rec.main_random_nth_row_selection := FND_API.g_miss_num;
3550: l_listheader_rec.main_random_pct_row_selection := FND_API.g_miss_num;
3543: l_listheader_rec.no_of_rows_do_not_call := FND_API.g_miss_num;
3544: l_listheader_rec.no_of_rows_do_not_mail :=FND_API.g_miss_num;
3545: l_listheader_rec.no_of_rows_random := FND_API.g_miss_num;
3546: l_listheader_rec.org_id := FND_API.g_miss_num;
3547: l_listheader_rec.main_gen_start_time := FND_API.g_miss_date;
3548: l_listheader_rec.main_gen_end_time := FND_API.g_miss_date;
3549: l_listheader_rec.main_random_nth_row_selection := FND_API.g_miss_num;
3550: l_listheader_rec.main_random_pct_row_selection := FND_API.g_miss_num;
3551: l_listheader_rec.ctrl_random_nth_row_selection := FND_API.g_miss_num;
3544: l_listheader_rec.no_of_rows_do_not_mail :=FND_API.g_miss_num;
3545: l_listheader_rec.no_of_rows_random := FND_API.g_miss_num;
3546: l_listheader_rec.org_id := FND_API.g_miss_num;
3547: l_listheader_rec.main_gen_start_time := FND_API.g_miss_date;
3548: l_listheader_rec.main_gen_end_time := FND_API.g_miss_date;
3549: l_listheader_rec.main_random_nth_row_selection := FND_API.g_miss_num;
3550: l_listheader_rec.main_random_pct_row_selection := FND_API.g_miss_num;
3551: l_listheader_rec.ctrl_random_nth_row_selection := FND_API.g_miss_num;
3552: l_listheader_rec.ctrl_random_pct_row_selection := FND_API.g_miss_num;
3545: l_listheader_rec.no_of_rows_random := FND_API.g_miss_num;
3546: l_listheader_rec.org_id := FND_API.g_miss_num;
3547: l_listheader_rec.main_gen_start_time := FND_API.g_miss_date;
3548: l_listheader_rec.main_gen_end_time := FND_API.g_miss_date;
3549: l_listheader_rec.main_random_nth_row_selection := FND_API.g_miss_num;
3550: l_listheader_rec.main_random_pct_row_selection := FND_API.g_miss_num;
3551: l_listheader_rec.ctrl_random_nth_row_selection := FND_API.g_miss_num;
3552: l_listheader_rec.ctrl_random_pct_row_selection := FND_API.g_miss_num;
3553: l_listheader_rec.repeat_source_list_header_id := FND_API.g_miss_char;
3546: l_listheader_rec.org_id := FND_API.g_miss_num;
3547: l_listheader_rec.main_gen_start_time := FND_API.g_miss_date;
3548: l_listheader_rec.main_gen_end_time := FND_API.g_miss_date;
3549: l_listheader_rec.main_random_nth_row_selection := FND_API.g_miss_num;
3550: l_listheader_rec.main_random_pct_row_selection := FND_API.g_miss_num;
3551: l_listheader_rec.ctrl_random_nth_row_selection := FND_API.g_miss_num;
3552: l_listheader_rec.ctrl_random_pct_row_selection := FND_API.g_miss_num;
3553: l_listheader_rec.repeat_source_list_header_id := FND_API.g_miss_char;
3554: l_listheader_rec.result_text := FND_API.g_miss_char;
3547: l_listheader_rec.main_gen_start_time := FND_API.g_miss_date;
3548: l_listheader_rec.main_gen_end_time := FND_API.g_miss_date;
3549: l_listheader_rec.main_random_nth_row_selection := FND_API.g_miss_num;
3550: l_listheader_rec.main_random_pct_row_selection := FND_API.g_miss_num;
3551: l_listheader_rec.ctrl_random_nth_row_selection := FND_API.g_miss_num;
3552: l_listheader_rec.ctrl_random_pct_row_selection := FND_API.g_miss_num;
3553: l_listheader_rec.repeat_source_list_header_id := FND_API.g_miss_char;
3554: l_listheader_rec.result_text := FND_API.g_miss_char;
3555: l_listheader_rec.keywords := FND_API.g_miss_char;
3548: l_listheader_rec.main_gen_end_time := FND_API.g_miss_date;
3549: l_listheader_rec.main_random_nth_row_selection := FND_API.g_miss_num;
3550: l_listheader_rec.main_random_pct_row_selection := FND_API.g_miss_num;
3551: l_listheader_rec.ctrl_random_nth_row_selection := FND_API.g_miss_num;
3552: l_listheader_rec.ctrl_random_pct_row_selection := FND_API.g_miss_num;
3553: l_listheader_rec.repeat_source_list_header_id := FND_API.g_miss_char;
3554: l_listheader_rec.result_text := FND_API.g_miss_char;
3555: l_listheader_rec.keywords := FND_API.g_miss_char;
3556: l_listheader_rec.description := FND_API.g_miss_char;
3549: l_listheader_rec.main_random_nth_row_selection := FND_API.g_miss_num;
3550: l_listheader_rec.main_random_pct_row_selection := FND_API.g_miss_num;
3551: l_listheader_rec.ctrl_random_nth_row_selection := FND_API.g_miss_num;
3552: l_listheader_rec.ctrl_random_pct_row_selection := FND_API.g_miss_num;
3553: l_listheader_rec.repeat_source_list_header_id := FND_API.g_miss_char;
3554: l_listheader_rec.result_text := FND_API.g_miss_char;
3555: l_listheader_rec.keywords := FND_API.g_miss_char;
3556: l_listheader_rec.description := FND_API.g_miss_char;
3557: l_listheader_rec.list_priority := FND_API.g_miss_num;
3550: l_listheader_rec.main_random_pct_row_selection := FND_API.g_miss_num;
3551: l_listheader_rec.ctrl_random_nth_row_selection := FND_API.g_miss_num;
3552: l_listheader_rec.ctrl_random_pct_row_selection := FND_API.g_miss_num;
3553: l_listheader_rec.repeat_source_list_header_id := FND_API.g_miss_char;
3554: l_listheader_rec.result_text := FND_API.g_miss_char;
3555: l_listheader_rec.keywords := FND_API.g_miss_char;
3556: l_listheader_rec.description := FND_API.g_miss_char;
3557: l_listheader_rec.list_priority := FND_API.g_miss_num;
3558: l_listheader_rec.assign_person_id := FND_API.g_miss_num;
3551: l_listheader_rec.ctrl_random_nth_row_selection := FND_API.g_miss_num;
3552: l_listheader_rec.ctrl_random_pct_row_selection := FND_API.g_miss_num;
3553: l_listheader_rec.repeat_source_list_header_id := FND_API.g_miss_char;
3554: l_listheader_rec.result_text := FND_API.g_miss_char;
3555: l_listheader_rec.keywords := FND_API.g_miss_char;
3556: l_listheader_rec.description := FND_API.g_miss_char;
3557: l_listheader_rec.list_priority := FND_API.g_miss_num;
3558: l_listheader_rec.assign_person_id := FND_API.g_miss_num;
3559: l_listheader_rec.list_source := FND_API.g_miss_char;
3552: l_listheader_rec.ctrl_random_pct_row_selection := FND_API.g_miss_num;
3553: l_listheader_rec.repeat_source_list_header_id := FND_API.g_miss_char;
3554: l_listheader_rec.result_text := FND_API.g_miss_char;
3555: l_listheader_rec.keywords := FND_API.g_miss_char;
3556: l_listheader_rec.description := FND_API.g_miss_char;
3557: l_listheader_rec.list_priority := FND_API.g_miss_num;
3558: l_listheader_rec.assign_person_id := FND_API.g_miss_num;
3559: l_listheader_rec.list_source := FND_API.g_miss_char;
3560: l_listheader_rec.list_source_type := FND_API.g_miss_char;
3553: l_listheader_rec.repeat_source_list_header_id := FND_API.g_miss_char;
3554: l_listheader_rec.result_text := FND_API.g_miss_char;
3555: l_listheader_rec.keywords := FND_API.g_miss_char;
3556: l_listheader_rec.description := FND_API.g_miss_char;
3557: l_listheader_rec.list_priority := FND_API.g_miss_num;
3558: l_listheader_rec.assign_person_id := FND_API.g_miss_num;
3559: l_listheader_rec.list_source := FND_API.g_miss_char;
3560: l_listheader_rec.list_source_type := FND_API.g_miss_char;
3561: l_listheader_rec.list_online_flag := FND_API.g_miss_char;
3554: l_listheader_rec.result_text := FND_API.g_miss_char;
3555: l_listheader_rec.keywords := FND_API.g_miss_char;
3556: l_listheader_rec.description := FND_API.g_miss_char;
3557: l_listheader_rec.list_priority := FND_API.g_miss_num;
3558: l_listheader_rec.assign_person_id := FND_API.g_miss_num;
3559: l_listheader_rec.list_source := FND_API.g_miss_char;
3560: l_listheader_rec.list_source_type := FND_API.g_miss_char;
3561: l_listheader_rec.list_online_flag := FND_API.g_miss_char;
3562: l_listheader_rec.random_list_id := FND_API.g_miss_num;
3555: l_listheader_rec.keywords := FND_API.g_miss_char;
3556: l_listheader_rec.description := FND_API.g_miss_char;
3557: l_listheader_rec.list_priority := FND_API.g_miss_num;
3558: l_listheader_rec.assign_person_id := FND_API.g_miss_num;
3559: l_listheader_rec.list_source := FND_API.g_miss_char;
3560: l_listheader_rec.list_source_type := FND_API.g_miss_char;
3561: l_listheader_rec.list_online_flag := FND_API.g_miss_char;
3562: l_listheader_rec.random_list_id := FND_API.g_miss_num;
3563: l_listheader_rec.enabled_flag := FND_API.g_miss_char;
3556: l_listheader_rec.description := FND_API.g_miss_char;
3557: l_listheader_rec.list_priority := FND_API.g_miss_num;
3558: l_listheader_rec.assign_person_id := FND_API.g_miss_num;
3559: l_listheader_rec.list_source := FND_API.g_miss_char;
3560: l_listheader_rec.list_source_type := FND_API.g_miss_char;
3561: l_listheader_rec.list_online_flag := FND_API.g_miss_char;
3562: l_listheader_rec.random_list_id := FND_API.g_miss_num;
3563: l_listheader_rec.enabled_flag := FND_API.g_miss_char;
3564: l_listheader_rec.assigned_to := FND_API.g_miss_num;
3557: l_listheader_rec.list_priority := FND_API.g_miss_num;
3558: l_listheader_rec.assign_person_id := FND_API.g_miss_num;
3559: l_listheader_rec.list_source := FND_API.g_miss_char;
3560: l_listheader_rec.list_source_type := FND_API.g_miss_char;
3561: l_listheader_rec.list_online_flag := FND_API.g_miss_char;
3562: l_listheader_rec.random_list_id := FND_API.g_miss_num;
3563: l_listheader_rec.enabled_flag := FND_API.g_miss_char;
3564: l_listheader_rec.assigned_to := FND_API.g_miss_num;
3565: l_listheader_rec.query_id := FND_API.g_miss_num;
3558: l_listheader_rec.assign_person_id := FND_API.g_miss_num;
3559: l_listheader_rec.list_source := FND_API.g_miss_char;
3560: l_listheader_rec.list_source_type := FND_API.g_miss_char;
3561: l_listheader_rec.list_online_flag := FND_API.g_miss_char;
3562: l_listheader_rec.random_list_id := FND_API.g_miss_num;
3563: l_listheader_rec.enabled_flag := FND_API.g_miss_char;
3564: l_listheader_rec.assigned_to := FND_API.g_miss_num;
3565: l_listheader_rec.query_id := FND_API.g_miss_num;
3566: l_listheader_rec.owner_person_id := FND_API.g_miss_num;
3559: l_listheader_rec.list_source := FND_API.g_miss_char;
3560: l_listheader_rec.list_source_type := FND_API.g_miss_char;
3561: l_listheader_rec.list_online_flag := FND_API.g_miss_char;
3562: l_listheader_rec.random_list_id := FND_API.g_miss_num;
3563: l_listheader_rec.enabled_flag := FND_API.g_miss_char;
3564: l_listheader_rec.assigned_to := FND_API.g_miss_num;
3565: l_listheader_rec.query_id := FND_API.g_miss_num;
3566: l_listheader_rec.owner_person_id := FND_API.g_miss_num;
3567: l_listheader_rec.archived_by := FND_API.g_miss_num;
3560: l_listheader_rec.list_source_type := FND_API.g_miss_char;
3561: l_listheader_rec.list_online_flag := FND_API.g_miss_char;
3562: l_listheader_rec.random_list_id := FND_API.g_miss_num;
3563: l_listheader_rec.enabled_flag := FND_API.g_miss_char;
3564: l_listheader_rec.assigned_to := FND_API.g_miss_num;
3565: l_listheader_rec.query_id := FND_API.g_miss_num;
3566: l_listheader_rec.owner_person_id := FND_API.g_miss_num;
3567: l_listheader_rec.archived_by := FND_API.g_miss_num;
3568: l_listheader_rec.archived_date := FND_API.g_miss_date;
3561: l_listheader_rec.list_online_flag := FND_API.g_miss_char;
3562: l_listheader_rec.random_list_id := FND_API.g_miss_num;
3563: l_listheader_rec.enabled_flag := FND_API.g_miss_char;
3564: l_listheader_rec.assigned_to := FND_API.g_miss_num;
3565: l_listheader_rec.query_id := FND_API.g_miss_num;
3566: l_listheader_rec.owner_person_id := FND_API.g_miss_num;
3567: l_listheader_rec.archived_by := FND_API.g_miss_num;
3568: l_listheader_rec.archived_date := FND_API.g_miss_date;
3569: l_listheader_rec.attribute_category := FND_API.g_miss_char;
3562: l_listheader_rec.random_list_id := FND_API.g_miss_num;
3563: l_listheader_rec.enabled_flag := FND_API.g_miss_char;
3564: l_listheader_rec.assigned_to := FND_API.g_miss_num;
3565: l_listheader_rec.query_id := FND_API.g_miss_num;
3566: l_listheader_rec.owner_person_id := FND_API.g_miss_num;
3567: l_listheader_rec.archived_by := FND_API.g_miss_num;
3568: l_listheader_rec.archived_date := FND_API.g_miss_date;
3569: l_listheader_rec.attribute_category := FND_API.g_miss_char;
3570: l_listheader_rec.attribute1 := FND_API.g_miss_char;
3563: l_listheader_rec.enabled_flag := FND_API.g_miss_char;
3564: l_listheader_rec.assigned_to := FND_API.g_miss_num;
3565: l_listheader_rec.query_id := FND_API.g_miss_num;
3566: l_listheader_rec.owner_person_id := FND_API.g_miss_num;
3567: l_listheader_rec.archived_by := FND_API.g_miss_num;
3568: l_listheader_rec.archived_date := FND_API.g_miss_date;
3569: l_listheader_rec.attribute_category := FND_API.g_miss_char;
3570: l_listheader_rec.attribute1 := FND_API.g_miss_char;
3571: l_listheader_rec.attribute2 := FND_API.g_miss_char;
3564: l_listheader_rec.assigned_to := FND_API.g_miss_num;
3565: l_listheader_rec.query_id := FND_API.g_miss_num;
3566: l_listheader_rec.owner_person_id := FND_API.g_miss_num;
3567: l_listheader_rec.archived_by := FND_API.g_miss_num;
3568: l_listheader_rec.archived_date := FND_API.g_miss_date;
3569: l_listheader_rec.attribute_category := FND_API.g_miss_char;
3570: l_listheader_rec.attribute1 := FND_API.g_miss_char;
3571: l_listheader_rec.attribute2 := FND_API.g_miss_char;
3572: l_listheader_rec.attribute3 := FND_API.g_miss_char;
3565: l_listheader_rec.query_id := FND_API.g_miss_num;
3566: l_listheader_rec.owner_person_id := FND_API.g_miss_num;
3567: l_listheader_rec.archived_by := FND_API.g_miss_num;
3568: l_listheader_rec.archived_date := FND_API.g_miss_date;
3569: l_listheader_rec.attribute_category := FND_API.g_miss_char;
3570: l_listheader_rec.attribute1 := FND_API.g_miss_char;
3571: l_listheader_rec.attribute2 := FND_API.g_miss_char;
3572: l_listheader_rec.attribute3 := FND_API.g_miss_char;
3573: l_listheader_rec.attribute4 := FND_API.g_miss_char;
3566: l_listheader_rec.owner_person_id := FND_API.g_miss_num;
3567: l_listheader_rec.archived_by := FND_API.g_miss_num;
3568: l_listheader_rec.archived_date := FND_API.g_miss_date;
3569: l_listheader_rec.attribute_category := FND_API.g_miss_char;
3570: l_listheader_rec.attribute1 := FND_API.g_miss_char;
3571: l_listheader_rec.attribute2 := FND_API.g_miss_char;
3572: l_listheader_rec.attribute3 := FND_API.g_miss_char;
3573: l_listheader_rec.attribute4 := FND_API.g_miss_char;
3574: l_listheader_rec.attribute5 := FND_API.g_miss_char;
3567: l_listheader_rec.archived_by := FND_API.g_miss_num;
3568: l_listheader_rec.archived_date := FND_API.g_miss_date;
3569: l_listheader_rec.attribute_category := FND_API.g_miss_char;
3570: l_listheader_rec.attribute1 := FND_API.g_miss_char;
3571: l_listheader_rec.attribute2 := FND_API.g_miss_char;
3572: l_listheader_rec.attribute3 := FND_API.g_miss_char;
3573: l_listheader_rec.attribute4 := FND_API.g_miss_char;
3574: l_listheader_rec.attribute5 := FND_API.g_miss_char;
3575: l_listheader_rec.attribute6 := FND_API.g_miss_char;
3568: l_listheader_rec.archived_date := FND_API.g_miss_date;
3569: l_listheader_rec.attribute_category := FND_API.g_miss_char;
3570: l_listheader_rec.attribute1 := FND_API.g_miss_char;
3571: l_listheader_rec.attribute2 := FND_API.g_miss_char;
3572: l_listheader_rec.attribute3 := FND_API.g_miss_char;
3573: l_listheader_rec.attribute4 := FND_API.g_miss_char;
3574: l_listheader_rec.attribute5 := FND_API.g_miss_char;
3575: l_listheader_rec.attribute6 := FND_API.g_miss_char;
3576: l_listheader_rec.attribute7 := FND_API.g_miss_char;
3569: l_listheader_rec.attribute_category := FND_API.g_miss_char;
3570: l_listheader_rec.attribute1 := FND_API.g_miss_char;
3571: l_listheader_rec.attribute2 := FND_API.g_miss_char;
3572: l_listheader_rec.attribute3 := FND_API.g_miss_char;
3573: l_listheader_rec.attribute4 := FND_API.g_miss_char;
3574: l_listheader_rec.attribute5 := FND_API.g_miss_char;
3575: l_listheader_rec.attribute6 := FND_API.g_miss_char;
3576: l_listheader_rec.attribute7 := FND_API.g_miss_char;
3577: l_listheader_rec.attribute8 := FND_API.g_miss_char;
3570: l_listheader_rec.attribute1 := FND_API.g_miss_char;
3571: l_listheader_rec.attribute2 := FND_API.g_miss_char;
3572: l_listheader_rec.attribute3 := FND_API.g_miss_char;
3573: l_listheader_rec.attribute4 := FND_API.g_miss_char;
3574: l_listheader_rec.attribute5 := FND_API.g_miss_char;
3575: l_listheader_rec.attribute6 := FND_API.g_miss_char;
3576: l_listheader_rec.attribute7 := FND_API.g_miss_char;
3577: l_listheader_rec.attribute8 := FND_API.g_miss_char;
3578: l_listheader_rec.attribute9 := FND_API.g_miss_char;
3571: l_listheader_rec.attribute2 := FND_API.g_miss_char;
3572: l_listheader_rec.attribute3 := FND_API.g_miss_char;
3573: l_listheader_rec.attribute4 := FND_API.g_miss_char;
3574: l_listheader_rec.attribute5 := FND_API.g_miss_char;
3575: l_listheader_rec.attribute6 := FND_API.g_miss_char;
3576: l_listheader_rec.attribute7 := FND_API.g_miss_char;
3577: l_listheader_rec.attribute8 := FND_API.g_miss_char;
3578: l_listheader_rec.attribute9 := FND_API.g_miss_char;
3579: l_listheader_rec.attribute10 := FND_API.g_miss_char;
3572: l_listheader_rec.attribute3 := FND_API.g_miss_char;
3573: l_listheader_rec.attribute4 := FND_API.g_miss_char;
3574: l_listheader_rec.attribute5 := FND_API.g_miss_char;
3575: l_listheader_rec.attribute6 := FND_API.g_miss_char;
3576: l_listheader_rec.attribute7 := FND_API.g_miss_char;
3577: l_listheader_rec.attribute8 := FND_API.g_miss_char;
3578: l_listheader_rec.attribute9 := FND_API.g_miss_char;
3579: l_listheader_rec.attribute10 := FND_API.g_miss_char;
3580: l_listheader_rec.attribute11 := FND_API.g_miss_char;
3573: l_listheader_rec.attribute4 := FND_API.g_miss_char;
3574: l_listheader_rec.attribute5 := FND_API.g_miss_char;
3575: l_listheader_rec.attribute6 := FND_API.g_miss_char;
3576: l_listheader_rec.attribute7 := FND_API.g_miss_char;
3577: l_listheader_rec.attribute8 := FND_API.g_miss_char;
3578: l_listheader_rec.attribute9 := FND_API.g_miss_char;
3579: l_listheader_rec.attribute10 := FND_API.g_miss_char;
3580: l_listheader_rec.attribute11 := FND_API.g_miss_char;
3581: l_listheader_rec.attribute12 := FND_API.g_miss_char;
3574: l_listheader_rec.attribute5 := FND_API.g_miss_char;
3575: l_listheader_rec.attribute6 := FND_API.g_miss_char;
3576: l_listheader_rec.attribute7 := FND_API.g_miss_char;
3577: l_listheader_rec.attribute8 := FND_API.g_miss_char;
3578: l_listheader_rec.attribute9 := FND_API.g_miss_char;
3579: l_listheader_rec.attribute10 := FND_API.g_miss_char;
3580: l_listheader_rec.attribute11 := FND_API.g_miss_char;
3581: l_listheader_rec.attribute12 := FND_API.g_miss_char;
3582: l_listheader_rec.attribute13 := FND_API.g_miss_char;
3575: l_listheader_rec.attribute6 := FND_API.g_miss_char;
3576: l_listheader_rec.attribute7 := FND_API.g_miss_char;
3577: l_listheader_rec.attribute8 := FND_API.g_miss_char;
3578: l_listheader_rec.attribute9 := FND_API.g_miss_char;
3579: l_listheader_rec.attribute10 := FND_API.g_miss_char;
3580: l_listheader_rec.attribute11 := FND_API.g_miss_char;
3581: l_listheader_rec.attribute12 := FND_API.g_miss_char;
3582: l_listheader_rec.attribute13 := FND_API.g_miss_char;
3583: l_listheader_rec.attribute14 := FND_API.g_miss_char;
3576: l_listheader_rec.attribute7 := FND_API.g_miss_char;
3577: l_listheader_rec.attribute8 := FND_API.g_miss_char;
3578: l_listheader_rec.attribute9 := FND_API.g_miss_char;
3579: l_listheader_rec.attribute10 := FND_API.g_miss_char;
3580: l_listheader_rec.attribute11 := FND_API.g_miss_char;
3581: l_listheader_rec.attribute12 := FND_API.g_miss_char;
3582: l_listheader_rec.attribute13 := FND_API.g_miss_char;
3583: l_listheader_rec.attribute14 := FND_API.g_miss_char;
3584: l_listheader_rec.attribute15 := FND_API.g_miss_char;
3577: l_listheader_rec.attribute8 := FND_API.g_miss_char;
3578: l_listheader_rec.attribute9 := FND_API.g_miss_char;
3579: l_listheader_rec.attribute10 := FND_API.g_miss_char;
3580: l_listheader_rec.attribute11 := FND_API.g_miss_char;
3581: l_listheader_rec.attribute12 := FND_API.g_miss_char;
3582: l_listheader_rec.attribute13 := FND_API.g_miss_char;
3583: l_listheader_rec.attribute14 := FND_API.g_miss_char;
3584: l_listheader_rec.attribute15 := FND_API.g_miss_char;
3585: l_listheader_rec.timezone_id := FND_API.g_miss_num;
3578: l_listheader_rec.attribute9 := FND_API.g_miss_char;
3579: l_listheader_rec.attribute10 := FND_API.g_miss_char;
3580: l_listheader_rec.attribute11 := FND_API.g_miss_char;
3581: l_listheader_rec.attribute12 := FND_API.g_miss_char;
3582: l_listheader_rec.attribute13 := FND_API.g_miss_char;
3583: l_listheader_rec.attribute14 := FND_API.g_miss_char;
3584: l_listheader_rec.attribute15 := FND_API.g_miss_char;
3585: l_listheader_rec.timezone_id := FND_API.g_miss_num;
3586: l_listheader_rec.user_entered_start_time := FND_API.g_miss_date;
3579: l_listheader_rec.attribute10 := FND_API.g_miss_char;
3580: l_listheader_rec.attribute11 := FND_API.g_miss_char;
3581: l_listheader_rec.attribute12 := FND_API.g_miss_char;
3582: l_listheader_rec.attribute13 := FND_API.g_miss_char;
3583: l_listheader_rec.attribute14 := FND_API.g_miss_char;
3584: l_listheader_rec.attribute15 := FND_API.g_miss_char;
3585: l_listheader_rec.timezone_id := FND_API.g_miss_num;
3586: l_listheader_rec.user_entered_start_time := FND_API.g_miss_date;
3587: l_listheader_rec.user_status_id := FND_API.g_miss_num;
3580: l_listheader_rec.attribute11 := FND_API.g_miss_char;
3581: l_listheader_rec.attribute12 := FND_API.g_miss_char;
3582: l_listheader_rec.attribute13 := FND_API.g_miss_char;
3583: l_listheader_rec.attribute14 := FND_API.g_miss_char;
3584: l_listheader_rec.attribute15 := FND_API.g_miss_char;
3585: l_listheader_rec.timezone_id := FND_API.g_miss_num;
3586: l_listheader_rec.user_entered_start_time := FND_API.g_miss_date;
3587: l_listheader_rec.user_status_id := FND_API.g_miss_num;
3588: l_listheader_rec.quantum := FND_API.g_miss_num;
3581: l_listheader_rec.attribute12 := FND_API.g_miss_char;
3582: l_listheader_rec.attribute13 := FND_API.g_miss_char;
3583: l_listheader_rec.attribute14 := FND_API.g_miss_char;
3584: l_listheader_rec.attribute15 := FND_API.g_miss_char;
3585: l_listheader_rec.timezone_id := FND_API.g_miss_num;
3586: l_listheader_rec.user_entered_start_time := FND_API.g_miss_date;
3587: l_listheader_rec.user_status_id := FND_API.g_miss_num;
3588: l_listheader_rec.quantum := FND_API.g_miss_num;
3589: l_listheader_rec.release_control_alg_id := FND_API.g_miss_num;
3582: l_listheader_rec.attribute13 := FND_API.g_miss_char;
3583: l_listheader_rec.attribute14 := FND_API.g_miss_char;
3584: l_listheader_rec.attribute15 := FND_API.g_miss_char;
3585: l_listheader_rec.timezone_id := FND_API.g_miss_num;
3586: l_listheader_rec.user_entered_start_time := FND_API.g_miss_date;
3587: l_listheader_rec.user_status_id := FND_API.g_miss_num;
3588: l_listheader_rec.quantum := FND_API.g_miss_num;
3589: l_listheader_rec.release_control_alg_id := FND_API.g_miss_num;
3590: l_listheader_rec.dialing_method := FND_API.g_miss_char;
3583: l_listheader_rec.attribute14 := FND_API.g_miss_char;
3584: l_listheader_rec.attribute15 := FND_API.g_miss_char;
3585: l_listheader_rec.timezone_id := FND_API.g_miss_num;
3586: l_listheader_rec.user_entered_start_time := FND_API.g_miss_date;
3587: l_listheader_rec.user_status_id := FND_API.g_miss_num;
3588: l_listheader_rec.quantum := FND_API.g_miss_num;
3589: l_listheader_rec.release_control_alg_id := FND_API.g_miss_num;
3590: l_listheader_rec.dialing_method := FND_API.g_miss_char;
3591: l_listheader_rec.calling_calendar_id := FND_API.g_miss_num;
3584: l_listheader_rec.attribute15 := FND_API.g_miss_char;
3585: l_listheader_rec.timezone_id := FND_API.g_miss_num;
3586: l_listheader_rec.user_entered_start_time := FND_API.g_miss_date;
3587: l_listheader_rec.user_status_id := FND_API.g_miss_num;
3588: l_listheader_rec.quantum := FND_API.g_miss_num;
3589: l_listheader_rec.release_control_alg_id := FND_API.g_miss_num;
3590: l_listheader_rec.dialing_method := FND_API.g_miss_char;
3591: l_listheader_rec.calling_calendar_id := FND_API.g_miss_num;
3592: l_listheader_rec.release_strategy := FND_API.g_miss_char;
3585: l_listheader_rec.timezone_id := FND_API.g_miss_num;
3586: l_listheader_rec.user_entered_start_time := FND_API.g_miss_date;
3587: l_listheader_rec.user_status_id := FND_API.g_miss_num;
3588: l_listheader_rec.quantum := FND_API.g_miss_num;
3589: l_listheader_rec.release_control_alg_id := FND_API.g_miss_num;
3590: l_listheader_rec.dialing_method := FND_API.g_miss_char;
3591: l_listheader_rec.calling_calendar_id := FND_API.g_miss_num;
3592: l_listheader_rec.release_strategy := FND_API.g_miss_char;
3593: l_listheader_rec.custom_setup_id := FND_API.g_miss_num;
3586: l_listheader_rec.user_entered_start_time := FND_API.g_miss_date;
3587: l_listheader_rec.user_status_id := FND_API.g_miss_num;
3588: l_listheader_rec.quantum := FND_API.g_miss_num;
3589: l_listheader_rec.release_control_alg_id := FND_API.g_miss_num;
3590: l_listheader_rec.dialing_method := FND_API.g_miss_char;
3591: l_listheader_rec.calling_calendar_id := FND_API.g_miss_num;
3592: l_listheader_rec.release_strategy := FND_API.g_miss_char;
3593: l_listheader_rec.custom_setup_id := FND_API.g_miss_num;
3594: l_listheader_rec.country := FND_API.g_miss_num;
3587: l_listheader_rec.user_status_id := FND_API.g_miss_num;
3588: l_listheader_rec.quantum := FND_API.g_miss_num;
3589: l_listheader_rec.release_control_alg_id := FND_API.g_miss_num;
3590: l_listheader_rec.dialing_method := FND_API.g_miss_char;
3591: l_listheader_rec.calling_calendar_id := FND_API.g_miss_num;
3592: l_listheader_rec.release_strategy := FND_API.g_miss_char;
3593: l_listheader_rec.custom_setup_id := FND_API.g_miss_num;
3594: l_listheader_rec.country := FND_API.g_miss_num;
3595: l_listheader_rec.callback_priority_flag := FND_API.g_miss_char;
3588: l_listheader_rec.quantum := FND_API.g_miss_num;
3589: l_listheader_rec.release_control_alg_id := FND_API.g_miss_num;
3590: l_listheader_rec.dialing_method := FND_API.g_miss_char;
3591: l_listheader_rec.calling_calendar_id := FND_API.g_miss_num;
3592: l_listheader_rec.release_strategy := FND_API.g_miss_char;
3593: l_listheader_rec.custom_setup_id := FND_API.g_miss_num;
3594: l_listheader_rec.country := FND_API.g_miss_num;
3595: l_listheader_rec.callback_priority_flag := FND_API.g_miss_char;
3596: l_listheader_rec.call_center_ready_flag := FND_API.g_miss_char;
3589: l_listheader_rec.release_control_alg_id := FND_API.g_miss_num;
3590: l_listheader_rec.dialing_method := FND_API.g_miss_char;
3591: l_listheader_rec.calling_calendar_id := FND_API.g_miss_num;
3592: l_listheader_rec.release_strategy := FND_API.g_miss_char;
3593: l_listheader_rec.custom_setup_id := FND_API.g_miss_num;
3594: l_listheader_rec.country := FND_API.g_miss_num;
3595: l_listheader_rec.callback_priority_flag := FND_API.g_miss_char;
3596: l_listheader_rec.call_center_ready_flag := FND_API.g_miss_char;
3597: l_listheader_rec.language := FND_API.g_miss_char;
3590: l_listheader_rec.dialing_method := FND_API.g_miss_char;
3591: l_listheader_rec.calling_calendar_id := FND_API.g_miss_num;
3592: l_listheader_rec.release_strategy := FND_API.g_miss_char;
3593: l_listheader_rec.custom_setup_id := FND_API.g_miss_num;
3594: l_listheader_rec.country := FND_API.g_miss_num;
3595: l_listheader_rec.callback_priority_flag := FND_API.g_miss_char;
3596: l_listheader_rec.call_center_ready_flag := FND_API.g_miss_char;
3597: l_listheader_rec.language := FND_API.g_miss_char;
3598: l_listheader_rec.purge_flag := FND_API.g_miss_char;
3591: l_listheader_rec.calling_calendar_id := FND_API.g_miss_num;
3592: l_listheader_rec.release_strategy := FND_API.g_miss_char;
3593: l_listheader_rec.custom_setup_id := FND_API.g_miss_num;
3594: l_listheader_rec.country := FND_API.g_miss_num;
3595: l_listheader_rec.callback_priority_flag := FND_API.g_miss_char;
3596: l_listheader_rec.call_center_ready_flag := FND_API.g_miss_char;
3597: l_listheader_rec.language := FND_API.g_miss_char;
3598: l_listheader_rec.purge_flag := FND_API.g_miss_char;
3599: l_listheader_rec.public_flag := FND_API.g_miss_char;
3592: l_listheader_rec.release_strategy := FND_API.g_miss_char;
3593: l_listheader_rec.custom_setup_id := FND_API.g_miss_num;
3594: l_listheader_rec.country := FND_API.g_miss_num;
3595: l_listheader_rec.callback_priority_flag := FND_API.g_miss_char;
3596: l_listheader_rec.call_center_ready_flag := FND_API.g_miss_char;
3597: l_listheader_rec.language := FND_API.g_miss_char;
3598: l_listheader_rec.purge_flag := FND_API.g_miss_char;
3599: l_listheader_rec.public_flag := FND_API.g_miss_char;
3600: l_listheader_rec.list_category := FND_API.g_miss_char;
3593: l_listheader_rec.custom_setup_id := FND_API.g_miss_num;
3594: l_listheader_rec.country := FND_API.g_miss_num;
3595: l_listheader_rec.callback_priority_flag := FND_API.g_miss_char;
3596: l_listheader_rec.call_center_ready_flag := FND_API.g_miss_char;
3597: l_listheader_rec.language := FND_API.g_miss_char;
3598: l_listheader_rec.purge_flag := FND_API.g_miss_char;
3599: l_listheader_rec.public_flag := FND_API.g_miss_char;
3600: l_listheader_rec.list_category := FND_API.g_miss_char;
3601: l_listheader_rec.quota := FND_API.g_miss_num;
3594: l_listheader_rec.country := FND_API.g_miss_num;
3595: l_listheader_rec.callback_priority_flag := FND_API.g_miss_char;
3596: l_listheader_rec.call_center_ready_flag := FND_API.g_miss_char;
3597: l_listheader_rec.language := FND_API.g_miss_char;
3598: l_listheader_rec.purge_flag := FND_API.g_miss_char;
3599: l_listheader_rec.public_flag := FND_API.g_miss_char;
3600: l_listheader_rec.list_category := FND_API.g_miss_char;
3601: l_listheader_rec.quota := FND_API.g_miss_num;
3602: l_listheader_rec.quota_reset := FND_API.g_miss_num;
3595: l_listheader_rec.callback_priority_flag := FND_API.g_miss_char;
3596: l_listheader_rec.call_center_ready_flag := FND_API.g_miss_char;
3597: l_listheader_rec.language := FND_API.g_miss_char;
3598: l_listheader_rec.purge_flag := FND_API.g_miss_char;
3599: l_listheader_rec.public_flag := FND_API.g_miss_char;
3600: l_listheader_rec.list_category := FND_API.g_miss_char;
3601: l_listheader_rec.quota := FND_API.g_miss_num;
3602: l_listheader_rec.quota_reset := FND_API.g_miss_num;
3603: l_listheader_rec.recycling_alg_id := FND_API.g_miss_num;
3596: l_listheader_rec.call_center_ready_flag := FND_API.g_miss_char;
3597: l_listheader_rec.language := FND_API.g_miss_char;
3598: l_listheader_rec.purge_flag := FND_API.g_miss_char;
3599: l_listheader_rec.public_flag := FND_API.g_miss_char;
3600: l_listheader_rec.list_category := FND_API.g_miss_char;
3601: l_listheader_rec.quota := FND_API.g_miss_num;
3602: l_listheader_rec.quota_reset := FND_API.g_miss_num;
3603: l_listheader_rec.recycling_alg_id := FND_API.g_miss_num;
3604: l_listheader_rec.source_lang := FND_API.g_miss_char;
3597: l_listheader_rec.language := FND_API.g_miss_char;
3598: l_listheader_rec.purge_flag := FND_API.g_miss_char;
3599: l_listheader_rec.public_flag := FND_API.g_miss_char;
3600: l_listheader_rec.list_category := FND_API.g_miss_char;
3601: l_listheader_rec.quota := FND_API.g_miss_num;
3602: l_listheader_rec.quota_reset := FND_API.g_miss_num;
3603: l_listheader_rec.recycling_alg_id := FND_API.g_miss_num;
3604: l_listheader_rec.source_lang := FND_API.g_miss_char;
3605:
3598: l_listheader_rec.purge_flag := FND_API.g_miss_char;
3599: l_listheader_rec.public_flag := FND_API.g_miss_char;
3600: l_listheader_rec.list_category := FND_API.g_miss_char;
3601: l_listheader_rec.quota := FND_API.g_miss_num;
3602: l_listheader_rec.quota_reset := FND_API.g_miss_num;
3603: l_listheader_rec.recycling_alg_id := FND_API.g_miss_num;
3604: l_listheader_rec.source_lang := FND_API.g_miss_char;
3605:
3606: G_LISTHEADER_REC_INITIAL := 1;
3599: l_listheader_rec.public_flag := FND_API.g_miss_char;
3600: l_listheader_rec.list_category := FND_API.g_miss_char;
3601: l_listheader_rec.quota := FND_API.g_miss_num;
3602: l_listheader_rec.quota_reset := FND_API.g_miss_num;
3603: l_listheader_rec.recycling_alg_id := FND_API.g_miss_num;
3604: l_listheader_rec.source_lang := FND_API.g_miss_char;
3605:
3606: G_LISTHEADER_REC_INITIAL := 1;
3607: END IF;
3600: l_listheader_rec.list_category := FND_API.g_miss_char;
3601: l_listheader_rec.quota := FND_API.g_miss_num;
3602: l_listheader_rec.quota_reset := FND_API.g_miss_num;
3603: l_listheader_rec.recycling_alg_id := FND_API.g_miss_num;
3604: l_listheader_rec.source_lang := FND_API.g_miss_char;
3605:
3606: G_LISTHEADER_REC_INITIAL := 1;
3607: END IF;
3608:
3619: x_msg_count => l_msg_count,
3620: x_msg_data => l_msg_data,
3621: p_listheader_rec => l_listheader_rec);
3622:
3623: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3624: Log_msg('AMS_LISTHEADER_PUB.Update_ListHeader', l_msg_data);
3625: END IF;
3626:
3627: /*
3654: , SQLERRM
3655:
3656: );
3657:
3658: RAISE fnd_api.g_exc_unexpected_error;
3659:
3660:
3661:
3662: END Update_AmsListHeaderCounts;
3714: );
3715:
3716: ROLLBACK;
3717:
3718: RAISE fnd_api.g_exc_unexpected_error;
3719:
3720:
3721:
3722: END Update_MoveEntriesStatusCounts;
3978: );
3979:
3980: ROLLBACK;
3981:
3982: RAISE fnd_api.g_exc_unexpected_error;
3983:
3984:
3985:
3986: END Update_MoveEntriesStatus;
4034: IF l_count = 0 THEN
4035:
4036: Log_ListRtInfoDNE('Update_PurgeStatus', 'CHECK_LIST_RT_INFO', Get_ScheduleName(p_schedule_id));
4037:
4038: RAISE fnd_api.g_exc_error;
4039:
4040: END IF;
4041:
4042:
4064: WHEN OTHERS THEN
4065:
4066: Log_StatusUpdateError('Update_PurgeStatus', 'DO_MKT_STATUS_UPDATE', Get_ListName(p_list_id));
4067:
4068: RAISE fnd_api.g_exc_unexpected_error;
4069:
4070: END;
4071:
4072:
4074: COMMIT;
4075:
4076: EXCEPTION
4077:
4078: WHEN fnd_api.g_exc_error THEN
4079:
4080: ROLLBACK;
4081:
4082: IF p_status <> 'FAILED_VALIDATION' THEN
4084: RAISE;
4085:
4086: END IF;
4087:
4088: WHEN fnd_api.g_exc_unexpected_error THEN
4089:
4090: ROLLBACK;
4091:
4092: IF p_status <> 'FAILED_VALIDATION' THEN
4102: Log('UPDATE_STATUS', 'MAIN', SQLERRM);
4103:
4104: IF p_status <> 'FAILED_VALIDATION' THEN
4105:
4106: RAISE fnd_api.g_exc_unexpected_error;
4107:
4108: END IF;
4109:
4110:
4190: IF SQLCODE = -904 THEN
4191:
4192: Log_MissingSourceTypeColumns(p_list_id, p_source_type_view, Get_SourceType(p_list_id), 'UPDATE_AMS_LIST_ENTRIES', 'UPDATE_LIST_ENTRIES');
4193:
4194: RAISE fnd_api.g_exc_unexpected_error;
4195:
4196: ELSE
4197:
4198: Log( 'Update_AmsListEntries'
4202: , SQLERRM
4203:
4204: );
4205:
4206: RAISE fnd_api.g_exc_unexpected_error;
4207:
4208: END IF;
4209:
4210: END Update_AmsListEntries;
4298: , SQLERRM
4299:
4300: );
4301:
4302: RAISE fnd_api.g_exc_unexpected_error;
4303:
4304: END;
4305:
4306:
4340: , SQLERRM
4341:
4342: );
4343:
4344: RAISE fnd_api.g_exc_unexpected_error;
4345:
4346: END;
4347:
4348:
4438: , SQLERRM
4439:
4440: );
4441:
4442: RAISE fnd_api.g_exc_unexpected_error;
4443:
4444: END;
4445:
4446:
4446:
4447:
4448: EXCEPTION
4449:
4450: WHEN fnd_api.g_exc_error THEN
4451:
4452: ROLLBACK;
4453:
4454: RAISE;
4452: ROLLBACK;
4453:
4454: RAISE;
4455:
4456: WHEN fnd_api.g_exc_unexpected_error THEN
4457:
4458: ROLLBACK;
4459:
4460: RAISE;
4470: , SQLERRM
4471:
4472: );
4473:
4474: RAISE fnd_api.g_exc_unexpected_error;
4475:
4476:
4477:
4478: END Update_ValidationReportDetails;
5020: , SQLERRM
5021:
5022: );
5023:
5024: RAISE fnd_api.g_exc_unexpected_error;
5025:
5026:
5027:
5028: END Update_CallableZones;
5076: , SQLERRM
5077:
5078: );
5079:
5080: RAISE fnd_api.g_exc_unexpected_error;
5081:
5082:
5083:
5084: END Incr_RecordsLoadedCounts;
5124: , SQLERRM
5125:
5126: );
5127:
5128: RAISE fnd_api.g_exc_unexpected_error;
5129:
5130:
5131:
5132: END Incr_CallableZoneCounts;
5172: , SQLERRM
5173:
5174: );
5175:
5176: RAISE fnd_api.g_exc_unexpected_error;
5177:
5178:
5179:
5180: END Incr_CallableZoneCounts_Cache;
5298: , SQLERRM
5299:
5300: );
5301:
5302: RAISE fnd_api.g_exc_unexpected_error;
5303:
5304:
5305:
5306: END Get_CallableZoneDetail;
5396: , SQLERRM
5397:
5398: );
5399:
5400: RAISE fnd_api.g_exc_unexpected_error;
5401:
5402:
5403:
5404: END Get_CallableZoneDetail_Cache;
5584: , SQLERRM
5585:
5586: );
5587:
5588: RAISE fnd_api.g_exc_unexpected_error;
5589:
5590:
5591:
5592: END Purge_CallableZones;
5706: , SQLERRM
5707:
5708: );
5709:
5710: RAISE fnd_api.g_exc_unexpected_error;
5711:
5712: END;
5713:
5714:
5746: , SQLERRM
5747:
5748: );
5749:
5750: RAISE fnd_api.g_exc_unexpected_error;
5751:
5752: END;
5753:
5754:
5904: , SQLERRM
5905:
5906: );
5907:
5908: RAISE fnd_api.g_exc_unexpected_error;
5909:
5910: END;
5911:
5912:
5912:
5913:
5914: EXCEPTION
5915:
5916: WHEN fnd_api.g_exc_error THEN
5917:
5918: RAISE;
5919:
5920: WHEN fnd_api.g_exc_unexpected_error THEN
5916: WHEN fnd_api.g_exc_error THEN
5917:
5918: RAISE;
5919:
5920: WHEN fnd_api.g_exc_unexpected_error THEN
5921:
5922: RAISE;
5923:
5924: WHEN OTHERS THEN
5930: , SQLERRM
5931:
5932: );
5933:
5934: RAISE fnd_api.g_exc_unexpected_error;
5935:
5936:
5937:
5938: END Update_IecReturnEntries;
6050: , l_return_code);
6051:
6052:
6053:
6054: IF l_return_code <> FND_API.G_RET_STS_SUCCESS THEN
6055:
6056: Log_GetSubsetViewError('Init_SubsetRtInfo', 'GET_SUBSET_VIEW', Get_SubsetName(l_subset_id), Get_ListName(p_list_id));
6057:
6058: RAISE fnd_api.g_exc_unexpected_error;
6054: IF l_return_code <> FND_API.G_RET_STS_SUCCESS THEN
6055:
6056: Log_GetSubsetViewError('Init_SubsetRtInfo', 'GET_SUBSET_VIEW', Get_SubsetName(l_subset_id), Get_ListName(p_list_id));
6057:
6058: RAISE fnd_api.g_exc_unexpected_error;
6059:
6060: END IF;
6061:
6062:
6118: , l_return_code);
6119:
6120:
6121:
6122: IF l_return_code <> FND_API.G_RET_STS_SUCCESS THEN
6123:
6124: Log_GetSubsetViewError('Init_SubsetRtInfo', 'GET_SUBSET_VIEW', Get_SubsetName(l_subset_id), Get_ListName(p_list_id));
6125:
6126: Log('Init_SubsetRtInfo', 'GET_SUBSET_VIEW');
6124: Log_GetSubsetViewError('Init_SubsetRtInfo', 'GET_SUBSET_VIEW', Get_SubsetName(l_subset_id), Get_ListName(p_list_id));
6125:
6126: Log('Init_SubsetRtInfo', 'GET_SUBSET_VIEW');
6127:
6128: RAISE fnd_api.g_exc_unexpected_error;
6129:
6130: END IF;
6131:
6132:
6142:
6143:
6144: EXCEPTION
6145:
6146: WHEN fnd_api.g_exc_error THEN
6147:
6148: RAISE;
6149:
6150: WHEN fnd_api.g_exc_unexpected_error THEN
6146: WHEN fnd_api.g_exc_error THEN
6147:
6148: RAISE;
6149:
6150: WHEN fnd_api.g_exc_unexpected_error THEN
6151:
6152: RAISE;
6153:
6154: WHEN OTHERS THEN
6160: , SQLERRM
6161:
6162: );
6163:
6164: RAISE fnd_api.g_exc_unexpected_error;
6165:
6166:
6167:
6168: END Init_SubsetRtInfo;
6226: ELSE
6227:
6228: Log_SubsetViewDoesNotExist('Partition_SubsetEntries', 'ASSIGN_ENTRIES_TO_SUBSET', Get_SubsetName(p_subset_id_col(i)), Get_ListName(p_list_id));
6229:
6230: RAISE fnd_api.g_exc_unexpected_error;
6231:
6232: END IF;
6233:
6234:
6290:
6291:
6292: EXCEPTION
6293:
6294: WHEN fnd_api.g_exc_error THEN
6295:
6296: RAISE;
6297:
6298: WHEN fnd_api.g_exc_unexpected_error THEN
6294: WHEN fnd_api.g_exc_error THEN
6295:
6296: RAISE;
6297:
6298: WHEN fnd_api.g_exc_unexpected_error THEN
6299:
6300: RAISE;
6301:
6302: WHEN OTHERS THEN
6308: , SQLERRM
6309:
6310: );
6311:
6312: RAISE fnd_api.g_exc_unexpected_error;
6313:
6314:
6315:
6316: END Partition_SubsetEntries;
6388:
6389:
6390: EXCEPTION
6391:
6392: WHEN fnd_api.g_exc_error THEN
6393:
6394: RAISE;
6395:
6396: WHEN fnd_api.g_exc_unexpected_error THEN
6392: WHEN fnd_api.g_exc_error THEN
6393:
6394: RAISE;
6395:
6396: WHEN fnd_api.g_exc_unexpected_error THEN
6397:
6398: RAISE;
6399:
6400: WHEN OTHERS THEN
6406: , SQLERRM
6407:
6408: );
6409:
6410: RAISE fnd_api.g_exc_unexpected_error;
6411:
6412:
6413:
6414: END Parse_Country_Code;
6528: , SQLERRM
6529:
6530: );
6531:
6532: RAISE fnd_api.g_exc_unexpected_error;
6533:
6534: END;
6535:
6536:
6596: , SQLERRM
6597:
6598: );
6599:
6600: RAISE fnd_api.g_exc_unexpected_error;
6601:
6602: END;
6603:
6604:
6684: , SQLERRM
6685:
6686: );
6687:
6688: RAISE fnd_api.g_exc_unexpected_error;
6689:
6690: END;
6691:
6692: END IF;
6730:
6731:
6732: EXCEPTION
6733:
6734: WHEN fnd_api.g_exc_error THEN
6735:
6736: RAISE;
6737:
6738: WHEN fnd_api.g_exc_unexpected_error THEN
6734: WHEN fnd_api.g_exc_error THEN
6735:
6736: RAISE;
6737:
6738: WHEN fnd_api.g_exc_unexpected_error THEN
6739:
6740: RAISE;
6741:
6742: WHEN OTHERS THEN
6748: , SQLERRM
6749:
6750: );
6751:
6752: RAISE fnd_api.g_exc_unexpected_error;
6753:
6754:
6755:
6756: END Parse_Area_Code;
6786: , SQLERRM
6787:
6788: );
6789:
6790: RAISE fnd_api.g_exc_unexpected_error;
6791:
6792:
6793:
6794: END Create_Canonical_Number;
6886: , SQLERRM
6887:
6888: );
6889:
6890: RAISE fnd_api.g_exc_unexpected_error;
6891:
6892: END;
6893:
6894: END IF;
6896:
6897:
6898: EXCEPTION
6899:
6900: WHEN fnd_api.g_exc_error THEN
6901:
6902: RAISE;
6903:
6904: WHEN fnd_api.g_exc_unexpected_error THEN
6900: WHEN fnd_api.g_exc_error THEN
6901:
6902: RAISE;
6903:
6904: WHEN fnd_api.g_exc_unexpected_error THEN
6905:
6906: RAISE;
6907:
6908: WHEN OTHERS THEN
6914: , SQLERRM
6915:
6916: );
6917:
6918: RAISE fnd_api.g_exc_unexpected_error;
6919:
6920:
6921:
6922: END Get_Territory_Code;
7000: , SQLERRM
7001:
7002: );
7003:
7004: RAISE fnd_api.g_exc_unexpected_error;
7005:
7006: END;
7007:
7008:
7046: , SQLERRM
7047:
7048: );
7049:
7050: RAISE fnd_api.g_exc_unexpected_error;
7051:
7052: END;
7053:
7054: END IF;
7118: , SQLERRM
7119:
7120: );
7121:
7122: RAISE fnd_api.g_exc_unexpected_error;
7123:
7124: END;
7125:
7126:
7230: , SQLERRM
7231:
7232: );
7233:
7234: RAISE fnd_api.g_exc_unexpected_error;
7235:
7236: END;
7237:
7238: END IF;
7260:
7261:
7262: EXCEPTION
7263:
7264: WHEN fnd_api.g_exc_error THEN
7265:
7266: RAISE;
7267:
7268: WHEN fnd_api.g_exc_unexpected_error THEN
7264: WHEN fnd_api.g_exc_error THEN
7265:
7266: RAISE;
7267:
7268: WHEN fnd_api.g_exc_unexpected_error THEN
7269:
7270: RAISE;
7271:
7272: WHEN OTHERS THEN
7278: , SQLERRM
7279:
7280: );
7281:
7282: RAISE fnd_api.g_exc_unexpected_error;
7283:
7284:
7285:
7286: END Get_Timezone_Id;
7416:
7417:
7418: EXCEPTION
7419:
7420: WHEN fnd_api.g_exc_error THEN
7421:
7422: RAISE;
7423:
7424: WHEN fnd_api.g_exc_unexpected_error THEN
7420: WHEN fnd_api.g_exc_error THEN
7421:
7422: RAISE;
7423:
7424: WHEN fnd_api.g_exc_unexpected_error THEN
7425:
7426: RAISE;
7427:
7428: WHEN OTHERS THEN
7434: , SQLERRM
7435:
7436: );
7437:
7438: RAISE fnd_api.g_exc_unexpected_error;
7439:
7440:
7441:
7442: END Validate_Canonical_Number;
7552:
7553:
7554: EXCEPTION
7555:
7556: WHEN fnd_api.g_exc_error THEN
7557:
7558: RAISE;
7559:
7560: WHEN fnd_api.g_exc_unexpected_error THEN
7556: WHEN fnd_api.g_exc_error THEN
7557:
7558: RAISE;
7559:
7560: WHEN fnd_api.g_exc_unexpected_error THEN
7561:
7562: RAISE;
7563:
7564: WHEN OTHERS THEN
7570: , SQLERRM
7571:
7572: );
7573:
7574: RAISE fnd_api.g_exc_unexpected_error;
7575:
7576:
7577:
7578: END Validate_Non_Canonical_Number;
7728:
7729:
7730: EXCEPTION
7731:
7732: WHEN fnd_api.g_exc_error THEN
7733:
7734: RAISE;
7735:
7736: WHEN fnd_api.g_exc_unexpected_error THEN
7732: WHEN fnd_api.g_exc_error THEN
7733:
7734: RAISE;
7735:
7736: WHEN fnd_api.g_exc_unexpected_error THEN
7737:
7738: RAISE;
7739:
7740: WHEN OTHERS THEN
7746: , SQLERRM
7747:
7748: );
7749:
7750: RAISE fnd_api.g_exc_unexpected_error;
7751:
7752:
7753:
7754: END Validate_Composite_Number;
8046: , l_msg_data
8047:
8048: );
8049:
8050: RAISE fnd_api.g_exc_unexpected_error;
8051:
8052: END IF;
8053:
8054:
8118:
8119:
8120: EXCEPTION
8121:
8122: WHEN fnd_api.g_exc_error THEN
8123:
8124: RAISE;
8125:
8126: WHEN fnd_api.g_exc_unexpected_error THEN
8122: WHEN fnd_api.g_exc_error THEN
8123:
8124: RAISE;
8125:
8126: WHEN fnd_api.g_exc_unexpected_error THEN
8127:
8128: RAISE;
8129:
8130: WHEN OTHERS THEN
8136: , SQLERRM
8137:
8138: );
8139:
8140: RAISE fnd_api.g_exc_unexpected_error;
8141:
8142:
8143:
8144: END Validate_ContactPointRecord;
8238:
8239:
8240: EXCEPTION
8241:
8242: WHEN fnd_api.g_exc_error OR fnd_api.g_exc_unexpected_error THEN
8243:
8244: RAISE;
8245:
8246: WHEN OTHERS THEN
8252: , SQLERRM
8253:
8254: );
8255:
8256: RAISE fnd_api.g_exc_unexpected_error;
8257:
8258:
8259:
8260: END Validate_List_Entry;
8418: , SQLERRM
8419:
8420: );
8421:
8422: RAISE fnd_api.g_exc_unexpected_error;
8423:
8424:
8425:
8426: END Remove_Entries_Pvt;
8548: , SQLERRM
8549:
8550: );
8551:
8552: RAISE fnd_api.g_exc_unexpected_error;
8553:
8554:
8555:
8556: END Remove_DeletedRecords;
8654: THEN
8655:
8656: Log_PurgeListStatusInvMsg('Purge_ScheduleEntries_Pvt','CHECK_SCHEDULE_STATUS', Get_ScheduleName(p_schedule_id));
8657:
8658: RAISE fnd_api.g_exc_error;
8659:
8660: END IF;
8661:
8662:
8770:
8771:
8772: EXCEPTION
8773:
8774: WHEN fnd_api.g_exc_error THEN
8775:
8776: ROLLBACK TO purge_schedule_entries;
8777:
8778: -- Update_PurgeStatus(l_list_id, p_schedule_id, 'FAILED_PURGE', l_api_initiated);
8780: Update_PurgeStatus(l_list_id, p_schedule_id, l_status_code, l_api_initiated);
8781:
8782: RAISE_APPLICATION_ERROR(-20999, Get_TranslatedErrorMessage);
8783:
8784: WHEN fnd_api.g_exc_unexpected_error THEN
8785:
8786: ROLLBACK TO purge_schedule_entries;
8787:
8788: -- Update_PurgeStatus(l_list_id, p_schedule_id, 'FAILED_PURGE', l_api_initiated);
8830: IS
8831:
8832: BEGIN
8833:
8834: x_return_status := FND_API.G_RET_STS_SUCCESS;
8835:
8836:
8837:
8838: Purge_ScheduleEntries_Pvt
8852: WHEN OTHERS THEN
8853:
8854: FND_MSG_PUB.ADD;
8855:
8856: x_return_status := FND_API.G_RET_STS_ERROR;
8857:
8858: END Purge_ScheduleEntries_Pub;
8859:
8860:
9196: END IF;
9197:
9198: EXCEPTION
9199:
9200: WHEN fnd_api.g_exc_error THEN
9201:
9202: GOTO Next_List_Entry;
9203:
9204: WHEN fnd_api.g_exc_unexpected_error THEN
9200: WHEN fnd_api.g_exc_error THEN
9201:
9202: GOTO Next_List_Entry;
9203:
9204: WHEN fnd_api.g_exc_unexpected_error THEN
9205:
9206: GOTO Next_List_Entry;
9207:
9208: WHEN OTHERS THEN
9698:
9699:
9700: EXCEPTION
9701:
9702: WHEN fnd_api.g_exc_error THEN
9703:
9704: RAISE;
9705:
9706: WHEN fnd_api.g_exc_unexpected_error THEN
9702: WHEN fnd_api.g_exc_error THEN
9703:
9704: RAISE;
9705:
9706: WHEN fnd_api.g_exc_unexpected_error THEN
9707:
9708: RAISE;
9709:
9710: WHEN OTHERS THEN
9716: , SQLERRM
9717:
9718: );
9719:
9720: RAISE fnd_api.g_exc_unexpected_error;
9721:
9722:
9723:
9724: END Validate_List_Pvt;
9770: , SQLERRM
9771:
9772: );
9773:
9774: RAISE fnd_api.g_exc_unexpected_error;
9775:
9776: END;
9777:
9778:
9810: WHEN OTHERS THEN
9811:
9812: Log('Get_ScheduleId', 'MAIN');
9813:
9814: RAISE fnd_api.g_exc_unexpected_error;
9815:
9816:
9817:
9818: END Get_ScheduleId;
9860: , SQLERRM
9861:
9862: );
9863:
9864: RAISE fnd_api.g_exc_unexpected_error;
9865:
9866: END;
9867:
9868:
9938: );
9939:
9940: ROLLBACK;
9941:
9942: RAISE fnd_api.g_exc_unexpected_error;
9943:
9944: END Validate_List_Pre;
9945:
9946:
9978: );
9979:
9980: ROLLBACK;
9981:
9982: RAISE fnd_api.g_exc_unexpected_error;
9983:
9984: END Validate_List_Post;
9985:
9986:
10771: BEGIN
10772:
10773:
10774:
10775: x_return_code := FND_API.G_RET_STS_SUCCESS;
10776:
10777:
10778:
10779: -- Setup logging information
10807: -- Check to see if all entries are assigned to the list's source type
10808:
10809: IF NOT Verify_EntrySourceTypes(p_list_id) THEN
10810:
10811: RAISE fnd_api.g_exc_error;
10812:
10813: END IF;
10814:
10815:
10893: IF SQLCODE = -904 THEN
10894:
10895: Log_MissingSourceTypeColumns(p_list_id, l_source_type_view, Get_SourceType(p_list_id), 'VALIDATE_LIST', 'SELECT_ENTRIES_FOR_VALIDATION');
10896:
10897: RAISE fnd_api.g_exc_error;
10898:
10899: ELSE
10900:
10901: RAISE;
10980:
10981:
10982: EXCEPTION
10983:
10984: WHEN fnd_api.g_exc_error THEN
10985:
10986: x_return_code := FND_API.G_RET_STS_ERROR;
10987:
10988: ROLLBACK;
10982: EXCEPTION
10983:
10984: WHEN fnd_api.g_exc_error THEN
10985:
10986: x_return_code := FND_API.G_RET_STS_ERROR;
10987:
10988: ROLLBACK;
10989:
10990: Validate_List_Post(p_list_id);
10994: Insert_ValidationHistoryRec(p_list_id);
10995:
10996: RAISE_APPLICATION_ERROR(-20999, Get_TranslatedErrorMessage);
10997:
10998: WHEN fnd_api.g_exc_unexpected_error THEN
10999:
11000: x_return_code := FND_API.G_RET_STS_ERROR;
11001:
11002: ROLLBACK;
10996: RAISE_APPLICATION_ERROR(-20999, Get_TranslatedErrorMessage);
10997:
10998: WHEN fnd_api.g_exc_unexpected_error THEN
10999:
11000: x_return_code := FND_API.G_RET_STS_ERROR;
11001:
11002: ROLLBACK;
11003:
11004: Validate_List_Post(p_list_id);
11018: , SQLERRM
11019:
11020: );
11021:
11022: x_return_code := FND_API.G_RET_STS_ERROR;
11023:
11024: ROLLBACK;
11025:
11026: Validate_List_Post(p_list_id);
11051: l_msg_count NUMBER;
11052: l_msg_data VARCHAR2(2000);
11053: l_listentry_rec AMS_LISTENTRY_PVT.entry_rec_type;
11054: BEGIN
11055: l_init_msg_list :=FND_API.G_TRUE;
11056:
11057: x_to_list_entry_id_col := SYSTEM.number_tbl_type();
11058:
11059: x_to_list_entry_id_col.EXTEND(p_from_list_entry_id_col.COUNT);
11239: x_msg_data => l_msg_data,
11240: p_entry_rec => l_listentry_rec,
11241: x_entry_id => x_to_list_entry_id_col(i) );
11242:
11243: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
11244: Log_msg('AMS_LISTENTRY_PUB.create_listentry', l_msg_data);
11245: END IF;
11246: END LOOP;
11247: /*
11416: , SQLERRM
11417:
11418: );
11419:
11420: RAISE fnd_api.g_exc_unexpected_error;
11421:
11422:
11423:
11424: END Copy_AmsListEntries;
11646: , SQLERRM
11647:
11648: );
11649:
11650: RAISE fnd_api.g_exc_unexpected_error;
11651:
11652:
11653:
11654: END Mark_EntriesDoNotUse;
11882: , SQLERRM
11883:
11884: );
11885:
11886: RAISE fnd_api.g_exc_unexpected_error;
11887:
11888:
11889:
11890: END Move_CallHistory;
11968: EXCEPTION
11969: WHEN OTHERS THEN
11970: IF SQLCODE = -904 THEN
11971: Log_MissingSourceTypeColumns(p_list_id, l_source_type_view, Get_SourceType(p_list_id), 'LOAD_ENTRIES_PVT', 'SELECT_ENTRIES_FOR_LOAD');
11972: RAISE fnd_api.g_exc_error;
11973: ELSE
11974: RAISE;
11975: END IF;
11976: END;
12002:
12003:
12004: EXCEPTION
12005:
12006: WHEN fnd_api.g_exc_error THEN
12007:
12008: RAISE;
12009:
12010: WHEN OTHERS THEN
12016: , SQLERRM
12017:
12018: );
12019:
12020: RAISE fnd_api.g_exc_unexpected_error;
12021:
12022:
12023:
12024: END Load_Entries_Pvt;
12110: l_msg_count NUMBER;
12111: l_msg_data VARCHAR2(2000);
12112: l_listentry_rec AMS_LISTENTRY_PVT.entry_rec_type;
12113: BEGIN
12114: l_init_msg_list :=FND_API.G_TRUE;
12115:
12116: -- Update duplicate records in ams list entries
12117:
12118: -- From Source List to Destination List
12467: l_listentry_rec.col299 := v_listentryrec.col299;
12468: l_listentry_rec.col300 := v_listentryrec.col300;
12469: l_listentry_rec.address_line1 := v_listentryrec.address_line1;
12470: l_listentry_rec.address_line2 := v_listentryrec.address_line2;
12471: l_listentry_rec.callback_flag := FND_API.g_miss_char;
12472: l_listentry_rec.city := v_listentryrec.city;
12473: l_listentry_rec.country := v_listentryrec.country;
12474: l_listentry_rec.do_not_use_flag := FND_API.g_miss_char;
12475: l_listentry_rec.do_not_use_reason := FND_API.g_miss_char;
12470: l_listentry_rec.address_line2 := v_listentryrec.address_line2;
12471: l_listentry_rec.callback_flag := FND_API.g_miss_char;
12472: l_listentry_rec.city := v_listentryrec.city;
12473: l_listentry_rec.country := v_listentryrec.country;
12474: l_listentry_rec.do_not_use_flag := FND_API.g_miss_char;
12475: l_listentry_rec.do_not_use_reason := FND_API.g_miss_char;
12476: l_listentry_rec.email_address := v_listentryrec.email_address;
12477: l_listentry_rec.fax := v_listentryrec.fax;
12478: l_listentry_rec.phone := v_listentryrec.phone;
12471: l_listentry_rec.callback_flag := FND_API.g_miss_char;
12472: l_listentry_rec.city := v_listentryrec.city;
12473: l_listentry_rec.country := v_listentryrec.country;
12474: l_listentry_rec.do_not_use_flag := FND_API.g_miss_char;
12475: l_listentry_rec.do_not_use_reason := FND_API.g_miss_char;
12476: l_listentry_rec.email_address := v_listentryrec.email_address;
12477: l_listentry_rec.fax := v_listentryrec.fax;
12478: l_listentry_rec.phone := v_listentryrec.phone;
12479: l_listentry_rec.record_out_flag := FND_API.g_miss_char;
12475: l_listentry_rec.do_not_use_reason := FND_API.g_miss_char;
12476: l_listentry_rec.email_address := v_listentryrec.email_address;
12477: l_listentry_rec.fax := v_listentryrec.fax;
12478: l_listentry_rec.phone := v_listentryrec.phone;
12479: l_listentry_rec.record_out_flag := FND_API.g_miss_char;
12480: l_listentry_rec.state := v_listentryrec.state;
12481: l_listentry_rec.suffix := v_listentryrec.suffix;
12482: l_listentry_rec.title := v_listentryrec.title;
12483: l_listentry_rec.usage_restriction := FND_API.g_miss_char;
12479: l_listentry_rec.record_out_flag := FND_API.g_miss_char;
12480: l_listentry_rec.state := v_listentryrec.state;
12481: l_listentry_rec.suffix := v_listentryrec.suffix;
12482: l_listentry_rec.title := v_listentryrec.title;
12483: l_listentry_rec.usage_restriction := FND_API.g_miss_char;
12484: l_listentry_rec.zipcode := v_listentryrec.zipcode;
12485: l_listentry_rec.curr_cp_country_code := FND_API.g_miss_char;
12486: l_listentry_rec.curr_cp_phone_number := FND_API.g_miss_char;
12487: l_listentry_rec.curr_cp_raw_phone_number := FND_API.g_miss_char;
12481: l_listentry_rec.suffix := v_listentryrec.suffix;
12482: l_listentry_rec.title := v_listentryrec.title;
12483: l_listentry_rec.usage_restriction := FND_API.g_miss_char;
12484: l_listentry_rec.zipcode := v_listentryrec.zipcode;
12485: l_listentry_rec.curr_cp_country_code := FND_API.g_miss_char;
12486: l_listentry_rec.curr_cp_phone_number := FND_API.g_miss_char;
12487: l_listentry_rec.curr_cp_raw_phone_number := FND_API.g_miss_char;
12488: l_listentry_rec.curr_cp_area_code := FND_API.g_miss_num;
12489: l_listentry_rec.curr_cp_id := FND_API.g_miss_num;
12482: l_listentry_rec.title := v_listentryrec.title;
12483: l_listentry_rec.usage_restriction := FND_API.g_miss_char;
12484: l_listentry_rec.zipcode := v_listentryrec.zipcode;
12485: l_listentry_rec.curr_cp_country_code := FND_API.g_miss_char;
12486: l_listentry_rec.curr_cp_phone_number := FND_API.g_miss_char;
12487: l_listentry_rec.curr_cp_raw_phone_number := FND_API.g_miss_char;
12488: l_listentry_rec.curr_cp_area_code := FND_API.g_miss_num;
12489: l_listentry_rec.curr_cp_id := FND_API.g_miss_num;
12490: l_listentry_rec.curr_cp_index := FND_API.g_miss_num;
12483: l_listentry_rec.usage_restriction := FND_API.g_miss_char;
12484: l_listentry_rec.zipcode := v_listentryrec.zipcode;
12485: l_listentry_rec.curr_cp_country_code := FND_API.g_miss_char;
12486: l_listentry_rec.curr_cp_phone_number := FND_API.g_miss_char;
12487: l_listentry_rec.curr_cp_raw_phone_number := FND_API.g_miss_char;
12488: l_listentry_rec.curr_cp_area_code := FND_API.g_miss_num;
12489: l_listentry_rec.curr_cp_id := FND_API.g_miss_num;
12490: l_listentry_rec.curr_cp_index := FND_API.g_miss_num;
12491: l_listentry_rec.curr_cp_time_zone := FND_API.g_miss_num;
12484: l_listentry_rec.zipcode := v_listentryrec.zipcode;
12485: l_listentry_rec.curr_cp_country_code := FND_API.g_miss_char;
12486: l_listentry_rec.curr_cp_phone_number := FND_API.g_miss_char;
12487: l_listentry_rec.curr_cp_raw_phone_number := FND_API.g_miss_char;
12488: l_listentry_rec.curr_cp_area_code := FND_API.g_miss_num;
12489: l_listentry_rec.curr_cp_id := FND_API.g_miss_num;
12490: l_listentry_rec.curr_cp_index := FND_API.g_miss_num;
12491: l_listentry_rec.curr_cp_time_zone := FND_API.g_miss_num;
12492: l_listentry_rec.curr_cp_time_zone_aux := FND_API.g_miss_num;
12485: l_listentry_rec.curr_cp_country_code := FND_API.g_miss_char;
12486: l_listentry_rec.curr_cp_phone_number := FND_API.g_miss_char;
12487: l_listentry_rec.curr_cp_raw_phone_number := FND_API.g_miss_char;
12488: l_listentry_rec.curr_cp_area_code := FND_API.g_miss_num;
12489: l_listentry_rec.curr_cp_id := FND_API.g_miss_num;
12490: l_listentry_rec.curr_cp_index := FND_API.g_miss_num;
12491: l_listentry_rec.curr_cp_time_zone := FND_API.g_miss_num;
12492: l_listentry_rec.curr_cp_time_zone_aux := FND_API.g_miss_num;
12493: l_listentry_rec.imp_source_line_id := v_listentryrec.imp_source_line_id;
12486: l_listentry_rec.curr_cp_phone_number := FND_API.g_miss_char;
12487: l_listentry_rec.curr_cp_raw_phone_number := FND_API.g_miss_char;
12488: l_listentry_rec.curr_cp_area_code := FND_API.g_miss_num;
12489: l_listentry_rec.curr_cp_id := FND_API.g_miss_num;
12490: l_listentry_rec.curr_cp_index := FND_API.g_miss_num;
12491: l_listentry_rec.curr_cp_time_zone := FND_API.g_miss_num;
12492: l_listentry_rec.curr_cp_time_zone_aux := FND_API.g_miss_num;
12493: l_listentry_rec.imp_source_line_id := v_listentryrec.imp_source_line_id;
12494: l_listentry_rec.next_call_time := FND_API.g_miss_date;
12487: l_listentry_rec.curr_cp_raw_phone_number := FND_API.g_miss_char;
12488: l_listentry_rec.curr_cp_area_code := FND_API.g_miss_num;
12489: l_listentry_rec.curr_cp_id := FND_API.g_miss_num;
12490: l_listentry_rec.curr_cp_index := FND_API.g_miss_num;
12491: l_listentry_rec.curr_cp_time_zone := FND_API.g_miss_num;
12492: l_listentry_rec.curr_cp_time_zone_aux := FND_API.g_miss_num;
12493: l_listentry_rec.imp_source_line_id := v_listentryrec.imp_source_line_id;
12494: l_listentry_rec.next_call_time := FND_API.g_miss_date;
12495: l_listentry_rec.record_release_time := FND_API.g_miss_date;
12488: l_listentry_rec.curr_cp_area_code := FND_API.g_miss_num;
12489: l_listentry_rec.curr_cp_id := FND_API.g_miss_num;
12490: l_listentry_rec.curr_cp_index := FND_API.g_miss_num;
12491: l_listentry_rec.curr_cp_time_zone := FND_API.g_miss_num;
12492: l_listentry_rec.curr_cp_time_zone_aux := FND_API.g_miss_num;
12493: l_listentry_rec.imp_source_line_id := v_listentryrec.imp_source_line_id;
12494: l_listentry_rec.next_call_time := FND_API.g_miss_date;
12495: l_listentry_rec.record_release_time := FND_API.g_miss_date;
12496: l_listentry_rec.party_id := v_listentryrec.party_id;
12490: l_listentry_rec.curr_cp_index := FND_API.g_miss_num;
12491: l_listentry_rec.curr_cp_time_zone := FND_API.g_miss_num;
12492: l_listentry_rec.curr_cp_time_zone_aux := FND_API.g_miss_num;
12493: l_listentry_rec.imp_source_line_id := v_listentryrec.imp_source_line_id;
12494: l_listentry_rec.next_call_time := FND_API.g_miss_date;
12495: l_listentry_rec.record_release_time := FND_API.g_miss_date;
12496: l_listentry_rec.party_id := v_listentryrec.party_id;
12497: l_listentry_rec.parent_party_id := v_listentryrec.parent_party_id;
12498:
12491: l_listentry_rec.curr_cp_time_zone := FND_API.g_miss_num;
12492: l_listentry_rec.curr_cp_time_zone_aux := FND_API.g_miss_num;
12493: l_listentry_rec.imp_source_line_id := v_listentryrec.imp_source_line_id;
12494: l_listentry_rec.next_call_time := FND_API.g_miss_date;
12495: l_listentry_rec.record_release_time := FND_API.g_miss_date;
12496: l_listentry_rec.party_id := v_listentryrec.party_id;
12497: l_listentry_rec.parent_party_id := v_listentryrec.parent_party_id;
12498:
12499: AMS_LISTENTRY_PUB.update_listentry(
12503: x_msg_count => l_msg_count,
12504: x_msg_data => l_msg_data,
12505: p_entry_rec => l_listentry_rec);
12506:
12507: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
12508: Log_msg('AMS_LISTENTRY_PUB.update_listentry', l_msg_data);
12509: END IF;
12510:
12511: UPDATE AMS_LIST_ENTRIES
12706: );
12707:
12708: EXCEPTION
12709:
12710: WHEN fnd_api.g_exc_error THEN
12711:
12712: RAISE;
12713:
12714: WHEN fnd_api.g_exc_unexpected_error THEN
12710: WHEN fnd_api.g_exc_error THEN
12711:
12712: RAISE;
12713:
12714: WHEN fnd_api.g_exc_unexpected_error THEN
12715:
12716: RAISE;
12717:
12718: WHEN OTHERS THEN
12724: , SQLERRM
12725:
12726: );
12727:
12728: RAISE fnd_api.g_exc_unexpected_error;
12729:
12730:
12731:
12732: END Update_DuplicateEntries;
12829: , SQLERRM
12830:
12831: );
12832:
12833: RAISE fnd_api.g_exc_unexpected_error;
12834:
12835:
12836:
12837: END Log_DuplicateEntries;
13000:
13001:
13002: EXCEPTION
13003:
13004: WHEN fnd_api.g_exc_error THEN
13005:
13006: RAISE_APPLICATION_ERROR(-20999, Get_TranslatedErrorMessage);
13007:
13008: WHEN fnd_api.g_exc_unexpected_error THEN
13004: WHEN fnd_api.g_exc_error THEN
13005:
13006: RAISE_APPLICATION_ERROR(-20999, Get_TranslatedErrorMessage);
13007:
13008: WHEN fnd_api.g_exc_unexpected_error THEN
13009:
13010: RAISE_APPLICATION_ERROR(-20999, Get_TranslatedErrorMessage);
13011:
13012:
13091: BEGIN
13092:
13093:
13094:
13095: x_return_status := FND_API.G_RET_STS_SUCCESS;
13096:
13097:
13098:
13099: SAVEPOINT move_entry;
13109: IF p_src_schedule_id IS NULL THEN
13110:
13111: Log_CopySrcListNullMsg('Move_ScheduleEntries_Pub','CHECK_SRC_SCHED_NULL', Get_ScheduleName(p_src_schedule_id), Get_ScheduleName(p_dest_schedule_id));
13112:
13113: RAISE fnd_api.g_exc_error;
13114:
13115: END IF;
13116:
13117:
13119: IF p_dest_schedule_id IS NULL THEN
13120:
13121: Log_CopyDestListNullMsg('Move_ScheduleEntries_Pub','CHECK_DEST_SCHED_NULL', Get_ScheduleName(p_src_schedule_id), Get_ScheduleName(p_dest_schedule_id));
13122:
13123: RAISE fnd_api.g_exc_error;
13124:
13125: END IF;
13126:
13127:
13193: IF l_call_center_ready_flag <> 'Y' THEN
13194:
13195: Log_CopySrcListNotCCRMsg('Move_ScheduleEntries_Pub','CHECK_SRC_SCHED_CCR', Get_ScheduleName(p_src_schedule_id), Get_ScheduleName(p_dest_schedule_id));
13196:
13197: RAISE fnd_api.g_exc_error;
13198:
13199: END IF;
13200:
13201: IF l_validated_once_flag <> 'Y' THEN
13201: IF l_validated_once_flag <> 'Y' THEN
13202:
13203: Log_CopySrcListNotValMsg('Move_ScheduleEntries_Pub','CHECK_SRC_SCHED_VAL_ONCE', Get_ScheduleName(p_src_schedule_id), Get_ScheduleName(p_dest_schedule_id));
13204:
13205: RAISE fnd_api.g_exc_error;
13206:
13207: END IF;
13208:
13209: -- not sure if we can do a move unless the list is stopped
13219: THEN
13220:
13221: Log_CopySrcListInvalidStatMsg('Move_ScheduleEntries_Pub','CHECK_SRC_SCHED_STATUS', Get_ScheduleName(p_src_schedule_id), Get_ScheduleName(p_dest_schedule_id));
13222:
13223: RAISE fnd_api.g_exc_error;
13224:
13225: END IF;
13226:
13227:
13257: IF l_call_center_ready_flag <> 'Y' THEN
13258:
13259: Log_CopyDestListNotCCRMsg('Move_ScheduleEntries_Pub','CHECK_DEST_SCHED_CCR', Get_ScheduleName(p_src_schedule_id), Get_ScheduleName(p_dest_schedule_id));
13260:
13261: RAISE fnd_api.g_exc_error;
13262:
13263: END IF;
13264:
13265: IF l_validated_once_flag <> 'Y' THEN
13265: IF l_validated_once_flag <> 'Y' THEN
13266:
13267: Log_CopyDestListNotValMsg('Move_ScheduleEntries_Pub','CHECK_DEST_SCHED_VAL_ONCE', Get_ScheduleName(p_src_schedule_id), Get_ScheduleName(p_dest_schedule_id));
13268:
13269: RAISE fnd_api.g_exc_error;
13270:
13271: END IF;
13272:
13273: -- maybe want to ensure that list is shut down
13281: THEN
13282:
13283: Log_CopyDestListInvalidStaMsg('Move_ScheduleEntries_Pub','CHECK_DEST_SCHED_STATUS', Get_ScheduleName(p_src_schedule_id), Get_ScheduleName(p_dest_schedule_id));
13284:
13285: RAISE fnd_api.g_exc_error;
13286:
13287: END IF;
13288:
13289:
13421: WHEN OTHERS THEN
13422:
13423: FND_MSG_PUB.ADD;
13424:
13425: x_return_status := FND_API.G_RET_STS_ERROR;
13426:
13427:
13428:
13429: END Move_ScheduleEntries_Pub;
13529: IF p_from_list_id IS NULL THEN
13530:
13531: Log_CopySrcListNullMsg('Copy_ScheduleEntries_Pvt','CHECK_SRC_SCHED_NULL', Get_ScheduleName(p_from_schedule_id), Get_ScheduleName(p_to_schedule_id));
13532:
13533: RAISE fnd_api.g_exc_error;
13534:
13535: END IF;
13536:
13537:
13539: IF p_to_list_id IS NULL THEN
13540:
13541: Log_CopyDestListNullMsg('Copy_ScheduleEntries_Pvt','CHECK_DEST_SCHED_NULL', Get_ScheduleName(p_from_schedule_id), Get_ScheduleName(p_to_schedule_id));
13542:
13543: RAISE fnd_api.g_exc_error;
13544:
13545: END IF;
13546:
13547:
13597: IF l_call_center_ready_flag <> 'Y' THEN
13598:
13599: Log_CopySrcListNotCCRMsg('Copy_ScheduleEntries_Pvt','CHECK_SRC_SCHED_CCR', Get_ScheduleName(p_from_schedule_id), Get_ScheduleName(p_to_schedule_id));
13600:
13601: RAISE fnd_api.g_exc_error;
13602:
13603: END IF;
13604:
13605: IF l_validated_once_flag <> 'Y' THEN
13605: IF l_validated_once_flag <> 'Y' THEN
13606:
13607: Log_CopySrcListNotValMsg('Copy_ScheduleEntries_Pvt','CHECK_SRC_SCHED_VAL_ONCE', Get_ScheduleName(p_from_schedule_id), Get_ScheduleName(p_to_schedule_id));
13608:
13609: RAISE fnd_api.g_exc_error;
13610:
13611: END IF;
13612:
13613: IF l_status_code <> 'ACTIVE' AND
13619: THEN
13620:
13621: Log_CopySrcListInvalidStatMsg('Copy_ScheduleEntries_Pvt','CHECK_SRC_SCHED_STATUS', 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:
13657: IF l_call_center_ready_flag <> 'Y' THEN
13658:
13659: Log_CopyDestListNotCCRMsg('Copy_ScheduleEntries_Pvt','CHECK_DEST_SCHED_CCR', Get_ScheduleName(p_from_schedule_id), Get_ScheduleName(p_to_schedule_id));
13660:
13661: RAISE fnd_api.g_exc_error;
13662:
13663: END IF;
13664:
13665: IF l_validated_once_flag <> 'Y' THEN
13665: IF l_validated_once_flag <> 'Y' THEN
13666:
13667: Log_CopyDestListNotValMsg('Copy_ScheduleEntries_Pvt','CHECK_DEST_SCHED_VAL_ONCE', Get_ScheduleName(p_from_schedule_id), Get_ScheduleName(p_to_schedule_id));
13668:
13669: RAISE fnd_api.g_exc_error;
13670:
13671: END IF;
13672:
13673: IF l_status_code <> 'ACTIVE' AND
13679: THEN
13680:
13681: Log_CopyDestListInvalidStaMsg('Copy_ScheduleEntries_Pvt','CHECK_DEST_SCHED_STATUS', 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:
13809:
13810:
13811: EXCEPTION
13812:
13813: WHEN fnd_api.g_exc_error THEN
13814:
13815: ROLLBACK TO move_entry;
13816:
13817: Update_MoveEntriesStatus(p_from_list_id, p_to_list_id, 'FAILED_MOVE', l_api_initiated);
13817: Update_MoveEntriesStatus(p_from_list_id, p_to_list_id, 'FAILED_MOVE', l_api_initiated);
13818:
13819: RAISE_APPLICATION_ERROR(-20999, Get_TranslatedErrorMessage);
13820:
13821: WHEN fnd_api.g_exc_unexpected_error THEN
13822:
13823: ROLLBACK TO move_entry;
13824:
13825: Update_MoveEntriesStatus(p_from_list_id, p_to_list_id, 'FAILED_MOVE', l_api_initiated);
13871: BEGIN
13872:
13873:
13874:
13875: x_return_status := FND_API.G_RET_STS_SUCCESS;
13876:
13877:
13878:
13879: IF p_src_schedule_id IS NULL THEN
13879: IF p_src_schedule_id IS NULL THEN
13880:
13881: Log_CopySrcListNullMsg('Copy_ScheduleEntries_Pub','CHECK_SRC_SCHED_NULL', Get_ScheduleName(p_src_schedule_id), Get_ScheduleName(p_dest_schedule_id));
13882:
13883: RAISE fnd_api.g_exc_error;
13884:
13885: END IF;
13886:
13887:
13889: IF p_dest_schedule_id IS NULL THEN
13890:
13891: Log_CopyDestListNullMsg('Copy_ScheduleEntries_Pub','CHECK_DEST_SCHED_NULL', Get_ScheduleName(p_src_schedule_id), Get_ScheduleName(p_dest_schedule_id));
13892:
13893: RAISE fnd_api.g_exc_error;
13894:
13895: END IF;
13896:
13897:
13913: , 'GET_LIST_HEADER_ID'
13914:
13915: );
13916:
13917: RAISE fnd_api.g_exc_error;
13918:
13919: END;
13920:
13921:
13943: WHEN OTHERS THEN
13944:
13945: FND_MSG_PUB.ADD;
13946:
13947: x_return_status := FND_API.G_RET_STS_ERROR;
13948:
13949:
13950:
13951: END Copy_ScheduleEntries_Pub;
14033:
14034:
14035: EXCEPTION
14036:
14037: WHEN fnd_api.g_exc_error THEN
14038:
14039: ROLLBACK TO load_entry;
14040:
14041: Truncate_Temporary_Tables;
14041: Truncate_Temporary_Tables;
14042:
14043: RAISE_APPLICATION_ERROR(-20999, Get_TranslatedErrorMessage);
14044:
14045: WHEN fnd_api.g_exc_unexpected_error THEN
14046:
14047: ROLLBACK TO load_entry;
14048:
14049: Truncate_Temporary_Tables;
14099:
14100:
14101: EXCEPTION
14102:
14103: WHEN fnd_api.g_exc_error THEN
14104:
14105: ROLLBACK TO load_entry;
14106:
14107: Truncate_Temporary_Tables;
14107: Truncate_Temporary_Tables;
14108:
14109: RAISE_APPLICATION_ERROR(-20999, Get_TranslatedErrorMessage);
14110:
14111: WHEN fnd_api.g_exc_unexpected_error THEN
14112:
14113: ROLLBACK TO load_entry;
14114:
14115: Truncate_Temporary_Tables;
14160: l_msg_count NUMBER;
14161: l_msg_data VARCHAR2(2000);
14162: l_listentry_rec AMS_LISTENTRY_PVT.entry_rec_type;
14163: BEGIN
14164: l_init_msg_list :=FND_API.G_TRUE;
14165:
14166: IF p_party_id IS NOT NULL THEN
14167:
14168: l_listentry_rec.LIST_HEADER_ID := p_list_id;
14211: x_msg_data => l_msg_data,
14212: p_entry_rec => l_listentry_rec,
14213: x_entry_id => x_list_entry_id );
14214:
14215: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
14216: Log_msg('AMS_LISTENTRY_PUB.create_listentry', l_msg_data);
14217: END IF;
14218:
14219: /*
14346: , SQLERRM
14347:
14348: );
14349:
14350: RAISE fnd_api.g_exc_unexpected_error;
14351:
14352:
14353:
14354: END Insert_AmsListEntries;
14434: , SQLERRM
14435:
14436: );
14437:
14438: RAISE fnd_api.g_exc_unexpected_error;
14439:
14440:
14441:
14442: END Update_AmsListEntries;
15024:
15025:
15026: EXCEPTION
15027:
15028: WHEN fnd_api.g_exc_error THEN
15029:
15030: RAISE;
15031:
15032: WHEN fnd_api.g_exc_unexpected_error THEN
15028: WHEN fnd_api.g_exc_error THEN
15029:
15030: RAISE;
15031:
15032: WHEN fnd_api.g_exc_unexpected_error THEN
15033:
15034: RAISE;
15035:
15036: WHEN OTHERS THEN
15042: , SQLERRM
15043:
15044: );
15045:
15046: RAISE fnd_api.g_exc_unexpected_error;
15047:
15048: END Create_NewEntry;
15049:
15050:
15100: , SQLERRM
15101:
15102: );
15103:
15104: RAISE fnd_api.g_exc_unexpected_error;
15105:
15106: END Get_ValidationFailureCode;
15107:
15108:
15162: , SQLERRM
15163:
15164: );
15165:
15166: RAISE fnd_api.g_exc_unexpected_error;
15167:
15168: END Update_CallbackTime;
15169:
15170:
15376:
15377:
15378: EXCEPTION
15379:
15380: WHEN fnd_api.g_exc_error THEN
15381:
15382: ROLLBACK;
15383:
15384: RAISE;
15382: ROLLBACK;
15383:
15384: RAISE;
15385:
15386: WHEN fnd_api.g_exc_unexpected_error THEN
15387:
15388: ROLLBACK;
15389:
15390: RAISE;
15400: );
15401:
15402: ROLLBACK;
15403:
15404: RAISE fnd_api.g_exc_unexpected_error;
15405:
15406: END Add_Record_To_List_Pvt;
15407:
15408:
15628:
15629:
15630: HZ_CONTACT_POINT_V2PUB.update_phone_contact_point
15631:
15632: ( fnd_api.g_true -- init msg list
15633:
15634: , l_contact_point_rec
15635:
15636: , l_phone_rec
15654: -- a log and stop the update list procedure.
15655:
15656: ----------------------------------------------------------------
15657:
15658: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
15659:
15660: BEGIN
15661:
15662: -- Get Marketing API Error Message
15662: -- Get Marketing API Error Message
15663:
15664: FOR i IN 1..FND_MSG_PUB.count_msg LOOP
15665:
15666: l_msg_data := LTRIM(RTRIM(FND_MSG_PUB.GET(i, FND_API.G_FALSE)));
15667:
15668: IF (NVL(LENGTH(l_error_msg), 0) + NVL(LENGTH(l_msg_data), 0) < 1000) THEN
15669:
15670: l_error_msg := l_error_msg || l_msg_data;
15696: );
15697:
15698:
15699:
15700: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
15701:
15702: RAISE FND_API.G_EXC_ERROR;
15703:
15704: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
15698:
15699:
15700: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
15701:
15702: RAISE FND_API.G_EXC_ERROR;
15703:
15704: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
15705:
15706: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
15700: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
15701:
15702: RAISE FND_API.G_EXC_ERROR;
15703:
15704: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
15705:
15706: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
15707:
15708: END IF;
15702: RAISE FND_API.G_EXC_ERROR;
15703:
15704: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
15705:
15706: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
15707:
15708: END IF;
15709:
15710: END IF;
15752: IF SQLCODE = -904 THEN
15753:
15754: Log_MissingSourceTypeColumns(p_list_id, l_source_type_view, Get_SourceType(p_list_id), 'Update_ContactPoint', 'UPDATE_AMS_LIST_ENTRIES');
15755:
15756: RAISE fnd_api.g_exc_unexpected_error;
15757:
15758: ELSE
15759:
15760: Log( 'Update_ContactPoint'
15764: , SQLERRM
15765:
15766: );
15767:
15768: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
15769:
15770: END IF;
15771:
15772: END;
15934: BEGIN
15935:
15936:
15937:
15938: x_return_code := FND_API.G_RET_STS_SUCCESS;
15939:
15940:
15941:
15942: SAVEPOINT subset_transition;
16172: g_error_msg := 'Source type view ' || p_source_type_v || ' is missing at least one of the following columns: ' ||
16173:
16174: 'REASON_CODE_S1, REASON_CODE_S2, REASON_CODE_S3, REASON_CODE_S4, REASON_CODE_S5, REASON_CODE_S6';
16175:
16176: RAISE fnd_api.g_exc_unexpected_error;
16177:
16178: ELSE
16179:
16180: RAISE;
16658:
16659:
16660: EXCEPTION
16661:
16662: WHEN fnd_api.g_exc_unexpected_error THEN
16663:
16664: x_return_code := FND_API.G_RET_STS_ERROR;
16665:
16666: ROLLBACK TO subset_transition;
16660: EXCEPTION
16661:
16662: WHEN fnd_api.g_exc_unexpected_error THEN
16663:
16664: x_return_code := FND_API.G_RET_STS_ERROR;
16665:
16666: ROLLBACK TO subset_transition;
16667:
16668: Truncate_Temporary_Tables;
16670: RAISE_APPLICATION_ERROR(-20999, g_error_msg);
16671:
16672: WHEN OTHERS THEN
16673:
16674: x_return_code := FND_API.G_RET_STS_ERROR;
16675:
16676: Log( 'SubsetTransition_list'
16677:
16678: , 'MAIN'