DBA Data[Home] [Help]

APPS.CS_SR_STATUS_PROPAGATION_PKG dependencies on FND_MSG_PUB

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

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

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

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

Line 135: FND_MSG_PUB.ADD;

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

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

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

Line 142: FND_MSG_PUB.ADD;

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

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

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

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

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

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

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

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

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

Line 308: FND_MSG_PUB.Count_And_Get

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

Line 315: FND_MSG_PUB.Count_And_Get

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

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

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

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

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

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

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

Line 581: FND_MSG_PUB.Count_And_Get

577: EXCEPTION
578: WHEN FND_API.G_EXC_ERROR THEN
579: ROLLBACK TO SR_UPWARD_STATUS_PROPAGATION;
580: x_return_status := FND_API.G_RET_STS_ERROR;
581: FND_MSG_PUB.Count_And_Get
582: ( p_count => x_msg_count,
583: p_data => x_msg_data
584: );
585: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 588: FND_MSG_PUB.Count_And_Get

584: );
585: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
586: ROLLBACK TO SR_UPWARD_STATUS_PROPAGATION;
587: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
588: FND_MSG_PUB.Count_And_Get
589: ( p_count => x_msg_count,
590: p_data => x_msg_data
591: );
592: WHEN CS_DEPOT_ORDERS_EXIST THEN

Line 596: FND_MSG_PUB.ADD;

592: WHEN CS_DEPOT_ORDERS_EXIST THEN
593: ROLLBACK TO SR_UPWARD_STATUS_PROPAGATION;
594: x_return_status := FND_API.G_RET_STS_ERROR;
595: FND_MESSAGE.SET_NAME('CS','CS_SR_EAM_ORDERS_EXIST');
596: FND_MSG_PUB.ADD;
597: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
598: p_data => x_msg_data);
599: WHEN CS_EAM_ORDERS_EXIST THEN
600: ROLLBACK TO SR_UPWARD_STATUS_PROPAGATION;

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

593: ROLLBACK TO SR_UPWARD_STATUS_PROPAGATION;
594: x_return_status := FND_API.G_RET_STS_ERROR;
595: FND_MESSAGE.SET_NAME('CS','CS_SR_EAM_ORDERS_EXIST');
596: FND_MSG_PUB.ADD;
597: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
598: p_data => x_msg_data);
599: WHEN CS_EAM_ORDERS_EXIST THEN
600: ROLLBACK TO SR_UPWARD_STATUS_PROPAGATION;
601: x_return_status := FND_API.G_RET_STS_ERROR;

Line 603: FND_MSG_PUB.ADD;

599: WHEN CS_EAM_ORDERS_EXIST THEN
600: ROLLBACK TO SR_UPWARD_STATUS_PROPAGATION;
601: x_return_status := FND_API.G_RET_STS_ERROR;
602: FND_MESSAGE.SET_NAME('CS','CS_SR_CMRO_ORDERS_EXIST');
603: FND_MSG_PUB.ADD;
604: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
605: p_data => x_msg_data);
606: WHEN CS_CMRO_ORDERS_EXIST THEN
607: ROLLBACK TO SR_UPWARD_STATUS_PROPAGATION;

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

600: ROLLBACK TO SR_UPWARD_STATUS_PROPAGATION;
601: x_return_status := FND_API.G_RET_STS_ERROR;
602: FND_MESSAGE.SET_NAME('CS','CS_SR_CMRO_ORDERS_EXIST');
603: FND_MSG_PUB.ADD;
604: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
605: p_data => x_msg_data);
606: WHEN CS_CMRO_ORDERS_EXIST THEN
607: ROLLBACK TO SR_UPWARD_STATUS_PROPAGATION;
608: x_return_status := FND_API.G_RET_STS_ERROR;

Line 610: FND_MSG_PUB.ADD;

606: WHEN CS_CMRO_ORDERS_EXIST THEN
607: ROLLBACK TO SR_UPWARD_STATUS_PROPAGATION;
608: x_return_status := FND_API.G_RET_STS_ERROR;
609: FND_MESSAGE.SET_NAME('CS','CS_SR_CMRO_ORDERS_EXIST');
610: FND_MSG_PUB.ADD;
611: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
612: p_data => x_msg_data);
613: WHEN CS_UNSUBMITTED_CHARGES_EXIST THEN
614: ROLLBACK TO SR_UPWARD_STATUS_PROPAGATION;

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

607: ROLLBACK TO SR_UPWARD_STATUS_PROPAGATION;
608: x_return_status := FND_API.G_RET_STS_ERROR;
609: FND_MESSAGE.SET_NAME('CS','CS_SR_CMRO_ORDERS_EXIST');
610: FND_MSG_PUB.ADD;
611: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
612: p_data => x_msg_data);
613: WHEN CS_UNSUBMITTED_CHARGES_EXIST THEN
614: ROLLBACK TO SR_UPWARD_STATUS_PROPAGATION;
615: x_return_status := FND_API.G_RET_STS_ERROR;

Line 617: FND_MSG_PUB.ADD;

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

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

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

Line 624: FND_MSG_PUB.ADD;

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

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

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

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

626: p_data => x_msg_data);
627: WHEN OTHERS THEN
628: ROLLBACK TO SR_UPWARD_STATUS_PROPAGATION;
629: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
630: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
631: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
632: END IF;
633: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
634: p_data => x_msg_data,

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

627: WHEN OTHERS THEN
628: ROLLBACK TO SR_UPWARD_STATUS_PROPAGATION;
629: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
630: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
631: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
632: END IF;
633: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
634: p_data => x_msg_data,
635: p_encoded => FND_API.G_FALSE );

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

629: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
630: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
631: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
632: END IF;
633: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
634: p_data => x_msg_data,
635: p_encoded => FND_API.G_FALSE );
636: END;
637: