DBA Data[Home] [Help]

APPS.CS_SR_STATUS_PROPAGATION_PKG dependencies on FND_MSG_PUB

Line 121: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

117: END LOOP;
118: EXCEPTION
119: WHEN FND_API.G_EXC_ERROR THEN
120: x_return_status := FND_API.G_RET_STS_ERROR;
121: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
122: p_data => x_msg_data);
123:
124: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
125: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 126: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

122: p_data => x_msg_data);
123:
124: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
125: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
126: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
127: p_data => x_msg_data);
128:
129: WHEN CS_UNSUBMITTED_CHARGES_EXIST THEN
130: x_return_status := FND_API.G_RET_STS_ERROR;

Line 132: FND_MSG_PUB.ADD;

128:
129: WHEN CS_UNSUBMITTED_CHARGES_EXIST THEN
130: x_return_status := FND_API.G_RET_STS_ERROR;
131: FND_MESSAGE.SET_NAME('CS','CS_SR_OPEN_CHARGES_EXISTS');
132: FND_MSG_PUB.ADD;
133: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
134: p_data => x_msg_data);
135:
136: WHEN CS_OPEN_TASKS_EXIST THEN

Line 133: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

129: WHEN CS_UNSUBMITTED_CHARGES_EXIST THEN
130: x_return_status := FND_API.G_RET_STS_ERROR;
131: FND_MESSAGE.SET_NAME('CS','CS_SR_OPEN_CHARGES_EXISTS');
132: FND_MSG_PUB.ADD;
133: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
134: p_data => x_msg_data);
135:
136: WHEN CS_OPEN_TASKS_EXIST THEN
137: x_return_status := FND_API.G_RET_STS_ERROR;

Line 139: FND_MSG_PUB.ADD;

135:
136: WHEN CS_OPEN_TASKS_EXIST THEN
137: x_return_status := FND_API.G_RET_STS_ERROR;
138: FND_MESSAGE.SET_NAME('CS','CS_SR_OPEN_TASKS_EXISTS');
139: FND_MSG_PUB.ADD;
140: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
141: p_data => x_msg_data);
142: WHEN OTHERS THEN
143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 140: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

136: WHEN CS_OPEN_TASKS_EXIST THEN
137: x_return_status := FND_API.G_RET_STS_ERROR;
138: FND_MESSAGE.SET_NAME('CS','CS_SR_OPEN_TASKS_EXISTS');
139: FND_MSG_PUB.ADD;
140: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
141: p_data => x_msg_data);
142: WHEN OTHERS THEN
143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
144: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 144: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

140: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
141: p_data => x_msg_data);
142: WHEN OTHERS THEN
143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
144: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
145: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
146: END IF;
147: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
148: p_data => x_msg_data);

Line 145: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

141: p_data => x_msg_data);
142: WHEN OTHERS THEN
143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
144: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
145: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
146: END IF;
147: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
148: p_data => x_msg_data);
149: END;

Line 147: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
144: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
145: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
146: END IF;
147: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
148: p_data => x_msg_data);
149: END;
150:
151: -- -----------------------------------------------------------------------------

Line 305: FND_MSG_PUB.Count_And_Get

301: EXCEPTION
302: WHEN FND_API.G_EXC_ERROR THEN
303: ROLLBACK TO CLOSE_SR_CHILDREN;
304: x_return_status := FND_API.G_RET_STS_ERROR;
305: FND_MSG_PUB.Count_And_Get
306: ( p_count => x_msg_count,
307: p_data => x_msg_data
308: );
309: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 312: FND_MSG_PUB.Count_And_Get

308: );
309: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
310: ROLLBACK TO CLOSE_SR_CHILDREN;
311: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
312: FND_MSG_PUB.Count_And_Get
313: ( p_count => x_msg_count,
314: p_data => x_msg_data
315: );
316: WHEN OTHERS THEN

Line 319: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

315: );
316: WHEN OTHERS THEN
317: ROLLBACK TO CLOSE_SR_CHILDREN;
318: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
319: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
320: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
321: END IF;
322: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
323: p_data => x_msg_data);

