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

3983: IF (c_action_dets%ROWCOUNT = 1) THEN
3984: IF (p_action_rec.list_action_type <> 'INCLUDE')then
3985: write_to_act_log('Action type of the first selection should always be INCLUDE. Aborting list generation.', 'LIST', g_list_header_id,'HIGH');
3986: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ACT_FIRST_INCLUDE');
3987: FND_MSG_PUB.Add;
3988: RAISE FND_API.G_EXC_ERROR;
3989: END IF; -- End of if for list_action_type check
3990: END IF; --End of Validation:- First Action Include Check
3991:

Line 4532: FND_MSG_PUB.count_and_get(

4528: write_to_act_log('Error while executing process_list_actions '
4529: ||sqlerrm||sqlcode, 'LIST', g_list_header_id,'HIGH');
4530: -- Check if reset of the status is required
4531: x_return_status := FND_API.G_RET_STS_ERROR ;
4532: FND_MSG_PUB.count_and_get(
4533: p_encoded => FND_API.g_false,
4534: p_count => x_msg_count,
4535: p_data => x_msg_data);
4536:

Line 4545: FND_MSG_PUB.Add;

4541: write_to_act_log('Error while executing process_list_actions '
4542: ||sqlerrm||sqlcode, 'LIST', g_list_header_id,'HIGH');
4543: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
4544: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
4545: FND_MSG_PUB.Add;
4546: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4547: FND_MSG_PUB.count_and_get(
4548: p_encoded => FND_API.g_false,
4549: p_count => x_msg_count,

Line 4547: FND_MSG_PUB.count_and_get(

4543: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
4544: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
4545: FND_MSG_PUB.Add;
4546: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4547: FND_MSG_PUB.count_and_get(
4548: p_encoded => FND_API.g_false,
4549: p_count => x_msg_count,
4550: p_data => x_msg_data);
4551:

Line 4571: FND_MSG_PUB.Add;

4567: write_to_act_log('Error while executing process_list_actions '
4568: ||sqlerrm||sqlcode, 'LIST', g_list_header_id,'HIGH');
4569: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
4570: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
4571: FND_MSG_PUB.Add;
4572: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4573: FND_MSG_PUB.count_and_get(
4574: p_encoded => FND_API.g_false,
4575: p_count => x_msg_count,

Line 4573: FND_MSG_PUB.count_and_get(

4569: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
4570: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
4571: FND_MSG_PUB.Add;
4572: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4573: FND_MSG_PUB.count_and_get(
4574: p_encoded => FND_API.g_false,
4575: p_count => x_msg_count,
4576: p_data => x_msg_data);
4577:

Line 4733: FND_MSG_PUB.Add;

4729: if(l_entry_count < p_no_of_rows_min_requested)then
4730: FND_MESSAGE.set_name('AMS', 'AMS_LIST_MINIMUM_NOT_REACHED');
4731: FND_MESSAGE.Set_Token('NO_AVAILABLE',TO_CHAR(l_entry_count));
4732: FND_MESSAGE.Set_Token('NO_REQUESTED',TO_CHAR(p_no_of_rows_min_requested));
4733: FND_MSG_PUB.Add;
4734: x_return_status := FND_API.G_RET_STS_ERROR;
4735: ELSE
4736: x_return_status := FND_API.G_RET_STS_SUCCESS;
4737: END if;

Line 7054: FND_MSG_PUB.count_and_get(

7050: status_date = sysdate,
7051: last_update_date = sysdate,
7052: main_gen_end_time = sysdate
7053: WHERE list_header_id = g_list_header_id;
7054: FND_MSG_PUB.count_and_get(
7055: p_encoded => FND_API.g_false,
7056: p_count => x_msg_count,
7057: p_data => x_msg_data
7058: );

Line 7158: FND_MSG_PUB.initialize;

7154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7155: END IF;
7156:
7157: IF FND_API.to_Boolean( p_init_msg_list ) THEN
7158: FND_MSG_PUB.initialize;
7159: END IF;
7160:
7161: -- Checking if Debug is set. If debug is set then log debugging message
7162: IF (AMS_DEBUG_HIGH_ON) THEN

Line 7165: FND_MSG_PUB.Add;

7161: -- Checking if Debug is set. If debug is set then log debugging message
7162: IF (AMS_DEBUG_HIGH_ON) THEN
7163: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
7164: FND_MESSAGE.Set_Token('TEXT', 'AMS_ListGeneration : Start');
7165: FND_MSG_PUB.Add;
7166: END IF;
7167:
7168: -- Initialize API return status to success
7169: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

7708: END IF;
7709:
7710: -- Success Message
7711: -- MMSG
7712: --IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
7713: --THEN
7714: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
7715: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration_PKG.Generate_List');
7716: FND_MSG_PUB.Add;

Line 7716: FND_MSG_PUB.Add;

7712: --IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
7713: --THEN
7714: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
7715: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration_PKG.Generate_List');
7716: FND_MSG_PUB.Add;
7717: --END IF;
7718:
7719: x_return_status := FND_API.G_RET_STS_SUCCESS;
7720: --IF (AMS_DEBUG_HIGH_ON) THEN

Line 7724: FND_MSG_PUB.Add;

7720: --IF (AMS_DEBUG_HIGH_ON) THEN
7721: --THEN
7722: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
7723: FND_MESSAGE.Set_Token('TEXT', 'AMS_ListGeneration_PKG.Generate_List: END');
7724: FND_MSG_PUB.Add;
7725: --END IF;
7726: FND_MSG_PUB.count_and_get(
7727: p_encoded => FND_API.g_false,
7728: p_count => x_msg_count,

Line 7726: FND_MSG_PUB.count_and_get(

7722: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
7723: FND_MESSAGE.Set_Token('TEXT', 'AMS_ListGeneration_PKG.Generate_List: END');
7724: FND_MSG_PUB.Add;
7725: --END IF;
7726: FND_MSG_PUB.count_and_get(
7727: p_encoded => FND_API.g_false,
7728: p_count => x_msg_count,
7729: p_data => x_msg_data
7730: );

Line 7749: FND_MSG_PUB.count_and_get(

7745: WHERE list_header_id = p_list_header_id;
7746: logger;
7747: -- Check if reset of the status is required
7748: x_return_status := FND_API.G_RET_STS_ERROR ;
7749: FND_MSG_PUB.count_and_get(
7750: p_encoded => FND_API.g_false,
7751: p_count => x_msg_count,
7752: p_data => x_msg_data);
7753:

Line 7769: FND_MSG_PUB.Add;

7765: WHERE list_header_id = p_list_header_id;
7766: logger;
7767: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
7768: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
7769: FND_MSG_PUB.Add;
7770: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7771: FND_MSG_PUB.count_and_get(
7772: p_encoded => FND_API.g_false,
7773: p_count => x_msg_count,

Line 7771: FND_MSG_PUB.count_and_get(

7767: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
7768: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
7769: FND_MSG_PUB.Add;
7770: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7771: FND_MSG_PUB.count_and_get(
7772: p_encoded => FND_API.g_false,
7773: p_count => x_msg_count,
7774: p_data => x_msg_data);
7775: ---------------Cancel List Gen Exception Begin --------------

Line 7792: FND_MSG_PUB.Add;

7788: logger;
7789:
7790: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
7791: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration_PKG.Generate_List');
7792: FND_MSG_PUB.Add;
7793:
7794: x_return_status := FND_API.G_RET_STS_SUCCESS;
7795:
7796: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');

Line 7798: FND_MSG_PUB.Add;

7794: x_return_status := FND_API.G_RET_STS_SUCCESS;
7795:
7796: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
7797: FND_MESSAGE.Set_Token('TEXT', 'AMS_ListGeneration_PKG.Generate_List: END');
7798: FND_MSG_PUB.Add;
7799:
7800: FND_MSG_PUB.count_and_get(
7801: p_encoded => FND_API.g_false,
7802: p_count => x_msg_count,

Line 7800: FND_MSG_PUB.count_and_get(

7796: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
7797: FND_MESSAGE.Set_Token('TEXT', 'AMS_ListGeneration_PKG.Generate_List: END');
7798: FND_MSG_PUB.Add;
7799:
7800: FND_MSG_PUB.count_and_get(
7801: p_encoded => FND_API.g_false,
7802: p_count => x_msg_count,
7803: p_data => x_msg_data
7804: );

Line 7822: FND_MSG_PUB.Add;

7818: WHERE list_header_id = p_list_header_id;
7819: logger;
7820: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
7821: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
7822: FND_MSG_PUB.Add;
7823: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7824: FND_MSG_PUB.count_and_get(
7825: p_encoded => FND_API.g_false,
7826: p_count => x_msg_count,

Line 7824: FND_MSG_PUB.count_and_get(

7820: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
7821: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
7822: FND_MSG_PUB.Add;
7823: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7824: FND_MSG_PUB.count_and_get(
7825: p_encoded => FND_API.g_false,
7826: p_count => x_msg_count,
7827: p_data => x_msg_data);
7828: END GENERATE_LIST;

Line 7898: FND_MSG_PUB.initialize;

7894:
7895:
7896: -- Initialize message list IF p_init_msg_list is set to TRUE.
7897: IF FND_API.to_Boolean( p_init_msg_list ) THEN
7898: FND_MSG_PUB.initialize;
7899: END IF;
7900:
7901: -- Debug Message
7902: IF (AMS_DEBUG_HIGH_ON) THEN

Line 7905: FND_MSG_PUB.Add;

7901: -- Debug Message
7902: IF (AMS_DEBUG_HIGH_ON) THEN
7903: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
7904: FND_MESSAGE.Set_Token('TEXT', 'AMS_ListGeneration_PKG.cerate_list: Start', TRUE);
7905: FND_MSG_PUB.Add;
7906: END IF;
7907:
7908: -- Initialize API return status to success
7909: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 7937: FND_MSG_PUB.Add;

7933: RAISE FND_API.G_EXC_ERROR;
7934: end if;
7935:
7936: FND_MESSAGE.set_name('AMS', 'bfore list query');
7937: FND_MSG_PUB.Add;
7938: l_list_query_rec.name := p_list_name || x_list_header_id;
7939: l_list_query_rec.sql_string := p_sql_string ;
7940: l_list_query_rec.primary_key := p_primary_key ;
7941: l_list_query_rec.type := p_master_type ;

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

8008: END IF;
8009:
8010: -- Success Message
8011: -- MMSG
8012: --IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
8013: --THEN
8014: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
8015: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration_PKG.create_list: ');
8016: FND_MSG_PUB.Add;

Line 8016: FND_MSG_PUB.Add;

8012: --IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
8013: --THEN
8014: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
8015: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration_PKG.create_list: ');
8016: FND_MSG_PUB.Add;
8017: --END IF;
8018:
8019: --IF (AMS_DEBUG_HIGH_ON) THEN
8020: --THEN

Line 8023: FND_MSG_PUB.Add;

8019: --IF (AMS_DEBUG_HIGH_ON) THEN
8020: --THEN
8021: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8022: FND_MESSAGE.Set_Token('TEXT', 'AMS_ListGeneration_PKG.create_list: END');
8023: FND_MSG_PUB.Add;
8024: --END IF;
8025: FND_MSG_PUB.count_and_get(
8026: p_encoded => FND_API.g_false,
8027: p_count => x_msg_count,

Line 8025: FND_MSG_PUB.count_and_get(

8021: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8022: FND_MESSAGE.Set_Token('TEXT', 'AMS_ListGeneration_PKG.create_list: END');
8023: FND_MSG_PUB.Add;
8024: --END IF;
8025: FND_MSG_PUB.count_and_get(
8026: p_encoded => FND_API.g_false,
8027: p_count => x_msg_count,
8028: p_data => x_msg_data
8029: );

Line 8035: FND_MSG_PUB.count_and_get(

8031: EXCEPTION
8032: WHEN FND_API.G_EXC_ERROR THEN
8033: -- Check if reset of the status is required
8034: x_return_status := FND_API.G_RET_STS_ERROR ;
8035: FND_MSG_PUB.count_and_get(
8036: p_encoded => FND_API.g_false,
8037: p_count => x_msg_count,
8038: p_data => x_msg_data);
8039:

Line 8042: FND_MSG_PUB.count_and_get(

8038: p_data => x_msg_data);
8039:
8040: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8041: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8042: FND_MSG_PUB.count_and_get(
8043: p_encoded => FND_API.g_false,
8044: p_count => x_msg_count,
8045: p_data => x_msg_data);
8046:

Line 8049: FND_MSG_PUB.count_and_get(

8045: p_data => x_msg_data);
8046:
8047: WHEN OTHERS THEN
8048: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8049: FND_MSG_PUB.count_and_get(
8050: p_encoded => FND_API.g_false,
8051: p_count => x_msg_count,
8052: p_data => x_msg_data);
8053: END CREATE_LIST;

Line 8118: FND_MSG_PUB.initialize;

8114:
8115:
8116: -- Initialize message list IF p_init_msg_list is set to TRUE.
8117: IF FND_API.to_Boolean( p_init_msg_list ) THEN
8118: FND_MSG_PUB.initialize;
8119: END IF;
8120:
8121: -- Debug Message
8122: IF (AMS_DEBUG_HIGH_ON) THEN

Line 8125: FND_MSG_PUB.Add;

8121: -- Debug Message
8122: IF (AMS_DEBUG_HIGH_ON) THEN
8123: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8124: FND_MESSAGE.Set_Token('TEXT', 'AMS_ListGeneration_PKG.cerate_list: Start', TRUE);
8125: FND_MSG_PUB.Add;
8126: END IF;
8127: -- Initialize API return status to success
8128: x_return_status := FND_API.G_RET_STS_SUCCESS;
8129: -- Perform the database operation

Line 8174: FND_MSG_PUB.Add;

8170: p_action_rec => l_action_rec,
8171: x_action_id => l_action_id
8172: ) ;
8173: FND_MESSAGE.set_name('AMS','after list action->'|| l_action_id|| '<-');
8174: FND_MSG_PUB.Add;
8175: if x_return_status <> FND_API.g_ret_sts_success THEN
8176: RAISE FND_API.G_EXC_ERROR;
8177: end if;
8178:

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

8199: END IF;
8200:
8201: -- Success Message
8202: -- MMSG
8203: --IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
8204: --THEN
8205: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
8206: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration_PKG.create_list: ');
8207: FND_MSG_PUB.Add;

Line 8207: FND_MSG_PUB.Add;

8203: --IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
8204: --THEN
8205: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
8206: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration_PKG.create_list: ');
8207: FND_MSG_PUB.Add;
8208: --END IF;
8209:
8210:
8211: --IF (AMS_DEBUG_HIGH_ON) THEN

Line 8215: FND_MSG_PUB.Add;

8211: --IF (AMS_DEBUG_HIGH_ON) THEN
8212: --THEN
8213: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8214: FND_MESSAGE.Set_Token('TEXT', 'AMS_ListGeneration_PKG.create_list: END');
8215: FND_MSG_PUB.Add;
8216: --END IF;
8217: FND_MSG_PUB.count_and_get(
8218: p_encoded => FND_API.g_false,
8219: p_count => x_msg_count,

Line 8217: FND_MSG_PUB.count_and_get(

8213: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8214: FND_MESSAGE.Set_Token('TEXT', 'AMS_ListGeneration_PKG.create_list: END');
8215: FND_MSG_PUB.Add;
8216: --END IF;
8217: FND_MSG_PUB.count_and_get(
8218: p_encoded => FND_API.g_false,
8219: p_count => x_msg_count,
8220: p_data => x_msg_data
8221: );

Line 8227: FND_MSG_PUB.Add;

8223: EXCEPTION
8224: WHEN FND_API.G_EXC_ERROR THEN
8225: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8226: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
8227: FND_MSG_PUB.Add;
8228: -- Check if reset of the status is required
8229: x_return_status := FND_API.G_RET_STS_ERROR ;
8230: FND_MSG_PUB.count_and_get(
8231: p_encoded => FND_API.g_false,

Line 8230: FND_MSG_PUB.count_and_get(

8226: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
8227: FND_MSG_PUB.Add;
8228: -- Check if reset of the status is required
8229: x_return_status := FND_API.G_RET_STS_ERROR ;
8230: FND_MSG_PUB.count_and_get(
8231: p_encoded => FND_API.g_false,
8232: p_count => x_msg_count,
8233: p_data => x_msg_data);
8234:

Line 8238: FND_MSG_PUB.Add;

8234:
8235: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8236: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8237: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
8238: FND_MSG_PUB.Add;
8239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8240: FND_MSG_PUB.count_and_get(
8241: p_encoded => FND_API.g_false,
8242: p_count => x_msg_count,

Line 8240: FND_MSG_PUB.count_and_get(

8236: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8237: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
8238: FND_MSG_PUB.Add;
8239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8240: FND_MSG_PUB.count_and_get(
8241: p_encoded => FND_API.g_false,
8242: p_count => x_msg_count,
8243: p_data => x_msg_data);
8244:

Line 8248: FND_MSG_PUB.Add;

8244:
8245: WHEN OTHERS THEN
8246: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8247: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
8248: FND_MSG_PUB.Add;
8249: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8250: FND_MSG_PUB.count_and_get(
8251: p_encoded => FND_API.g_false,
8252: p_count => x_msg_count,

Line 8250: FND_MSG_PUB.count_and_get(

8246: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8247: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
8248: FND_MSG_PUB.Add;
8249: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8250: FND_MSG_PUB.count_and_get(
8251: p_encoded => FND_API.g_false,
8252: p_count => x_msg_count,
8253: p_data => x_msg_data);
8254: END CREATE_import_LIST;

Line 8297: FND_MSG_PUB.initialize;

8293:
8294:
8295: -- Initialize message list IF p_init_msg_list is set to TRUE.
8296: IF FND_API.to_Boolean( p_init_msg_list ) THEN
8297: FND_MSG_PUB.initialize;
8298: END IF;
8299:
8300: -- Debug Message
8301: IF (AMS_DEBUG_HIGH_ON) THEN

Line 8304: FND_MSG_PUB.Add;

8300: -- Debug Message
8301: IF (AMS_DEBUG_HIGH_ON) THEN
8302: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8303: FND_MESSAGE.Set_Token('TEXT', 'AMS_ListGeneration_PKG.cerate_list: Start', TRUE);
8304: FND_MSG_PUB.Add;
8305: END IF;
8306:
8307: -- Initialize API return status to success
8308: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

8377: END IF;
8378:
8379: -- Success Message
8380: -- MMSG
8381: --IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
8382: --THEN
8383: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
8384: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration_PKG.create_list: ');
8385: FND_MSG_PUB.Add;

Line 8385: FND_MSG_PUB.Add;

8381: --IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
8382: --THEN
8383: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
8384: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration_PKG.create_list: ');
8385: FND_MSG_PUB.Add;
8386: --END IF;
8387:
8388:
8389: --IF (AMS_DEBUG_HIGH_ON) THEN

Line 8393: FND_MSG_PUB.Add;

8389: --IF (AMS_DEBUG_HIGH_ON) THEN
8390: --THEN
8391: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8392: FND_MESSAGE.Set_Token('TEXT', 'AMS_ListGeneration_PKG.create_list: END');
8393: FND_MSG_PUB.Add;
8394: --END IF;
8395: FND_MSG_PUB.count_and_get(
8396: p_encoded => FND_API.g_false,
8397: p_count => x_msg_count,

Line 8395: FND_MSG_PUB.count_and_get(

8391: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8392: FND_MESSAGE.Set_Token('TEXT', 'AMS_ListGeneration_PKG.create_list: END');
8393: FND_MSG_PUB.Add;
8394: --END IF;
8395: FND_MSG_PUB.count_and_get(
8396: p_encoded => FND_API.g_false,
8397: p_count => x_msg_count,
8398: p_data => x_msg_data
8399: );

Line 8405: FND_MSG_PUB.Add;

8401: EXCEPTION
8402: WHEN FND_API.G_EXC_ERROR THEN
8403: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8404: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
8405: FND_MSG_PUB.Add;
8406: -- Check if reset of the status is required
8407: x_return_status := FND_API.G_RET_STS_ERROR ;
8408: FND_MSG_PUB.count_and_get(
8409: p_encoded => FND_API.g_false,

Line 8408: FND_MSG_PUB.count_and_get(

8404: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
8405: FND_MSG_PUB.Add;
8406: -- Check if reset of the status is required
8407: x_return_status := FND_API.G_RET_STS_ERROR ;
8408: FND_MSG_PUB.count_and_get(
8409: p_encoded => FND_API.g_false,
8410: p_count => x_msg_count,
8411: p_data => x_msg_data);
8412:

Line 8416: FND_MSG_PUB.Add;

8412:
8413: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8414: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8415: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
8416: FND_MSG_PUB.Add;
8417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8418: FND_MSG_PUB.count_and_get(
8419: p_encoded => FND_API.g_false,
8420: p_count => x_msg_count,

Line 8418: FND_MSG_PUB.count_and_get(

8414: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8415: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
8416: FND_MSG_PUB.Add;
8417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8418: FND_MSG_PUB.count_and_get(
8419: p_encoded => FND_API.g_false,
8420: p_count => x_msg_count,
8421: p_data => x_msg_data);
8422:

Line 8426: FND_MSG_PUB.Add;

8422:
8423: WHEN OTHERS THEN
8424: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8425: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
8426: FND_MSG_PUB.Add;
8427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8428: FND_MSG_PUB.count_and_get(
8429: p_encoded => FND_API.g_false,
8430: p_count => x_msg_count,

Line 8428: FND_MSG_PUB.count_and_get(

8424: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8425: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
8426: FND_MSG_PUB.Add;
8427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8428: FND_MSG_PUB.count_and_get(
8429: p_encoded => FND_API.g_false,
8430: p_count => x_msg_count,
8431: p_data => x_msg_data);
8432: END CREATE_LIST_FROM_QUERY ;

Line 8476: FND_MSG_PUB.initialize;

8472:
8473:
8474: -- Initialize message list IF p_init_msg_list is set to TRUE.
8475: IF FND_API.to_Boolean( p_init_msg_list ) THEN
8476: FND_MSG_PUB.initialize;
8477: END IF;
8478:
8479: -- Debug Message
8480: IF (AMS_DEBUG_HIGH_ON) THEN

Line 8483: FND_MSG_PUB.Add;

8479: -- Debug Message
8480: IF (AMS_DEBUG_HIGH_ON) THEN
8481: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8482: FND_MESSAGE.Set_Token('TEXT', 'AMS_ListGeneration_PKG.cerate_list: Start', TRUE);
8483: FND_MSG_PUB.Add;
8484: END IF;
8485:
8486: -- Initialize API return status to success
8487: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

8558: END IF;
8559:
8560: -- Success Message
8561: -- MMSG
8562: --IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
8563: --THEN
8564: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
8565: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration_PKG.create_list: ');
8566: FND_MSG_PUB.Add;

Line 8566: FND_MSG_PUB.Add;

8562: --IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
8563: --THEN
8564: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
8565: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration_PKG.create_list: ');
8566: FND_MSG_PUB.Add;
8567: --END IF;
8568:
8569:
8570: --IF (AMS_DEBUG_HIGH_ON) THEN

Line 8574: FND_MSG_PUB.Add;

8570: --IF (AMS_DEBUG_HIGH_ON) THEN
8571: --THEN
8572: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8573: FND_MESSAGE.Set_Token('TEXT', 'AMS_ListGeneration_PKG.create_list: END');
8574: FND_MSG_PUB.Add;
8575: --END IF;
8576: FND_MSG_PUB.count_and_get(
8577: p_encoded => FND_API.g_false,
8578: p_count => x_msg_count,

Line 8576: FND_MSG_PUB.count_and_get(

8572: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8573: FND_MESSAGE.Set_Token('TEXT', 'AMS_ListGeneration_PKG.create_list: END');
8574: FND_MSG_PUB.Add;
8575: --END IF;
8576: FND_MSG_PUB.count_and_get(
8577: p_encoded => FND_API.g_false,
8578: p_count => x_msg_count,
8579: p_data => x_msg_data
8580: );

Line 8586: FND_MSG_PUB.Add;

8582: EXCEPTION
8583: WHEN FND_API.G_EXC_ERROR THEN
8584: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8585: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
8586: FND_MSG_PUB.Add;
8587: -- Check if reset of the status is required
8588: x_return_status := FND_API.G_RET_STS_ERROR ;
8589: FND_MSG_PUB.count_and_get(
8590: p_encoded => FND_API.g_false,

Line 8589: FND_MSG_PUB.count_and_get(

8585: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
8586: FND_MSG_PUB.Add;
8587: -- Check if reset of the status is required
8588: x_return_status := FND_API.G_RET_STS_ERROR ;
8589: FND_MSG_PUB.count_and_get(
8590: p_encoded => FND_API.g_false,
8591: p_count => x_msg_count,
8592: p_data => x_msg_data);
8593:

Line 8597: FND_MSG_PUB.Add;

8593:
8594: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8595: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8596: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
8597: FND_MSG_PUB.Add;
8598: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8599: FND_MSG_PUB.count_and_get(
8600: p_encoded => FND_API.g_false,
8601: p_count => x_msg_count,

Line 8599: FND_MSG_PUB.count_and_get(

8595: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8596: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
8597: FND_MSG_PUB.Add;
8598: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8599: FND_MSG_PUB.count_and_get(
8600: p_encoded => FND_API.g_false,
8601: p_count => x_msg_count,
8602: p_data => x_msg_data);
8603:

Line 8607: FND_MSG_PUB.Add;

8603:
8604: WHEN OTHERS THEN
8605: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8606: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
8607: FND_MSG_PUB.Add;
8608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8609: FND_MSG_PUB.count_and_get(
8610: p_encoded => FND_API.g_false,
8611: p_count => x_msg_count,

Line 8609: FND_MSG_PUB.count_and_get(

8605: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
8606: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
8607: FND_MSG_PUB.Add;
8608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8609: FND_MSG_PUB.count_and_get(
8610: p_encoded => FND_API.g_false,
8611: p_count => x_msg_count,
8612: p_data => x_msg_data);
8613: END CREATE_LIST_FROM_QUERY ;

Line 8777: FND_MSG_PUB.Add;

8773: EXIT WHEN c_action_dets%NOTFOUND;
8774:
8775: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
8776: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration : before IMMEDIATE');
8777: FND_MSG_PUB.Add;
8778: 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');
8779: 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');
8780: if l_action_dets_rec.list_act_type = 'SQL' then
8781: OPEN c_query( l_action_dets_rec.list_header_id );

Line 8910: FND_MSG_PUB.Add;

8906: end if;
8907:
8908: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
8909: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration : AFTER IMMEDIATE');
8910: FND_MSG_PUB.Add;
8911:
8912: if l_action_dets_rec.list_action_type = 'INCLUDE' then
8913: l_include_count := l_include_count +1 ;
8914: l_include_sql_tbl(l_include_count) := l_include_sql ;

Line 9353: FND_MSG_PUB.count_and_get(

9349: END IF;
9350: -- Check if reset of the status is required
9351: write_to_act_log('Error while executing procedure process_tar_actions '||sqlcode||' '||sqlerrm,'LIST',g_list_header_id,'HIGH');
9352: x_return_status := FND_API.G_RET_STS_ERROR ;
9353: FND_MSG_PUB.count_and_get(
9354: p_encoded => FND_API.g_false,
9355: p_count => x_msg_count,
9356: p_data => x_msg_data);
9357:

Line 9365: FND_MSG_PUB.Add;

9361: END IF;
9362: write_to_act_log('Error while executing procedure process_tar_actions '||sqlcode||' '||sqlerrm,'LIST',g_list_header_id,'HIGH');
9363: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
9364: FND_MESSAGE.Set_Token('ROW', sqlerrm||' '||sqlcode);
9365: FND_MSG_PUB.Add;
9366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9367: FND_MSG_PUB.count_and_get(
9368: p_encoded => FND_API.g_false,
9369: p_count => x_msg_count,

Line 9367: FND_MSG_PUB.count_and_get(

9363: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
9364: FND_MESSAGE.Set_Token('ROW', sqlerrm||' '||sqlcode);
9365: FND_MSG_PUB.Add;
9366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9367: FND_MSG_PUB.count_and_get(
9368: p_encoded => FND_API.g_false,
9369: p_count => x_msg_count,
9370: p_data => x_msg_data);
9371:

Line 9379: FND_MSG_PUB.Add;

9375: END IF;
9376: write_to_act_log('Error while executing procedure process_tar_actions '||sqlcode||' '||sqlerrm,'LIST',g_list_header_id,'HIGH');
9377: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
9378: FND_MESSAGE.Set_Token('ROW', sqlerrm||' '||sqlcode);
9379: FND_MSG_PUB.Add;
9380: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9381: FND_MSG_PUB.count_and_get(
9382: p_encoded => FND_API.g_false,
9383: p_count => x_msg_count,

Line 9381: FND_MSG_PUB.count_and_get(

9377: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
9378: FND_MESSAGE.Set_Token('ROW', sqlerrm||' '||sqlcode);
9379: FND_MSG_PUB.Add;
9380: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9381: FND_MSG_PUB.count_and_get(
9382: p_encoded => FND_API.g_false,
9383: p_count => x_msg_count,
9384: p_data => x_msg_data);
9385: END process_tar_actions;

Line 9644: FND_MSG_PUB.count_and_get(

9640: main_gen_end_time = sysdate,
9641: ctrl_status_code = 'DRAFT',
9642: no_of_rows_in_ctrl_group = null
9643: WHERE list_header_id = p_list_header_id;
9644: FND_MSG_PUB.count_and_get(
9645: p_encoded => FND_API.g_false,
9646: p_count => x_msg_count,
9647: p_data => x_msg_data
9648: );

Line 9752: FND_MSG_PUB.initialize;

9748: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9749: END IF;
9750:
9751: IF FND_API.to_Boolean( p_init_msg_list ) THEN
9752: FND_MSG_PUB.initialize;
9753: END IF;
9754:
9755: -- Checking if Debug is set. If debug is set then log debugging message
9756: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH)

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

9752: FND_MSG_PUB.initialize;
9753: END IF;
9754:
9755: -- Checking if Debug is set. If debug is set then log debugging message
9756: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH)
9757: THEN
9758: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
9759: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration : Start');
9760: FND_MSG_PUB.Add;

Line 9760: FND_MSG_PUB.Add;

9756: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH)
9757: THEN
9758: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
9759: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration : Start');
9760: FND_MSG_PUB.Add;
9761: END IF;
9762:
9763: -- Initialize API return status to success
9764: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

10259: END IF;
10260:
10261: -- Success Message
10262: -- MMSG
10263: --IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
10264: --THEN
10265: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
10266: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration_PKG.Generate_List');
10267: FND_MSG_PUB.Add;

Line 10267: FND_MSG_PUB.Add;

10263: --IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
10264: --THEN
10265: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
10266: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration_PKG.Generate_List');
10267: FND_MSG_PUB.Add;
10268: --END IF;
10269:
10270:
10271: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

10268: --END IF;
10269:
10270:
10271: x_return_status := FND_API.G_RET_STS_SUCCESS;
10272: --IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH)
10273: --THEN
10274: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
10275: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration_PKG.Generate_List: END');
10276: FND_MSG_PUB.Add;

Line 10276: FND_MSG_PUB.Add;

10272: --IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH)
10273: --THEN
10274: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
10275: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration_PKG.Generate_List: END');
10276: FND_MSG_PUB.Add;
10277: --END IF;
10278: FND_MSG_PUB.count_and_get(
10279: p_encoded => FND_API.g_false,
10280: p_count => x_msg_count,

Line 10278: FND_MSG_PUB.count_and_get(

10274: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
10275: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration_PKG.Generate_List: END');
10276: FND_MSG_PUB.Add;
10277: --END IF;
10278: FND_MSG_PUB.count_and_get(
10279: p_encoded => FND_API.g_false,
10280: p_count => x_msg_count,
10281: p_data => x_msg_data
10282: );

Line 10306: FND_MSG_PUB.count_and_get(

10302: --write_to_act_log('Error: AMS_ListGeneration_PKG.Generate_List: '||
10303: --l_error_position||sqlerrm||sqlcode);
10304: -- Check if reset of the status is required
10305: x_return_status := FND_API.G_RET_STS_ERROR ;
10306: FND_MSG_PUB.count_and_get(
10307: p_encoded => FND_API.g_false,
10308: p_count => x_msg_count,
10309: p_data => x_msg_data);
10310:

Line 10330: FND_MSG_PUB.Add;

10326: --write_to_act_log('Error: AMS_ListGeneration_PKG.Generate_List:'||
10327: --l_error_position||sqlerrm||sqlcode);
10328: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
10329: FND_MESSAGE.Set_Token('ROW', sqlerrm||' '||sqlcode);
10330: FND_MSG_PUB.Add;
10331: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10332: FND_MSG_PUB.count_and_get(
10333: p_encoded => FND_API.g_false,
10334: p_count => x_msg_count,

Line 10332: FND_MSG_PUB.count_and_get(

10328: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
10329: FND_MESSAGE.Set_Token('ROW', sqlerrm||' '||sqlcode);
10330: FND_MSG_PUB.Add;
10331: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10332: FND_MSG_PUB.count_and_get(
10333: p_encoded => FND_API.g_false,
10334: p_count => x_msg_count,
10335: p_data => x_msg_data);
10336:

Line 10358: FND_MSG_PUB.Add;

10354: --write_to_act_log('Error: AMS_ListGeneration_PKG.Generate_List:'||
10355: --l_error_position||sqlerrm||sqlcode);
10356: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
10357: FND_MESSAGE.Set_Token('ROW', sqlerrm||' '||sqlcode);
10358: FND_MSG_PUB.Add;
10359: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10360: FND_MSG_PUB.count_and_get(
10361: p_encoded => FND_API.g_false,
10362: p_count => x_msg_count,

Line 10360: FND_MSG_PUB.count_and_get(

10356: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
10357: FND_MESSAGE.Set_Token('ROW', sqlerrm||' '||sqlcode);
10358: FND_MSG_PUB.Add;
10359: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10360: FND_MSG_PUB.count_and_get(
10361: p_encoded => FND_API.g_false,
10362: p_count => x_msg_count,
10363: p_data => x_msg_data);
10364: END GENERATE_TARGET_GROUP;

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

10514: Write_To_Act_Log ('No more rules associated with the List','LIST',p_list_header_id ,'LOW');
10515: NULL;
10516: END IF;
10517:
10518: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
10519: THEN
10520: FND_MESSAGE.set_name('AMS', 'AMS_LIST_NO_LIST_RULE');
10521: FND_MSG_PUB.add;
10522: END IF;

Line 10521: FND_MSG_PUB.add;

10517:
10518: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
10519: THEN
10520: FND_MESSAGE.set_name('AMS', 'AMS_LIST_NO_LIST_RULE');
10521: FND_MSG_PUB.add;
10522: END IF;
10523:
10524: CLOSE c_list_rules;
10525: return;

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

10539: COMMIT;
10540: END IF;
10541: */
10542: Write_To_Act_Log ( 'More than one rule cannot be applied to the list','LIST',p_list_header_id ,'HIGH');
10543: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
10544: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ONLY_ONE_LIST_RULE');
10545: FND_MSG_PUB.add;
10546: END IF;
10547:

Line 10545: FND_MSG_PUB.add;

10541: */
10542: Write_To_Act_Log ( 'More than one rule cannot be applied to the list','LIST',p_list_header_id ,'HIGH');
10543: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
10544: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ONLY_ONE_LIST_RULE');
10545: FND_MSG_PUB.add;
10546: END IF;
10547:
10548: CLOSE c_list_rules;
10549: RETURN;

Line 11801: FND_MSG_PUB.Add;

11797: argument1 => p_action_used_by_id);
11798: commit;
11799: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
11800: FND_MESSAGE.Set_Token('TEXT', 'request_id->'||l_request_id || '<-');
11801: FND_MSG_PUB.Add;
11802: -- FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
11803: -- FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
11804: -- FND_MSG_PUB.Add;
11805: FND_MSG_PUB.count_and_get(

Line 11804: -- FND_MSG_PUB.Add;

11800: FND_MESSAGE.Set_Token('TEXT', 'request_id->'||l_request_id || '<-');
11801: FND_MSG_PUB.Add;
11802: -- FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
11803: -- FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
11804: -- FND_MSG_PUB.Add;
11805: FND_MSG_PUB.count_and_get(
11806: p_encoded => FND_API.g_false,
11807: p_count => x_msg_count,
11808: p_data => x_msg_data );

Line 11805: FND_MSG_PUB.count_and_get(

11801: FND_MSG_PUB.Add;
11802: -- FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
11803: -- FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
11804: -- FND_MSG_PUB.Add;
11805: FND_MSG_PUB.count_and_get(
11806: p_encoded => FND_API.g_false,
11807: p_count => x_msg_count,
11808: p_data => x_msg_data );
11809: x_return_status := 'S';

Line 11818: FND_MSG_PUB.Add;

11814:
11815:
11816: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
11817: FND_MESSAGE.Set_Token('TEXT', 'Error '|| sqlerrm||' '||sqlcode);
11818: FND_MSG_PUB.Add;
11819: FND_MSG_PUB.count_and_get(
11820: p_encoded => FND_API.g_false,
11821: p_count => x_msg_count,
11822: p_data => x_msg_data

Line 11819: FND_MSG_PUB.count_and_get(

11815:
11816: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
11817: FND_MESSAGE.Set_Token('TEXT', 'Error '|| sqlerrm||' '||sqlcode);
11818: FND_MSG_PUB.Add;
11819: FND_MSG_PUB.count_and_get(
11820: p_encoded => FND_API.g_false,
11821: p_count => x_msg_count,
11822: p_data => x_msg_data
11823: );

Line 11944: FND_MSG_PUB.Add;

11940: IF (p_action_rec.list_action_type <> 'INCLUDE')then
11941: write_to_act_log('Error. The action type of the first selection is NOT INCLUDE.', 'LIST', g_list_header_id,'HIGH');
11942: Ams_Utility_Pvt.Write_Conc_log('process list actions : first action INCLUDE check failed');
11943: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ACT_FIRST_INCLUDE');
11944: FND_MSG_PUB.Add;
11945: RAISE FND_API.G_EXC_ERROR;
11946: END IF; -- End of if for list_action_type check
11947: END IF; --End of Validation:- First Action Include Check
11948:

Line 12123: FND_MSG_PUB.count_and_get(

12119: CLOSE c_action_dets;
12120: END IF;
12121: -- Check if reset of the status is required
12122: x_return_status := FND_API.G_RET_STS_ERROR ;
12123: FND_MSG_PUB.count_and_get(
12124: p_encoded => FND_API.g_false,
12125: p_count => x_msg_count,
12126: p_data => x_msg_data);
12127:

Line 12138: FND_MSG_PUB.Add;

12134: write_to_act_log('Error: AMS_ListGeneration_PKG.Process_list_actions:'
12135: ||sqlerrm||sqlcode, 'LIST', g_list_header_id);
12136: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
12137: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
12138: FND_MSG_PUB.Add;
12139: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
12140: FND_MSG_PUB.count_and_get(
12141: p_encoded => FND_API.g_false,
12142: p_count => x_msg_count,

Line 12140: FND_MSG_PUB.count_and_get(

12136: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
12137: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
12138: FND_MSG_PUB.Add;
12139: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
12140: FND_MSG_PUB.count_and_get(
12141: p_encoded => FND_API.g_false,
12142: p_count => x_msg_count,
12143: p_data => x_msg_data);
12144:

Line 12155: FND_MSG_PUB.Add;

12151: write_to_act_log('Error: AMS_ListGeneration_PKG.Process_list_actions:'
12152: ||sqlerrm||sqlcode, 'LIST', g_list_header_id,'HIGH');
12153: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
12154: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
12155: FND_MSG_PUB.Add;
12156: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
12157: FND_MSG_PUB.count_and_get(
12158: p_encoded => FND_API.g_false,
12159: p_count => x_msg_count,

Line 12157: FND_MSG_PUB.count_and_get(

12153: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
12154: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
12155: FND_MSG_PUB.Add;
12156: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
12157: FND_MSG_PUB.count_and_get(
12158: p_encoded => FND_API.g_false,
12159: p_count => x_msg_count,
12160: p_data => x_msg_data);
12161: END calc_running_total;

Line 12519: FND_MSG_PUB.Add;

12515: -- write_to_act_log('Process_rt_all_sql l_found : '||l_found,'LIST', g_list_header_id);
12516: -- write_to_act_log('Process_rt_all_sql return status: After validate_sql_string call ','LIST', g_list_header_id);
12517: if l_found = 'N' then
12518: FND_MESSAGE.set_name('AMS', 'AMS_LIST_FROM_NOT_FOUND');
12519: FND_MSG_PUB.Add;
12520: RAISE FND_API.G_EXC_ERROR;
12521: end if;
12522: /* write_to_act_log('Process_rt_all_sql: FROM Position ->'|| l_from_position ||
12523: '<--FROM Counter ->' || l_from_counter ||

Line 12539: FND_MSG_PUB.Add;

12535: x_source_object_pk_field => l_source_object_pk_field);
12536:
12537: if l_found = 'N' then
12538: FND_MESSAGE.set_name('AMS', 'AMS_LIST_NO_MASTER_TYPE');
12539: FND_MSG_PUB.Add;
12540: RAISE FND_API.G_EXC_ERROR;
12541: end if;
12542: write_to_act_log('Master type is '|| l_master_type ||'<--' , 'LIST', g_list_header_id,'LOW');
12543:

Line 12589: FND_MSG_PUB.count_and_get(

12585: EXCEPTION
12586: WHEN FND_API.G_EXC_ERROR THEN
12587: write_to_act_log('Error when executing procedure process_rt_all_sql '||sqlcode||' '||sqlerrm, 'LIST', g_list_header_id,'HIGH');
12588: x_return_status := FND_API.G_RET_STS_ERROR ;
12589: FND_MSG_PUB.count_and_get(
12590: p_encoded => FND_API.g_false,
12591: p_count => x_msg_count,
12592: p_data => x_msg_data
12593: );

Line 12598: FND_MSG_PUB.count_and_get(

12594:
12595: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
12596: write_to_act_log('Error when executing procedure process_rt_all_sql '||sqlcode||' '||sqlerrm, 'LIST', g_list_header_id,'HIGH');
12597: x_return_status := FND_API.G_RET_STS_ERROR ;
12598: FND_MSG_PUB.count_and_get(
12599: p_encoded => FND_API.g_false,
12600: p_count => x_msg_count,
12601: p_data => x_msg_data
12602: );

Line 12607: FND_MSG_PUB.count_and_get(

12603:
12604: WHEN OTHERS THEN
12605: write_to_act_log('Error when executing procedure process_rt_all_sql '||sqlcode||' '||sqlerrm, 'LIST', g_list_header_id,'HIGH');
12606: x_return_status := FND_API.G_RET_STS_ERROR ;
12607: FND_MSG_PUB.count_and_get(
12608: p_encoded => FND_API.g_false,
12609: p_count => x_msg_count,
12610: p_data => x_msg_data
12611: );

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

13690: -- write_to_act_log('Party id is '||l_party_id, 'LIST', p_list_header_id,'LOW');
13691: if x_msg_count > 0 then
13692: FOR i IN 1..x_msg_count LOOP
13693: -- Following code was modified by bmuthukr
13694: --x_tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
13695: --x_tmp_var1 := substrb(x_tmp_var1 || ' '|| x_tmp_var,1,4000);
13696: x_tmp_var := 'Please make sure that the required fields (eg. person first name, last name) are available in the remote database';
13697: write_to_act_log('Updating the tca_load_status as ERROR', 'LIST', p_list_header_id,'HIGH');
13698:

Line 13758: FND_MSG_PUB.count_and_get(

13754: if l_prof <> 'N' then
13755: fnd_profile.put('HZ_EXECUTE_API_CALLOUTS',l_prof);
13756: end if;
13757:
13758: FND_MSG_PUB.count_and_get(
13759: p_encoded => FND_API.g_false,
13760: p_count => x_msg_count,
13761: p_data => x_msg_data
13762: );

Line 13774: FND_MSG_PUB.count_and_get(

13770: if l_prof <> 'N' then
13771: fnd_profile.put('HZ_EXECUTE_API_CALLOUTS',l_prof);
13772: end if;
13773:
13774: FND_MSG_PUB.count_and_get(
13775: p_encoded => FND_API.g_false,
13776: p_count => x_msg_count,
13777: p_data => x_msg_data
13778: );

Line 13788: FND_MSG_PUB.count_and_get(

13784: if l_prof <> 'N' then
13785: fnd_profile.put('HZ_EXECUTE_API_CALLOUTS',l_prof);
13786: end if;
13787:
13788: FND_MSG_PUB.count_and_get(
13789: p_encoded => FND_API.g_false,
13790: p_count => x_msg_count,
13791: p_data => x_msg_data
13792: );

Line 13868: FND_MSG_PUB.count_and_get(

13864: write_to_act_log('Error while executing procedure remote_list_gen '||sqlcode||' '||sqlerrm, 'LIST', g_list_header_id,'HIGH');
13865: x_return_status := FND_API.G_RET_STS_ERROR ;
13866: x_msg_data := 'Error while executing procedure remote_list_gen '||sqlcode||' '||sqlerrm;
13867: x_msg_count := 1;
13868: FND_MSG_PUB.count_and_get(
13869: p_encoded => FND_API.g_false,
13870: p_count => x_msg_count,
13871: p_data => x_msg_data
13872: );