eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_LISTIMPORT_PVT dependencies on AMS_USER_STATUSES_VL

Line 2198: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

2194: null, null, null,null,
2195: 'Error in TCA load program ' || SQLERRM||' '||SQLCODE);
2196: l_lookup_code := 'ERROR';
2197: l_user_status_id := null;
2198: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
2199: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
2200: system_status_code = 'ERROR' and default_flag = 'Y';
2201:
2202: UPDATE ams_imp_list_headers_all

Line 2345: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

2341: if l_execute_mode = 'R' then
2342: l_lookup_code := 'STAGED';
2343: l_status_code := 'STAGED';
2344: l_user_status_id := null;
2345: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
2346: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
2347: system_status_code = 'STAGED' and default_flag = 'Y';
2348:
2349: select as_import_interface_s.nextval into l_batch_id from dual;

Line 2404: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

2400: end if;
2401:
2402: l_lookup_code := 'STAGED';
2403: l_user_status_id := null;
2404: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
2405: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
2406: system_status_code = 'STAGED' and default_flag = 'Y';
2407:
2408: UPDATE ams_imp_list_headers_all

Line 2470: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

2466: p_msg_data => l_mesg_text,
2467: p_msg_type => 'DEBUG' );
2468:
2469: l_user_status_id := null;
2470: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
2471: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
2472: system_status_code = 'ERROR' and default_flag = 'Y';
2473: UPDATE ams_imp_list_headers_all
2474: set status_code = l_lookup_code,

Line 2542: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

2538: p_msg_data => l_mesg_text,
2539: p_msg_type => 'DEBUG' );
2540:
2541: l_user_status_id := null;
2542: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
2543: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
2544: system_status_code = 'ERROR' and default_flag = 'Y';
2545: UPDATE ams_imp_list_headers_all
2546: set status_code = l_lookup_code,

Line 2573: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

2569: );
2570:
2571: l_lookup_code := 'STAGED';
2572: l_user_status_id := null;
2573: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
2574: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
2575: system_status_code = 'STAGED' and default_flag = 'Y';
2576:
2577: UPDATE ams_imp_list_headers_all

Line 2625: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

2621: p_msg_type => 'DEBUG'
2622: );
2623: l_lookup_code := 'ERROR';
2624: l_user_status_id := null;
2625: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
2626: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
2627: system_status_code = 'ERROR' and default_flag = 'Y';
2628:
2629: UPDATE ams_imp_list_headers_all

Line 2713: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

2709: p_msg_data => 'Aborting org_existence_checking.',
2710: p_msg_type => 'DEBUG');
2711: l_lookup_code := 'ERROR';
2712: l_user_status_id := null;
2713: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
2714: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
2715: system_status_code = 'ERROR' and default_flag = 'Y';
2716:
2717: UPDATE ams_imp_list_headers_all

Line 2740: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

2736: p_msg_data => 'Aborting org_cont_existence_checking.',
2737: p_msg_type => 'DEBUG');
2738: l_lookup_code := 'ERROR';
2739: l_user_status_id := null;
2740: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
2741: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
2742: system_status_code = 'ERROR' and default_flag = 'Y';
2743: UPDATE ams_imp_list_headers_all
2744: set status_code = l_lookup_code,

Line 2762: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

2758: p_msg_data => 'Aborting org_address_existence_checking.',
2759: p_msg_type => 'DEBUG');
2760: l_lookup_code := 'ERROR';
2761: l_user_status_id := null;
2762: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
2763: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
2764: system_status_code = 'ERROR' and default_flag = 'Y';
2765: UPDATE ams_imp_list_headers_all
2766: set status_code = l_lookup_code,

Line 2784: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

2780: p_msg_data => 'Aborting org_address1_exist_checking.',
2781: p_msg_type => 'DEBUG');
2782: l_lookup_code := 'ERROR';
2783: l_user_status_id := null;
2784: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
2785: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
2786: system_status_code = 'ERROR' and default_flag = 'Y';
2787: UPDATE ams_imp_list_headers_all
2788: set status_code = l_lookup_code,

Line 2811: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

2807: p_log_used_by_id => p_import_list_header_id,
2808: p_msg_data => 'Aborting per_existence_checking.',
2809: p_msg_type => 'DEBUG'); l_lookup_code := 'ERROR';
2810: l_user_status_id := null;
2811: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
2812: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
2813: system_status_code = 'ERROR' and default_flag = 'Y';
2814:
2815: UPDATE ams_imp_list_headers_all

Line 2834: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

2830: p_msg_data => 'Aborting per_address_existence_checking.',
2831: p_msg_type => 'DEBUG');
2832: l_lookup_code := 'ERROR';
2833: l_user_status_id := null;
2834: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
2835: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
2836: system_status_code = 'ERROR' and default_flag = 'Y';
2837:
2838: UPDATE ams_imp_list_headers_all

