APPS.CSI_WEB_SERVICE_PKG dependencies on CSI_GEN_UTILITY_PVT

Line 45: csi_gen_utility_pvt.put_line('Incompatible API call');

41: IF NOT FND_API.Compatible_API_Call(l_api_version,
42: p_api_version,
43: l_api_name,
44: G_PKG_NAME) THEN
45: csi_gen_utility_pvt.put_line('Incompatible API call');
46: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
47: END IF;
48:
49: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 59: csi_gen_utility_pvt.put_line('CSI_WEB_SERVICE_PKG.get_item_instance_obj');

55: l_debug_level := fnd_profile.value('CSI_DEBUG_LEVEL');
56:
57: -- If debug_level = 1 then dump the procedure name
58: IF (l_debug_level > 0) THEN
59: csi_gen_utility_pvt.put_line('CSI_WEB_SERVICE_PKG.get_item_instance_obj');
60: END IF;
61:
62: -- If the debug level = 2 then dump all the parameters values.
63: IF (l_debug_level > 1) THEN

Line 64: csi_gen_utility_pvt.put_line('get_item_instance_obj ' ||

60: END IF;
61:
62: -- If the debug level = 2 then dump all the parameters values.
63: IF (l_debug_level > 1) THEN
64: csi_gen_utility_pvt.put_line('get_item_instance_obj ' ||
65: p_api_version ||'-'||
66: p_commit ||'-'||
67: p_init_msg_list ||'-'||
68: p_validation_level );

Line 69: csi_gen_utility_pvt.put_line(' Instance Id : '||p_instance_id);

65: p_api_version ||'-'||
66: p_commit ||'-'||
67: p_init_msg_list ||'-'||
68: p_validation_level );
69: csi_gen_utility_pvt.put_line(' Instance Id : '||p_instance_id);
70: csi_gen_utility_pvt.put_line(' Instance Number : '||p_instance_number);
71: END IF;
72:
73: -- Initialize API return status to success

Line 70: csi_gen_utility_pvt.put_line(' Instance Number : '||p_instance_number);

66: p_commit ||'-'||
67: p_init_msg_list ||'-'||
68: p_validation_level );
69: csi_gen_utility_pvt.put_line(' Instance Id : '||p_instance_id);
70: csi_gen_utility_pvt.put_line(' Instance Number : '||p_instance_number);
71: END IF;
72:
73: -- Initialize API return status to success
74: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 87: csi_gen_utility_pvt.put_line(' ERROR-CSI_CANT_GET_ITEM_INSTANCE: '

83: AND csi.instance_number = p_instance_number;
84: EXCEPTION
85: WHEN NO_DATA_FOUND THEN
86: IF (l_debug_level > 1) THEN
87: csi_gen_utility_pvt.put_line(' ERROR-CSI_CANT_GET_ITEM_INSTANCE: '
88: ||'No item found with instance id '||p_instance_id
89: ||' and instance number '||p_instance_number);
90: END IF;
91: FND_MESSAGE.SET_NAME('CSI','CSI_CANT_GET_ITEM_INSTANCE');

Line 98: csi_gen_utility_pvt.put_line(' ERROR-CSI_CANT_GET_ITEM_INSTANCE: '

94: FND_MSG_PUB.Add;
95: RAISE FND_API.G_EXC_ERROR;
96: WHEN OTHERS THEN
97: IF (l_debug_level > 1) THEN
98: csi_gen_utility_pvt.put_line(' ERROR-CSI_CANT_GET_ITEM_INSTANCE: '
99: ||SQLERRM);
100: END IF;
101: FND_MESSAGE.SET_NAME('CSI','CSI_CANT_GET_ITEM_INSTANCE');
102: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

Line 118: csi_gen_utility_pvt.put_line(' ERROR-CSI_CANT_GET_ITEM_INSTANCE: '

114: WHERE csi.instance_number = p_instance_number;
115: EXCEPTION
116: WHEN NO_DATA_FOUND THEN
117: IF (l_debug_level > 1) THEN
118: csi_gen_utility_pvt.put_line(' ERROR-CSI_CANT_GET_ITEM_INSTANCE: '
119: ||'No item found with instance number '||p_instance_number);
120: END IF;
121: FND_MESSAGE.SET_NAME('CSI','CSI_CANT_GET_ITEM_INSTANCE');
122: FND_MESSAGE.SET_TOKEN('ERROR','No item found with instance number '

Line 128: csi_gen_utility_pvt.put_line(' ERROR-CSI_CANT_GET_ITEM_INSTANCE: '

124: FND_MSG_PUB.Add;
125: RAISE FND_API.G_EXC_ERROR;
126: WHEN OTHERS THEN
127: IF (l_debug_level > 1) THEN
128: csi_gen_utility_pvt.put_line(' ERROR-CSI_CANT_GET_ITEM_INSTANCE: '
129: ||SQLERRM);
130: END IF;
131: FND_MESSAGE.SET_NAME('CSI','CSI_CANT_GET_ITEM_INSTANCE');
132: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

Line 138: csi_gen_utility_pvt.put_line(' ERROR-CSI_CANT_GET_ITEM_INSTANCE: '

134: RAISE FND_API.G_EXC_ERROR;
135: END;
136: ELSE
137: IF (l_debug_level > 1) THEN
138: csi_gen_utility_pvt.put_line(' ERROR-CSI_CANT_GET_ITEM_INSTANCE: '
139: ||'Must specify at least instance id or instance number');
140: END IF;
141: FND_MESSAGE.SET_NAME('CSI','CSI_CANT_GET_ITEM_INSTANCE');
142: FND_MESSAGE.SET_TOKEN('ERROR','Must specify at least instance id or instance number');