APPS.POA_BIS_ALERTS dependencies on FND_API

Line 241: p_value := FND_API.G_MISS_CHAR;

237: END IF;
238: END LOOP;
239:
240: p_index := to_number(NULL);
241: p_value := FND_API.G_MISS_CHAR;
242:
243: EXCEPTION
244: WHEN others THEN
245: POA_LOG.put_line('Error in get_value procedure:');

Line 736: 'p_commit='|| FND_API.g_true ||' ' ||

732: 'target_level_name='||l_actual_rec.target_level_name ||' ' ||
733: 'target_level_shortname='||l_actual_rec.Target_Level_Short_Name ||' ' ||
734: 'org_level_id='||l_actual_rec.Org_Level_value_ID ||' ' ||
735: 'time_level_id='||l_actual_rec.time_Level_value_ID ||' ' ||
736: 'p_commit='|| FND_API.g_true ||' ' ||
737: 'x_return_status='|| l_return_status ||' ' ||
738: 'x_msg_count='|| l_msg_count
739: );
740:

Line 743: p_commit => FND_API.G_TRUE,

739: );
740:
741: BIS_ACTUAL_PUB.Post_Actual(p_api_version => 1.0,
742: p_Actual_Rec => l_actual_rec,
743: p_commit => FND_API.G_TRUE,
744: x_return_status => l_return_status,
745: x_msg_count => l_msg_count,
746: x_msg_data => l_msg_data,
747: x_error_tbl => l_error_tbl);

Line 859: IF (l_target_rec.range1_low <> FND_API.g_miss_num AND

855: l_actual := TO_NUMBER(l_value);
856:
857: POA_LOG.debug_line('Actual: ' || l_actual);
858:
859: IF (l_target_rec.range1_low <> FND_API.g_miss_num AND
860: l_target_rec.range1_high <> FND_API.g_miss_num) THEN
861: l_range_low := l_target_rec.target*(1-l_target_rec.range1_low/100);
862: l_range_high := l_target_rec.target*(1+l_target_rec.range1_high/100);
863:

Line 860: l_target_rec.range1_high <> FND_API.g_miss_num) THEN

856:
857: POA_LOG.debug_line('Actual: ' || l_actual);
858:
859: IF (l_target_rec.range1_low <> FND_API.g_miss_num AND
860: l_target_rec.range1_high <> FND_API.g_miss_num) THEN
861: l_range_low := l_target_rec.target*(1-l_target_rec.range1_low/100);
862: l_range_high := l_target_rec.target*(1+l_target_rec.range1_high/100);
863:
864: IF (l_actual NOT BETWEEN l_range_low AND l_range_high) THEN

Line 908: IF (l_target_rec.range2_low <> FND_API.g_miss_num AND

904: END IF;
905:
906: END IF;
907:
908: IF (l_target_rec.range2_low <> FND_API.g_miss_num AND
909: l_target_rec.range2_high <> FND_API.g_miss_num) THEN
910: l_range_low := l_target_rec.target*(1-l_target_rec.range2_low/100);
911: l_range_high := l_target_rec.target*(1+l_target_rec.range2_high/100);
912:

Line 909: l_target_rec.range2_high <> FND_API.g_miss_num) THEN

905:
906: END IF;
907:
908: IF (l_target_rec.range2_low <> FND_API.g_miss_num AND
909: l_target_rec.range2_high <> FND_API.g_miss_num) THEN
910: l_range_low := l_target_rec.target*(1-l_target_rec.range2_low/100);
911: l_range_high := l_target_rec.target*(1+l_target_rec.range2_high/100);
912:
913: IF (l_actual NOT BETWEEN l_range_low AND l_range_high) THEN

Line 934: IF (l_target_rec.range3_low <> FND_API.g_miss_num AND

930: END IF;
931:
932: END IF;
933:
934: IF (l_target_rec.range3_low <> FND_API.g_miss_num AND
935: l_target_rec.range3_high <> FND_API.g_miss_num) THEN
936: l_range_low := l_target_rec.target*(1-l_target_rec.range3_low/100);
937: l_range_high := l_target_rec.target*(1+l_target_rec.range3_high/100);
938:

Line 935: l_target_rec.range3_high <> FND_API.g_miss_num) THEN

931:
932: END IF;
933:
934: IF (l_target_rec.range3_low <> FND_API.g_miss_num AND
935: l_target_rec.range3_high <> FND_API.g_miss_num) THEN
936: l_range_low := l_target_rec.target*(1-l_target_rec.range3_low/100);
937: l_range_high := l_target_rec.target*(1+l_target_rec.range3_high/100);
938:
939: IF (l_actual NOT BETWEEN l_range_low AND l_range_high) THEN

Line 1032: x_return_status := FND_API.G_RET_STS_SUCCESS;

1028: WHERE name = p_role;
1029: BEGIN
1030: POA_LOG.debug_line('Starting Workflow Notification');
1031:
1032: x_return_status := FND_API.G_RET_STS_SUCCESS;
1033: IF p_wf_process is NULL or p_role is NULL THEN
1034: x_return_status := FND_API.G_RET_STS_ERROR;
1035: return;
1036: END IF;

Line 1034: x_return_status := FND_API.G_RET_STS_ERROR;

1030: POA_LOG.debug_line('Starting Workflow Notification');
1031:
1032: x_return_status := FND_API.G_RET_STS_SUCCESS;
1033: IF p_wf_process is NULL or p_role is NULL THEN
1034: x_return_status := FND_API.G_RET_STS_ERROR;
1035: return;
1036: END IF;
1037:
1038: OPEN c_role_name;

Line 1042: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1038: OPEN c_role_name;
1039: FETCH c_role_name INTO l_role_name;
1040:
1041: IF C_ROLE_NAME%NOTFOUND THEN
1042: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1043: return;
1044: END IF;
1045:
1046: POA_LOG.debug_line('Notifying: ' || l_role_name);