Line 3090: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

3086: close c_conc_name;
3087:
3088: l_lookup_code := 'SCHEDULED';
3089: l_user_status_id := null;
3090: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
3091: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
3092: system_status_code = 'SCHEDULED' and default_flag = 'Y';
3093:
3094:

Line 3140: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

3136: );
3137:
3138: l_lookup_code := 'ERROR';
3139: l_user_status_id := null;
3140: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
3141: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
3142: system_status_code = 'ERROR' and default_flag = 'Y';
3143:
3144: UPDATE ams_imp_list_headers_all

Line 3188: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

3184: p_msg_data => l_mesg_text,
3185: p_msg_type => 'DEBUG' );
3186:
3187: l_user_status_id := null;
3188: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
3189: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
3190: system_status_code = 'ERROR' and default_flag = 'Y';
3191: UPDATE ams_imp_list_headers_all
3192: set status_code = l_lookup_code,

Line 3266: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

3262: );
3263:
3264: l_lookup_code := 'ERROR';
3265: l_user_status_id := null;
3266: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
3267: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
3268: system_status_code = 'ERROR' and default_flag = 'Y';
3269:
3270: UPDATE ams_imp_list_headers_all

Line 3331: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

3327: p_msg_data => l_mesg_text,
3328: p_msg_type => 'DEBUG' );
3329:
3330: l_user_status_id := null;
3331: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
3332: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
3333: system_status_code = 'ERROR' and default_flag = 'Y';
3334: UPDATE ams_imp_list_headers_all
3335: set status_code = l_lookup_code,

Line 3362: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

3358: if l_dev_phase = 'COMPLETE' then
3359: if l_dev_status = 'NORMAL' then
3360: l_lookup_code := 'COMPLETED';
3361: l_user_status_id := null;
3362: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
3363: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
3364: system_status_code = 'COMPLETED' and default_flag = 'Y';
3365: end if;
3366: if l_dev_status = 'ERROR' then

Line 3369: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

3365: end if;
3366: if l_dev_status = 'ERROR' then
3367: l_lookup_code := 'ERROR';
3368: l_user_status_id := null;
3369: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
3370: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
3371: system_status_code = 'ERROR' and default_flag = 'Y';
3372: end if;
3373:

Line 3408: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

3404: close c_error_exist;
3405: if l_error_exist = 'Y' then
3406: l_lookup_code := 'ERROR';
3407: l_user_status_id := null;
3408: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
3409: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
3410: system_status_code = 'ERROR' and default_flag = 'Y';
3411:
3412: UPDATE ams_imp_list_headers_all

Line 3498: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

3494: p_msg_type => 'DEBUG'
3495: );
3496: l_lookup_code := 'ERROR';
3497: l_user_status_id := null;
3498: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
3499: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
3500: system_status_code = 'ERROR' and default_flag = 'Y';
3501:
3502: UPDATE ams_imp_list_headers_all

Line 3522: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

3518: p_msg_data => 'XML import is not available for EVENT and LEADS, Aborting import process',
3519: p_msg_type => 'DEBUG'
3520: );
3521: l_user_status_id := null;
3522: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
3523: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
3524: system_status_code = 'ERROR' and default_flag = 'Y';
3525:
3526: UPDATE ams_imp_list_headers_all

Line 3558: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

3554: p_msg_data => l_mesg_text,
3555: p_msg_type => 'DEBUG' );
3556:
3557: l_user_status_id := null;
3558: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
3559: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
3560: system_status_code = 'ERROR' and default_flag = 'Y';
3561: UPDATE ams_imp_list_headers_all
3562: set status_code = l_lookup_code,

Line 3642: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

3638: p_msg_data => 'XML import is not available for EVENT and LEADS, Aborting import process',
3639: p_msg_type => 'DEBUG'
3640: );
3641: l_user_status_id := null;
3642: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
3643: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
3644: system_status_code = 'ERROR' and default_flag = 'Y';
3645:
3646: UPDATE ams_imp_list_headers_all

Line 3678: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

3674: p_msg_data => l_mesg_text,
3675: p_msg_type => 'DEBUG' );
3676:
3677: l_user_status_id := null;
3678: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
3679: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
3680: system_status_code = 'ERROR' and default_flag = 'Y';
3681: UPDATE ams_imp_list_headers_all
3682: set status_code = l_lookup_code,

Line 4149: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

4145: );
4146:
4147: l_lookup_code := 'ERROR';
4148: l_user_status_id := null;
4149: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
4150: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
4151: system_status_code = 'ERROR' and default_flag = 'Y';
4152:
4153: UPDATE ams_imp_list_headers_all

