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_LISTGENERATION_PKG dependencies on FND_API

Line 530: FND_API.G_FALSE,

526: l_msg_count := FND_MSG_PUB.Count_Msg;
527: IF(l_msg_count <> 0)THEN
528: FOR l_iterator IN 1 .. l_msg_count LOOP
529: FND_MSG_PUB.Get(FND_MSG_PUB.G_NEXT,
530: FND_API.G_FALSE,
531: l_msg_data,
532: l_msg_count);
533: UPDATE ams_list_headers_all
534: SET result_text = result_text||' '|| l_msg_data

Line 978: x_return_status := FND_API.G_RET_STS_SUCCESS;

974: l_null varchar2(30) := null;
975: -- deletes from ams_list_entries in case of standard type of generation
976: BEGIN
977: write_to_act_log('Executing delete_list_entries to delete entries from ams_list_entries(Since list/target group is generated in STANDARD mode).', 'LIST', g_list_header_id,'LOW');
978: x_return_status := FND_API.G_RET_STS_SUCCESS;
979: -------------------------------------------------------------------------------
980: --Delete all existing entries for this list which are in the temporary table.--
981: -------------------------------------------------------------------------------
982: l_delete_action := 'List tmp Entries delete';

Line 1035: x_return_status := FND_API.G_RET_STS_ERROR ;

1031: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
1032: FND_MESSAGE.Set_Token('TEXT', 'Delete List Entries ' ||
1033: l_delete_action || ' '|| SQLERRM||' '||SQLCODE);
1034: FND_MSG_PUB.Add;
1035: x_return_status := FND_API.G_RET_STS_ERROR ;
1036:
1037: END delete_list_entries;
1038:
1039:

Line 1070: x_return_status := FND_API.G_RET_STS_SUCCESS;

1066: SET no_of_rows_used = 0
1067: WHERE arc_action_used_by = 'LIST'
1068: and action_used_by_id = p_list_header_id;
1069:
1070: x_return_status := FND_API.G_RET_STS_SUCCESS;
1071:
1072: EXCEPTION
1073: WHEN OTHERS THEN
1074: write_to_act_log('Error while executing initialize_list_header procedure', 'LIST', g_list_header_id,'HIGH');

Line 1079: x_return_status := FND_API.G_RET_STS_ERROR ;

1075: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
1076: FND_MESSAGE.Set_Token('TEXT', 'Initialize List Header ' ||
1077: SQLERRM||' '||SQLCODE);
1078: FND_MSG_PUB.Add;
1079: x_return_status := FND_API.G_RET_STS_ERROR ;
1080: END initialize_list_header;
1081:
1082: -------------------------------------------------------------------------------
1083: -- Start of Comments

Line 1110: x_return_status := FND_API.G_RET_STS_SUCCESS;

1106: x_msg_data OUT NOCOPY varchar2,
1107: x_return_status OUT NOCOPY VARCHAR2 ) IS
1108: BEGIN
1109: write_to_act_log('Executing procedure initialize_list', 'LIST', g_list_header_id,'LOW');
1110: x_return_status := FND_API.G_RET_STS_SUCCESS;
1111: -----------------------------------------------------------------
1112: --Delete any existing log entries for this list. --
1113: -----------------------------------------------------------------
1114: --DELETE FROM ams_act_logs

Line 1126: if x_return_status <> FND_API.g_ret_sts_success then

1122: initialize_list_header(p_list_header_id => p_list_header_rec.list_header_id,
1123: x_msg_count => x_msg_count,
1124: x_msg_data => x_msg_data,
1125: x_return_status => x_return_status);
1126: if x_return_status <> FND_API.g_ret_sts_success then
1127: write_to_act_log('Error while executing initialize_list_header. Unable to Initialize List ', 'LIST', g_list_header_id,'HIGH');
1128: raise FND_API.g_exc_unexpected_error;
1129: end if;
1130: -----------------------------------------------------------------

Line 1128: raise FND_API.g_exc_unexpected_error;

1124: x_msg_data => x_msg_data,
1125: x_return_status => x_return_status);
1126: if x_return_status <> FND_API.g_ret_sts_success then
1127: write_to_act_log('Error while executing initialize_list_header. Unable to Initialize List ', 'LIST', g_list_header_id,'HIGH');
1128: raise FND_API.g_exc_unexpected_error;
1129: end if;
1130: -----------------------------------------------------------------
1131: --Deleting any existing entries. if generation type is Standard--
1132: -----------------------------------------------------------------

Line 1139: if x_return_status <> FND_API.g_ret_sts_success then

1135: delete_list_entries (p_list_header_id => p_list_header_rec.list_header_id,
1136: x_msg_count => x_msg_count,
1137: x_msg_data => x_msg_data,
1138: x_return_status => x_return_status);
1139: if x_return_status <> FND_API.g_ret_sts_success then
1140: write_to_act_log('Error while executing delete_list_entries. Unable to delete entries.', 'LIST', g_list_header_id,'HIGH');
1141: raise FND_API.g_exc_unexpected_error;
1142: end if;
1143: end if;

Line 1141: raise FND_API.g_exc_unexpected_error;

1137: x_msg_data => x_msg_data,
1138: x_return_status => x_return_status);
1139: if x_return_status <> FND_API.g_ret_sts_success then
1140: write_to_act_log('Error while executing delete_list_entries. Unable to delete entries.', 'LIST', g_list_header_id,'HIGH');
1141: raise FND_API.g_exc_unexpected_error;
1142: end if;
1143: end if;
1144: write_to_act_log('Procedure initialize_list executed successfully.', 'LIST', g_list_header_id,'LOW');
1145: -- CHECK if we need to initlialize list select actions and

Line 1148: WHEN FND_API.g_exc_error THEN

1144: write_to_act_log('Procedure initialize_list executed successfully.', 'LIST', g_list_header_id,'LOW');
1145: -- CHECK if we need to initlialize list select actions and
1146: -- and list header number of rows etc.
1147: EXCEPTION
1148: WHEN FND_API.g_exc_error THEN
1149: write_to_act_log('Error while executing procedure initialize_list '||sqlcode||' '||sqlerrm, 'LIST', g_list_header_id,'HIGH');
1150: x_return_status := FND_API.g_ret_sts_error;
1151: FND_MSG_PUB.count_and_get(
1152: p_encoded => FND_API.g_false,

Line 1150: x_return_status := FND_API.g_ret_sts_error;

1146: -- and list header number of rows etc.
1147: EXCEPTION
1148: WHEN FND_API.g_exc_error THEN
1149: write_to_act_log('Error while executing procedure initialize_list '||sqlcode||' '||sqlerrm, 'LIST', g_list_header_id,'HIGH');
1150: x_return_status := FND_API.g_ret_sts_error;
1151: FND_MSG_PUB.count_and_get(
1152: p_encoded => FND_API.g_false,
1153: p_count => x_msg_count,
1154: p_data => x_msg_data

Line 1152: p_encoded => FND_API.g_false,

1148: WHEN FND_API.g_exc_error THEN
1149: write_to_act_log('Error while executing procedure initialize_list '||sqlcode||' '||sqlerrm, 'LIST', g_list_header_id,'HIGH');
1150: x_return_status := FND_API.g_ret_sts_error;
1151: FND_MSG_PUB.count_and_get(
1152: p_encoded => FND_API.g_false,
1153: p_count => x_msg_count,
1154: p_data => x_msg_data
1155: );
1156:

Line 1157: WHEN FND_API.g_exc_unexpected_error THEN

1153: p_count => x_msg_count,
1154: p_data => x_msg_data
1155: );
1156:
1157: WHEN FND_API.g_exc_unexpected_error THEN
1158: write_to_act_log('Error while executing procedure initialize_list '||sqlcode||' '||sqlerrm, 'LIST', g_list_header_id,'HIGH');
1159: x_return_status := FND_API.g_ret_sts_unexp_error ;
1160: FND_MSG_PUB.count_and_get(
1161: p_encoded => FND_API.g_false,

Line 1159: x_return_status := FND_API.g_ret_sts_unexp_error ;

1155: );
1156:
1157: WHEN FND_API.g_exc_unexpected_error THEN
1158: write_to_act_log('Error while executing procedure initialize_list '||sqlcode||' '||sqlerrm, 'LIST', g_list_header_id,'HIGH');
1159: x_return_status := FND_API.g_ret_sts_unexp_error ;
1160: FND_MSG_PUB.count_and_get(
1161: p_encoded => FND_API.g_false,
1162: p_count => x_msg_count,
1163: p_data => x_msg_data

Line 1161: p_encoded => FND_API.g_false,

1157: WHEN FND_API.g_exc_unexpected_error THEN
1158: write_to_act_log('Error while executing procedure initialize_list '||sqlcode||' '||sqlerrm, 'LIST', g_list_header_id,'HIGH');
1159: x_return_status := FND_API.g_ret_sts_unexp_error ;
1160: FND_MSG_PUB.count_and_get(
1161: p_encoded => FND_API.g_false,
1162: p_count => x_msg_count,
1163: p_data => x_msg_data
1164: );
1165:

Line 1168: x_return_status := FND_API.g_ret_sts_unexp_error ;

1164: );
1165:
1166: WHEN OTHERS THEN
1167: write_to_act_log('Error while executing procedure initialize_list '||sqlcode||' '||sqlerrm, 'LIST', g_list_header_id,'HIGH');
1168: x_return_status := FND_API.g_ret_sts_unexp_error ;
1169: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1170: FND_MSG_PUB.add_exc_msg(g_pkg_name, g_file_name);
1171: END IF;
1172: FND_MSG_PUB.count_and_get(

Line 1173: p_encoded => FND_API.g_false,

1169: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1170: FND_MSG_PUB.add_exc_msg(g_pkg_name, g_file_name);
1171: END IF;
1172: FND_MSG_PUB.count_and_get(
1173: p_encoded => FND_API.g_false,
1174: p_count => x_msg_count,
1175: p_data => x_msg_data
1176: );
1177:

Line 3296: RAISE FND_API.G_EXC_ERROR;

3292: if l_found = 'N' then
3293: write_to_act_log('Validation failed for this SQL string in validate_sql_string procedure'||l_found,'LIST', g_list_header_id,'HIGH');
3294: FND_MESSAGE.set_name('AMS', 'AMS_LIST_FROM_NOT_FOUND');
3295: FND_MSG_PUB.Add;
3296: RAISE FND_API.G_EXC_ERROR;
3297: end if;
3298: write_to_act_log('SQL string validated successfully in validate_sql_string','LIST', g_list_header_id,'LOW');
3299:
3300: l_found := 'N';

Line 3317: RAISE FND_API.G_EXC_ERROR;

3313: if l_found = 'N' then
3314: write_to_act_log('No master type found','LIST', g_list_header_id,'LOW');
3315: FND_MESSAGE.set_name('AMS', 'AMS_LIST_NO_MASTER_TYPE');
3316: FND_MSG_PUB.Add;
3317: RAISE FND_API.G_EXC_ERROR;
3318: end if;
3319:
3320: if p_list_action_type = 'INCLUDE' then
3321: l_found := 'N';

Line 3403: WHEN FND_API.G_EXC_ERROR THEN

3399: end if;
3400: end if;
3401: write_to_act_log('Execution of process_all_sql ends ', 'LIST', g_list_header_id,'LOW');
3402: EXCEPTION
3403: WHEN FND_API.G_EXC_ERROR THEN
3404: write_to_act_log('Error while executing process_all_sql '||sqlcode||' '||sqlerrm, 'LIST', g_list_header_id,'HIGH');
3405: x_return_status := FND_API.G_RET_STS_ERROR ;
3406: FND_MSG_PUB.count_and_get(
3407: p_encoded => FND_API.g_false,

Line 3405: x_return_status := FND_API.G_RET_STS_ERROR ;

3401: write_to_act_log('Execution of process_all_sql ends ', 'LIST', g_list_header_id,'LOW');
3402: EXCEPTION
3403: WHEN FND_API.G_EXC_ERROR THEN
3404: write_to_act_log('Error while executing process_all_sql '||sqlcode||' '||sqlerrm, 'LIST', g_list_header_id,'HIGH');
3405: x_return_status := FND_API.G_RET_STS_ERROR ;
3406: FND_MSG_PUB.count_and_get(
3407: p_encoded => FND_API.g_false,
3408: p_count => x_msg_count,
3409: p_data => x_msg_data

Line 3407: p_encoded => FND_API.g_false,

3403: WHEN FND_API.G_EXC_ERROR THEN
3404: write_to_act_log('Error while executing process_all_sql '||sqlcode||' '||sqlerrm, 'LIST', g_list_header_id,'HIGH');
3405: x_return_status := FND_API.G_RET_STS_ERROR ;
3406: FND_MSG_PUB.count_and_get(
3407: p_encoded => FND_API.g_false,
3408: p_count => x_msg_count,
3409: p_data => x_msg_data
3410: );
3411:

Line 3412: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3408: p_count => x_msg_count,
3409: p_data => x_msg_data
3410: );
3411:
3412: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3413: write_to_act_log('Error while executing process_all_sql '||sqlcode||' '||sqlerrm, 'LIST', g_list_header_id,'HIGH');
3414: x_return_status := FND_API.G_RET_STS_ERROR ;
3415: FND_MSG_PUB.count_and_get(
3416: p_encoded => FND_API.g_false,

Line 3414: x_return_status := FND_API.G_RET_STS_ERROR ;

3410: );
3411:
3412: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3413: write_to_act_log('Error while executing process_all_sql '||sqlcode||' '||sqlerrm, 'LIST', g_list_header_id,'HIGH');
3414: x_return_status := FND_API.G_RET_STS_ERROR ;
3415: FND_MSG_PUB.count_and_get(
3416: p_encoded => FND_API.g_false,
3417: p_count => x_msg_count,
3418: p_data => x_msg_data

Line 3416: p_encoded => FND_API.g_false,

3412: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3413: write_to_act_log('Error while executing process_all_sql '||sqlcode||' '||sqlerrm, 'LIST', g_list_header_id,'HIGH');
3414: x_return_status := FND_API.G_RET_STS_ERROR ;
3415: FND_MSG_PUB.count_and_get(
3416: p_encoded => FND_API.g_false,
3417: p_count => x_msg_count,
3418: p_data => x_msg_data
3419: );
3420:

Line 3423: x_return_status := FND_API.G_RET_STS_ERROR ;

3419: );
3420:
3421: WHEN OTHERS THEN
3422: write_to_act_log('Error while executing process_all_sql '||sqlcode||' '||sqlerrm, 'LIST', g_list_header_id,'HIGH');
3423: x_return_status := FND_API.G_RET_STS_ERROR ;
3424: FND_MSG_PUB.count_and_get(
3425: p_encoded => FND_API.g_false,
3426: p_count => x_msg_count,
3427: p_data => x_msg_data

Line 3425: p_encoded => FND_API.g_false,

3421: WHEN OTHERS THEN
3422: write_to_act_log('Error while executing process_all_sql '||sqlcode||' '||sqlerrm, 'LIST', g_list_header_id,'HIGH');
3423: x_return_status := FND_API.G_RET_STS_ERROR ;
3424: FND_MSG_PUB.count_and_get(
3425: p_encoded => FND_API.g_false,
3426: p_count => x_msg_count,
3427: p_data => x_msg_data
3428: );
3429:

Line 3576: x_return_status := FND_API.G_RET_STS_ERROR ;

3572: write_to_act_log('Procedure process_sql executed.', 'LIST', g_list_header_id,'LOW' );
3573: exception
3574: when others then
3575: write_to_act_log('Error while executing procedure process_sql '||sqlcode||' '|| sqlerrm, 'LIST', g_list_header_id,'HIGH');
3576: x_return_status := FND_API.G_RET_STS_ERROR ;
3577: END process_sql;
3578:
3579: PROCEDURE process_diwb (p_action_used_by_id in number,
3580: p_incl_object_id in number,

Line 3654: x_return_status := FND_API.G_RET_STS_ERROR;

3650: where list_header_id = g_list_header_id;
3651: -- Added for cancel list gen as it prevents parallel update- Raghu
3652: -- of list headers when cancel button is pressed
3653: commit;
3654: x_return_status := FND_API.G_RET_STS_ERROR;
3655: return;
3656: end if;
3657: --
3658: l_counter := l_counter +1 ;

Line 3731: p_init_msg_list => FND_API.g_false,

3727: write_to_act_log('Executing process_cell since segment has been included in list/target group selections.', 'LIST', g_list_header_id,'LOW');
3728: write_to_act_log('Calling ams_cell_pvt.get_comp_sql to get the sql', 'LIST', g_list_header_id,'LOW');
3729: ams_cell_pvt.get_comp_sql(
3730: p_api_version => 1.0,
3731: p_init_msg_list => FND_API.g_false,
3732: p_validation_level => FND_API.g_valid_level_full,
3733: x_return_status => x_return_status,
3734: x_msg_count => x_msg_count ,
3735: x_msg_data =>x_msg_data,

Line 3732: p_validation_level => FND_API.g_valid_level_full,

3728: write_to_act_log('Calling ams_cell_pvt.get_comp_sql to get the sql', 'LIST', g_list_header_id,'LOW');
3729: ams_cell_pvt.get_comp_sql(
3730: p_api_version => 1.0,
3731: p_init_msg_list => FND_API.g_false,
3732: p_validation_level => FND_API.g_valid_level_full,
3733: x_return_status => x_return_status,
3734: x_msg_count => x_msg_count ,
3735: x_msg_data =>x_msg_data,
3736: p_cell_id => p_incl_object_id ,

Line 3737: p_party_id_only => FND_API.g_true, --bug 4635925

3733: x_return_status => x_return_status,
3734: x_msg_count => x_msg_count ,
3735: x_msg_data =>x_msg_data,
3736: p_cell_id => p_incl_object_id ,
3737: p_party_id_only => FND_API.g_true, --bug 4635925
3738: x_sql_tbl => l_sql_2
3739: );
3740: write_to_act_log('Procedure ams_cell_pvt.get_comp_sql executed. Return status is '||x_return_status, 'LIST', g_list_header_id,'LOW');
3741: l_sql_string_final := '';

Line 3803: l_return_status VARCHAR2(100) := FND_API.G_FALSE;

3799: -- AMS_LIST_SELECT_ACTIONS Record for init record and complete record
3800: l_tmp_action_rec ams_listaction_pvt.action_rec_type;
3801: p_action_rec ams_listaction_pvt.action_rec_type;
3802: l_list_select_action_id number;
3803: l_return_status VARCHAR2(100) := FND_API.G_FALSE;
3804:
3805: ----------------------------------------------------------------------------
3806: -- Cursor definition to select list_select_action_id.Will be used in loop to
3807: -- Process each cursor record according to order specified by the user

Line 3951: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS )THEN

3947: x_msg_data => x_msg_data ,
3948: x_return_status => x_return_status
3949: );
3950:
3951: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS )THEN
3952: if nvl(x_return_status,'S') in ('E','U') then -- resulted in error.
3953: write_to_act_log('Error in Cancel List generation', 'LIST', g_list_header_id,'HIGH');
3954: write_to_act_log('Error while executing Cancel List generation '||sqlerrm||sqlcode, 'LIST', g_list_header_id,'HIGH');
3955: end if;

Line 3956: RAISE FND_API.G_EXC_ERROR;

3952: if nvl(x_return_status,'S') in ('E','U') then -- resulted in error.
3953: write_to_act_log('Error in Cancel List generation', 'LIST', g_list_header_id,'HIGH');
3954: write_to_act_log('Error while executing Cancel List generation '||sqlerrm||sqlcode, 'LIST', g_list_header_id,'HIGH');
3955: end if;
3956: RAISE FND_API.G_EXC_ERROR;
3957: ELSE
3958: write_to_act_log('Success in Cancel List generation', 'LIST', g_list_header_id,'LOW');
3959: END IF;
3960:

Line 3989: RAISE FND_API.G_EXC_ERROR;

3985: IF (p_action_rec.list_action_type <> 'INCLUDE')then
3986: write_to_act_log('Action type of the first selection should always be INCLUDE. Aborting list generation.', 'LIST', g_list_header_id,'HIGH');
3987: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ACT_FIRST_INCLUDE');
3988: FND_MSG_PUB.Add;
3989: RAISE FND_API.G_EXC_ERROR;
3990: END IF; -- End of if for list_action_type check
3991: END IF; --End of Validation:- First Action Include Check
3992:
3993: write_to_act_log('Calling validate_listaction procedure to validate the list selection attributes','LIST',g_list_header_id, 'LOW');

Line 3996: p_init_msg_list => FND_API.G_FALSE,

3992:
3993: write_to_act_log('Calling validate_listaction procedure to validate the list selection attributes','LIST',g_list_header_id, 'LOW');
3994: ams_listaction_pvt.Validate_ListAction
3995: ( p_api_version => 1.0,
3996: p_init_msg_list => FND_API.G_FALSE,
3997: p_validation_level => JTF_PLSQL_API.G_VALID_LEVEL_RECORD,
3998: x_return_status => x_return_status,
3999: x_msg_count => x_msg_count,
4000: x_msg_data => x_msg_data,

Line 4004: IF x_return_status = FND_API.g_ret_sts_error THEN

4000: x_msg_data => x_msg_data,
4001: p_action_rec => p_action_rec
4002: );
4003:
4004: IF x_return_status = FND_API.g_ret_sts_error THEN
4005: RAISE FND_API.g_exc_error;
4006: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
4007: RAISE FND_API.g_exc_unexpected_error;
4008: END IF;

Line 4005: RAISE FND_API.g_exc_error;

4001: p_action_rec => p_action_rec
4002: );
4003:
4004: IF x_return_status = FND_API.g_ret_sts_error THEN
4005: RAISE FND_API.g_exc_error;
4006: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
4007: RAISE FND_API.g_exc_unexpected_error;
4008: END IF;
4009:

Line 4006: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

4002: );
4003:
4004: IF x_return_status = FND_API.g_ret_sts_error THEN
4005: RAISE FND_API.g_exc_error;
4006: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
4007: RAISE FND_API.g_exc_unexpected_error;
4008: END IF;
4009:
4010: if nvl(x_return_status,'S') in ('E','U') then -- resulted in error.

Line 4007: RAISE FND_API.g_exc_unexpected_error;

4003:
4004: IF x_return_status = FND_API.g_ret_sts_error THEN
4005: RAISE FND_API.g_exc_error;
4006: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
4007: RAISE FND_API.g_exc_unexpected_error;
4008: END IF;
4009:
4010: if nvl(x_return_status,'S') in ('E','U') then -- resulted in error.
4011: write_to_act_log('Error while validating list selections', 'LIST', g_list_header_id,'HIGH');

Line 4155: IF(x_return_status <>FND_API.G_RET_STS_SUCCESS )THEN

4151: end loop;
4152:
4153: end if;
4154:
4155: IF(x_return_status <>FND_API.G_RET_STS_SUCCESS )THEN
4156: RAISE FND_API.G_EXC_ERROR;
4157: END IF;
4158: write_to_act_log('Action on the list/target group selection completed. ', 'LIST', g_list_header_id,'LOW');
4159: -- end Of Dynamic Procedure

Line 4156: RAISE FND_API.G_EXC_ERROR;

4152:
4153: end if;
4154:
4155: IF(x_return_status <>FND_API.G_RET_STS_SUCCESS )THEN
4156: RAISE FND_API.G_EXC_ERROR;
4157: END IF;
4158: write_to_act_log('Action on the list/target group selection completed. ', 'LIST', g_list_header_id,'LOW');
4159: -- end Of Dynamic Procedure
4160: l_join_string :='';

Line 4333: x_return_status := FND_API.g_ret_sts_error; --Gen return status should go to error.

4329: main_gen_end_time = sysdate
4330: where list_header_id = g_list_header_id;
4331: update_remote_list_header(g_list_header_id,x_return_status,x_msg_count,x_msg_data);
4332: write_to_act_log('Aborting list generation ', 'LIST', g_list_header_id,'HIGH');
4333: x_return_status := FND_API.g_ret_sts_error; --Gen return status should go to error.
4334: return;
4335: --
4336: else
4337: write_to_act_log('List generated successfully in remote instance', 'LIST', g_list_header_id,'HIGH');

Line 4515: x_return_status := FND_API.g_ret_sts_error; --Gen return status should go to error.

4511: main_gen_end_time = sysdate
4512: where list_header_id = g_list_header_id;
4513: update_remote_list_header(g_list_header_id,x_return_status,x_msg_count,x_msg_data);
4514: write_to_act_log('Aborting list generation ', 'LIST', g_list_header_id,'HIGH');
4515: x_return_status := FND_API.g_ret_sts_error; --Gen return status should go to error.
4516: return;
4517: --
4518: else
4519: write_to_act_log('List generated successfully in remote instance', 'LIST', g_list_header_id,'HIGH');

Line 4531: WHEN FND_API.G_EXC_ERROR THEN

4527: close c_count1;
4528: WRITE_TO_ACT_LOG('Total Number of entries in list is '|| l_count1, 'LIST', g_list_header_id,'LOW');
4529: WRITE_TO_ACT_LOG('Execution of Process_list_action completed', 'LIST', g_list_header_id,'LOW');
4530: EXCEPTION
4531: WHEN FND_API.G_EXC_ERROR THEN
4532: IF(c_action_dets%ISOPEN)THEN
4533: CLOSE c_action_dets;
4534: END IF;
4535: write_to_act_log('Error while executing process_list_actions '

Line 4538: x_return_status := FND_API.G_RET_STS_ERROR ;

4534: END IF;
4535: write_to_act_log('Error while executing process_list_actions '
4536: ||sqlerrm||sqlcode, 'LIST', g_list_header_id,'HIGH');
4537: -- Check if reset of the status is required
4538: x_return_status := FND_API.G_RET_STS_ERROR ;
4539: FND_MSG_PUB.count_and_get(
4540: p_encoded => FND_API.g_false,
4541: p_count => x_msg_count,
4542: p_data => x_msg_data);

Line 4540: p_encoded => FND_API.g_false,

4536: ||sqlerrm||sqlcode, 'LIST', g_list_header_id,'HIGH');
4537: -- Check if reset of the status is required
4538: x_return_status := FND_API.G_RET_STS_ERROR ;
4539: FND_MSG_PUB.count_and_get(
4540: p_encoded => FND_API.g_false,
4541: p_count => x_msg_count,
4542: p_data => x_msg_data);
4543:
4544: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4544: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4540: p_encoded => FND_API.g_false,
4541: p_count => x_msg_count,
4542: p_data => x_msg_data);
4543:
4544: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4545: IF(c_action_dets%ISOPEN)THEN
4546: CLOSE c_action_dets;
4547: END IF;
4548: write_to_act_log('Error while executing process_list_actions '

Line 4553: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4549: ||sqlerrm||sqlcode, 'LIST', g_list_header_id,'HIGH');
4550: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
4551: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
4552: FND_MSG_PUB.Add;
4553: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4554: FND_MSG_PUB.count_and_get(
4555: p_encoded => FND_API.g_false,
4556: p_count => x_msg_count,
4557: p_data => x_msg_data);

