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_MSG_PUB

Line 55: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);

51: g_reqd_num_tbl t_number;
52: g_act_num_tbl t_number;
53: g_no_of_rows_ini_selected number :=0;
54:
55: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
56: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
57: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
58: ------------------------------------------------------------------
59: --This Variable stores the primary key of the list header. --

Line 56: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

52: g_act_num_tbl t_number;
53: g_no_of_rows_ini_selected number :=0;
54:
55: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
56: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
57: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
58: ------------------------------------------------------------------
59: --This Variable stores the primary key of the list header. --
60: ------------------------------------------------------------------

Line 57: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);

53: g_no_of_rows_ini_selected number :=0;
54:
55: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
56: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
57: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
58: ------------------------------------------------------------------
59: --This Variable stores the primary key of the list header. --
60: ------------------------------------------------------------------
61: g_list_header_id ams_list_headers_all.list_header_id%type;

Line 526: l_msg_count := FND_MSG_PUB.Count_Msg;

522: PRAGMA AUTONOMOUS_TRANSACTION;
523: l_msg_data VARCHAR2(2000);
524: l_msg_count number;
525: BEGIN
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,

Line 529: FND_MSG_PUB.Get(FND_MSG_PUB.G_NEXT,

525: BEGIN
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

Line 1034: FND_MSG_PUB.Add;

1030: write_to_act_log('Error while executing delete_list_entries '||sqlcode || ' '||sqlerrm, 'LIST',g_list_header_id,'HIGH');
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:

Line 1078: FND_MSG_PUB.Add;

1074: write_to_act_log('Error while executing initialize_list_header procedure', 'LIST', g_list_header_id,'HIGH');
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: -------------------------------------------------------------------------------

Line 1151: FND_MSG_PUB.count_and_get(

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
1155: );

Line 1160: FND_MSG_PUB.count_and_get(

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
1164: );

Line 1169: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

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(
1173: p_encoded => FND_API.g_false,

Line 1170: FND_MSG_PUB.add_exc_msg(g_pkg_name, g_file_name);

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(
1173: p_encoded => FND_API.g_false,
1174: p_count => x_msg_count,

Line 1172: FND_MSG_PUB.count_and_get(

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(
1173: p_encoded => FND_API.g_false,
1174: p_count => x_msg_count,
1175: p_data => x_msg_data
1176: );

Line 3295: FND_MSG_PUB.Add;

3291:
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:

Line 3316: FND_MSG_PUB.Add;

3312:
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

Line 3406: FND_MSG_PUB.count_and_get(

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
3410: );

Line 3415: FND_MSG_PUB.count_and_get(

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
3419: );

Line 3424: FND_MSG_PUB.count_and_get(

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
3428: );

Line 3988: FND_MSG_PUB.Add;

3984: IF (c_action_dets%ROWCOUNT = 1) THEN
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:

Line 4539: FND_MSG_PUB.count_and_get(

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);
4543:

Line 4552: FND_MSG_PUB.Add;

4548: write_to_act_log('Error while executing process_list_actions '
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,

Line 4554: FND_MSG_PUB.count_and_get(

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);
4558:

Line 4578: FND_MSG_PUB.Add;

4574: write_to_act_log('Error while executing process_list_actions '
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,

Line 4580: FND_MSG_PUB.count_and_get(

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);
4584:

Line 4740: FND_MSG_PUB.Add;

4736: if(l_entry_count < p_no_of_rows_min_requested)then
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;

Line 7139: FND_MSG_PUB.count_and_get(

7135: status_date = sysdate,
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: );

Line 7243: FND_MSG_PUB.initialize;

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
7247: IF (AMS_DEBUG_HIGH_ON) THEN

Line 7250: FND_MSG_PUB.Add;

7246: -- Checking if Debug is set. If debug is set then log debugging message
7247: IF (AMS_DEBUG_HIGH_ON) THEN
7248: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
7249: FND_MESSAGE.Set_Token('TEXT', 'AMS_ListGeneration : Start');
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;

Line 7800: --IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)

7796: END IF;
7797:
7798: -- Success Message
7799: -- MMSG
7800: --IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
7801: --THEN
7802: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
7803: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration_PKG.Generate_List');
7804: FND_MSG_PUB.Add;

Line 7804: FND_MSG_PUB.Add;

7800: --IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
7801: --THEN
7802: FND_MESSAGE.Set_Name('AMS', 'API_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

Line 7812: FND_MSG_PUB.Add;

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');
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,

Line 7814: FND_MSG_PUB.count_and_get(

7810: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
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: );

Line 7837: FND_MSG_PUB.count_and_get(

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);
7841:

Line 7857: FND_MSG_PUB.Add;

7853: WHERE list_header_id = p_list_header_id;
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,

Line 7859: FND_MSG_PUB.count_and_get(

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);
7863: ---------------Cancel List Gen Exception Begin --------------

Line 7880: FND_MSG_PUB.Add;

7876: logger;
7877:
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');

Line 7886: FND_MSG_PUB.Add;

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;
7887:
7888: FND_MSG_PUB.count_and_get(
7889: p_encoded => FND_API.g_false,
7890: p_count => x_msg_count,

Line 7888: FND_MSG_PUB.count_and_get(

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;
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: );

Line 7910: FND_MSG_PUB.Add;

7906: WHERE list_header_id = p_list_header_id;
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,

Line 7912: FND_MSG_PUB.count_and_get(

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);
7916: END GENERATE_LIST;

Line 7986: FND_MSG_PUB.initialize;

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
7990: IF (AMS_DEBUG_HIGH_ON) THEN

Line 7993: FND_MSG_PUB.Add;

7989: -- Debug Message
7990: IF (AMS_DEBUG_HIGH_ON) THEN
7991: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
7992: FND_MESSAGE.Set_Token('TEXT', 'AMS_ListGeneration_PKG.cerate_list: Start', TRUE);
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;

Line 8025: FND_MSG_PUB.Add;

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;
8026: l_list_query_rec.name := p_list_name || x_list_header_id;
8027: l_list_query_rec.sql_string := p_sql_string ;
8028: l_list_query_rec.primary_key := p_primary_key ;
8029: l_list_query_rec.type := p_master_type ;

Line 8100: --IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)

8096: END IF;
8097:
8098: -- Success Message
8099: -- MMSG
8100: --IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
8101: --THEN
8102: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
8103: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration_PKG.create_list: ');
8104: FND_MSG_PUB.Add;

Line 8104: FND_MSG_PUB.Add;

8100: --IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
8101: --THEN
8102: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
8103: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration_PKG.create_list: ');
8104: FND_MSG_PUB.Add;
8105: --END IF;
8106:
8107: --IF (AMS_DEBUG_HIGH_ON) THEN
8108: --THEN

Line 8111: FND_MSG_PUB.Add;

8107: --IF (AMS_DEBUG_HIGH_ON) THEN
8108: --THEN
8109: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
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,

Line 8113: FND_MSG_PUB.count_and_get(

8109: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
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: );

Line 8123: FND_MSG_PUB.count_and_get(

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);
8127:

Line 8130: FND_MSG_PUB.count_and_get(

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);
8134:

Line 8137: FND_MSG_PUB.count_and_get(

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);
8141: END CREATE_LIST;

Line 8206: FND_MSG_PUB.initialize;

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
8210: IF (AMS_DEBUG_HIGH_ON) THEN

Line 8213: FND_MSG_PUB.Add;

8209: -- Debug Message
8210: IF (AMS_DEBUG_HIGH_ON) THEN
8211: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
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

Line 8262: FND_MSG_PUB.Add;

8258: p_action_rec => l_action_rec,
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:

Line 8291: --IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)

8287: END IF;
8288:
8289: -- Success Message
8290: -- MMSG
8291: --IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
8292: --THEN
8293: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
8294: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration_PKG.create_list: ');
8295: FND_MSG_PUB.Add;

Line 8295: FND_MSG_PUB.Add;

8291: --IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
8292: --THEN
8293: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
8294: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration_PKG.create_list: ');
8295: FND_MSG_PUB.Add;
8296: --END IF;
8297:
8298:
8299: --IF (AMS_DEBUG_HIGH_ON) THEN

Line 8303: FND_MSG_PUB.Add;

8299: --IF (AMS_DEBUG_HIGH_ON) THEN
8300: --THEN
8301: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
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,

Line 8305: FND_MSG_PUB.count_and_get(

8301: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
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: );

Line 8315: FND_MSG_PUB.Add;

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
8317: x_return_status := FND_API.G_RET_STS_ERROR ;
8318: FND_MSG_PUB.count_and_get(
8319: p_encoded => FND_API.g_false,

Line 8318: FND_MSG_PUB.count_and_get(

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);
8322:

Line 8326: FND_MSG_PUB.Add;

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 ;
8328: FND_MSG_PUB.count_and_get(
8329: p_encoded => FND_API.g_false,
8330: p_count => x_msg_count,

Line 8328: FND_MSG_PUB.count_and_get(

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);
8332:

Line 8336: FND_MSG_PUB.Add;

8332:
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,

Line 8338: FND_MSG_PUB.count_and_get(

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);
8342: END CREATE_import_LIST;

Line 8385: FND_MSG_PUB.initialize;

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
8389: IF (AMS_DEBUG_HIGH_ON) THEN

Line 8392: FND_MSG_PUB.Add;

8388: -- Debug Message
8389: IF (AMS_DEBUG_HIGH_ON) THEN
8390: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8391: FND_MESSAGE.Set_Token('TEXT', 'AMS_ListGeneration_PKG.cerate_list: Start', TRUE);
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;

Line 8469: --IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)

8465: END IF;
8466:
8467: -- Success Message
8468: -- MMSG
8469: --IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
8470: --THEN
8471: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
8472: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration_PKG.create_list: ');
8473: FND_MSG_PUB.Add;

Line 8473: FND_MSG_PUB.Add;

8469: --IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
8470: --THEN
8471: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
8472: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration_PKG.create_list: ');
8473: FND_MSG_PUB.Add;
8474: --END IF;
8475:
8476:
8477: --IF (AMS_DEBUG_HIGH_ON) THEN

Line 8481: FND_MSG_PUB.Add;

8477: --IF (AMS_DEBUG_HIGH_ON) THEN
8478: --THEN
8479: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
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,

Line 8483: FND_MSG_PUB.count_and_get(

8479: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
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: );

Line 8493: FND_MSG_PUB.Add;

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
8495: x_return_status := FND_API.G_RET_STS_ERROR ;
8496: FND_MSG_PUB.count_and_get(
8497: p_encoded => FND_API.g_false,

Line 8496: FND_MSG_PUB.count_and_get(

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);
8500:

Line 8504: FND_MSG_PUB.Add;

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 ;
8506: FND_MSG_PUB.count_and_get(
8507: p_encoded => FND_API.g_false,
8508: p_count => x_msg_count,

Line 8506: FND_MSG_PUB.count_and_get(

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);
8510:

Line 8514: FND_MSG_PUB.Add;

8510:
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,

Line 8516: FND_MSG_PUB.count_and_get(

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);
8520: END CREATE_LIST_FROM_QUERY ;

Line 8564: FND_MSG_PUB.initialize;

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
8568: IF (AMS_DEBUG_HIGH_ON) THEN

Line 8571: FND_MSG_PUB.Add;

8567: -- Debug Message
8568: IF (AMS_DEBUG_HIGH_ON) THEN
8569: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8570: FND_MESSAGE.Set_Token('TEXT', 'AMS_ListGeneration_PKG.cerate_list: Start', TRUE);
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;

Line 8650: --IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)

8646: END IF;
8647:
8648: -- Success Message
8649: -- MMSG
8650: --IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
8651: --THEN
8652: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
8653: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration_PKG.create_list: ');
8654: FND_MSG_PUB.Add;

Line 8654: FND_MSG_PUB.Add;

8650: --IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
8651: --THEN
8652: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
8653: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration_PKG.create_list: ');
8654: FND_MSG_PUB.Add;
8655: --END IF;
8656:
8657:
8658: --IF (AMS_DEBUG_HIGH_ON) THEN

Line 8662: FND_MSG_PUB.Add;

8658: --IF (AMS_DEBUG_HIGH_ON) THEN
8659: --THEN
8660: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
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,

Line 8664: FND_MSG_PUB.count_and_get(

8660: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
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: );

Line 8674: FND_MSG_PUB.Add;

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
8676: x_return_status := FND_API.G_RET_STS_ERROR ;
8677: FND_MSG_PUB.count_and_get(
8678: p_encoded => FND_API.g_false,

Line 8677: FND_MSG_PUB.count_and_get(

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);
8681:

Line 8685: FND_MSG_PUB.Add;

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 ;
8687: FND_MSG_PUB.count_and_get(
8688: p_encoded => FND_API.g_false,
8689: p_count => x_msg_count,

Line 8687: FND_MSG_PUB.count_and_get(

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);
8691:

Line 8695: FND_MSG_PUB.Add;

8691:
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,

Line 8697: FND_MSG_PUB.count_and_get(

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);
8701: END CREATE_LIST_FROM_QUERY ;

Line 8872: FND_MSG_PUB.Add;

8868: EXIT WHEN c_action_dets%NOTFOUND;
8869:
8870: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
8871: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration : before IMMEDIATE');
8872: FND_MSG_PUB.Add;
8873: write_to_act_log('Selection included in target group is of type '||l_action_dets_rec.list_act_type||' , action type is '||l_action_dets_rec.list_action_type, 'LIST', g_list_header_id,'HIGH');
8874: write_to_act_log('List header id is '||l_action_dets_rec.list_header_id||' act list header id is '||l_action_dets_rec.act_list_header_id||' and order no is '||l_action_dets_rec.order_number, 'LIST', g_list_header_id,'HIGH');
8875: if l_action_dets_rec.list_act_type = 'SQL' then
8876: OPEN c_query( l_action_dets_rec.list_header_id );

Line 9005: FND_MSG_PUB.Add;

9001: end if;
9002:
9003: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
9004: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration : AFTER IMMEDIATE');
9005: FND_MSG_PUB.Add;
9006:
9007: if l_action_dets_rec.list_action_type = 'INCLUDE' then
9008: l_include_count := l_include_count +1 ;
9009: l_include_sql_tbl(l_include_count) := l_include_sql ;

Line 9454: FND_MSG_PUB.count_and_get(

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);
9458:

Line 9466: FND_MSG_PUB.Add;

9462: END IF;
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,

Line 9468: FND_MSG_PUB.count_and_get(

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);
9472:

Line 9480: FND_MSG_PUB.Add;

9476: END IF;
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,

Line 9482: FND_MSG_PUB.count_and_get(

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);
9486: END process_tar_actions;

Line 9745: FND_MSG_PUB.count_and_get(

9741: main_gen_end_time = sysdate,
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: );

Line 9853: FND_MSG_PUB.initialize;

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
9857: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH)

Line 9857: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH)

9853: FND_MSG_PUB.initialize;
9854: END IF;
9855:
9856: -- Checking if Debug is set. If debug is set then log debugging message
9857: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH)
9858: THEN
9859: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
9860: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration : Start');
9861: FND_MSG_PUB.Add;

Line 9861: FND_MSG_PUB.Add;

9857: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH)
9858: THEN
9859: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
9860: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration : Start');
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;

Line 10364: --IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)

10360: END IF;
10361:
10362: -- Success Message
10363: -- MMSG
10364: --IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
10365: --THEN
10366: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
10367: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration_PKG.Generate_List');
10368: FND_MSG_PUB.Add;

Line 10368: FND_MSG_PUB.Add;

10364: --IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
10365: --THEN
10366: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
10367: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration_PKG.Generate_List');
10368: FND_MSG_PUB.Add;
10369: --END IF;
10370:
10371:
10372: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 10373: --IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH)

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');
10377: FND_MSG_PUB.Add;

Line 10377: FND_MSG_PUB.Add;

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');
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,

Line 10379: FND_MSG_PUB.count_and_get(

10375: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
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: );

Line 10407: FND_MSG_PUB.count_and_get(

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);
10411:

Line 10431: FND_MSG_PUB.Add;

10427: --write_to_act_log('Error: AMS_ListGeneration_PKG.Generate_List:'||
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,

Line 10433: FND_MSG_PUB.count_and_get(

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);
10437:

Line 10459: FND_MSG_PUB.Add;

10455: --write_to_act_log('Error: AMS_ListGeneration_PKG.Generate_List:'||
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,

Line 10461: FND_MSG_PUB.count_and_get(

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);
10465: END GENERATE_TARGET_GROUP;

Line 10619: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

10615: Write_To_Act_Log ('No more rules associated with the List','LIST',p_list_header_id ,'LOW');
10616: NULL;
10617: END IF;
10618:
10619: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
10620: THEN
10621: FND_MESSAGE.set_name('AMS', 'AMS_LIST_NO_LIST_RULE');
10622: FND_MSG_PUB.add;
10623: END IF;

Line 10622: FND_MSG_PUB.add;

10618:
10619: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
10620: THEN
10621: FND_MESSAGE.set_name('AMS', 'AMS_LIST_NO_LIST_RULE');
10622: FND_MSG_PUB.add;
10623: END IF;
10624:
10625: CLOSE c_list_rules;
10626: return;

Line 10644: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

10640: COMMIT;
10641: END IF;
10642: */
10643: Write_To_Act_Log ( 'More than one rule cannot be applied to the list','LIST',p_list_header_id ,'HIGH');
10644: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
10645: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ONLY_ONE_LIST_RULE');
10646: FND_MSG_PUB.add;
10647: END IF;
10648:

Line 10646: FND_MSG_PUB.add;

10642: */
10643: Write_To_Act_Log ( 'More than one rule cannot be applied to the list','LIST',p_list_header_id ,'HIGH');
10644: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
10645: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ONLY_ONE_LIST_RULE');
10646: FND_MSG_PUB.add;
10647: END IF;
10648:
10649: CLOSE c_list_rules;
10650: RETURN;

Line 11902: FND_MSG_PUB.Add;

11898: argument1 => p_action_used_by_id);
11899: commit;
11900: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
11901: FND_MESSAGE.Set_Token('TEXT', 'request_id->'||l_request_id || '<-');
11902: FND_MSG_PUB.Add;
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(

Line 11905: -- FND_MSG_PUB.Add;

11901: FND_MESSAGE.Set_Token('TEXT', 'request_id->'||l_request_id || '<-');
11902: FND_MSG_PUB.Add;
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 );

Line 11906: FND_MSG_PUB.count_and_get(

11902: FND_MSG_PUB.Add;
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';

Line 11919: FND_MSG_PUB.Add;

11915:
11916:
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

Line 11920: FND_MSG_PUB.count_and_get(

11916:
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: );

Line 12045: FND_MSG_PUB.Add;

12041: IF (p_action_rec.list_action_type <> 'INCLUDE')then
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:

Line 12224: FND_MSG_PUB.count_and_get(

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);
12228:

Line 12239: FND_MSG_PUB.Add;

12235: write_to_act_log('Error: AMS_ListGeneration_PKG.Process_list_actions:'
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,

Line 12241: FND_MSG_PUB.count_and_get(

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);
12245:

Line 12256: FND_MSG_PUB.Add;

12252: write_to_act_log('Error: AMS_ListGeneration_PKG.Process_list_actions:'
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,

Line 12258: FND_MSG_PUB.count_and_get(

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);
12262: END calc_running_total;

Line 12620: FND_MSG_PUB.Add;

12616: -- write_to_act_log('Process_rt_all_sql l_found : '||l_found,'LIST', g_list_header_id);
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 ||

Line 12640: FND_MSG_PUB.Add;

12636: x_source_object_pk_field => l_source_object_pk_field);
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:

Line 12690: FND_MSG_PUB.count_and_get(

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
12694: );

Line 12699: FND_MSG_PUB.count_and_get(

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
12703: );

Line 12708: FND_MSG_PUB.count_and_get(

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
12712: );

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 13859: FND_MSG_PUB.count_and_get(

13855: if l_prof <> 'N' then
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: );

Line 13875: FND_MSG_PUB.count_and_get(

13871: if l_prof <> 'N' then
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: );

Line 13889: FND_MSG_PUB.count_and_get(

13885: if l_prof <> 'N' then
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: );

Line 13969: FND_MSG_PUB.count_and_get(

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,
13971: p_count => x_msg_count,
13972: p_data => x_msg_data
13973: );