Line 4201: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

4197: );
4198:
4199: l_lookup_code := 'ERROR';
4200: l_user_status_id := null;
4201: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
4202: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
4203: system_status_code = 'ERROR' and default_flag = 'Y';
4204:
4205: UPDATE ams_imp_list_headers_all

Line 4230: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

4226: close c_rec_failed_in_ams;
4227:
4228: l_lookup_code := 'ERROR';
4229: l_user_status_id := null;
4230: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
4231: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
4232: system_status_code = 'ERROR' and default_flag = 'Y';
4233:
4234: UPDATE ams_imp_list_headers_all

Line 4271: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

4267: p_msg_data => l_mesg_text,
4268: p_msg_type => 'DEBUG' );
4269:
4270: l_user_status_id := null;
4271: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
4272: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
4273: system_status_code = 'ERROR' and default_flag = 'Y';
4274: UPDATE ams_imp_list_headers_all
4275: set status_code = l_lookup_code,

Line 4322: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

4318: /*
4319: if l_dev_status = 'NORMAL' then
4320: l_lookup_code := 'COMPLETED';
4321: l_user_status_id := null;
4322: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
4323: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
4324: system_status_code = 'COMPLETED' and default_flag = 'Y';
4325: end if;
4326: */

Line 4330: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

4326: */
4327: if l_dev_status = 'ERROR' then
4328: l_lookup_code := 'ERROR';
4329: l_user_status_id := null;
4330: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
4331: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
4332: system_status_code = 'ERROR' and default_flag = 'Y';
4333: UPDATE ams_imp_list_headers_all
4334: set status_code = l_lookup_code,

Line 4372: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

4368: if l_lead_status = 'ERROR' then
4369: /*
4370: l_lookup_code := 'ERROR';
4371: l_user_status_id := null;
4372: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
4373: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
4374: system_status_code = 'ERROR' and default_flag = 'Y';
4375: */
4376: AMS_Utility_PVT.Create_Log (

Line 13780: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

13776: p_msg_type => 'DEBUG'
13777: );
13778: l_lookup_code := 'ERROR';
13779: l_user_status_id := null;
13780: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
13781: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
13782: system_status_code = 'ERROR' and default_flag = 'Y';
13783:
13784: UPDATE ams_imp_list_headers_all

Line 13803: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

13799: if l_execute_mode = 'R' then
13800: l_lookup_code := 'STAGED';
13801: l_status_code := 'STAGED';
13802: l_user_status_id := null;
13803: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
13804: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
13805: system_status_code = 'STAGED' and default_flag = 'Y';
13806:
13807: select as_import_interface_s.nextval into l_batch_id from dual;

Line 14040: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

14036: p_msg_data => 'Aborting org_existence_checking.',
14037: p_msg_type => 'DEBUG');
14038: l_lookup_code := 'ERROR';
14039: l_user_status_id := null;
14040: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
14041: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
14042: system_status_code = 'ERROR' and default_flag = 'Y';
14043:
14044: UPDATE ams_imp_list_headers_all

Line 14094: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

14090: p_msg_data => 'Aborting org_cont_existence_checking.',
14091: p_msg_type => 'DEBUG');
14092: l_lookup_code := 'ERROR';
14093: l_user_status_id := null;
14094: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
14095: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
14096: system_status_code = 'ERROR' and default_flag = 'Y';
14097:
14098: UPDATE ams_imp_list_headers_all

Line 14130: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

14126: p_msg_data => 'Aborting org_address_existence_checking.',
14127: p_msg_type => 'DEBUG');
14128: l_lookup_code := 'ERROR';
14129: l_user_status_id := null;
14130: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
14131: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
14132: system_status_code = 'ERROR' and default_flag = 'Y';
14133:
14134: UPDATE ams_imp_list_headers_all

Line 14166: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

14162: p_msg_data => 'Aborting org_address1_exist_checking.',
14163: p_msg_type => 'DEBUG');
14164: l_lookup_code := 'ERROR';
14165: l_user_status_id := null;
14166: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
14167: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
14168: system_status_code = 'ERROR' and default_flag = 'Y';
14169: UPDATE ams_imp_list_headers_all
14170: set status_code = l_lookup_code,

Line 14222: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

14218: p_msg_data => 'Aborting per_existence_checking.',
14219: p_msg_type => 'DEBUG');
14220: l_lookup_code := 'ERROR';
14221: l_user_status_id := null;
14222: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
14223: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
14224: system_status_code = 'ERROR' and default_flag = 'Y';
14225:
14226: UPDATE ams_imp_list_headers_all

Line 14258: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