Line 4555: p_encoded => FND_API.g_false,

4551: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
4552: FND_MSG_PUB.Add;
4553: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4554: FND_MSG_PUB.count_and_get(
4555: p_encoded => FND_API.g_false,
4556: p_count => x_msg_count,
4557: p_data => x_msg_data);
4558:
4559: WHEN AMS_LISTGENERATION_UTIL_PKG.cancelListGen THEN

Line 4564: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4560: IF(c_action_dets%ISOPEN)THEN
4561: CLOSE c_action_dets;
4562: END IF;
4563:
4564: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4565:
4566: write_to_act_log('executing process_list_actions - user action to cancel list generation detected ' ||sqlerrm||sqlcode, 'LIST', g_list_header_id,'HIGH');
4567: -- Got to raise the exception again because Listgen has to end generation.
4568: raise AMS_LISTGENERATION_UTIL_PKG.cancelListGen;

Line 4579: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4575: ||sqlerrm||sqlcode, 'LIST', g_list_header_id,'HIGH');
4576: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
4577: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
4578: FND_MSG_PUB.Add;
4579: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4580: FND_MSG_PUB.count_and_get(
4581: p_encoded => FND_API.g_false,
4582: p_count => x_msg_count,
4583: p_data => x_msg_data);

Line 4581: p_encoded => FND_API.g_false,

4577: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
4578: FND_MSG_PUB.Add;
4579: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4580: FND_MSG_PUB.count_and_get(
4581: p_encoded => FND_API.g_false,
4582: p_count => x_msg_count,
4583: p_data => x_msg_data);
4584:
4585: END process_list_actions;

Line 4624: l_return_status VARCHAR2(100) := FND_API.G_FALSE;

4620: p_no_of_rows_min_requested in number,
4621: x_return_status OUT NOCOPY VARCHAR2 ) IS
4622:
4623: l_entry_count NUMBER;
4624: l_return_status VARCHAR2(100) := FND_API.G_FALSE;
4625: l_source_code VARCHAR2(100) := 'NONE';
4626: l_source_id NUMBER := 0;
4627:
4628: l_created_by NUMBER;

Line 4741: x_return_status := FND_API.G_RET_STS_ERROR;

4737: FND_MESSAGE.set_name('AMS', 'AMS_LIST_MINIMUM_NOT_REACHED');
4738: FND_MESSAGE.Set_Token('NO_AVAILABLE',TO_CHAR(l_entry_count));
4739: FND_MESSAGE.Set_Token('NO_REQUESTED',TO_CHAR(p_no_of_rows_min_requested));
4740: FND_MSG_PUB.Add;
4741: x_return_status := FND_API.G_RET_STS_ERROR;
4742: ELSE
4743: x_return_status := FND_API.G_RET_STS_SUCCESS;
4744: END if;
4745: */

Line 4743: x_return_status := FND_API.G_RET_STS_SUCCESS;

4739: FND_MESSAGE.Set_Token('NO_REQUESTED',TO_CHAR(p_no_of_rows_min_requested));
4740: FND_MSG_PUB.Add;
4741: x_return_status := FND_API.G_RET_STS_ERROR;
4742: ELSE
4743: x_return_status := FND_API.G_RET_STS_SUCCESS;
4744: END if;
4745: */
4746: x_return_status := FND_API.G_RET_STS_SUCCESS;
4747: -- End changes for migration

Line 4746: x_return_status := FND_API.G_RET_STS_SUCCESS;

4742: ELSE
4743: x_return_status := FND_API.G_RET_STS_SUCCESS;
4744: END if;
4745: */
4746: x_return_status := FND_API.G_RET_STS_SUCCESS;
4747: -- End changes for migration
4748: exception
4749: when others then
4750: write_to_act_log('Error while executing procedure create_list_entries', 'LIST', g_list_header_id,'HIGH');

Line 4751: x_return_status := FND_API.G_RET_STS_ERROR;

4747: -- End changes for migration
4748: exception
4749: when others then
4750: write_to_act_log('Error while executing procedure create_list_entries', 'LIST', g_list_header_id,'HIGH');
4751: x_return_status := FND_API.G_RET_STS_ERROR;
4752:
4753: end create_list_entries;
4754:
4755:

Line 6776: x_return_status := FND_API.G_RET_STS_SUCCESS;

6772: END LOOP;
6773: CLOSE c_child_mapping;
6774: END LOOP;
6775: CLOSE C_MAPPING_TYPES_USED;
6776: x_return_status := FND_API.G_RET_STS_SUCCESS;
6777: write_to_act_log('Calling update_list_entries to update selections based on list.','LIST', g_list_header_id,'LOW');
6778: -- update_list_entries(p_list_header_id); LPO
6779: write_to_act_log('Calling update_import_list_entries to update selections based on import.','LIST', g_list_header_id,'LOW');
6780: update_import_list_entries (p_list_header_id);

Line 6793: x_return_status := FND_API.G_RET_STS_ERROR;

6789: CLOSE C_MAPPING_TYPE_FIELDS;
6790: END IF;
6791:
6792: write_to_act_log('Error while generating list in update mode : '||sqlerrm||sqlcode, 'LIST', g_list_header_id,'HIGH');
6793: x_return_status := FND_API.G_RET_STS_ERROR;
6794: END GET_LIST_ENTRY_DATA;
6795:
6796:
6797: -- START OF COMMENTS

Line 6810: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

6806: -------------------------------------------------------------------------------
6807:
6808: PROCEDURE GENERATE_LIST
6809: ( p_api_version IN NUMBER,
6810: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
6811: p_commit IN VARCHAR2 := FND_API.G_FALSE,
6812: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
6813: p_list_header_id IN NUMBER,
6814: x_return_status OUT NOCOPY VARCHAR2,

Line 6811: p_commit IN VARCHAR2 := FND_API.G_FALSE,

6807:
6808: PROCEDURE GENERATE_LIST
6809: ( p_api_version IN NUMBER,
6810: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
6811: p_commit IN VARCHAR2 := FND_API.G_FALSE,
6812: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
6813: p_list_header_id IN NUMBER,
6814: x_return_status OUT NOCOPY VARCHAR2,
6815: x_msg_count OUT NOCOPY NUMBER,

Line 6812: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

6808: PROCEDURE GENERATE_LIST
6809: ( p_api_version IN NUMBER,
6810: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
6811: p_commit IN VARCHAR2 := FND_API.G_FALSE,
6812: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
6813: p_list_header_id IN NUMBER,
6814: x_return_status OUT NOCOPY VARCHAR2,
6815: x_msg_count OUT NOCOPY NUMBER,
6816: x_msg_data OUT NOCOPY VARCHAR2) IS

Line 7140: p_encoded => FND_API.g_false,

7136: last_update_date = sysdate,
7137: main_gen_end_time = sysdate
7138: WHERE list_header_id = g_list_header_id;
7139: FND_MSG_PUB.count_and_get(
7140: p_encoded => FND_API.g_false,
7141: p_count => x_msg_count,
7142: p_data => x_msg_data
7143: );
7144: x_return_status := FND_API.g_ret_sts_error;

Line 7144: x_return_status := FND_API.g_ret_sts_error;

7140: p_encoded => FND_API.g_false,
7141: p_count => x_msg_count,
7142: p_data => x_msg_data
7143: );
7144: x_return_status := FND_API.g_ret_sts_error;
7145: --
7146: logger;
7147: RETURN;
7148: END IF;

Line 7177: IF FND_API.To_Boolean ( p_commit ) THEN

7173: WHERE list_header_id = p_list_header_id;
7174: -- calling logging program
7175: logger;
7176: --
7177: IF FND_API.To_Boolean ( p_commit ) THEN
7178: COMMIT WORK;
7179: END IF;
7180: --Modified by bmuthukr. Bug # 4083665
7181: x_return_status := FND_API.g_ret_sts_error;

Line 7181: x_return_status := FND_API.g_ret_sts_error;

7177: IF FND_API.To_Boolean ( p_commit ) THEN
7178: COMMIT WORK;
7179: END IF;
7180: --Modified by bmuthukr. Bug # 4083665
7181: x_return_status := FND_API.g_ret_sts_error;
7182: --
7183: RETURN;
7184: end if;
7185:

Line 7219: x_return_status := FND_API.g_ret_sts_error;

7215: last_update_date = sysdate,
7216: main_gen_end_time = sysdate
7217: WHERE list_header_id = g_list_header_id;
7218: --Modified by bmuthukr. Bug # 4083665
7219: x_return_status := FND_API.g_ret_sts_error;
7220: --
7221: logger;
7222: RETURN;
7223: END IF;

Line 7231: x_return_status := FND_API.G_RET_STS_SUCCESS;

7227: p_arc_log_used_by => 'LIST',
7228: p_log_used_by_id => p_list_header_id,
7229: p_level => 'LOW');
7230:
7231: x_return_status := FND_API.G_RET_STS_SUCCESS;
7232:
7233: -- Standard call to check for call compatibility.
7234: IF NOT FND_API.Compatible_API_Call ( l_api_version,
7235: p_api_version,

Line 7234: IF NOT FND_API.Compatible_API_Call ( l_api_version,

7230:
7231: x_return_status := FND_API.G_RET_STS_SUCCESS;
7232:
7233: -- Standard call to check for call compatibility.
7234: IF NOT FND_API.Compatible_API_Call ( l_api_version,
7235: p_api_version,
7236: l_api_name,
7237: G_PKG_NAME)
7238: THEN

Line 7239: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7235: p_api_version,
7236: l_api_name,
7237: G_PKG_NAME)
7238: THEN
7239: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7240: END IF;
7241:
7242: IF FND_API.to_Boolean( p_init_msg_list ) THEN
7243: FND_MSG_PUB.initialize;

Line 7242: IF FND_API.to_Boolean( p_init_msg_list ) THEN

7238: THEN
7239: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7240: END IF;
7241:
7242: IF FND_API.to_Boolean( p_init_msg_list ) THEN
7243: FND_MSG_PUB.initialize;
7244: END IF;
7245:
7246: -- Checking if Debug is set. If debug is set then log debugging message

Line 7254: x_return_status := FND_API.G_RET_STS_SUCCESS;

7250: FND_MSG_PUB.Add;
7251: END IF;
7252:
7253: -- Initialize API return status to success
7254: x_return_status := FND_API.G_RET_STS_SUCCESS;
7255:
7256:
7257: open c_remote_list;
7258: fetch c_remote_list into g_remote_list,g_database_link;

Line 7335: IF x_return_status = FND_API.g_ret_sts_error THEN

7331: p_log_used_by_id => p_list_header_id,
7332: p_level => 'LOW');
7333: end if;
7334:
7335: IF x_return_status = FND_API.g_ret_sts_error THEN
7336: RAISE FND_API.g_exc_error;
7337: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
7338: RAISE FND_API.g_exc_unexpected_error;
7339: END IF;

