DBA Data[Home] [Help]

APPS.HZ_TIMEZONE_PUB dependencies on ARP_UTIL

Line 227: /* comment out arp_util.debug for fixing bug 3655764

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

Line 228: arp_util.debug('x_msg_count ' || to_char(x_msg_count));

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); */

Line 229: arp_util.debug('x_msg_data '|| x_msg_data);

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

Line 230: arp_util.debug('EXC');

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;

Line 231: arp_util.debug('error code : '|| to_char(SQLCODE));

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(

Line 232: arp_util.debug('error text : '|| SQLERRM); */

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,

Line 239: /* comment out arp_util.debug for fixing bug 3655764

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

Line 240: arp_util.debug('x_msg_count ' || to_char(x_msg_count));

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;

Line 241: arp_util.debug('x_msg_data '|| x_msg_data);

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(

Line 242: arp_util.debug('UNEXC'); */

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,

Line 249: /* comment out arp_util.debug for fixing bug 3655764

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

Line 250: arp_util.debug('x_msg_count ' || to_char(x_msg_count));

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

Line 251: arp_util.debug('x_msg_count ' || to_char(x_msg_count));

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); */

Line 252: arp_util.debug('x_msg_data '|| x_msg_data);

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;

Line 253: arp_util.debug('OTHERS');

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:

Line 254: arp_util.debug('error code : '|| to_char(SQLCODE));

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: /*===========================================================================+

Line 255: arp_util.debug('error text : '|| SQLERRM); */

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 |

Line 620: arp_util.debug('x_msg_count ' || to_char(x_msg_count));

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

Line 621: arp_util.debug('x_msg_data '|| x_msg_data);

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

Line 622: arp_util.debug('EXC');

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;

Line 623: arp_util.debug('error code : '|| to_char(SQLCODE));

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(

Line 624: arp_util.debug('error text : '|| SQLERRM);

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,

Line 631: arp_util.debug('x_msg_count ' || to_char(x_msg_count));

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;

Line 632: arp_util.debug('x_msg_data '|| x_msg_data);

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(

Line 633: arp_util.debug('UNEXC');

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,

Line 640: arp_util.debug('x_msg_count ' || to_char(x_msg_count));

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

Line 641: arp_util.debug('x_msg_data '|| x_msg_data);

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;

Line 642: arp_util.debug('OTHERS');

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:

Line 643: arp_util.debug('error code : '|| to_char(SQLCODE));

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: /*===========================================================================+

Line 644: arp_util.debug('error text : '|| SQLERRM);

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 |

Line 1109: arp_util.debug('x_msg_count ' || to_char(x_msg_count));

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

Line 1110: arp_util.debug('x_msg_data '|| x_msg_data);

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

Line 1111: arp_util.debug('EXC');

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;

Line 1112: arp_util.debug('error code : '|| to_char(SQLCODE));

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(

Line 1113: arp_util.debug('error text : '|| SQLERRM);

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,

Line 1120: arp_util.debug('x_msg_count ' || to_char(x_msg_count));

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;

Line 1121: arp_util.debug('x_msg_data '|| x_msg_data);

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(

Line 1122: arp_util.debug('UNEXC');

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,

Line 1129: arp_util.debug('x_msg_count ' || to_char(x_msg_count));

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

Line 1130: arp_util.debug('x_msg_data '|| x_msg_data);

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;

Line 1131: arp_util.debug('OTHERS');

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:

Line 1132: arp_util.debug('error code : '|| to_char(SQLCODE));

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:

Line 1133: arp_util.debug('error text : '|| SQLERRM);

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: /*===========================================================================+