14254: p_msg_data => 'Aborting per_address_existence_checking.',
14255: p_msg_type => 'DEBUG');
14256: l_lookup_code := 'ERROR';
14257: l_user_status_id := null;
14258: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
14259: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
14260: system_status_code = 'ERROR' and default_flag = 'Y';
14261:
14262: UPDATE ams_imp_list_headers_all

Line 14309: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

14305: );
14306:
14307: l_lookup_code := 'ERROR';
14308: l_user_status_id := null;
14309: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
14310: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
14311: system_status_code = 'ERROR' and default_flag = 'Y';
14312:
14313: UPDATE ams_imp_list_headers_all

Line 14334: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

14330: p_msg_type => 'DEBUG'
14331: );
14332: l_lookup_code := 'ERROR';
14333: l_user_status_id := null;
14334: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
14335: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
14336: system_status_code = 'ERROR' and default_flag = 'Y';
14337:
14338: UPDATE ams_imp_list_headers_all

Line 14408: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

14404: p_msg_data => l_mesg_text,
14405: p_msg_type => 'DEBUG' );
14406:
14407: l_user_status_id := null;
14408: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
14409: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
14410: system_status_code = 'ERROR' and default_flag = 'Y';
14411: UPDATE ams_imp_list_headers_all
14412: set status_code = l_lookup_code,

Line 14441: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

14437: /*
14438: if l_msg_code = 2 then
14439: l_lookup_code := 'ERROR';
14440: l_user_status_id := null;
14441: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
14442: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
14443: system_status_code = 'ERROR' and default_flag = 'Y';
14444:
14445: UPDATE ams_imp_list_headers_all

Line 14460: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

14456: close c_error_exist;
14457: if l_error_exist = 'Y' then
14458: l_lookup_code := 'ERROR';
14459: l_user_status_id := null;
14460: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
14461: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
14462: system_status_code = 'ERROR' and default_flag = 'Y';
14463:
14464: UPDATE ams_imp_list_headers_all

Line 14473: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

14469: end if;
14470: if l_error_exist is NULL then
14471: l_lookup_code := 'COMPLETED';
14472: l_user_status_id := null;
14473: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
14474: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
14475: system_status_code = 'COMPLETED' and default_flag = 'Y';
14476:
14477: UPDATE ams_imp_list_headers_all

Line 14626: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

14622: );
14623:
14624: l_lookup_code := 'ERROR';
14625: l_user_status_id := null;
14626: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
14627: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
14628: system_status_code = 'ERROR' and default_flag = 'Y';
14629:
14630: UPDATE ams_imp_list_headers_all

Line 14673: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

14669: close c_error_exist;
14670: if l_error_exist = 'Y' then
14671: l_lookup_code := 'ERROR';
14672: l_user_status_id := null;
14673: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
14674: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
14675: system_status_code = 'ERROR' and default_flag = 'Y';
14676:
14677: UPDATE ams_imp_list_headers_all

Line 14686: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

14682: end if;
14683: if l_error_exist is NULL then
14684: l_lookup_code := 'COMPLETED';
14685: l_user_status_id := null;
14686: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
14687: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
14688: system_status_code = 'COMPLETED' and default_flag = 'Y';
14689:
14690: UPDATE ams_imp_list_headers_all

Line 15980: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

15976: if l_status_code is NULL then
15977: l_status_code := 'ERROR';
15978: end if;
15979: l_user_status_id := null;
15980: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
15981: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
15982: system_status_code = l_status_code and default_flag = 'Y';
15983:
15984: UPDATE ams_imp_list_headers_all

Line 20953: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

20949: close c_error_exist;
20950: if l_error_exist = 'Y' then
20951: l_lookup_code := 'ERROR';
20952: l_user_status_id := null;
20953: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
20954: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
20955: system_status_code = 'ERROR' and default_flag = 'Y';
20956:
20957: UPDATE ams_imp_list_headers_all

Line 20966: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

20962: end if;
20963: if l_error_exist is NULL then
20964: l_lookup_code := 'COMPLETED';
20965: l_user_status_id := null;
20966: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
20967: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
20968: system_status_code = 'COMPLETED' and default_flag = 'Y';
20969:
20970: UPDATE ams_imp_list_headers_all

Line 21456: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

21452: p_msg_data => 'Business Event Error: '||l_error_text,
21453: p_msg_type => 'DEBUG'
21454: );
21455: l_user_status_id := null;
21456: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl
21457: WHERE system_status_type = 'AMS_IMPORT_STATUS' AND
21458: system_status_code = 'ERROR' and default_flag = 'Y';
21459: UPDATE ams_imp_list_headers_all
21460: set status_code = 'ERROR' ,