Line 7336: RAISE FND_API.g_exc_error;

7332: p_level => 'LOW');
7333: end if;
7334:
7335: IF x_return_status = FND_API.g_ret_sts_error THEN
7336: RAISE FND_API.g_exc_error;
7337: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
7338: RAISE FND_API.g_exc_unexpected_error;
7339: END IF;
7340:

Line 7337: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

7333: end if;
7334:
7335: IF x_return_status = FND_API.g_ret_sts_error THEN
7336: RAISE FND_API.g_exc_error;
7337: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
7338: RAISE FND_API.g_exc_unexpected_error;
7339: END IF;
7340:
7341: if l_listheader_rec.generation_type = 'UPD' then

Line 7338: RAISE FND_API.g_exc_unexpected_error;

7334:
7335: IF x_return_status = FND_API.g_ret_sts_error THEN
7336: RAISE FND_API.g_exc_error;
7337: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
7338: RAISE FND_API.g_exc_unexpected_error;
7339: END IF;
7340:
7341: if l_listheader_rec.generation_type = 'UPD' then
7342: open c_check_gen_mode;

Line 7358: x_return_status := FND_API.g_ret_sts_error;

7354: last_update_date = sysdate,
7355: main_gen_end_time = sysdate,
7356: no_of_rows_in_ctrl_group = null
7357: WHERE list_header_id = g_list_header_id;
7358: x_return_status := FND_API.g_ret_sts_error;
7359: logger;
7360: RETURN;
7361: end if;
7362: end if;

Line 7423: IF x_return_status = FND_API.g_ret_sts_error THEN

7419: --
7420: GET_LIST_ENTRY_DATA(
7421: p_list_header_id =>l_listheader_rec.list_header_id,
7422: x_return_status => x_return_status);
7423: IF x_return_status = FND_API.g_ret_sts_error THEN
7424: RAISE FND_API.g_exc_error;
7425: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
7426: RAISE FND_API.g_exc_unexpected_error;
7427: END IF;

Line 7424: RAISE FND_API.g_exc_error;

7420: GET_LIST_ENTRY_DATA(
7421: p_list_header_id =>l_listheader_rec.list_header_id,
7422: x_return_status => x_return_status);
7423: IF x_return_status = FND_API.g_ret_sts_error THEN
7424: RAISE FND_API.g_exc_error;
7425: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
7426: RAISE FND_API.g_exc_unexpected_error;
7427: END IF;
7428: -- end if;

Line 7425: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

7421: p_list_header_id =>l_listheader_rec.list_header_id,
7422: x_return_status => x_return_status);
7423: IF x_return_status = FND_API.g_ret_sts_error THEN
7424: RAISE FND_API.g_exc_error;
7425: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
7426: RAISE FND_API.g_exc_unexpected_error;
7427: END IF;
7428: -- end if;
7429: -- END IF;

Line 7426: RAISE FND_API.g_exc_unexpected_error;

7422: x_return_status => x_return_status);
7423: IF x_return_status = FND_API.g_ret_sts_error THEN
7424: RAISE FND_API.g_exc_error;
7425: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
7426: RAISE FND_API.g_exc_unexpected_error;
7427: END IF;
7428: -- end if;
7429: -- END IF;
7430: ELSE --

Line 7452: IF x_return_status = FND_API.g_ret_sts_error THEN

7448: write_to_act_log('Error in generating list.', 'LIST', g_list_header_id,'HIGH');
7449: write_to_act_log('Error '||x_msg_data , 'LIST', g_list_header_id,'HIGH');
7450: end if;
7451:
7452: IF x_return_status = FND_API.g_ret_sts_error THEN
7453: RAISE FND_API.g_exc_error;
7454: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
7455: RAISE FND_API.g_exc_unexpected_error;
7456: END IF;

Line 7453: RAISE FND_API.g_exc_error;

7449: write_to_act_log('Error '||x_msg_data , 'LIST', g_list_header_id,'HIGH');
7450: end if;
7451:
7452: IF x_return_status = FND_API.g_ret_sts_error THEN
7453: RAISE FND_API.g_exc_error;
7454: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
7455: RAISE FND_API.g_exc_unexpected_error;
7456: END IF;
7457:

Line 7454: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

7450: end if;
7451:
7452: IF x_return_status = FND_API.g_ret_sts_error THEN
7453: RAISE FND_API.g_exc_error;
7454: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
7455: RAISE FND_API.g_exc_unexpected_error;
7456: END IF;
7457:
7458:

Line 7455: RAISE FND_API.g_exc_unexpected_error;

7451:
7452: IF x_return_status = FND_API.g_ret_sts_error THEN
7453: RAISE FND_API.g_exc_error;
7454: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
7455: RAISE FND_API.g_exc_unexpected_error;
7456: END IF;
7457:
7458:
7459: /******************************************************************************/

Line 7474: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS )THEN

7470: x_msg_data => x_msg_data ,
7471: x_return_status => x_return_status
7472: );
7473:
7474: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS )THEN
7475: if nvl(x_return_status,'S') in ('E','U') then -- resulted in error.
7476: write_to_act_log('Error in Cancel List generation', 'LIST', g_list_header_id,'HIGH');
7477: write_to_act_log('Error while executing Cancel List generation '||sqlerrm||sqlcode, 'LIST', g_list_header_id,'HIGH');
7478: end if;

Line 7479: RAISE FND_API.G_EXC_ERROR;

7475: if nvl(x_return_status,'S') in ('E','U') then -- resulted in error.
7476: write_to_act_log('Error in Cancel List generation', 'LIST', g_list_header_id,'HIGH');
7477: write_to_act_log('Error while executing Cancel List generation '||sqlerrm||sqlcode, 'LIST', g_list_header_id,'HIGH');
7478: end if;
7479: RAISE FND_API.G_EXC_ERROR;
7480: ELSE
7481: write_to_act_log('Success in Cancel List generation', 'LIST', g_list_header_id,'LOW');
7482: END IF;
7483:

Line 7497: IF x_return_status = FND_API.g_ret_sts_error THEN

7493: set enabled_flag = 'N'
7494: where newly_updated_flag = 'N'
7495: and list_header_id = l_listheader_rec.list_header_id;
7496: write_to_act_log(sql%rowcount||' entries disabled when generating list in update mode','LIST',g_list_header_id,'HIGH');
7497: IF x_return_status = FND_API.g_ret_sts_error THEN
7498: RAISE FND_API.g_exc_error;
7499: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
7500: RAISE FND_API.g_exc_unexpected_error;
7501: END IF;

Line 7498: RAISE FND_API.g_exc_error;

7494: where newly_updated_flag = 'N'
7495: and list_header_id = l_listheader_rec.list_header_id;
7496: write_to_act_log(sql%rowcount||' entries disabled when generating list in update mode','LIST',g_list_header_id,'HIGH');
7497: IF x_return_status = FND_API.g_ret_sts_error THEN
7498: RAISE FND_API.g_exc_error;
7499: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
7500: RAISE FND_API.g_exc_unexpected_error;
7501: END IF;
7502: -- -----------------------

Line 7499: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

7495: and list_header_id = l_listheader_rec.list_header_id;
7496: write_to_act_log(sql%rowcount||' entries disabled when generating list in update mode','LIST',g_list_header_id,'HIGH');
7497: IF x_return_status = FND_API.g_ret_sts_error THEN
7498: RAISE FND_API.g_exc_error;
7499: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
7500: RAISE FND_API.g_exc_unexpected_error;
7501: END IF;
7502: -- -----------------------
7503: else -- if g_remote_list = 'Y' then

Line 7500: RAISE FND_API.g_exc_unexpected_error;

7496: write_to_act_log(sql%rowcount||' entries disabled when generating list in update mode','LIST',g_list_header_id,'HIGH');
7497: IF x_return_status = FND_API.g_ret_sts_error THEN
7498: RAISE FND_API.g_exc_error;
7499: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
7500: RAISE FND_API.g_exc_unexpected_error;
7501: END IF;
7502: -- -----------------------
7503: else -- if g_remote_list = 'Y' then
7504: write_to_act_log('Updating list in remote instance.', 'LIST', p_list_header_id,'HIGH');

Line 7636: IF (x_return_status <>FND_API.G_RET_STS_SUCCESS )THEN

7632: out x_msg_data;
7633: write_to_act_log('x return status '||x_return_status, 'LIST', g_list_header_id,'LOW');
7634: write_to_act_log('apply_size_reduction procedure executed in the remote instance.', 'LIST', g_list_header_id,'LOW');
7635: end if;
7636: IF (x_return_status <>FND_API.G_RET_STS_SUCCESS )THEN
7637: if nvl(x_return_status,'S') in ('E','U') then -- resulted in error.
7638: write_to_act_log('Error in while executing size reduction procedure.', 'LIST', g_list_header_id,'HIGH');
7639: end if;
7640: RAISE FND_API.G_EXC_ERROR;

Line 7640: RAISE FND_API.G_EXC_ERROR;

7636: IF (x_return_status <>FND_API.G_RET_STS_SUCCESS )THEN
7637: if nvl(x_return_status,'S') in ('E','U') then -- resulted in error.
7638: write_to_act_log('Error in while executing size reduction procedure.', 'LIST', g_list_header_id,'HIGH');
7639: end if;
7640: RAISE FND_API.G_EXC_ERROR;
7641: ELSE
7642: write_to_act_log('Procedure apply_size_reduction executed successfully.', 'LIST', g_list_header_id,'LOW');
7643: IF FND_API.To_Boolean ( p_commit ) THEN
7644: COMMIT;

Line 7643: IF FND_API.To_Boolean ( p_commit ) THEN

7639: end if;
7640: RAISE FND_API.G_EXC_ERROR;
7641: ELSE
7642: write_to_act_log('Procedure apply_size_reduction executed successfully.', 'LIST', g_list_header_id,'LOW');
7643: IF FND_API.To_Boolean ( p_commit ) THEN
7644: COMMIT;
7645: END IF;
7646: END IF;
7647: end if;

Line 7761: IF(x_return_status <>FND_API.G_RET_STS_SUCCESS )THEN

7757: elsif nvl(x_return_status,'S') = 'S' then
7758: write_to_act_log('List header and selections info updated.'||x_msg_data , 'LIST', g_list_header_id,'LOW');
7759: end if;
7760:
7761: IF(x_return_status <>FND_API.G_RET_STS_SUCCESS )THEN
7762: write_to_act_log('Error after calling update_list_dets procedure', 'LIST', p_list_header_id,'HIGH');
7763: RAISE FND_API.G_EXC_ERROR;
7764: ELSE
7765: IF FND_API.To_Boolean ( p_commit ) THEN

Line 7763: RAISE FND_API.G_EXC_ERROR;

7759: end if;
7760:
7761: IF(x_return_status <>FND_API.G_RET_STS_SUCCESS )THEN
7762: write_to_act_log('Error after calling update_list_dets procedure', 'LIST', p_list_header_id,'HIGH');
7763: RAISE FND_API.G_EXC_ERROR;
7764: ELSE
7765: IF FND_API.To_Boolean ( p_commit ) THEN
7766: write_to_act_log('Generate_list : Commit', 'LIST', g_list_header_id,'LOW');
7767: COMMIT;

Line 7765: IF FND_API.To_Boolean ( p_commit ) THEN

7761: IF(x_return_status <>FND_API.G_RET_STS_SUCCESS )THEN
7762: write_to_act_log('Error after calling update_list_dets procedure', 'LIST', p_list_header_id,'HIGH');
7763: RAISE FND_API.G_EXC_ERROR;
7764: ELSE
7765: IF FND_API.To_Boolean ( p_commit ) THEN
7766: write_to_act_log('Generate_list : Commit', 'LIST', g_list_header_id,'LOW');
7767: COMMIT;
7768: END IF;
7769: END IF;

Line 7794: IF FND_API.To_Boolean ( p_commit ) THEN

7790:
7791: logger;
7792: -- Standard check of p_commit.
7793:
7794: IF FND_API.To_Boolean ( p_commit ) THEN
7795: COMMIT WORK;
7796: END IF;
7797:
7798: -- Success Message

Line 7807: x_return_status := FND_API.G_RET_STS_SUCCESS;

7803: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration_PKG.Generate_List');
7804: FND_MSG_PUB.Add;
7805: --END IF;
7806:
7807: x_return_status := FND_API.G_RET_STS_SUCCESS;
7808: --IF (AMS_DEBUG_HIGH_ON) THEN
7809: --THEN
7810: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
7811: FND_MESSAGE.Set_Token('TEXT', 'AMS_ListGeneration_PKG.Generate_List: END');

Line 7815: p_encoded => FND_API.g_false,

7811: FND_MESSAGE.Set_Token('TEXT', 'AMS_ListGeneration_PKG.Generate_List: END');
7812: FND_MSG_PUB.Add;
7813: --END IF;
7814: FND_MSG_PUB.count_and_get(
7815: p_encoded => FND_API.g_false,
7816: p_count => x_msg_count,
7817: p_data => x_msg_data
7818: );
7819:

Line 7821: WHEN FND_API.G_EXC_ERROR THEN

7817: p_data => x_msg_data
7818: );
7819:
7820: EXCEPTION
7821: WHEN FND_API.G_EXC_ERROR THEN
7822: -- calling logging program
7823: write_to_act_log('Error in generating list while executing procedure generate_list '||sqlcode||' '||sqlerrm,'LIST',g_list_header_id,'HIGH');
7824:
7825: --

Line 7836: x_return_status := FND_API.G_RET_STS_ERROR ;

7832: main_gen_end_time = sysdate
7833: WHERE list_header_id = p_list_header_id;
7834: logger;
7835: -- Check if reset of the status is required
7836: x_return_status := FND_API.G_RET_STS_ERROR ;
7837: FND_MSG_PUB.count_and_get(
7838: p_encoded => FND_API.g_false,
7839: p_count => x_msg_count,
7840: p_data => x_msg_data);

Line 7838: p_encoded => FND_API.g_false,

7834: logger;
7835: -- Check if reset of the status is required
7836: x_return_status := FND_API.G_RET_STS_ERROR ;
7837: FND_MSG_PUB.count_and_get(
7838: p_encoded => FND_API.g_false,
7839: p_count => x_msg_count,
7840: p_data => x_msg_data);
7841:
7842: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 7842: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

7838: p_encoded => FND_API.g_false,
7839: p_count => x_msg_count,
7840: p_data => x_msg_data);
7841:
7842: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7843: -- calling logging program
7844: write_to_act_log('Error in generating list while executing procedure generate_list '||sqlcode||' '||sqlerrm,'LIST',g_list_header_id,'HIGH');
7845: --
7846: UPDATE ams_list_headers_all

Line 7858: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

7854: logger;
7855: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
7856: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
7857: FND_MSG_PUB.Add;
7858: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7859: FND_MSG_PUB.count_and_get(
7860: p_encoded => FND_API.g_false,
7861: p_count => x_msg_count,
7862: p_data => x_msg_data);

Line 7860: p_encoded => FND_API.g_false,

7856: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
7857: FND_MSG_PUB.Add;
7858: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7859: FND_MSG_PUB.count_and_get(
7860: p_encoded => FND_API.g_false,
7861: p_count => x_msg_count,
7862: p_data => x_msg_data);
7863: ---------------Cancel List Gen Exception Begin --------------
7864: WHEN AMS_LISTGENERATION_UTIL_PKG.cancelListGen THEN