Line 320: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

316: WHEN OTHERS THEN
317: ROLLBACK TO CLOSE_SR_CHILDREN;
318: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
319: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
320: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
321: END IF;
322: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
323: p_data => x_msg_data);
324:

Line 322: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

318: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
319: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
320: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
321: END IF;
322: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
323: p_data => x_msg_data);
324:
325: END;
326:

Line 601: FND_MSG_PUB.Count_And_Get

597: EXCEPTION
598: WHEN FND_API.G_EXC_ERROR THEN
599: ROLLBACK TO SR_UPWARD_STATUS_PROPAGATION;
600: x_return_status := FND_API.G_RET_STS_ERROR;
601: FND_MSG_PUB.Count_And_Get
602: ( p_count => x_msg_count,
603: p_data => x_msg_data
604: );
605: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 608: FND_MSG_PUB.Count_And_Get

604: );
605: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
606: ROLLBACK TO SR_UPWARD_STATUS_PROPAGATION;
607: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
608: FND_MSG_PUB.Count_And_Get
609: ( p_count => x_msg_count,
610: p_data => x_msg_data
611: );
612: WHEN CS_DEPOT_ORDERS_EXIST THEN

Line 616: FND_MSG_PUB.ADD;

612: WHEN CS_DEPOT_ORDERS_EXIST THEN
613: ROLLBACK TO SR_UPWARD_STATUS_PROPAGATION;
614: x_return_status := FND_API.G_RET_STS_ERROR;
615: FND_MESSAGE.SET_NAME('CS','CS_SR_EAM_ORDERS_EXIST');
616: FND_MSG_PUB.ADD;
617: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
618: p_data => x_msg_data);
619: WHEN CS_EAM_ORDERS_EXIST THEN
620: ROLLBACK TO SR_UPWARD_STATUS_PROPAGATION;

Line 617: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

613: ROLLBACK TO SR_UPWARD_STATUS_PROPAGATION;
614: x_return_status := FND_API.G_RET_STS_ERROR;
615: FND_MESSAGE.SET_NAME('CS','CS_SR_EAM_ORDERS_EXIST');
616: FND_MSG_PUB.ADD;
617: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
618: p_data => x_msg_data);
619: WHEN CS_EAM_ORDERS_EXIST THEN
620: ROLLBACK TO SR_UPWARD_STATUS_PROPAGATION;
621: x_return_status := FND_API.G_RET_STS_ERROR;

Line 623: FND_MSG_PUB.ADD;

619: WHEN CS_EAM_ORDERS_EXIST THEN
620: ROLLBACK TO SR_UPWARD_STATUS_PROPAGATION;
621: x_return_status := FND_API.G_RET_STS_ERROR;
622: FND_MESSAGE.SET_NAME('CS','CS_SR_CMRO_ORDERS_EXIST');
623: FND_MSG_PUB.ADD;
624: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
625: p_data => x_msg_data);
626: WHEN CS_CMRO_ORDERS_EXIST THEN
627: ROLLBACK TO SR_UPWARD_STATUS_PROPAGATION;

Line 624: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

620: ROLLBACK TO SR_UPWARD_STATUS_PROPAGATION;
621: x_return_status := FND_API.G_RET_STS_ERROR;
622: FND_MESSAGE.SET_NAME('CS','CS_SR_CMRO_ORDERS_EXIST');
623: FND_MSG_PUB.ADD;
624: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
625: p_data => x_msg_data);
626: WHEN CS_CMRO_ORDERS_EXIST THEN
627: ROLLBACK TO SR_UPWARD_STATUS_PROPAGATION;
628: x_return_status := FND_API.G_RET_STS_ERROR;

Line 630: FND_MSG_PUB.ADD;

626: WHEN CS_CMRO_ORDERS_EXIST THEN
627: ROLLBACK TO SR_UPWARD_STATUS_PROPAGATION;
628: x_return_status := FND_API.G_RET_STS_ERROR;
629: FND_MESSAGE.SET_NAME('CS','CS_SR_CMRO_ORDERS_EXIST');
630: FND_MSG_PUB.ADD;
631: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
632: p_data => x_msg_data);
633: WHEN CS_UNSUBMITTED_CHARGES_EXIST THEN
634: ROLLBACK TO SR_UPWARD_STATUS_PROPAGATION;

Line 631: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

627: ROLLBACK TO SR_UPWARD_STATUS_PROPAGATION;
628: x_return_status := FND_API.G_RET_STS_ERROR;
629: FND_MESSAGE.SET_NAME('CS','CS_SR_CMRO_ORDERS_EXIST');
630: FND_MSG_PUB.ADD;
631: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
632: p_data => x_msg_data);
633: WHEN CS_UNSUBMITTED_CHARGES_EXIST THEN
634: ROLLBACK TO SR_UPWARD_STATUS_PROPAGATION;
635: x_return_status := FND_API.G_RET_STS_ERROR;

Line 637: FND_MSG_PUB.ADD;

633: WHEN CS_UNSUBMITTED_CHARGES_EXIST THEN
634: ROLLBACK TO SR_UPWARD_STATUS_PROPAGATION;
635: x_return_status := FND_API.G_RET_STS_ERROR;
636: FND_MESSAGE.SET_NAME('CS','CS_SR_OPEN_CHARGES_EXISTS');
637: FND_MSG_PUB.ADD;
638: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
639: p_data => x_msg_data);
640: WHEN CS_OPEN_TASKS_EXIST THEN
641: ROLLBACK TO SR_UPWARD_STATUS_PROPAGATION;

Line 638: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

634: ROLLBACK TO SR_UPWARD_STATUS_PROPAGATION;
635: x_return_status := FND_API.G_RET_STS_ERROR;
636: FND_MESSAGE.SET_NAME('CS','CS_SR_OPEN_CHARGES_EXISTS');
637: FND_MSG_PUB.ADD;
638: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
639: p_data => x_msg_data);
640: WHEN CS_OPEN_TASKS_EXIST THEN
641: ROLLBACK TO SR_UPWARD_STATUS_PROPAGATION;
642: x_return_status := FND_API.G_RET_STS_ERROR;

Line 644: FND_MSG_PUB.ADD;

640: WHEN CS_OPEN_TASKS_EXIST THEN
641: ROLLBACK TO SR_UPWARD_STATUS_PROPAGATION;
642: x_return_status := FND_API.G_RET_STS_ERROR;
643: FND_MESSAGE.SET_NAME('CS','CS_SR_OPEN_TASKS_EXIST');
644: FND_MSG_PUB.ADD;
645: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
646: p_data => x_msg_data);
647: WHEN OTHERS THEN
648: ROLLBACK TO SR_UPWARD_STATUS_PROPAGATION;

Line 645: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

641: ROLLBACK TO SR_UPWARD_STATUS_PROPAGATION;
642: x_return_status := FND_API.G_RET_STS_ERROR;
643: FND_MESSAGE.SET_NAME('CS','CS_SR_OPEN_TASKS_EXIST');
644: FND_MSG_PUB.ADD;
645: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
646: p_data => x_msg_data);
647: WHEN OTHERS THEN
648: ROLLBACK TO SR_UPWARD_STATUS_PROPAGATION;
649: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 650: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

646: p_data => x_msg_data);
647: WHEN OTHERS THEN
648: ROLLBACK TO SR_UPWARD_STATUS_PROPAGATION;
649: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
650: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
651: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
652: END IF;
653: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
654: p_data => x_msg_data,

Line 651: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

647: WHEN OTHERS THEN
648: ROLLBACK TO SR_UPWARD_STATUS_PROPAGATION;
649: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
650: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
651: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
652: END IF;
653: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
654: p_data => x_msg_data,
655: p_encoded => FND_API.G_FALSE );

Line 653: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

649: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
650: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
651: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
652: END IF;
653: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
654: p_data => x_msg_data,
655: p_encoded => FND_API.G_FALSE );
656: END;
657: