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 2197: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

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

Line 2344: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

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

Line 2403: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

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

Line 2469: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

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

Line 2541: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

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

Line 2572: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

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

Line 2624: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

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

Line 2712: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

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

Line 2739: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

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

Line 2761: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

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

Line 2783: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

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

Line 2810: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

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

Line 2833: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

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

Line 3089: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

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

Line 3139: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

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

Line 3187: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

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

Line 3265: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

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

Line 3330: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

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

Line 3361: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

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

Line 3368: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

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

Line 3407: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

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

Line 3497: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

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

Line 3521: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

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

Line 3557: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

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

Line 3641: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

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

Line 3677: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

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

Line 4148: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

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

Line 4200: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

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

Line 4229: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

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

Line 4270: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

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

Line 4321: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

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

Line 4329: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

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

Line 4371: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

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

Line 13779: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

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

Line 13802: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

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

Line 14039: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

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

Line 14093: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

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

Line 14129: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

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

Line 14165: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

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

Line 14221: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

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

Line 14257: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

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

Line 14308: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

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

Line 14333: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

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

Line 14407: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

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

Line 14440: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

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

Line 14459: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

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

Line 14472: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

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

Line 14625: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

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

Line 14672: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

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

Line 14685: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

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

Line 15979: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

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

Line 20952: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

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

Line 20965: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

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

Line 21455: SELECT user_status_id into l_user_status_id FROM ams_user_statuses_vl

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