Line 7882: x_return_status := FND_API.G_RET_STS_SUCCESS;

7878: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
7879: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration_PKG.Generate_List');
7880: FND_MSG_PUB.Add;
7881:
7882: x_return_status := FND_API.G_RET_STS_SUCCESS;
7883:
7884: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
7885: FND_MESSAGE.Set_Token('TEXT', 'AMS_ListGeneration_PKG.Generate_List: END');
7886: FND_MSG_PUB.Add;

Line 7889: p_encoded => FND_API.g_false,

7885: FND_MESSAGE.Set_Token('TEXT', 'AMS_ListGeneration_PKG.Generate_List: END');
7886: FND_MSG_PUB.Add;
7887:
7888: FND_MSG_PUB.count_and_get(
7889: p_encoded => FND_API.g_false,
7890: p_count => x_msg_count,
7891: p_data => x_msg_data
7892: );
7893: ---------------Cancel List Gen Exception End --------------

Line 7911: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

7907: logger;
7908: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
7909: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
7910: FND_MSG_PUB.Add;
7911: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7912: FND_MSG_PUB.count_and_get(
7913: p_encoded => FND_API.g_false,
7914: p_count => x_msg_count,
7915: p_data => x_msg_data);

Line 7913: p_encoded => FND_API.g_false,

7909: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
7910: FND_MSG_PUB.Add;
7911: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7912: FND_MSG_PUB.count_and_get(
7913: p_encoded => FND_API.g_false,
7914: p_count => x_msg_count,
7915: p_data => x_msg_data);
7916: END GENERATE_LIST;
7917:

Line 7920: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

7916: END GENERATE_LIST;
7917:
7918: PROCEDURE create_list
7919: ( p_api_version IN NUMBER,
7920: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
7921: p_commit IN VARCHAR2 := FND_API.G_FALSE,
7922: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
7923: p_list_name in varchar2,
7924: p_list_type in varchar2,

Line 7921: p_commit IN VARCHAR2 := FND_API.G_FALSE,

7917:
7918: PROCEDURE create_list
7919: ( p_api_version IN NUMBER,
7920: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
7921: p_commit IN VARCHAR2 := FND_API.G_FALSE,
7922: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
7923: p_list_name in varchar2,
7924: p_list_type in varchar2,
7925: p_owner_user_id in number,

Line 7922: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

7918: PROCEDURE create_list
7919: ( p_api_version IN NUMBER,
7920: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
7921: p_commit IN VARCHAR2 := FND_API.G_FALSE,
7922: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
7923: p_list_name in varchar2,
7924: p_list_type in varchar2,
7925: p_owner_user_id in number,
7926: p_sql_string in OUT NOCOPY varchar2,

Line 7935: l_init_msg_list varchar2(2000) := FND_API.G_FALSE;

7931: x_msg_count OUT NOCOPY NUMBER,
7932: x_msg_data OUT NOCOPY VARCHAR2,
7933: x_list_header_id OUT NOCOPY NUMBER ) is
7934: l_list_header_rec AMS_ListHeader_PVT.list_header_rec_type;
7935: l_init_msg_list varchar2(2000) := FND_API.G_FALSE;
7936: l_api_version number := 1.0;
7937: l_api_name constant varchar2(30) := 'Create_List';
7938: l_list_query_rec AMS_List_Query_PVT.list_query_rec_type ;
7939: l_list_query_id number ;

Line 7974: x_return_status := FND_API.G_RET_STS_SUCCESS;

7970: close c_mapping_subtypes;
7971: */
7972:
7973: p_sql_string := l_select_string ||','|| substrb(p_sql_string,instr(upper(p_sql_string),'SELECT',1)+6);
7974: x_return_status := FND_API.G_RET_STS_SUCCESS;
7975: -- Standard call to check for call compatibility.
7976: IF NOT FND_API.Compatible_API_Call ( l_api_version,
7977: p_api_version,
7978: l_api_name,

Line 7976: IF NOT FND_API.Compatible_API_Call ( l_api_version,

7972:
7973: p_sql_string := l_select_string ||','|| substrb(p_sql_string,instr(upper(p_sql_string),'SELECT',1)+6);
7974: x_return_status := FND_API.G_RET_STS_SUCCESS;
7975: -- Standard call to check for call compatibility.
7976: IF NOT FND_API.Compatible_API_Call ( l_api_version,
7977: p_api_version,
7978: l_api_name,
7979: G_PKG_NAME) THEN
7980: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 7980: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7976: IF NOT FND_API.Compatible_API_Call ( l_api_version,
7977: p_api_version,
7978: l_api_name,
7979: G_PKG_NAME) THEN
7980: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7981: END IF;
7982:
7983:
7984: -- Initialize message list IF p_init_msg_list is set to TRUE.

Line 7985: IF FND_API.to_Boolean( p_init_msg_list ) THEN

7981: END IF;
7982:
7983:
7984: -- Initialize message list IF p_init_msg_list is set to TRUE.
7985: IF FND_API.to_Boolean( p_init_msg_list ) THEN
7986: FND_MSG_PUB.initialize;
7987: END IF;
7988:
7989: -- Debug Message

Line 7997: x_return_status := FND_API.G_RET_STS_SUCCESS;

7993: FND_MSG_PUB.Add;
7994: END IF;
7995:
7996: -- Initialize API return status to success
7997: x_return_status := FND_API.G_RET_STS_SUCCESS;
7998: -- Perform the database operation
7999:
8000: -- ams_listheader_pvt.init_listheader_rec(l_list_header_rec);
8001: l_list_header_rec.list_name := p_list_name;

Line 8020: if x_return_status <> FND_API.g_ret_sts_success THEN

8016: p_listheader_rec => l_list_header_rec,
8017: x_listheader_id => x_list_header_id
8018: );
8019:
8020: if x_return_status <> FND_API.g_ret_sts_success THEN
8021: RAISE FND_API.G_EXC_ERROR;
8022: end if;
8023:
8024: FND_MESSAGE.set_name('AMS', 'bfore list query');

Line 8021: RAISE FND_API.G_EXC_ERROR;

8017: x_listheader_id => x_list_header_id
8018: );
8019:
8020: if x_return_status <> FND_API.g_ret_sts_success THEN
8021: RAISE FND_API.G_EXC_ERROR;
8022: end if;
8023:
8024: FND_MESSAGE.set_name('AMS', 'bfore list query');
8025: FND_MSG_PUB.Add;

Line 8042: if x_return_status <> FND_API.g_ret_sts_success THEN

8038: x_msg_data => x_msg_data,
8039: p_list_query_rec => l_list_query_rec ,
8040: x_list_query_id => l_list_query_id
8041: );
8042: if x_return_status <> FND_API.g_ret_sts_success THEN
8043: RAISE FND_API.G_EXC_ERROR;
8044: end if;
8045:
8046: l_action_rec.arc_action_used_by := 'LIST';

Line 8043: RAISE FND_API.G_EXC_ERROR;

8039: p_list_query_rec => l_list_query_rec ,
8040: x_list_query_id => l_list_query_id
8041: );
8042: if x_return_status <> FND_API.g_ret_sts_success THEN
8043: RAISE FND_API.G_EXC_ERROR;
8044: end if;
8045:
8046: l_action_rec.arc_action_used_by := 'LIST';
8047: l_action_rec.action_used_by_id := x_list_header_id ;

Line 8064: if x_return_status <> FND_API.g_ret_sts_success THEN

8060: x_msg_data => x_msg_data,
8061: p_action_rec => l_action_rec,
8062: x_action_id => l_action_id
8063: ) ;
8064: if x_return_status <> FND_API.g_ret_sts_success THEN
8065: RAISE FND_API.G_EXC_ERROR;
8066: end if;
8067: --For bug 4351391
8068: ams_list_wf.StartListBizEventProcess(p_list_header_id => x_list_header_id);

Line 8065: RAISE FND_API.G_EXC_ERROR;

8061: p_action_rec => l_action_rec,
8062: x_action_id => l_action_id
8063: ) ;
8064: if x_return_status <> FND_API.g_ret_sts_success THEN
8065: RAISE FND_API.G_EXC_ERROR;
8066: end if;
8067: --For bug 4351391
8068: ams_list_wf.StartListBizEventProcess(p_list_header_id => x_list_header_id);
8069:

Line 8081: if x_return_status <> FND_API.g_ret_sts_success THEN

8077: x_return_status => x_return_status,
8078: x_msg_count => x_msg_count,
8079: x_msg_data => x_msg_data);
8080:
8081: if x_return_status <> FND_API.g_ret_sts_success THEN
8082: RAISE FND_API.G_EXC_ERROR;
8083: end if;
8084: -- END of API body.
8085:

Line 8082: RAISE FND_API.G_EXC_ERROR;

8078: x_msg_count => x_msg_count,
8079: x_msg_data => x_msg_data);
8080:
8081: if x_return_status <> FND_API.g_ret_sts_success THEN
8082: RAISE FND_API.G_EXC_ERROR;
8083: end if;
8084: -- END of API body.
8085:
8086: if x_return_status <> FND_API.g_ret_sts_success THEN

Line 8086: if x_return_status <> FND_API.g_ret_sts_success THEN

8082: RAISE FND_API.G_EXC_ERROR;
8083: end if;
8084: -- END of API body.
8085:
8086: if x_return_status <> FND_API.g_ret_sts_success THEN
8087: RAISE FND_API.G_EXC_ERROR;
8088: end if;
8089: -- END of API body.
8090: --

Line 8087: RAISE FND_API.G_EXC_ERROR;

8083: end if;
8084: -- END of API body.
8085:
8086: if x_return_status <> FND_API.g_ret_sts_success THEN
8087: RAISE FND_API.G_EXC_ERROR;
8088: end if;
8089: -- END of API body.
8090: --
8091: */

Line 8094: IF FND_API.To_Boolean ( p_commit ) THEN

8090: --
8091: */
8092: -- Standard check of p_commit.
8093:
8094: IF FND_API.To_Boolean ( p_commit ) THEN
8095: COMMIT WORK;
8096: END IF;
8097:
8098: -- Success Message

Line 8114: p_encoded => FND_API.g_false,

8110: FND_MESSAGE.Set_Token('TEXT', 'AMS_ListGeneration_PKG.create_list: END');
8111: FND_MSG_PUB.Add;
8112: --END IF;
8113: FND_MSG_PUB.count_and_get(
8114: p_encoded => FND_API.g_false,
8115: p_count => x_msg_count,
8116: p_data => x_msg_data
8117: );
8118:

Line 8120: WHEN FND_API.G_EXC_ERROR THEN

8116: p_data => x_msg_data
8117: );
8118:
8119: EXCEPTION
8120: WHEN FND_API.G_EXC_ERROR THEN
8121: -- Check if reset of the status is required
8122: x_return_status := FND_API.G_RET_STS_ERROR ;
8123: FND_MSG_PUB.count_and_get(
8124: p_encoded => FND_API.g_false,

Line 8122: x_return_status := FND_API.G_RET_STS_ERROR ;

8118:
8119: EXCEPTION
8120: WHEN FND_API.G_EXC_ERROR THEN
8121: -- Check if reset of the status is required
8122: x_return_status := FND_API.G_RET_STS_ERROR ;
8123: FND_MSG_PUB.count_and_get(
8124: p_encoded => FND_API.g_false,
8125: p_count => x_msg_count,
8126: p_data => x_msg_data);

Line 8124: p_encoded => FND_API.g_false,

8120: WHEN FND_API.G_EXC_ERROR THEN
8121: -- Check if reset of the status is required
8122: x_return_status := FND_API.G_RET_STS_ERROR ;
8123: FND_MSG_PUB.count_and_get(
8124: p_encoded => FND_API.g_false,
8125: p_count => x_msg_count,
8126: p_data => x_msg_data);
8127:
8128: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 8128: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

8124: p_encoded => FND_API.g_false,
8125: p_count => x_msg_count,
8126: p_data => x_msg_data);
8127:
8128: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8130: FND_MSG_PUB.count_and_get(
8131: p_encoded => FND_API.g_false,
8132: p_count => x_msg_count,

Line 8129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

8125: p_count => x_msg_count,
8126: p_data => x_msg_data);
8127:
8128: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8130: FND_MSG_PUB.count_and_get(
8131: p_encoded => FND_API.g_false,
8132: p_count => x_msg_count,
8133: p_data => x_msg_data);

Line 8131: p_encoded => FND_API.g_false,

8127:
8128: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8130: FND_MSG_PUB.count_and_get(
8131: p_encoded => FND_API.g_false,
8132: p_count => x_msg_count,
8133: p_data => x_msg_data);
8134:
8135: WHEN OTHERS THEN

Line 8136: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

8132: p_count => x_msg_count,
8133: p_data => x_msg_data);
8134:
8135: WHEN OTHERS THEN
8136: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8137: FND_MSG_PUB.count_and_get(
8138: p_encoded => FND_API.g_false,
8139: p_count => x_msg_count,
8140: p_data => x_msg_data);

Line 8138: p_encoded => FND_API.g_false,

8134:
8135: WHEN OTHERS THEN
8136: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8137: FND_MSG_PUB.count_and_get(
8138: p_encoded => FND_API.g_false,
8139: p_count => x_msg_count,
8140: p_data => x_msg_data);
8141: END CREATE_LIST;
8142:

Line 8145: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

8141: END CREATE_LIST;
8142:
8143: PROCEDURE create_import_list
8144: ( p_api_version IN NUMBER,
8145: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
8146: p_commit IN VARCHAR2 := FND_API.G_FALSE,
8147: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
8148: p_owner_user_id in number,
8149: p_imp_list_header_id in number,

Line 8146: p_commit IN VARCHAR2 := FND_API.G_FALSE,

8142:
8143: PROCEDURE create_import_list
8144: ( p_api_version IN NUMBER,
8145: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
8146: p_commit IN VARCHAR2 := FND_API.G_FALSE,
8147: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
8148: p_owner_user_id in number,
8149: p_imp_list_header_id in number,
8150: x_return_status OUT NOCOPY VARCHAR2,

Line 8147: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

8143: PROCEDURE create_import_list
8144: ( p_api_version IN NUMBER,
8145: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
8146: p_commit IN VARCHAR2 := FND_API.G_FALSE,
8147: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
8148: p_owner_user_id in number,
8149: p_imp_list_header_id in number,
8150: x_return_status OUT NOCOPY VARCHAR2,
8151: x_msg_count OUT NOCOPY NUMBER,

Line 8156: l_init_msg_list varchar2(2000) := FND_API.G_FALSE;

8152: x_msg_data OUT NOCOPY VARCHAR2,
8153: x_list_header_id OUT NOCOPY NUMBER ,
8154: p_list_name in VARCHAR2 ) is
8155: l_list_header_rec AMS_ListHeader_PVT.list_header_rec_type;
8156: l_init_msg_list varchar2(2000) := FND_API.G_FALSE;
8157: l_api_version number := 1.0;
8158: l_api_name constant varchar2(30) := 'Create_import_List';
8159: l_action_rec AMS_ListAction_PVT.action_rec_type ;
8160: l_action_id number;

Line 8196: IF NOT FND_API.Compatible_API_Call ( l_api_version,

8192: else
8193: l_import_list_name := p_list_name ;
8194: end if;
8195:
8196: IF NOT FND_API.Compatible_API_Call ( l_api_version,
8197: p_api_version,
8198: l_api_name,
8199: G_PKG_NAME) THEN
8200: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 8200: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

8196: IF NOT FND_API.Compatible_API_Call ( l_api_version,
8197: p_api_version,
8198: l_api_name,
8199: G_PKG_NAME) THEN
8200: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8201: END IF;
8202:
8203:
8204: -- Initialize message list IF p_init_msg_list is set to TRUE.

Line 8205: IF FND_API.to_Boolean( p_init_msg_list ) THEN

8201: END IF;
8202:
8203:
8204: -- Initialize message list IF p_init_msg_list is set to TRUE.
8205: IF FND_API.to_Boolean( p_init_msg_list ) THEN
8206: FND_MSG_PUB.initialize;
8207: END IF;
8208:
8209: -- Debug Message

Line 8216: x_return_status := FND_API.G_RET_STS_SUCCESS;

8212: FND_MESSAGE.Set_Token('TEXT', 'AMS_ListGeneration_PKG.cerate_list: Start', TRUE);
8213: FND_MSG_PUB.Add;
8214: END IF;
8215: -- Initialize API return status to success
8216: x_return_status := FND_API.G_RET_STS_SUCCESS;
8217: -- Perform the database operation
8218:
8219: -- ams_listheader_pvt.init_listheader_rec(l_list_header_rec);
8220: l_list_header_rec.list_name := l_import_list_name ;

Line 8239: if x_return_status <> FND_API.g_ret_sts_success THEN

8235: p_listheader_rec => l_list_header_rec,
8236: x_listheader_id => x_list_header_id
8237: );
8238:
8239: if x_return_status <> FND_API.g_ret_sts_success THEN
8240: RAISE FND_API.G_EXC_ERROR;
8241: end if;
8242:
8243: l_action_rec.arc_action_used_by := 'LIST';

Line 8240: RAISE FND_API.G_EXC_ERROR;

8236: x_listheader_id => x_list_header_id
8237: );
8238:
8239: if x_return_status <> FND_API.g_ret_sts_success THEN
8240: RAISE FND_API.G_EXC_ERROR;
8241: end if;
8242:
8243: l_action_rec.arc_action_used_by := 'LIST';
8244: l_action_rec.action_used_by_id := x_list_header_id ;

Line 8263: if x_return_status <> FND_API.g_ret_sts_success THEN

8259: x_action_id => l_action_id
8260: ) ;
8261: FND_MESSAGE.set_name('AMS','after list action->'|| l_action_id|| '<-');
8262: FND_MSG_PUB.Add;
8263: if x_return_status <> FND_API.g_ret_sts_success THEN
8264: RAISE FND_API.G_EXC_ERROR;
8265: end if;
8266:
8267: GENERATE_LIST

Line 8264: RAISE FND_API.G_EXC_ERROR;

8260: ) ;
8261: FND_MESSAGE.set_name('AMS','after list action->'|| l_action_id|| '<-');
8262: FND_MSG_PUB.Add;
8263: if x_return_status <> FND_API.g_ret_sts_success THEN
8264: RAISE FND_API.G_EXC_ERROR;
8265: end if;
8266:
8267: GENERATE_LIST
8268: ( p_api_version => 1.0,

Line 8277: if x_return_status <> FND_API.g_ret_sts_success THEN

8273: x_return_status => x_return_status,
8274: x_msg_count => x_msg_count,
8275: x_msg_data => x_msg_data);
8276:
8277: if x_return_status <> FND_API.g_ret_sts_success THEN
8278: RAISE FND_API.G_EXC_ERROR;
8279: end if;
8280: -- END of API body.
8281: --

Line 8278: RAISE FND_API.G_EXC_ERROR;

8274: x_msg_count => x_msg_count,
8275: x_msg_data => x_msg_data);
8276:
8277: if x_return_status <> FND_API.g_ret_sts_success THEN
8278: RAISE FND_API.G_EXC_ERROR;
8279: end if;
8280: -- END of API body.
8281: --
8282:

Line 8285: IF FND_API.To_Boolean ( p_commit ) THEN

8281: --
8282:
8283: -- Standard check of p_commit.
8284:
8285: IF FND_API.To_Boolean ( p_commit ) THEN
8286: COMMIT WORK;
8287: END IF;
8288:
8289: -- Success Message

Line 8306: p_encoded => FND_API.g_false,

8302: FND_MESSAGE.Set_Token('TEXT', 'AMS_ListGeneration_PKG.create_list: END');
8303: FND_MSG_PUB.Add;
8304: --END IF;
8305: FND_MSG_PUB.count_and_get(
8306: p_encoded => FND_API.g_false,
8307: p_count => x_msg_count,
8308: p_data => x_msg_data
8309: );
8310:

Line 8312: WHEN FND_API.G_EXC_ERROR THEN

8308: p_data => x_msg_data
8309: );
8310:
8311: EXCEPTION
8312: WHEN FND_API.G_EXC_ERROR THEN
8313: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8314: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
8315: FND_MSG_PUB.Add;
8316: -- Check if reset of the status is required

Line 8317: x_return_status := FND_API.G_RET_STS_ERROR ;

8313: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8314: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
8315: FND_MSG_PUB.Add;
8316: -- Check if reset of the status is required
8317: x_return_status := FND_API.G_RET_STS_ERROR ;
8318: FND_MSG_PUB.count_and_get(
8319: p_encoded => FND_API.g_false,
8320: p_count => x_msg_count,
8321: p_data => x_msg_data);

Line 8319: p_encoded => FND_API.g_false,

8315: FND_MSG_PUB.Add;
8316: -- Check if reset of the status is required
8317: x_return_status := FND_API.G_RET_STS_ERROR ;
8318: FND_MSG_PUB.count_and_get(
8319: p_encoded => FND_API.g_false,
8320: p_count => x_msg_count,
8321: p_data => x_msg_data);
8322:
8323: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 8323: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

8319: p_encoded => FND_API.g_false,
8320: p_count => x_msg_count,
8321: p_data => x_msg_data);
8322:
8323: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8324: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8325: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
8326: FND_MSG_PUB.Add;
8327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 8327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

8323: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8324: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8325: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
8326: FND_MSG_PUB.Add;
8327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8328: FND_MSG_PUB.count_and_get(
8329: p_encoded => FND_API.g_false,
8330: p_count => x_msg_count,
8331: p_data => x_msg_data);

Line 8329: p_encoded => FND_API.g_false,

8325: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
8326: FND_MSG_PUB.Add;
8327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8328: FND_MSG_PUB.count_and_get(
8329: p_encoded => FND_API.g_false,
8330: p_count => x_msg_count,
8331: p_data => x_msg_data);
8332:
8333: WHEN OTHERS THEN

Line 8337: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

8333: WHEN OTHERS THEN
8334: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8335: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
8336: FND_MSG_PUB.Add;
8337: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8338: FND_MSG_PUB.count_and_get(
8339: p_encoded => FND_API.g_false,
8340: p_count => x_msg_count,
8341: p_data => x_msg_data);

Line 8339: p_encoded => FND_API.g_false,

8335: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
8336: FND_MSG_PUB.Add;
8337: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8338: FND_MSG_PUB.count_and_get(
8339: p_encoded => FND_API.g_false,
8340: p_count => x_msg_count,
8341: p_data => x_msg_data);
8342: END CREATE_import_LIST;
8343:

Line 8346: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

8342: END CREATE_import_LIST;
8343:
8344: PROCEDURE create_list_from_query
8345: ( p_api_version IN NUMBER,
8346: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
8347: p_commit IN VARCHAR2 := FND_API.G_FALSE,
8348: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
8349: p_list_name in varchar2,
8350: p_list_type in varchar2,

Line 8347: p_commit IN VARCHAR2 := FND_API.G_FALSE,

8343:
8344: PROCEDURE create_list_from_query
8345: ( p_api_version IN NUMBER,
8346: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
8347: p_commit IN VARCHAR2 := FND_API.G_FALSE,
8348: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
8349: p_list_name in varchar2,
8350: p_list_type in varchar2,
8351: p_owner_user_id in number,

Line 8348: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

8344: PROCEDURE create_list_from_query
8345: ( p_api_version IN NUMBER,
8346: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
8347: p_commit IN VARCHAR2 := FND_API.G_FALSE,
8348: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
8349: p_list_name in varchar2,
8350: p_list_type in varchar2,
8351: p_owner_user_id in number,
8352: p_list_header_id in number,

Line 8362: l_init_msg_list varchar2(2000) := FND_API.G_FALSE;

8358: x_msg_count OUT NOCOPY NUMBER,
8359: x_msg_data OUT NOCOPY VARCHAR2
8360: ) is
8361: l_list_header_rec AMS_ListHeader_PVT.list_header_rec_type;
8362: l_init_msg_list varchar2(2000) := FND_API.G_FALSE;
8363: l_api_version number := 1.0;
8364: l_api_name constant varchar2(30) := 'Create_List';
8365: l_list_query_rec_tbl AMS_List_Query_PVT.list_query_rec_type_tbl ;
8366: l_list_query_id number ;

Line 8373: x_return_status := FND_API.G_RET_STS_SUCCESS;

8369:
8370: l_master_type_id number;
8371: l_source_type_code varchar2(30);
8372: BEGIN
8373: x_return_status := FND_API.G_RET_STS_SUCCESS;
8374: -- Standard call to check for call compatibility.
8375: IF NOT FND_API.Compatible_API_Call ( l_api_version,
8376: p_api_version,
8377: l_api_name,

Line 8375: IF NOT FND_API.Compatible_API_Call ( l_api_version,

8371: l_source_type_code varchar2(30);
8372: BEGIN
8373: x_return_status := FND_API.G_RET_STS_SUCCESS;
8374: -- Standard call to check for call compatibility.
8375: IF NOT FND_API.Compatible_API_Call ( l_api_version,
8376: p_api_version,
8377: l_api_name,
8378: G_PKG_NAME) THEN
8379: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 8379: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

8375: IF NOT FND_API.Compatible_API_Call ( l_api_version,
8376: p_api_version,
8377: l_api_name,
8378: G_PKG_NAME) THEN
8379: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8380: END IF;
8381:
8382:
8383: -- Initialize message list IF p_init_msg_list is set to TRUE.

Line 8384: IF FND_API.to_Boolean( p_init_msg_list ) THEN

8380: END IF;
8381:
8382:
8383: -- Initialize message list IF p_init_msg_list is set to TRUE.
8384: IF FND_API.to_Boolean( p_init_msg_list ) THEN
8385: FND_MSG_PUB.initialize;
8386: END IF;
8387:
8388: -- Debug Message

Line 8396: x_return_status := FND_API.G_RET_STS_SUCCESS;

8392: FND_MSG_PUB.Add;
8393: END IF;
8394:
8395: -- Initialize API return status to success
8396: x_return_status := FND_API.G_RET_STS_SUCCESS;
8397: -- Perform the database operation
8398:
8399: l_list_query_rec_tbl.name := p_list_name ||'_'|| p_list_header_id;
8400: -- l_list_query_rec_tbl.sql_string := p_sql_string ;

Line 8418: if x_return_status <> FND_API.g_ret_sts_success THEN

8414: x_parent_list_query_id => l_list_query_id
8415: );
8416:
8417:
8418: if x_return_status <> FND_API.g_ret_sts_success THEN
8419: RAISE FND_API.G_EXC_ERROR;
8420: end if;
8421:
8422: l_action_rec.arc_action_used_by := 'LIST';

Line 8419: RAISE FND_API.G_EXC_ERROR;

8415: );
8416:
8417:
8418: if x_return_status <> FND_API.g_ret_sts_success THEN
8419: RAISE FND_API.G_EXC_ERROR;
8420: end if;
8421:
8422: l_action_rec.arc_action_used_by := 'LIST';
8423: l_action_rec.action_used_by_id := p_list_header_id ;

Line 8441: if x_return_status <> FND_API.g_ret_sts_success THEN

8437: x_msg_data => x_msg_data,
8438: p_action_rec => l_action_rec,
8439: x_action_id => l_action_id
8440: ) ;
8441: if x_return_status <> FND_API.g_ret_sts_success THEN
8442: RAISE FND_API.G_EXC_ERROR;
8443: end if;
8444:
8445: GENERATE_LIST

Line 8442: RAISE FND_API.G_EXC_ERROR;

8438: p_action_rec => l_action_rec,
8439: x_action_id => l_action_id
8440: ) ;
8441: if x_return_status <> FND_API.g_ret_sts_success THEN
8442: RAISE FND_API.G_EXC_ERROR;
8443: end if;
8444:
8445: GENERATE_LIST
8446: ( p_api_version => 1.0,

Line 8455: if x_return_status <> FND_API.g_ret_sts_success THEN

8451: x_return_status => x_return_status,
8452: x_msg_count => x_msg_count,
8453: x_msg_data => x_msg_data);
8454:
8455: if x_return_status <> FND_API.g_ret_sts_success THEN
8456: RAISE FND_API.G_EXC_ERROR;
8457: end if;
8458: -- END of API body.
8459: --

Line 8456: RAISE FND_API.G_EXC_ERROR;

8452: x_msg_count => x_msg_count,
8453: x_msg_data => x_msg_data);
8454:
8455: if x_return_status <> FND_API.g_ret_sts_success THEN
8456: RAISE FND_API.G_EXC_ERROR;
8457: end if;
8458: -- END of API body.
8459: --
8460:

Line 8463: IF FND_API.To_Boolean ( p_commit ) THEN

8459: --
8460:
8461: -- Standard check of p_commit.
8462:
8463: IF FND_API.To_Boolean ( p_commit ) THEN
8464: COMMIT WORK;
8465: END IF;
8466:
8467: -- Success Message

Line 8484: p_encoded => FND_API.g_false,

8480: FND_MESSAGE.Set_Token('TEXT', 'AMS_ListGeneration_PKG.create_list: END');
8481: FND_MSG_PUB.Add;
8482: --END IF;
8483: FND_MSG_PUB.count_and_get(
8484: p_encoded => FND_API.g_false,
8485: p_count => x_msg_count,
8486: p_data => x_msg_data
8487: );
8488:

Line 8490: WHEN FND_API.G_EXC_ERROR THEN

8486: p_data => x_msg_data
8487: );
8488:
8489: EXCEPTION
8490: WHEN FND_API.G_EXC_ERROR THEN
8491: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8492: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
8493: FND_MSG_PUB.Add;
8494: -- Check if reset of the status is required

Line 8495: x_return_status := FND_API.G_RET_STS_ERROR ;

8491: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8492: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
8493: FND_MSG_PUB.Add;
8494: -- Check if reset of the status is required
8495: x_return_status := FND_API.G_RET_STS_ERROR ;
8496: FND_MSG_PUB.count_and_get(
8497: p_encoded => FND_API.g_false,
8498: p_count => x_msg_count,
8499: p_data => x_msg_data);

Line 8497: p_encoded => FND_API.g_false,

8493: FND_MSG_PUB.Add;
8494: -- Check if reset of the status is required
8495: x_return_status := FND_API.G_RET_STS_ERROR ;
8496: FND_MSG_PUB.count_and_get(
8497: p_encoded => FND_API.g_false,
8498: p_count => x_msg_count,
8499: p_data => x_msg_data);
8500:
8501: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 8501: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

8497: p_encoded => FND_API.g_false,
8498: p_count => x_msg_count,
8499: p_data => x_msg_data);
8500:
8501: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8502: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8503: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
8504: FND_MSG_PUB.Add;
8505: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 8505: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

8501: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8502: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8503: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
8504: FND_MSG_PUB.Add;
8505: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8506: FND_MSG_PUB.count_and_get(
8507: p_encoded => FND_API.g_false,
8508: p_count => x_msg_count,
8509: p_data => x_msg_data);

Line 8507: p_encoded => FND_API.g_false,

8503: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
8504: FND_MSG_PUB.Add;
8505: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8506: FND_MSG_PUB.count_and_get(
8507: p_encoded => FND_API.g_false,
8508: p_count => x_msg_count,
8509: p_data => x_msg_data);
8510:
8511: WHEN OTHERS THEN

Line 8515: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

8511: WHEN OTHERS THEN
8512: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8513: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
8514: FND_MSG_PUB.Add;
8515: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8516: FND_MSG_PUB.count_and_get(
8517: p_encoded => FND_API.g_false,
8518: p_count => x_msg_count,
8519: p_data => x_msg_data);

Line 8517: p_encoded => FND_API.g_false,

8513: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
8514: FND_MSG_PUB.Add;
8515: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8516: FND_MSG_PUB.count_and_get(
8517: p_encoded => FND_API.g_false,
8518: p_count => x_msg_count,
8519: p_data => x_msg_data);
8520: END CREATE_LIST_FROM_QUERY ;
8521:

Line 8524: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

8520: END CREATE_LIST_FROM_QUERY ;
8521:
8522: PROCEDURE create_list_from_query
8523: ( p_api_version IN NUMBER,
8524: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
8525: p_commit IN VARCHAR2 := FND_API.G_FALSE,
8526: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
8527: p_list_name in varchar2,
8528: p_list_type in varchar2,

Line 8525: p_commit IN VARCHAR2 := FND_API.G_FALSE,

8521:
8522: PROCEDURE create_list_from_query
8523: ( p_api_version IN NUMBER,
8524: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
8525: p_commit IN VARCHAR2 := FND_API.G_FALSE,
8526: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
8527: p_list_name in varchar2,
8528: p_list_type in varchar2,
8529: p_owner_user_id in number,

Line 8526: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

8522: PROCEDURE create_list_from_query
8523: ( p_api_version IN NUMBER,
8524: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
8525: p_commit IN VARCHAR2 := FND_API.G_FALSE,
8526: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
8527: p_list_name in varchar2,
8528: p_list_type in varchar2,
8529: p_owner_user_id in number,
8530: p_list_header_id in number,

Line 8541: l_init_msg_list varchar2(2000) := FND_API.G_FALSE;

8537: x_msg_count OUT NOCOPY NUMBER,
8538: x_msg_data OUT NOCOPY VARCHAR2
8539: ) is
8540: l_list_header_rec AMS_ListHeader_PVT.list_header_rec_type;
8541: l_init_msg_list varchar2(2000) := FND_API.G_FALSE;
8542: l_api_version number := 1.0;
8543: l_api_name constant varchar2(30) := 'Create_List';
8544: l_list_query_rec_tbl AMS_List_Query_PVT.list_query_rec_type_tbl ;
8545: l_list_query_id number ;

Line 8552: x_return_status := FND_API.G_RET_STS_SUCCESS;

8548:
8549: l_master_type_id number;
8550: l_source_type_code varchar2(30);
8551: BEGIN
8552: x_return_status := FND_API.G_RET_STS_SUCCESS;
8553: -- Standard call to check for call compatibility.
8554: IF NOT FND_API.Compatible_API_Call ( l_api_version,
8555: p_api_version,
8556: l_api_name,

Line 8554: IF NOT FND_API.Compatible_API_Call ( l_api_version,

8550: l_source_type_code varchar2(30);
8551: BEGIN
8552: x_return_status := FND_API.G_RET_STS_SUCCESS;
8553: -- Standard call to check for call compatibility.
8554: IF NOT FND_API.Compatible_API_Call ( l_api_version,
8555: p_api_version,
8556: l_api_name,
8557: G_PKG_NAME) THEN
8558: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 8558: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

8554: IF NOT FND_API.Compatible_API_Call ( l_api_version,
8555: p_api_version,
8556: l_api_name,
8557: G_PKG_NAME) THEN
8558: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8559: END IF;
8560:
8561:
8562: -- Initialize message list IF p_init_msg_list is set to TRUE.

Line 8563: IF FND_API.to_Boolean( p_init_msg_list ) THEN

8559: END IF;
8560:
8561:
8562: -- Initialize message list IF p_init_msg_list is set to TRUE.
8563: IF FND_API.to_Boolean( p_init_msg_list ) THEN
8564: FND_MSG_PUB.initialize;
8565: END IF;
8566:
8567: -- Debug Message

Line 8575: x_return_status := FND_API.G_RET_STS_SUCCESS;

8571: FND_MSG_PUB.Add;
8572: END IF;
8573:
8574: -- Initialize API return status to success
8575: x_return_status := FND_API.G_RET_STS_SUCCESS;
8576: -- Perform the database operation
8577:
8578: l_list_query_rec_tbl.name := p_list_name ||'_'|| p_list_header_id;
8579: -- l_list_query_rec_tbl.sql_string := p_sql_string ;

Line 8599: if x_return_status <> FND_API.g_ret_sts_success THEN

8595: x_parent_list_query_id => l_list_query_id
8596: );
8597:
8598:
8599: if x_return_status <> FND_API.g_ret_sts_success THEN
8600: RAISE FND_API.G_EXC_ERROR;
8601: end if;
8602:
8603: l_action_rec.arc_action_used_by := 'LIST';

Line 8600: RAISE FND_API.G_EXC_ERROR;

8596: );
8597:
8598:
8599: if x_return_status <> FND_API.g_ret_sts_success THEN
8600: RAISE FND_API.G_EXC_ERROR;
8601: end if;
8602:
8603: l_action_rec.arc_action_used_by := 'LIST';
8604: l_action_rec.action_used_by_id := p_list_header_id ;

Line 8622: if x_return_status <> FND_API.g_ret_sts_success THEN

8618: x_msg_data => x_msg_data,
8619: p_action_rec => l_action_rec,
8620: x_action_id => l_action_id
8621: ) ;
8622: if x_return_status <> FND_API.g_ret_sts_success THEN
8623: RAISE FND_API.G_EXC_ERROR;
8624: end if;
8625:
8626: GENERATE_LIST

Line 8623: RAISE FND_API.G_EXC_ERROR;

8619: p_action_rec => l_action_rec,
8620: x_action_id => l_action_id
8621: ) ;
8622: if x_return_status <> FND_API.g_ret_sts_success THEN
8623: RAISE FND_API.G_EXC_ERROR;
8624: end if;
8625:
8626: GENERATE_LIST
8627: ( p_api_version => 1.0,

Line 8636: if x_return_status <> FND_API.g_ret_sts_success THEN

8632: x_return_status => x_return_status,
8633: x_msg_count => x_msg_count,
8634: x_msg_data => x_msg_data);
8635:
8636: if x_return_status <> FND_API.g_ret_sts_success THEN
8637: RAISE FND_API.G_EXC_ERROR;
8638: end if;
8639: -- END of API body.
8640: --

Line 8637: RAISE FND_API.G_EXC_ERROR;

8633: x_msg_count => x_msg_count,
8634: x_msg_data => x_msg_data);
8635:
8636: if x_return_status <> FND_API.g_ret_sts_success THEN
8637: RAISE FND_API.G_EXC_ERROR;
8638: end if;
8639: -- END of API body.
8640: --
8641:

Line 8644: IF FND_API.To_Boolean ( p_commit ) THEN

8640: --
8641:
8642: -- Standard check of p_commit.
8643:
8644: IF FND_API.To_Boolean ( p_commit ) THEN
8645: COMMIT WORK;
8646: END IF;
8647:
8648: -- Success Message

Line 8665: p_encoded => FND_API.g_false,

8661: FND_MESSAGE.Set_Token('TEXT', 'AMS_ListGeneration_PKG.create_list: END');
8662: FND_MSG_PUB.Add;
8663: --END IF;
8664: FND_MSG_PUB.count_and_get(
8665: p_encoded => FND_API.g_false,
8666: p_count => x_msg_count,
8667: p_data => x_msg_data
8668: );
8669:

Line 8671: WHEN FND_API.G_EXC_ERROR THEN

8667: p_data => x_msg_data
8668: );
8669:
8670: EXCEPTION
8671: WHEN FND_API.G_EXC_ERROR THEN
8672: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8673: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
8674: FND_MSG_PUB.Add;
8675: -- Check if reset of the status is required

Line 8676: x_return_status := FND_API.G_RET_STS_ERROR ;

8672: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8673: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
8674: FND_MSG_PUB.Add;
8675: -- Check if reset of the status is required
8676: x_return_status := FND_API.G_RET_STS_ERROR ;
8677: FND_MSG_PUB.count_and_get(
8678: p_encoded => FND_API.g_false,
8679: p_count => x_msg_count,
8680: p_data => x_msg_data);

Line 8678: p_encoded => FND_API.g_false,

8674: FND_MSG_PUB.Add;
8675: -- Check if reset of the status is required
8676: x_return_status := FND_API.G_RET_STS_ERROR ;
8677: FND_MSG_PUB.count_and_get(
8678: p_encoded => FND_API.g_false,
8679: p_count => x_msg_count,
8680: p_data => x_msg_data);
8681:
8682: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 8682: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

8678: p_encoded => FND_API.g_false,
8679: p_count => x_msg_count,
8680: p_data => x_msg_data);
8681:
8682: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8683: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8684: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
8685: FND_MSG_PUB.Add;
8686: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 8686: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

8682: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8683: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8684: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
8685: FND_MSG_PUB.Add;
8686: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8687: FND_MSG_PUB.count_and_get(
8688: p_encoded => FND_API.g_false,
8689: p_count => x_msg_count,
8690: p_data => x_msg_data);

Line 8688: p_encoded => FND_API.g_false,

8684: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
8685: FND_MSG_PUB.Add;
8686: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8687: FND_MSG_PUB.count_and_get(
8688: p_encoded => FND_API.g_false,
8689: p_count => x_msg_count,
8690: p_data => x_msg_data);
8691:
8692: WHEN OTHERS THEN

Line 8696: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

8692: WHEN OTHERS THEN
8693: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8694: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
8695: FND_MSG_PUB.Add;
8696: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8697: FND_MSG_PUB.count_and_get(
8698: p_encoded => FND_API.g_false,
8699: p_count => x_msg_count,
8700: p_data => x_msg_data);

Line 8698: p_encoded => FND_API.g_false,

8694: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
8695: FND_MSG_PUB.Add;
8696: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8697: FND_MSG_PUB.count_and_get(
8698: p_encoded => FND_API.g_false,
8699: p_count => x_msg_count,
8700: p_data => x_msg_data);
8701: END CREATE_LIST_FROM_QUERY ;
8702: -- >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>.

Line 8954: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS )THEN

8950: x_msg_data => x_msg_data ,
8951: x_return_status => x_return_status
8952: );
8953:
8954: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS )THEN
8955: if nvl(x_return_status,'S') in ('E','U') then -- resulted in error.
8956: write_to_act_log('Error in Cancel List generation', 'LIST', g_list_header_id,'HIGH');
8957: write_to_act_log('Error while executing Cancel List generation '||sqlerrm||sqlcode, 'LIST', g_list_header_id,'HIGH');
8958: end if;

Line 8959: RAISE FND_API.G_EXC_ERROR;

8955: if nvl(x_return_status,'S') in ('E','U') then -- resulted in error.
8956: write_to_act_log('Error in Cancel List generation', 'LIST', g_list_header_id,'HIGH');
8957: write_to_act_log('Error while executing Cancel List generation '||sqlerrm||sqlcode, 'LIST', g_list_header_id,'HIGH');
8958: end if;
8959: RAISE FND_API.G_EXC_ERROR;
8960: ELSE
8961: write_to_act_log('Success in Cancel List generation', 'LIST', g_list_header_id,'LOW');
8962: END IF;
8963:

Line 9052: IF(x_return_status <>FND_API.G_RET_STS_SUCCESS )THEN

9048: end loop;
9049: end if;
9050:
9051:
9052: IF(x_return_status <>FND_API.G_RET_STS_SUCCESS )THEN
9053: RAISE FND_API.G_EXC_ERROR;
9054: END IF;
9055: -- end Of Dynamic Procedure
9056: l_join_string :='';

Line 9053: RAISE FND_API.G_EXC_ERROR;

9049: end if;
9050:
9051:
9052: IF(x_return_status <>FND_API.G_RET_STS_SUCCESS )THEN
9053: RAISE FND_API.G_EXC_ERROR;
9054: END IF;
9055: -- end Of Dynamic Procedure
9056: l_join_string :='';
9057: write_to_act_log('Action on this selection completed. ', 'LIST', g_list_header_id,'LOW');

Line 9224: x_return_status := FND_API.g_ret_sts_error; --Gen return status should go to error.

9220: no_of_rows_in_ctrl_group = null
9221: where list_header_id = g_list_header_id;
9222: update_remote_list_header(g_list_header_id,x_return_status,x_msg_count,x_msg_data);
9223: write_to_act_log('Aborting list generation ', 'LIST', g_list_header_id,'HIGH');
9224: x_return_status := FND_API.g_ret_sts_error; --Gen return status should go to error.
9225: return;
9226: --
9227: else
9228: write_to_act_log('Target group generated in remote instance', 'LIST', g_list_header_id,'HIGH');

Line 9418: x_return_status := FND_API.g_ret_sts_error; --Gen return status should go to error.

9414: no_of_rows_in_ctrl_group = null
9415: where list_header_id = g_list_header_id;
9416: update_remote_list_header(g_list_header_id,x_return_status,x_msg_count,x_msg_data);
9417: write_to_act_log('Aborting list generation ', 'LIST', g_list_header_id,'HIGH');
9418: x_return_status := FND_API.g_ret_sts_error; --Gen return status should go to error.
9419: return;
9420: --
9421: else
9422: write_to_act_log('Target group generated successfully in remote instance', 'LIST', g_list_header_id,'HIGH');

Line 9441: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

9437: IF(c_action_dets%ISOPEN)THEN
9438: CLOSE c_action_dets;
9439: END IF;
9440:
9441: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9442:
9443: write_to_act_log('executing process_tar_actions - user action to cancel list generation detected ', 'LIST', g_list_header_id,'HIGH');
9444: -- Got to raise the exception again because Listgen has to end generation.
9445: raise AMS_LISTGENERATION_UTIL_PKG.cancelListGen;

Line 9447: WHEN FND_API.G_EXC_ERROR THEN

9443: write_to_act_log('executing process_tar_actions - user action to cancel list generation detected ', 'LIST', g_list_header_id,'HIGH');
9444: -- Got to raise the exception again because Listgen has to end generation.
9445: raise AMS_LISTGENERATION_UTIL_PKG.cancelListGen;
9446:
9447: WHEN FND_API.G_EXC_ERROR THEN
9448: IF(c_action_dets%ISOPEN)THEN
9449: CLOSE c_action_dets;
9450: END IF;
9451: -- Check if reset of the status is required

Line 9453: x_return_status := FND_API.G_RET_STS_ERROR ;

9449: CLOSE c_action_dets;
9450: END IF;
9451: -- Check if reset of the status is required
9452: write_to_act_log('Error while executing procedure process_tar_actions '||sqlcode||' '||sqlerrm,'LIST',g_list_header_id,'HIGH');
9453: x_return_status := FND_API.G_RET_STS_ERROR ;
9454: FND_MSG_PUB.count_and_get(
9455: p_encoded => FND_API.g_false,
9456: p_count => x_msg_count,
9457: p_data => x_msg_data);

Line 9455: p_encoded => FND_API.g_false,

9451: -- Check if reset of the status is required
9452: write_to_act_log('Error while executing procedure process_tar_actions '||sqlcode||' '||sqlerrm,'LIST',g_list_header_id,'HIGH');
9453: x_return_status := FND_API.G_RET_STS_ERROR ;
9454: FND_MSG_PUB.count_and_get(
9455: p_encoded => FND_API.g_false,
9456: p_count => x_msg_count,
9457: p_data => x_msg_data);
9458:
9459: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 9459: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

9455: p_encoded => FND_API.g_false,
9456: p_count => x_msg_count,
9457: p_data => x_msg_data);
9458:
9459: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9460: IF(c_action_dets%ISOPEN)THEN
9461: CLOSE c_action_dets;
9462: END IF;
9463: write_to_act_log('Error while executing procedure process_tar_actions '||sqlcode||' '||sqlerrm,'LIST',g_list_header_id,'HIGH');

Line 9467: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

9463: write_to_act_log('Error while executing procedure process_tar_actions '||sqlcode||' '||sqlerrm,'LIST',g_list_header_id,'HIGH');
9464: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
9465: FND_MESSAGE.Set_Token('ROW', sqlerrm||' '||sqlcode);
9466: FND_MSG_PUB.Add;
9467: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9468: FND_MSG_PUB.count_and_get(
9469: p_encoded => FND_API.g_false,
9470: p_count => x_msg_count,
9471: p_data => x_msg_data);

Line 9469: p_encoded => FND_API.g_false,

9465: FND_MESSAGE.Set_Token('ROW', sqlerrm||' '||sqlcode);
9466: FND_MSG_PUB.Add;
9467: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9468: FND_MSG_PUB.count_and_get(
9469: p_encoded => FND_API.g_false,
9470: p_count => x_msg_count,
9471: p_data => x_msg_data);
9472:
9473: WHEN OTHERS THEN

Line 9481: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

9477: write_to_act_log('Error while executing procedure process_tar_actions '||sqlcode||' '||sqlerrm,'LIST',g_list_header_id,'HIGH');
9478: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
9479: FND_MESSAGE.Set_Token('ROW', sqlerrm||' '||sqlcode);
9480: FND_MSG_PUB.Add;
9481: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9482: FND_MSG_PUB.count_and_get(
9483: p_encoded => FND_API.g_false,
9484: p_count => x_msg_count,
9485: p_data => x_msg_data);

Line 9483: p_encoded => FND_API.g_false,

9479: FND_MESSAGE.Set_Token('ROW', sqlerrm||' '||sqlcode);
9480: FND_MSG_PUB.Add;
9481: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9482: FND_MSG_PUB.count_and_get(
9483: p_encoded => FND_API.g_false,
9484: p_count => x_msg_count,
9485: p_data => x_msg_data);
9486: END process_tar_actions;
9487:

Line 9492: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

9488: -- >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>.
9489:
9490: PROCEDURE GENERATE_TARGET_GROUP
9491: ( p_api_version IN NUMBER,
9492: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
9493: p_commit IN VARCHAR2 := FND_API.G_FALSE,
9494: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
9495: p_list_header_id IN NUMBER,
9496: x_return_status OUT NOCOPY VARCHAR2,

Line 9493: p_commit IN VARCHAR2 := FND_API.G_FALSE,

9489:
9490: PROCEDURE GENERATE_TARGET_GROUP
9491: ( p_api_version IN NUMBER,
9492: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
9493: p_commit IN VARCHAR2 := FND_API.G_FALSE,
9494: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
9495: p_list_header_id IN NUMBER,
9496: x_return_status OUT NOCOPY VARCHAR2,
9497: x_msg_count OUT NOCOPY NUMBER,

Line 9494: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

9490: PROCEDURE GENERATE_TARGET_GROUP
9491: ( p_api_version IN NUMBER,
9492: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
9493: p_commit IN VARCHAR2 := FND_API.G_FALSE,
9494: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
9495: p_list_header_id IN NUMBER,
9496: x_return_status OUT NOCOPY VARCHAR2,
9497: x_msg_count OUT NOCOPY NUMBER,
9498: x_msg_data OUT NOCOPY VARCHAR2) IS

Line 9746: p_encoded => FND_API.g_false,

9742: ctrl_status_code = 'DRAFT',
9743: no_of_rows_in_ctrl_group = null
9744: WHERE list_header_id = p_list_header_id;
9745: FND_MSG_PUB.count_and_get(
9746: p_encoded => FND_API.g_false,
9747: p_count => x_msg_count,
9748: p_data => x_msg_data
9749: );
9750: x_return_status := FND_API.g_ret_sts_error;

Line 9750: x_return_status := FND_API.g_ret_sts_error;

9746: p_encoded => FND_API.g_false,
9747: p_count => x_msg_count,
9748: p_data => x_msg_data
9749: );
9750: x_return_status := FND_API.g_ret_sts_error;
9751: --
9752: logger;
9753: RETURN;
9754: END IF;

Line 9789: IF FND_API.To_Boolean ( p_commit ) THEN

9785: WHERE list_header_id = p_list_header_id;
9786: -- calling logging program
9787: logger;
9788: --
9789: IF FND_API.To_Boolean ( p_commit ) THEN
9790: COMMIT WORK;
9791: END IF;
9792: --Modified by bmuthukr. Bug # 4083665
9793: x_return_status := FND_API.g_ret_sts_error;

Line 9793: x_return_status := FND_API.g_ret_sts_error;

9789: IF FND_API.To_Boolean ( p_commit ) THEN
9790: COMMIT WORK;
9791: END IF;
9792: --Modified by bmuthukr. Bug # 4083665
9793: x_return_status := FND_API.g_ret_sts_error;
9794: --
9795: RETURN;
9796: end if;
9797:

Line 9835: x_return_status := FND_API.g_ret_sts_error;

9831: ctrl_status_code = 'DRAFT',
9832: no_of_rows_in_ctrl_group = null
9833: WHERE list_header_id = g_list_header_id;
9834: --Modified by bmuthukr. Bug # 4083665
9835: x_return_status := FND_API.g_ret_sts_error;
9836: --
9837: logger;
9838: RETURN;
9839: END IF;

Line 9841: x_return_status := FND_API.G_RET_STS_SUCCESS;

9837: logger;
9838: RETURN;
9839: END IF;
9840:
9841: x_return_status := FND_API.G_RET_STS_SUCCESS;
9842:
9843: -- Standard call to check for call compatibility.
9844: IF NOT FND_API.Compatible_API_Call ( l_api_version,
9845: p_api_version,

Line 9844: IF NOT FND_API.Compatible_API_Call ( l_api_version,

9840:
9841: x_return_status := FND_API.G_RET_STS_SUCCESS;
9842:
9843: -- Standard call to check for call compatibility.
9844: IF NOT FND_API.Compatible_API_Call ( l_api_version,
9845: p_api_version,
9846: l_api_name,
9847: G_PKG_NAME)
9848: THEN

Line 9849: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

9845: p_api_version,
9846: l_api_name,
9847: G_PKG_NAME)
9848: THEN
9849: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9850: END IF;
9851:
9852: IF FND_API.to_Boolean( p_init_msg_list ) THEN
9853: FND_MSG_PUB.initialize;

Line 9852: IF FND_API.to_Boolean( p_init_msg_list ) THEN

9848: THEN
9849: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9850: END IF;
9851:
9852: IF FND_API.to_Boolean( p_init_msg_list ) THEN
9853: FND_MSG_PUB.initialize;
9854: END IF;
9855:
9856: -- Checking if Debug is set. If debug is set then log debugging message

Line 9865: x_return_status := FND_API.G_RET_STS_SUCCESS;

9861: FND_MSG_PUB.Add;
9862: END IF;
9863:
9864: -- Initialize API return status to success
9865: x_return_status := FND_API.G_RET_STS_SUCCESS;
9866:
9867: l_error_position := '<- Init List->';
9868: --These values need to be fetched before calling initialize_list. Changes done by bmuthukr.
9869:

Line 9928: IF x_return_status = FND_API.g_ret_sts_error THEN

9924: else
9925: write_to_act_log('Target group initialized.' ,'LIST',p_list_header_id,'HIGH');
9926: end if;
9927:
9928: IF x_return_status = FND_API.g_ret_sts_error THEN
9929: RAISE FND_API.g_exc_error;
9930: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
9931: RAISE FND_API.g_exc_unexpected_error;
9932: END IF;

Line 9929: RAISE FND_API.g_exc_error;

9925: write_to_act_log('Target group initialized.' ,'LIST',p_list_header_id,'HIGH');
9926: end if;
9927:
9928: IF x_return_status = FND_API.g_ret_sts_error THEN
9929: RAISE FND_API.g_exc_error;
9930: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
9931: RAISE FND_API.g_exc_unexpected_error;
9932: END IF;
9933: -- -------------------------------------------------------------------------

Line 9930: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

9926: end if;
9927:
9928: IF x_return_status = FND_API.g_ret_sts_error THEN
9929: RAISE FND_API.g_exc_error;
9930: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
9931: RAISE FND_API.g_exc_unexpected_error;
9932: END IF;
9933: -- -------------------------------------------------------------------------
9934: if g_remote_list = 'Y' then

Line 9931: RAISE FND_API.g_exc_unexpected_error;

9927:
9928: IF x_return_status = FND_API.g_ret_sts_error THEN
9929: RAISE FND_API.g_exc_error;
9930: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
9931: RAISE FND_API.g_exc_unexpected_error;
9932: END IF;
9933: -- -------------------------------------------------------------------------
9934: if g_remote_list = 'Y' then
9935: remote_list_gen(p_list_header_id => p_list_header_id,

Line 9967: x_return_status := FND_API.g_ret_sts_error;

9963: status_date = sysdate,
9964: last_update_date = sysdate,
9965: main_gen_end_time = sysdate
9966: WHERE list_header_id = g_list_header_id;
9967: x_return_status := FND_API.g_ret_sts_error;
9968: logger;
9969: RETURN;
9970: end if;
9971: end if;

Line 10030: IF x_return_status = FND_API.g_ret_sts_error THEN

10026: write_to_act_log('Target group is generated in UPDATE mode in local instance.', 'LIST', g_list_header_id,'HIGH');
10027: GET_LIST_ENTRY_DATA(
10028: p_list_header_id =>l_listheader_rec.list_header_id,
10029: x_return_status => x_return_status);
10030: IF x_return_status = FND_API.g_ret_sts_error THEN
10031: RAISE FND_API.g_exc_error;
10032: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
10033: RAISE FND_API.g_exc_unexpected_error;
10034: END IF;

Line 10031: RAISE FND_API.g_exc_error;

10027: GET_LIST_ENTRY_DATA(
10028: p_list_header_id =>l_listheader_rec.list_header_id,
10029: x_return_status => x_return_status);
10030: IF x_return_status = FND_API.g_ret_sts_error THEN
10031: RAISE FND_API.g_exc_error;
10032: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
10033: RAISE FND_API.g_exc_unexpected_error;
10034: END IF;
10035: --end if;

Line 10032: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

10028: p_list_header_id =>l_listheader_rec.list_header_id,
10029: x_return_status => x_return_status);
10030: IF x_return_status = FND_API.g_ret_sts_error THEN
10031: RAISE FND_API.g_exc_error;
10032: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
10033: RAISE FND_API.g_exc_unexpected_error;
10034: END IF;
10035: --end if;
10036: -- END IF;

Line 10033: RAISE FND_API.g_exc_unexpected_error;

10029: x_return_status => x_return_status);
10030: IF x_return_status = FND_API.g_ret_sts_error THEN
10031: RAISE FND_API.g_exc_error;
10032: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
10033: RAISE FND_API.g_exc_unexpected_error;
10034: END IF;
10035: --end if;
10036: -- END IF;
10037: else

Line 10060: IF x_return_status = FND_API.g_ret_sts_error THEN

10056: write_to_act_log('Error in generating list', 'LIST', g_list_header_id,'HIGH');
10057: write_to_act_log('Error '||x_msg_data , 'LIST', g_list_header_id,'HIGH');
10058: end if;
10059:
10060: IF x_return_status = FND_API.g_ret_sts_error THEN
10061: RAISE FND_API.g_exc_error;
10062: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
10063: RAISE FND_API.g_exc_unexpected_error;
10064: END IF;

Line 10061: RAISE FND_API.g_exc_error;

10057: write_to_act_log('Error '||x_msg_data , 'LIST', g_list_header_id,'HIGH');
10058: end if;
10059:
10060: IF x_return_status = FND_API.g_ret_sts_error THEN
10061: RAISE FND_API.g_exc_error;
10062: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
10063: RAISE FND_API.g_exc_unexpected_error;
10064: END IF;
10065:

Line 10062: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

10058: end if;
10059:
10060: IF x_return_status = FND_API.g_ret_sts_error THEN
10061: RAISE FND_API.g_exc_error;
10062: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
10063: RAISE FND_API.g_exc_unexpected_error;
10064: END IF;
10065:
10066:

Line 10063: RAISE FND_API.g_exc_unexpected_error;

10059:
10060: IF x_return_status = FND_API.g_ret_sts_error THEN
10061: RAISE FND_API.g_exc_error;
10062: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
10063: RAISE FND_API.g_exc_unexpected_error;
10064: END IF;
10065:
10066:
10067: -- added for R12. bmuthukr

Line 10358: IF FND_API.To_Boolean ( p_commit ) THEN

10354: -- END of API body.
10355: --
10356: -- Standard check of p_commit.
10357:
10358: IF FND_API.To_Boolean ( p_commit ) THEN
10359: COMMIT WORK;
10360: END IF;
10361:
10362: -- Success Message

Line 10372: x_return_status := FND_API.G_RET_STS_SUCCESS;

10368: FND_MSG_PUB.Add;
10369: --END IF;
10370:
10371:
10372: x_return_status := FND_API.G_RET_STS_SUCCESS;
10373: --IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH)
10374: --THEN
10375: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
10376: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration_PKG.Generate_List: END');

Line 10380: p_encoded => FND_API.g_false,

10376: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration_PKG.Generate_List: END');
10377: FND_MSG_PUB.Add;
10378: --END IF;
10379: FND_MSG_PUB.count_and_get(
10380: p_encoded => FND_API.g_false,
10381: p_count => x_msg_count,
10382: p_data => x_msg_data
10383: );
10384:

Line 10386: WHEN FND_API.G_EXC_ERROR THEN

10382: p_data => x_msg_data
10383: );
10384:
10385: EXCEPTION
10386: WHEN FND_API.G_EXC_ERROR THEN
10387: -- calling logging program
10388: write_to_act_log('Error while executing procedure generate_target_group for generating target group.', 'LIST', g_list_header_id,'HIGH');
10389:
10390: UPDATE ams_list_headers_all

Line 10406: x_return_status := FND_API.G_RET_STS_ERROR ;

10402:
10403: --write_to_act_log('Error: AMS_ListGeneration_PKG.Generate_List: '||
10404: --l_error_position||sqlerrm||sqlcode);
10405: -- Check if reset of the status is required
10406: x_return_status := FND_API.G_RET_STS_ERROR ;
10407: FND_MSG_PUB.count_and_get(
10408: p_encoded => FND_API.g_false,
10409: p_count => x_msg_count,
10410: p_data => x_msg_data);

Line 10408: p_encoded => FND_API.g_false,

10404: --l_error_position||sqlerrm||sqlcode);
10405: -- Check if reset of the status is required
10406: x_return_status := FND_API.G_RET_STS_ERROR ;
10407: FND_MSG_PUB.count_and_get(
10408: p_encoded => FND_API.g_false,
10409: p_count => x_msg_count,
10410: p_data => x_msg_data);
10411:
10412: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 10412: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

10408: p_encoded => FND_API.g_false,
10409: p_count => x_msg_count,
10410: p_data => x_msg_data);
10411:
10412: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10413: -- calling logging program
10414: write_to_act_log('Error while executing procedure generate_target_group for generating target group.', 'LIST', g_list_header_id,'HIGH');
10415:
10416: UPDATE ams_list_headers_all

Line 10432: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

10428: --l_error_position||sqlerrm||sqlcode);
10429: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
10430: FND_MESSAGE.Set_Token('ROW', sqlerrm||' '||sqlcode);
10431: FND_MSG_PUB.Add;
10432: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10433: FND_MSG_PUB.count_and_get(
10434: p_encoded => FND_API.g_false,
10435: p_count => x_msg_count,
10436: p_data => x_msg_data);

Line 10434: p_encoded => FND_API.g_false,

10430: FND_MESSAGE.Set_Token('ROW', sqlerrm||' '||sqlcode);
10431: FND_MSG_PUB.Add;
10432: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10433: FND_MSG_PUB.count_and_get(
10434: p_encoded => FND_API.g_false,
10435: p_count => x_msg_count,
10436: p_data => x_msg_data);
10437:
10438: WHEN OTHERS THEN

Line 10460: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

10456: --l_error_position||sqlerrm||sqlcode);
10457: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
10458: FND_MESSAGE.Set_Token('ROW', sqlerrm||' '||sqlcode);
10459: FND_MSG_PUB.Add;
10460: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10461: FND_MSG_PUB.count_and_get(
10462: p_encoded => FND_API.g_false,
10463: p_count => x_msg_count,
10464: p_data => x_msg_data);

Line 10462: p_encoded => FND_API.g_false,

10458: FND_MESSAGE.Set_Token('ROW', sqlerrm||' '||sqlcode);
10459: FND_MSG_PUB.Add;
10460: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10461: FND_MSG_PUB.count_and_get(
10462: p_encoded => FND_API.g_false,
10463: p_count => x_msg_count,
10464: p_data => x_msg_data);
10465: END GENERATE_TARGET_GROUP;
10466:

Line 11710: IF(l_return_status <>FND_API.G_RET_STS_SUCCESS )THEN

11706: end if;
11707:
11708: Ams_Utility_Pvt.Write_Conc_log('After Update_List_Dets call : ');
11709:
11710: IF(l_return_status <>FND_API.G_RET_STS_SUCCESS )THEN
11711: RAISE FND_API.G_EXC_ERROR;
11712: END IF;
11713: EXCEPTION
11714: WHEN OTHERS THEN

Line 11711: RAISE FND_API.G_EXC_ERROR;

11707:
11708: Ams_Utility_Pvt.Write_Conc_log('After Update_List_Dets call : ');
11709:
11710: IF(l_return_status <>FND_API.G_RET_STS_SUCCESS )THEN
11711: RAISE FND_API.G_EXC_ERROR;
11712: END IF;
11713: EXCEPTION
11714: WHEN OTHERS THEN
11715: UPDATE ams_list_headers_all

Line 11907: p_encoded => FND_API.g_false,

11903: -- FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
11904: -- FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
11905: -- FND_MSG_PUB.Add;
11906: FND_MSG_PUB.count_and_get(
11907: p_encoded => FND_API.g_false,
11908: p_count => x_msg_count,
11909: p_data => x_msg_data );
11910: x_return_status := 'S';
11911: x_msg_data := to_char(l_request_id);

Line 11921: p_encoded => FND_API.g_false,

11917: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
11918: FND_MESSAGE.Set_Token('TEXT', 'Error '|| sqlerrm||' '||sqlcode);
11919: FND_MSG_PUB.Add;
11920: FND_MSG_PUB.count_and_get(
11921: p_encoded => FND_API.g_false,
11922: p_count => x_msg_count,
11923: p_data => x_msg_data
11924: );
11925: x_return_status := 'E';

Line 11926: RAISE FND_API.g_exc_unexpected_error;

11922: p_count => x_msg_count,
11923: p_data => x_msg_data
11924: );
11925: x_return_status := 'E';
11926: RAISE FND_API.g_exc_unexpected_error;
11927: end if;
11928: end calc_selection_running_total;
11929:
11930: -- ----------------------------------------------------------------------------

Line 12046: RAISE FND_API.G_EXC_ERROR;

12042: write_to_act_log('Error. The action type of the first selection is NOT INCLUDE.', 'LIST', g_list_header_id,'HIGH');
12043: Ams_Utility_Pvt.Write_Conc_log('process list actions : first action INCLUDE check failed');
12044: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ACT_FIRST_INCLUDE');
12045: FND_MSG_PUB.Add;
12046: RAISE FND_API.G_EXC_ERROR;
12047: END IF; -- End of if for list_action_type check
12048: END IF; --End of Validation:- First Action Include Check
12049:
12050:

Line 12053: p_init_msg_list => FND_API.G_FALSE,

12049:
12050:
12051: ams_listaction_pvt.Validate_ListAction
12052: ( p_api_version => 1.0,
12053: p_init_msg_list => FND_API.G_FALSE,
12054: p_validation_level => JTF_PLSQL_API.G_VALID_LEVEL_RECORD,
12055: x_return_status => x_return_status,
12056: x_msg_count => x_msg_count,
12057: x_msg_data => x_msg_data,

Line 12061: IF x_return_status = FND_API.g_ret_sts_error THEN

12057: x_msg_data => x_msg_data,
12058: p_action_rec => p_action_rec
12059: );
12060:
12061: IF x_return_status = FND_API.g_ret_sts_error THEN
12062: RAISE FND_API.g_exc_error;
12063: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
12064: RAISE FND_API.g_exc_unexpected_error;
12065: END IF;

Line 12062: RAISE FND_API.g_exc_error;

12058: p_action_rec => p_action_rec
12059: );
12060:
12061: IF x_return_status = FND_API.g_ret_sts_error THEN
12062: RAISE FND_API.g_exc_error;
12063: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
12064: RAISE FND_API.g_exc_unexpected_error;
12065: END IF;
12066:

Line 12063: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

12059: );
12060:
12061: IF x_return_status = FND_API.g_ret_sts_error THEN
12062: RAISE FND_API.g_exc_error;
12063: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
12064: RAISE FND_API.g_exc_unexpected_error;
12065: END IF;
12066:
12067: Ams_Utility_Pvt.Write_Conc_log('calc_selection_running_total : Dynamic ');

Line 12064: RAISE FND_API.g_exc_unexpected_error;

