223: FND_MSG_PUB.Count_And_Get(
224: p_encoded => FND_API.G_FALSE,
225: p_count => x_msg_count,
226: p_data => x_msg_data);
227: /* comment out arp_util.debug for fixing bug 3655764
228: arp_util.debug('x_msg_count ' || to_char(x_msg_count));
229: arp_util.debug('x_msg_data '|| x_msg_data);
230: arp_util.debug('EXC');
231: arp_util.debug('error code : '|| to_char(SQLCODE));
224: p_encoded => FND_API.G_FALSE,
225: p_count => x_msg_count,
226: p_data => x_msg_data);
227: /* comment out arp_util.debug for fixing bug 3655764
228: arp_util.debug('x_msg_count ' || to_char(x_msg_count));
229: arp_util.debug('x_msg_data '|| x_msg_data);
230: arp_util.debug('EXC');
231: arp_util.debug('error code : '|| to_char(SQLCODE));
232: arp_util.debug('error text : '|| SQLERRM); */
225: p_count => x_msg_count,
226: p_data => x_msg_data);
227: /* comment out arp_util.debug for fixing bug 3655764
228: arp_util.debug('x_msg_count ' || to_char(x_msg_count));
229: arp_util.debug('x_msg_data '|| x_msg_data);
230: arp_util.debug('EXC');
231: arp_util.debug('error code : '|| to_char(SQLCODE));
232: arp_util.debug('error text : '|| SQLERRM); */
233: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
226: p_data => x_msg_data);
227: /* comment out arp_util.debug for fixing bug 3655764
228: arp_util.debug('x_msg_count ' || to_char(x_msg_count));
229: arp_util.debug('x_msg_data '|| x_msg_data);
230: arp_util.debug('EXC');
231: arp_util.debug('error code : '|| to_char(SQLCODE));
232: arp_util.debug('error text : '|| SQLERRM); */
233: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
227: /* comment out arp_util.debug for fixing bug 3655764
228: arp_util.debug('x_msg_count ' || to_char(x_msg_count));
229: arp_util.debug('x_msg_data '|| x_msg_data);
230: arp_util.debug('EXC');
231: arp_util.debug('error code : '|| to_char(SQLCODE));
232: arp_util.debug('error text : '|| SQLERRM); */
233: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
235: FND_MSG_PUB.Count_And_Get(
228: arp_util.debug('x_msg_count ' || to_char(x_msg_count));
229: arp_util.debug('x_msg_data '|| x_msg_data);
230: arp_util.debug('EXC');
231: arp_util.debug('error code : '|| to_char(SQLCODE));
232: arp_util.debug('error text : '|| SQLERRM); */
233: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
235: FND_MSG_PUB.Count_And_Get(
236: p_encoded => FND_API.G_FALSE,
235: FND_MSG_PUB.Count_And_Get(
236: p_encoded => FND_API.G_FALSE,
237: p_count => x_msg_count,
238: p_data => x_msg_data);
239: /* comment out arp_util.debug for fixing bug 3655764
240: arp_util.debug('x_msg_count ' || to_char(x_msg_count));
241: arp_util.debug('x_msg_data '|| x_msg_data);
242: arp_util.debug('UNEXC'); */
243: WHEN OTHERS THEN
236: p_encoded => FND_API.G_FALSE,
237: p_count => x_msg_count,
238: p_data => x_msg_data);
239: /* comment out arp_util.debug for fixing bug 3655764
240: arp_util.debug('x_msg_count ' || to_char(x_msg_count));
241: arp_util.debug('x_msg_data '|| x_msg_data);
242: arp_util.debug('UNEXC'); */
243: WHEN OTHERS THEN
244: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
237: p_count => x_msg_count,
238: p_data => x_msg_data);
239: /* comment out arp_util.debug for fixing bug 3655764
240: arp_util.debug('x_msg_count ' || to_char(x_msg_count));
241: arp_util.debug('x_msg_data '|| x_msg_data);
242: arp_util.debug('UNEXC'); */
243: WHEN OTHERS THEN
244: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
245: FND_MSG_PUB.Count_And_Get(
238: p_data => x_msg_data);
239: /* comment out arp_util.debug for fixing bug 3655764
240: arp_util.debug('x_msg_count ' || to_char(x_msg_count));
241: arp_util.debug('x_msg_data '|| x_msg_data);
242: arp_util.debug('UNEXC'); */
243: WHEN OTHERS THEN
244: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
245: FND_MSG_PUB.Count_And_Get(
246: p_encoded => FND_API.G_FALSE,
245: FND_MSG_PUB.Count_And_Get(
246: p_encoded => FND_API.G_FALSE,
247: p_count => x_msg_count,
248: p_data => x_msg_data);
249: /* comment out arp_util.debug for fixing bug 3655764
250: arp_util.debug('x_msg_count ' || to_char(x_msg_count));
251: arp_util.debug('x_msg_count ' || to_char(x_msg_count));
252: arp_util.debug('x_msg_data '|| x_msg_data);
253: arp_util.debug('OTHERS');
246: p_encoded => FND_API.G_FALSE,
247: p_count => x_msg_count,
248: p_data => x_msg_data);
249: /* comment out arp_util.debug for fixing bug 3655764
250: arp_util.debug('x_msg_count ' || to_char(x_msg_count));
251: arp_util.debug('x_msg_count ' || to_char(x_msg_count));
252: arp_util.debug('x_msg_data '|| x_msg_data);
253: arp_util.debug('OTHERS');
254: arp_util.debug('error code : '|| to_char(SQLCODE));
247: p_count => x_msg_count,
248: p_data => x_msg_data);
249: /* comment out arp_util.debug for fixing bug 3655764
250: arp_util.debug('x_msg_count ' || to_char(x_msg_count));
251: arp_util.debug('x_msg_count ' || to_char(x_msg_count));
252: arp_util.debug('x_msg_data '|| x_msg_data);
253: arp_util.debug('OTHERS');
254: arp_util.debug('error code : '|| to_char(SQLCODE));
255: arp_util.debug('error text : '|| SQLERRM); */
248: p_data => x_msg_data);
249: /* comment out arp_util.debug for fixing bug 3655764
250: arp_util.debug('x_msg_count ' || to_char(x_msg_count));
251: arp_util.debug('x_msg_count ' || to_char(x_msg_count));
252: arp_util.debug('x_msg_data '|| x_msg_data);
253: arp_util.debug('OTHERS');
254: arp_util.debug('error code : '|| to_char(SQLCODE));
255: arp_util.debug('error text : '|| SQLERRM); */
256: END Get_Timezone_ID;
249: /* comment out arp_util.debug for fixing bug 3655764
250: arp_util.debug('x_msg_count ' || to_char(x_msg_count));
251: arp_util.debug('x_msg_count ' || to_char(x_msg_count));
252: arp_util.debug('x_msg_data '|| x_msg_data);
253: arp_util.debug('OTHERS');
254: arp_util.debug('error code : '|| to_char(SQLCODE));
255: arp_util.debug('error text : '|| SQLERRM); */
256: END Get_Timezone_ID;
257:
250: arp_util.debug('x_msg_count ' || to_char(x_msg_count));
251: arp_util.debug('x_msg_count ' || to_char(x_msg_count));
252: arp_util.debug('x_msg_data '|| x_msg_data);
253: arp_util.debug('OTHERS');
254: arp_util.debug('error code : '|| to_char(SQLCODE));
255: arp_util.debug('error text : '|| SQLERRM); */
256: END Get_Timezone_ID;
257:
258: /*===========================================================================+
251: arp_util.debug('x_msg_count ' || to_char(x_msg_count));
252: arp_util.debug('x_msg_data '|| x_msg_data);
253: arp_util.debug('OTHERS');
254: arp_util.debug('error code : '|| to_char(SQLCODE));
255: arp_util.debug('error text : '|| SQLERRM); */
256: END Get_Timezone_ID;
257:
258: /*===========================================================================+
259: | PROCEDURE |
616: FND_MSG_PUB.Count_And_Get(
617: p_encoded => FND_API.G_FALSE,
618: p_count => x_msg_count,
619: p_data => x_msg_data);
620: arp_util.debug('x_msg_count ' || to_char(x_msg_count));
621: arp_util.debug('x_msg_data '|| x_msg_data);
622: arp_util.debug('EXC');
623: arp_util.debug('error code : '|| to_char(SQLCODE));
624: arp_util.debug('error text : '|| SQLERRM);
617: p_encoded => FND_API.G_FALSE,
618: p_count => x_msg_count,
619: p_data => x_msg_data);
620: arp_util.debug('x_msg_count ' || to_char(x_msg_count));
621: arp_util.debug('x_msg_data '|| x_msg_data);
622: arp_util.debug('EXC');
623: arp_util.debug('error code : '|| to_char(SQLCODE));
624: arp_util.debug('error text : '|| SQLERRM);
625: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
618: p_count => x_msg_count,
619: p_data => x_msg_data);
620: arp_util.debug('x_msg_count ' || to_char(x_msg_count));
621: arp_util.debug('x_msg_data '|| x_msg_data);
622: arp_util.debug('EXC');
623: arp_util.debug('error code : '|| to_char(SQLCODE));
624: arp_util.debug('error text : '|| SQLERRM);
625: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
626: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
619: p_data => x_msg_data);
620: arp_util.debug('x_msg_count ' || to_char(x_msg_count));
621: arp_util.debug('x_msg_data '|| x_msg_data);
622: arp_util.debug('EXC');
623: arp_util.debug('error code : '|| to_char(SQLCODE));
624: arp_util.debug('error text : '|| SQLERRM);
625: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
626: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
627: FND_MSG_PUB.Count_And_Get(
620: arp_util.debug('x_msg_count ' || to_char(x_msg_count));
621: arp_util.debug('x_msg_data '|| x_msg_data);
622: arp_util.debug('EXC');
623: arp_util.debug('error code : '|| to_char(SQLCODE));
624: arp_util.debug('error text : '|| SQLERRM);
625: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
626: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
627: FND_MSG_PUB.Count_And_Get(
628: p_encoded => FND_API.G_FALSE,
627: FND_MSG_PUB.Count_And_Get(
628: p_encoded => FND_API.G_FALSE,
629: p_count => x_msg_count,
630: p_data => x_msg_data);
631: arp_util.debug('x_msg_count ' || to_char(x_msg_count));
632: arp_util.debug('x_msg_data '|| x_msg_data);
633: arp_util.debug('UNEXC');
634: WHEN OTHERS THEN
635: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
628: p_encoded => FND_API.G_FALSE,
629: p_count => x_msg_count,
630: p_data => x_msg_data);
631: arp_util.debug('x_msg_count ' || to_char(x_msg_count));
632: arp_util.debug('x_msg_data '|| x_msg_data);
633: arp_util.debug('UNEXC');
634: WHEN OTHERS THEN
635: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
636: FND_MSG_PUB.Count_And_Get(
629: p_count => x_msg_count,
630: p_data => x_msg_data);
631: arp_util.debug('x_msg_count ' || to_char(x_msg_count));
632: arp_util.debug('x_msg_data '|| x_msg_data);
633: arp_util.debug('UNEXC');
634: WHEN OTHERS THEN
635: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
636: FND_MSG_PUB.Count_And_Get(
637: p_encoded => FND_API.G_FALSE,
636: FND_MSG_PUB.Count_And_Get(
637: p_encoded => FND_API.G_FALSE,
638: p_count => x_msg_count,
639: p_data => x_msg_data);
640: arp_util.debug('x_msg_count ' || to_char(x_msg_count));
641: arp_util.debug('x_msg_data '|| x_msg_data);
642: arp_util.debug('OTHERS');
643: arp_util.debug('error code : '|| to_char(SQLCODE));
644: arp_util.debug('error text : '|| SQLERRM);
637: p_encoded => FND_API.G_FALSE,
638: p_count => x_msg_count,
639: p_data => x_msg_data);
640: arp_util.debug('x_msg_count ' || to_char(x_msg_count));
641: arp_util.debug('x_msg_data '|| x_msg_data);
642: arp_util.debug('OTHERS');
643: arp_util.debug('error code : '|| to_char(SQLCODE));
644: arp_util.debug('error text : '|| SQLERRM);
645: END Get_Timezone_GMT_Deviation;
638: p_count => x_msg_count,
639: p_data => x_msg_data);
640: arp_util.debug('x_msg_count ' || to_char(x_msg_count));
641: arp_util.debug('x_msg_data '|| x_msg_data);
642: arp_util.debug('OTHERS');
643: arp_util.debug('error code : '|| to_char(SQLCODE));
644: arp_util.debug('error text : '|| SQLERRM);
645: END Get_Timezone_GMT_Deviation;
646:
639: p_data => x_msg_data);
640: arp_util.debug('x_msg_count ' || to_char(x_msg_count));
641: arp_util.debug('x_msg_data '|| x_msg_data);
642: arp_util.debug('OTHERS');
643: arp_util.debug('error code : '|| to_char(SQLCODE));
644: arp_util.debug('error text : '|| SQLERRM);
645: END Get_Timezone_GMT_Deviation;
646:
647: /*===========================================================================+
640: arp_util.debug('x_msg_count ' || to_char(x_msg_count));
641: arp_util.debug('x_msg_data '|| x_msg_data);
642: arp_util.debug('OTHERS');
643: arp_util.debug('error code : '|| to_char(SQLCODE));
644: arp_util.debug('error text : '|| SQLERRM);
645: END Get_Timezone_GMT_Deviation;
646:
647: /*===========================================================================+
648: | FUNCTION |
1105: FND_MSG_PUB.Count_And_Get(
1106: p_encoded => FND_API.G_FALSE,
1107: p_count => x_msg_count,
1108: p_data => x_msg_data);
1109: arp_util.debug('x_msg_count ' || to_char(x_msg_count));
1110: arp_util.debug('x_msg_data '|| x_msg_data);
1111: arp_util.debug('EXC');
1112: arp_util.debug('error code : '|| to_char(SQLCODE));
1113: arp_util.debug('error text : '|| SQLERRM);
1106: p_encoded => FND_API.G_FALSE,
1107: p_count => x_msg_count,
1108: p_data => x_msg_data);
1109: arp_util.debug('x_msg_count ' || to_char(x_msg_count));
1110: arp_util.debug('x_msg_data '|| x_msg_data);
1111: arp_util.debug('EXC');
1112: arp_util.debug('error code : '|| to_char(SQLCODE));
1113: arp_util.debug('error text : '|| SQLERRM);
1114: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1107: p_count => x_msg_count,
1108: p_data => x_msg_data);
1109: arp_util.debug('x_msg_count ' || to_char(x_msg_count));
1110: arp_util.debug('x_msg_data '|| x_msg_data);
1111: arp_util.debug('EXC');
1112: arp_util.debug('error code : '|| to_char(SQLCODE));
1113: arp_util.debug('error text : '|| SQLERRM);
1114: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1115: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1108: p_data => x_msg_data);
1109: arp_util.debug('x_msg_count ' || to_char(x_msg_count));
1110: arp_util.debug('x_msg_data '|| x_msg_data);
1111: arp_util.debug('EXC');
1112: arp_util.debug('error code : '|| to_char(SQLCODE));
1113: arp_util.debug('error text : '|| SQLERRM);
1114: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1115: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1116: FND_MSG_PUB.Count_And_Get(
1109: arp_util.debug('x_msg_count ' || to_char(x_msg_count));
1110: arp_util.debug('x_msg_data '|| x_msg_data);
1111: arp_util.debug('EXC');
1112: arp_util.debug('error code : '|| to_char(SQLCODE));
1113: arp_util.debug('error text : '|| SQLERRM);
1114: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1115: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1116: FND_MSG_PUB.Count_And_Get(
1117: p_encoded => FND_API.G_FALSE,
1116: FND_MSG_PUB.Count_And_Get(
1117: p_encoded => FND_API.G_FALSE,
1118: p_count => x_msg_count,
1119: p_data => x_msg_data);
1120: arp_util.debug('x_msg_count ' || to_char(x_msg_count));
1121: arp_util.debug('x_msg_data '|| x_msg_data);
1122: arp_util.debug('UNEXC');
1123: WHEN OTHERS THEN
1124: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1117: p_encoded => FND_API.G_FALSE,
1118: p_count => x_msg_count,
1119: p_data => x_msg_data);
1120: arp_util.debug('x_msg_count ' || to_char(x_msg_count));
1121: arp_util.debug('x_msg_data '|| x_msg_data);
1122: arp_util.debug('UNEXC');
1123: WHEN OTHERS THEN
1124: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1125: FND_MSG_PUB.Count_And_Get(
1118: p_count => x_msg_count,
1119: p_data => x_msg_data);
1120: arp_util.debug('x_msg_count ' || to_char(x_msg_count));
1121: arp_util.debug('x_msg_data '|| x_msg_data);
1122: arp_util.debug('UNEXC');
1123: WHEN OTHERS THEN
1124: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1125: FND_MSG_PUB.Count_And_Get(
1126: p_encoded => FND_API.G_FALSE,
1125: FND_MSG_PUB.Count_And_Get(
1126: p_encoded => FND_API.G_FALSE,
1127: p_count => x_msg_count,
1128: p_data => x_msg_data);
1129: arp_util.debug('x_msg_count ' || to_char(x_msg_count));
1130: arp_util.debug('x_msg_data '|| x_msg_data);
1131: arp_util.debug('OTHERS');
1132: arp_util.debug('error code : '|| to_char(SQLCODE));
1133: arp_util.debug('error text : '|| SQLERRM);
1126: p_encoded => FND_API.G_FALSE,
1127: p_count => x_msg_count,
1128: p_data => x_msg_data);
1129: arp_util.debug('x_msg_count ' || to_char(x_msg_count));
1130: arp_util.debug('x_msg_data '|| x_msg_data);
1131: arp_util.debug('OTHERS');
1132: arp_util.debug('error code : '|| to_char(SQLCODE));
1133: arp_util.debug('error text : '|| SQLERRM);
1134: END Get_Primary_Zone;
1127: p_count => x_msg_count,
1128: p_data => x_msg_data);
1129: arp_util.debug('x_msg_count ' || to_char(x_msg_count));
1130: arp_util.debug('x_msg_data '|| x_msg_data);
1131: arp_util.debug('OTHERS');
1132: arp_util.debug('error code : '|| to_char(SQLCODE));
1133: arp_util.debug('error text : '|| SQLERRM);
1134: END Get_Primary_Zone;
1135:
1128: p_data => x_msg_data);
1129: arp_util.debug('x_msg_count ' || to_char(x_msg_count));
1130: arp_util.debug('x_msg_data '|| x_msg_data);
1131: arp_util.debug('OTHERS');
1132: arp_util.debug('error code : '|| to_char(SQLCODE));
1133: arp_util.debug('error text : '|| SQLERRM);
1134: END Get_Primary_Zone;
1135:
1136:
1129: arp_util.debug('x_msg_count ' || to_char(x_msg_count));
1130: arp_util.debug('x_msg_data '|| x_msg_data);
1131: arp_util.debug('OTHERS');
1132: arp_util.debug('error code : '|| to_char(SQLCODE));
1133: arp_util.debug('error text : '|| SQLERRM);
1134: END Get_Primary_Zone;
1135:
1136:
1137: /*===========================================================================+