12060:
12061: IF x_return_status = FND_API.g_ret_sts_error THEN
12062: RAISE FND_API.g_exc_error;
12063: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
12064: RAISE FND_API.g_exc_unexpected_error;
12065: END IF;
12066:
12067: Ams_Utility_Pvt.Write_Conc_log('calc_selection_running_total : Dynamic ');
12068: /********************************************************************

Line 12128: IF(x_return_status <>FND_API.G_RET_STS_SUCCESS )THEN

12124: end loop;
12125: end if; -- if p_action_rec.list_action_type = 'INCLUDE'
12126:
12127:
12128: IF(x_return_status <>FND_API.G_RET_STS_SUCCESS )THEN
12129: RAISE FND_API.G_EXC_ERROR;
12130: END IF;
12131: Ams_Utility_Pvt.Write_Conc_log('calc_selection_running_total : End Dynamic ');
12132: -- end Of Dynamic Procedure

Line 12129: RAISE FND_API.G_EXC_ERROR;

12125: end if; -- if p_action_rec.list_action_type = 'INCLUDE'
12126:
12127:
12128: IF(x_return_status <>FND_API.G_RET_STS_SUCCESS )THEN
12129: RAISE FND_API.G_EXC_ERROR;
12130: END IF;
12131: Ams_Utility_Pvt.Write_Conc_log('calc_selection_running_total : End Dynamic ');
12132: -- end Of Dynamic Procedure
12133: l_join_string :='';

Line 12217: WHEN FND_API.G_EXC_ERROR THEN

12213: end loop;
12214: close c_delta;
12215: commit;
12216: EXCEPTION
12217: WHEN FND_API.G_EXC_ERROR THEN
12218: write_to_act_log('Error while executing procedure calc_running_total '||sqlcode||' '||sqlerrm, 'LIST', g_list_header_id,'HIGH');
12219: IF(c_action_dets%ISOPEN)THEN
12220: CLOSE c_action_dets;
12221: END IF;

Line 12223: x_return_status := FND_API.G_RET_STS_ERROR ;

12219: IF(c_action_dets%ISOPEN)THEN
12220: CLOSE c_action_dets;
12221: END IF;
12222: -- Check if reset of the status is required
12223: x_return_status := FND_API.G_RET_STS_ERROR ;
12224: FND_MSG_PUB.count_and_get(
12225: p_encoded => FND_API.g_false,
12226: p_count => x_msg_count,
12227: p_data => x_msg_data);

Line 12225: p_encoded => FND_API.g_false,

12221: END IF;
12222: -- Check if reset of the status is required
12223: x_return_status := FND_API.G_RET_STS_ERROR ;
12224: FND_MSG_PUB.count_and_get(
12225: p_encoded => FND_API.g_false,
12226: p_count => x_msg_count,
12227: p_data => x_msg_data);
12228:
12229: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 12229: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

12225: p_encoded => FND_API.g_false,
12226: p_count => x_msg_count,
12227: p_data => x_msg_data);
12228:
12229: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
12230: write_to_act_log('Error while executing procedure calc_running_total '||sqlcode||' '||sqlerrm, 'LIST', g_list_header_id,'HIGH');
12231: IF(c_action_dets%ISOPEN)THEN
12232: CLOSE c_action_dets;
12233: END IF;

Line 12240: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

12236: ||sqlerrm||sqlcode, 'LIST', g_list_header_id);
12237: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
12238: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
12239: FND_MSG_PUB.Add;
12240: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
12241: FND_MSG_PUB.count_and_get(
12242: p_encoded => FND_API.g_false,
12243: p_count => x_msg_count,
12244: p_data => x_msg_data);

Line 12242: p_encoded => FND_API.g_false,

12238: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
12239: FND_MSG_PUB.Add;
12240: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
12241: FND_MSG_PUB.count_and_get(
12242: p_encoded => FND_API.g_false,
12243: p_count => x_msg_count,
12244: p_data => x_msg_data);
12245:
12246: WHEN OTHERS THEN

Line 12257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

12253: ||sqlerrm||sqlcode, 'LIST', g_list_header_id,'HIGH');
12254: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
12255: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
12256: FND_MSG_PUB.Add;
12257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
12258: FND_MSG_PUB.count_and_get(
12259: p_encoded => FND_API.g_false,
12260: p_count => x_msg_count,
12261: p_data => x_msg_data);

Line 12259: p_encoded => FND_API.g_false,

12255: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
12256: FND_MSG_PUB.Add;
12257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
12258: FND_MSG_PUB.count_and_get(
12259: p_encoded => FND_API.g_false,
12260: p_count => x_msg_count,
12261: p_data => x_msg_data);
12262: END calc_running_total;
12263:

Line 12621: RAISE FND_API.G_EXC_ERROR;

12617: -- write_to_act_log('Process_rt_all_sql return status: After validate_sql_string call ','LIST', g_list_header_id);
12618: if l_found = 'N' then
12619: FND_MESSAGE.set_name('AMS', 'AMS_LIST_FROM_NOT_FOUND');
12620: FND_MSG_PUB.Add;
12621: RAISE FND_API.G_EXC_ERROR;
12622: end if;
12623: /* write_to_act_log('Process_rt_all_sql: FROM Position ->'|| l_from_position ||
12624: '<--FROM Counter ->' || l_from_counter ||
12625: '<--FROM Found ->' || l_found, 'LIST', g_list_header_id);*/

Line 12641: RAISE FND_API.G_EXC_ERROR;

12637:
12638: if l_found = 'N' then
12639: FND_MESSAGE.set_name('AMS', 'AMS_LIST_NO_MASTER_TYPE');
12640: FND_MSG_PUB.Add;
12641: RAISE FND_API.G_EXC_ERROR;
12642: end if;
12643: write_to_act_log('Master type is '|| l_master_type ||'<--' , 'LIST', g_list_header_id,'LOW');
12644:
12645: l_found := 'N';

Line 12687: WHEN FND_API.G_EXC_ERROR THEN

12683:
12684: write_to_act_log('Procedure process_rt_all_sql executed ', 'LIST', g_list_header_id ,'LOW');
12685:
12686: EXCEPTION
12687: WHEN FND_API.G_EXC_ERROR THEN
12688: write_to_act_log('Error when executing procedure process_rt_all_sql '||sqlcode||' '||sqlerrm, 'LIST', g_list_header_id,'HIGH');
12689: x_return_status := FND_API.G_RET_STS_ERROR ;
12690: FND_MSG_PUB.count_and_get(
12691: p_encoded => FND_API.g_false,

Line 12689: x_return_status := FND_API.G_RET_STS_ERROR ;

12685:
12686: EXCEPTION
12687: WHEN FND_API.G_EXC_ERROR THEN
12688: write_to_act_log('Error when executing procedure process_rt_all_sql '||sqlcode||' '||sqlerrm, 'LIST', g_list_header_id,'HIGH');
12689: x_return_status := FND_API.G_RET_STS_ERROR ;
12690: FND_MSG_PUB.count_and_get(
12691: p_encoded => FND_API.g_false,
12692: p_count => x_msg_count,
12693: p_data => x_msg_data

Line 12691: p_encoded => FND_API.g_false,

12687: WHEN FND_API.G_EXC_ERROR THEN
12688: write_to_act_log('Error when executing procedure process_rt_all_sql '||sqlcode||' '||sqlerrm, 'LIST', g_list_header_id,'HIGH');
12689: x_return_status := FND_API.G_RET_STS_ERROR ;
12690: FND_MSG_PUB.count_and_get(
12691: p_encoded => FND_API.g_false,
12692: p_count => x_msg_count,
12693: p_data => x_msg_data
12694: );
12695:

Line 12696: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

12692: p_count => x_msg_count,
12693: p_data => x_msg_data
12694: );
12695:
12696: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
12697: write_to_act_log('Error when executing procedure process_rt_all_sql '||sqlcode||' '||sqlerrm, 'LIST', g_list_header_id,'HIGH');
12698: x_return_status := FND_API.G_RET_STS_ERROR ;
12699: FND_MSG_PUB.count_and_get(
12700: p_encoded => FND_API.g_false,

Line 12698: x_return_status := FND_API.G_RET_STS_ERROR ;

12694: );
12695:
12696: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
12697: write_to_act_log('Error when executing procedure process_rt_all_sql '||sqlcode||' '||sqlerrm, 'LIST', g_list_header_id,'HIGH');
12698: x_return_status := FND_API.G_RET_STS_ERROR ;
12699: FND_MSG_PUB.count_and_get(
12700: p_encoded => FND_API.g_false,
12701: p_count => x_msg_count,
12702: p_data => x_msg_data

Line 12700: p_encoded => FND_API.g_false,

12696: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
12697: write_to_act_log('Error when executing procedure process_rt_all_sql '||sqlcode||' '||sqlerrm, 'LIST', g_list_header_id,'HIGH');
12698: x_return_status := FND_API.G_RET_STS_ERROR ;
12699: FND_MSG_PUB.count_and_get(
12700: p_encoded => FND_API.g_false,
12701: p_count => x_msg_count,
12702: p_data => x_msg_data
12703: );
12704:

Line 12707: x_return_status := FND_API.G_RET_STS_ERROR ;

12703: );
12704:
12705: WHEN OTHERS THEN
12706: write_to_act_log('Error when executing procedure process_rt_all_sql '||sqlcode||' '||sqlerrm, 'LIST', g_list_header_id,'HIGH');
12707: x_return_status := FND_API.G_RET_STS_ERROR ;
12708: FND_MSG_PUB.count_and_get(
12709: p_encoded => FND_API.g_false,
12710: p_count => x_msg_count,
12711: p_data => x_msg_data

Line 12709: p_encoded => FND_API.g_false,

12705: WHEN OTHERS THEN
12706: write_to_act_log('Error when executing procedure process_rt_all_sql '||sqlcode||' '||sqlerrm, 'LIST', g_list_header_id,'HIGH');
12707: x_return_status := FND_API.G_RET_STS_ERROR ;
12708: FND_MSG_PUB.count_and_get(
12709: p_encoded => FND_API.g_false,
12710: p_count => x_msg_count,
12711: p_data => x_msg_data
12712: );
12713:

Line 12863: x_return_status := FND_API.G_RET_STS_ERROR ;

12859:
12860: exception
12861: when others then
12862: write_to_act_log('Error while executing process_run_total_sql ' ||sqlcode||' '||sqlerrm, 'LIST', g_list_header_id,'HIGH');
12863: x_return_status := FND_API.G_RET_STS_ERROR ;
12864: END process_run_total_sql;
12865:
12866: -- ----------------------------------------------------------------------------------------------
12867: PROCEDURE process_run_total_cell

Line 12917: p_init_msg_list => FND_API.g_false,

12913:
12914: write_to_act_log('Executing procedure process_run_total_cell', 'LIST', g_list_header_id,'LOW' );
12915: ams_cell_pvt.get_comp_sql(
12916: p_api_version => 1.0,
12917: p_init_msg_list => FND_API.g_false,
12918: p_validation_level => FND_API.g_valid_level_full,
12919: x_return_status => x_return_status,
12920: x_msg_count => x_msg_count ,
12921: x_msg_data =>x_msg_data,

Line 12918: p_validation_level => FND_API.g_valid_level_full,

12914: write_to_act_log('Executing procedure process_run_total_cell', 'LIST', g_list_header_id,'LOW' );
12915: ams_cell_pvt.get_comp_sql(
12916: p_api_version => 1.0,
12917: p_init_msg_list => FND_API.g_false,
12918: p_validation_level => FND_API.g_valid_level_full,
12919: x_return_status => x_return_status,
12920: x_msg_count => x_msg_count ,
12921: x_msg_data =>x_msg_data,
12922: p_cell_id => p_incl_object_id ,

Line 12923: p_party_id_only => FND_API.g_false,

12919: x_return_status => x_return_status,
12920: x_msg_count => x_msg_count ,
12921: x_msg_data =>x_msg_data,
12922: p_cell_id => p_incl_object_id ,
12923: p_party_id_only => FND_API.g_false,
12924: x_sql_tbl => l_sql_2
12925: );
12926: write_to_act_log('AMS_ListGeneration_PKG.After Comp sql:', 'LIST', g_list_header_id,'LOW');
12927:

Line 13795: --x_tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

13791: -- write_to_act_log('Party id is '||l_party_id, 'LIST', p_list_header_id,'LOW');
13792: if x_msg_count > 0 then
13793: FOR i IN 1..x_msg_count LOOP
13794: -- Following code was modified by bmuthukr
13795: --x_tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
13796: --x_tmp_var1 := substrb(x_tmp_var1 || ' '|| x_tmp_var,1,4000);
13797: x_tmp_var := 'Please make sure that the required fields (eg. person first name, last name) are available in the remote database';
13798: write_to_act_log('Updating the tca_load_status as ERROR', 'LIST', p_list_header_id,'HIGH');
13799:

Line 13851: WHEN FND_API.G_EXC_ERROR THEN

13847:
13848: commit;
13849:
13850: EXCEPTION
13851: WHEN FND_API.G_EXC_ERROR THEN
13852: write_to_act_log('Error while executing procedure tca_upload_process '||sqlcode||' '||sqlerrm, 'LIST', g_list_header_id,'HIGH');
13853: x_return_status := FND_API.G_RET_STS_ERROR ;
13854:
13855: if l_prof <> 'N' then

Line 13853: x_return_status := FND_API.G_RET_STS_ERROR ;

13849:
13850: EXCEPTION
13851: WHEN FND_API.G_EXC_ERROR THEN
13852: write_to_act_log('Error while executing procedure tca_upload_process '||sqlcode||' '||sqlerrm, 'LIST', g_list_header_id,'HIGH');
13853: x_return_status := FND_API.G_RET_STS_ERROR ;
13854:
13855: if l_prof <> 'N' then
13856: fnd_profile.put('HZ_EXECUTE_API_CALLOUTS',l_prof);
13857: end if;

Line 13860: p_encoded => FND_API.g_false,

13856: fnd_profile.put('HZ_EXECUTE_API_CALLOUTS',l_prof);
13857: end if;
13858:
13859: FND_MSG_PUB.count_and_get(
13860: p_encoded => FND_API.g_false,
13861: p_count => x_msg_count,
13862: p_data => x_msg_data
13863: );
13864:

Line 13867: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

13863: );
13864:
13865:
13866:
13867: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
13868: write_to_act_log('Error while executing procedure tca_upload_process '||sqlcode||' '||sqlerrm, 'LIST', g_list_header_id,'HIGH');
13869: x_return_status := FND_API.G_RET_STS_ERROR ;
13870:
13871: if l_prof <> 'N' then

Line 13869: x_return_status := FND_API.G_RET_STS_ERROR ;

13865:
13866:
13867: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
13868: write_to_act_log('Error while executing procedure tca_upload_process '||sqlcode||' '||sqlerrm, 'LIST', g_list_header_id,'HIGH');
13869: x_return_status := FND_API.G_RET_STS_ERROR ;
13870:
13871: if l_prof <> 'N' then
13872: fnd_profile.put('HZ_EXECUTE_API_CALLOUTS',l_prof);
13873: end if;

Line 13876: p_encoded => FND_API.g_false,

13872: fnd_profile.put('HZ_EXECUTE_API_CALLOUTS',l_prof);
13873: end if;
13874:
13875: FND_MSG_PUB.count_and_get(
13876: p_encoded => FND_API.g_false,
13877: p_count => x_msg_count,
13878: p_data => x_msg_data
13879: );
13880:

Line 13883: x_return_status := FND_API.G_RET_STS_ERROR ;

13879: );
13880:
13881: WHEN OTHERS THEN
13882: write_to_act_log('Error while executing procedure tca_upload_process '||sqlcode||' '||sqlerrm, 'LIST', g_list_header_id,'HIGH');
13883: x_return_status := FND_API.G_RET_STS_ERROR ;
13884:
13885: if l_prof <> 'N' then
13886: fnd_profile.put('HZ_EXECUTE_API_CALLOUTS',l_prof);
13887: end if;

Line 13890: p_encoded => FND_API.g_false,

13886: fnd_profile.put('HZ_EXECUTE_API_CALLOUTS',l_prof);
13887: end if;
13888:
13889: FND_MSG_PUB.count_and_get(
13890: p_encoded => FND_API.g_false,
13891: p_count => x_msg_count,
13892: p_data => x_msg_data
13893: );
13894:

Line 13934: x_return_status := FND_API.G_RET_STS_SUCCESS;

13930: p_arc_log_used_by => 'LIST',
13931: p_log_used_by_id => p_list_header_id,
13932: p_level => 'LOW');
13933: x_remote_gen := 'Y';
13934: x_return_status := FND_API.G_RET_STS_SUCCESS;
13935: else
13936: write_to_act_log(p_msg_data => 'List selection does not include segments/workbook/SQL.' ,
13937: p_arc_log_used_by => 'LIST',
13938: p_log_used_by_id => p_list_header_id,

Line 13952: x_return_status := FND_API.G_RET_STS_SUCCESS;

13948: p_arc_log_used_by => 'LIST',
13949: p_log_used_by_id => p_list_header_id,
13950: p_level => 'LOW');
13951: x_remote_gen := 'Y';
13952: x_return_status := FND_API.G_RET_STS_SUCCESS;
13953: else
13954: write_to_act_log(p_msg_data => 'List/TG will be generated in local instance.' ,
13955: p_arc_log_used_by => 'LIST',
13956: p_log_used_by_id => p_list_header_id,

Line 13959: x_return_status := FND_API.G_RET_STS_SUCCESS;

13955: p_arc_log_used_by => 'LIST',
13956: p_log_used_by_id => p_list_header_id,
13957: p_level => 'LOW');
13958: x_remote_gen := 'N';
13959: x_return_status := FND_API.G_RET_STS_SUCCESS;
13960: end if;
13961: end if;
13962:
13963: EXCEPTION

Line 13966: x_return_status := FND_API.G_RET_STS_ERROR ;

13962:
13963: EXCEPTION
13964: WHEN OTHERS THEN
13965: write_to_act_log('Error while executing procedure remote_list_gen '||sqlcode||' '||sqlerrm, 'LIST', g_list_header_id,'HIGH');
13966: x_return_status := FND_API.G_RET_STS_ERROR ;
13967: x_msg_data := 'Error while executing procedure remote_list_gen '||sqlcode||' '||sqlerrm;
13968: x_msg_count := 1;
13969: FND_MSG_PUB.count_and_get(
13970: p_encoded => FND_API.g_false,

Line 13970: p_encoded => FND_API.g_false,

13966: x_return_status := FND_API.G_RET_STS_ERROR ;
13967: x_msg_data := 'Error while executing procedure remote_list_gen '||sqlcode||' '||sqlerrm;
13968: x_msg_count := 1;
13969: FND_MSG_PUB.count_and_get(
13970: p_encoded => FND_API.g_false,
13971: p_count => x_msg_count,
13972: p_data => x_msg_data
13973: );
13974:

Line 14088: x_return_status := FND_API.G_RET_STS_ERROR ;

14084:
14085: exception
14086: when others then
14087: write_to_act_log('Error while executing procedure is_manual '||sqlcode||' '||sqlerrm,'LIST',p_list_header_id,'HIGH');
14088: x_return_status := FND_API.G_RET_STS_ERROR ;
14089: x_msg_data := 'Error while executing procedure is_manual '||sqlcode||' '||sqlerrm;
14090: x_msg_count := 1;
14091: end is_manual;
14092:

Line 14170: x_return_status := FND_API.G_RET_STS_ERROR;

14166: commit;
14167:
14168: exception
14169: when others then
14170: x_return_status := FND_API.G_RET_STS_ERROR;
14171: x_msg_data := 'Error while executing upd_list_header_info. '||sqlcode||' '||sqlerrm;
14172: x_msg_count := 1;
14173: end upd_list_header_info;
14174: