DBA Data[Home] [Help]

APPS.CN_PREPOST_PVT dependencies on FND_MSG_PUB

Line 70: FND_MSG_PUB.initialize;

66: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
67: END IF;
68: -- Initialize message list if p_init_msg_list is set to TRUE.
69: IF FND_API.to_Boolean( p_init_msg_list ) THEN
70: FND_MSG_PUB.initialize;
71: END IF;
72: -- Initialize API return status to success
73: x_return_status := FND_API.G_RET_STS_SUCCESS;
74: x_loading_status := 'CN_INSERTED';

Line 98: FND_MSG_PUB.Count_And_Get

94: IF FND_API.To_Boolean( p_commit ) THEN
95: COMMIT WORK;
96: END IF;
97: -- Standard call to get message count and if count is 1, get message info.
98: FND_MSG_PUB.Count_And_Get
99: ( p_count => x_msg_count ,
100: p_data => x_msg_data
101: );
102: EXCEPTION

Line 106: FND_MSG_PUB.Count_And_Get

102: EXCEPTION
103: WHEN FND_API.G_EXC_ERROR THEN
104: ROLLBACK TO Initialize_Batch;
105: x_return_status := FND_API.G_RET_STS_ERROR ;
106: FND_MSG_PUB.Count_And_Get
107: ( p_count => x_msg_count ,
108: p_data => x_msg_data
109: );
110: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 113: FND_MSG_PUB.Count_And_Get

109: );
110: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
111: ROLLBACK TO Initialize_Batch;
112: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
113: FND_MSG_PUB.Count_And_Get
114: ( p_count => x_msg_count ,
115: p_data => x_msg_data
116: );
117: WHEN OTHERS THEN

Line 120: IF FND_MSG_PUB.Check_Msg_Level

116: );
117: WHEN OTHERS THEN
118: ROLLBACK TO Initialize_Batch;
119: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
120: IF FND_MSG_PUB.Check_Msg_Level
121: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
122: FND_MSG_PUB.Add_Exc_Msg
123: ( G_PKG_NAME,
124: l_api_name);

Line 121: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

117: WHEN OTHERS THEN
118: ROLLBACK TO Initialize_Batch;
119: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
120: IF FND_MSG_PUB.Check_Msg_Level
121: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
122: FND_MSG_PUB.Add_Exc_Msg
123: ( G_PKG_NAME,
124: l_api_name);
125: END IF;

Line 122: FND_MSG_PUB.Add_Exc_Msg

118: ROLLBACK TO Initialize_Batch;
119: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
120: IF FND_MSG_PUB.Check_Msg_Level
121: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
122: FND_MSG_PUB.Add_Exc_Msg
123: ( G_PKG_NAME,
124: l_api_name);
125: END IF;
126: FND_MSG_PUB.Count_And_Get

Line 126: FND_MSG_PUB.Count_And_Get

122: FND_MSG_PUB.Add_Exc_Msg
123: ( G_PKG_NAME,
124: l_api_name);
125: END IF;
126: FND_MSG_PUB.Count_And_Get
127: ( p_count => x_msg_count,
128: p_data => x_msg_data
129: );
130: END Initialize_Batch;

Line 220: FND_MSG_PUB.Count_And_Get

216: RAISE FND_API.G_EXC_ERROR;
217: END IF;
218: -- End of Validate Posting
219: -- Standard call to get message count and if count is 1, get message info.
220: FND_MSG_PUB.Count_And_Get
221: ( p_count => x_msg_count ,
222: p_data => x_msg_data ,
223: p_encoded => FND_API.G_FALSE
224: );

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

230: x_loading_status := 'UNEXPECTED_ERR';
231: WHEN OTHERS THEN
232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
233: x_loading_status := 'UNEXPECTED_ERR';
234: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
235: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
236: END IF;
237: END Validate_PrePostDetails;
238:

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

231: WHEN OTHERS THEN
232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
233: x_loading_status := 'UNEXPECTED_ERR';
234: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
235: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
236: END IF;
237: END Validate_PrePostDetails;
238:
239: -- ============================================================================

Line 421: FND_MSG_PUB.initialize;

417: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
418: END IF;
419: -- Initialize message list if p_init_msg_list is set to TRUE.
420: IF FND_API.to_Boolean( p_init_msg_list ) THEN
421: FND_MSG_PUB.initialize;
422: END IF;
423: -- Initialize API return status to success
424: x_return_status := FND_API.G_RET_STS_SUCCESS;
425: l_loading_status := 'CN_INSERTED';

Line 463: FND_MSG_PUB.ADD;

459: IF get_comm_line_rec%ROWCOUNT <> 1 THEN
460: FND_MESSAGE.SET_NAME('CN', 'CN_INVALID_COMMISSION_LINE');
461: FND_MESSAGE.SET_TOKEN('COMMISSION_LINE_ID',
462: TO_CHAR(p_commission_line_id));
463: FND_MSG_PUB.ADD;
464: l_loading_status := 'CN_INVALID_COMMISSION_LINE';
465: l_status := l_loading_status;
466: RAISE FND_API.G_EXC_ERROR;
467: END IF;

Line 536: FND_MSG_PUB.Count_And_Get

532: IF FND_API.To_Boolean( p_commit ) THEN
533: COMMIT WORK;
534: END IF;
535: -- Standard call to get message count and if count is 1, get message info
536: FND_MSG_PUB.Count_And_Get
537: ( p_count => x_msg_count ,
538: p_data => x_msg_data
539: );
540: EXCEPTION

Line 545: FND_MSG_PUB.Count_And_Get

541: WHEN FND_API.G_EXC_ERROR THEN
542: --dbms_output.put_line('EXP '||sqlerrm);
543: ROLLBACK TO Create_From_CommLine;
544: x_return_status := FND_API.G_RET_STS_ERROR ;
545: FND_MSG_PUB.Count_And_Get
546: ( p_count => x_msg_count ,
547: p_data => x_msg_data
548: );
549: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 553: FND_MSG_PUB.Count_And_Get

549: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
550: --dbms_output.put_line('UNEXP '||sqlerrm);
551: ROLLBACK TO Create_From_CommLine;
552: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
553: FND_MSG_PUB.Count_And_Get
554: ( p_count => x_msg_count ,
555: p_data => x_msg_data
556: );
557: WHEN OTHERS THEN

Line 561: IF FND_MSG_PUB.Check_Msg_Level

557: WHEN OTHERS THEN
558: --dbms_output.put_line('OTHERS '||sqlerrm);
559: ROLLBACK TO Create_From_CommLine;
560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
561: IF FND_MSG_PUB.Check_Msg_Level
562: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
563: FND_MSG_PUB.Add_Exc_Msg
564: ( G_PKG_NAME ,
565: l_api_name);

Line 562: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

558: --dbms_output.put_line('OTHERS '||sqlerrm);
559: ROLLBACK TO Create_From_CommLine;
560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
561: IF FND_MSG_PUB.Check_Msg_Level
562: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
563: FND_MSG_PUB.Add_Exc_Msg
564: ( G_PKG_NAME ,
565: l_api_name);
566: END IF;

Line 563: FND_MSG_PUB.Add_Exc_Msg

559: ROLLBACK TO Create_From_CommLine;
560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
561: IF FND_MSG_PUB.Check_Msg_Level
562: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
563: FND_MSG_PUB.Add_Exc_Msg
564: ( G_PKG_NAME ,
565: l_api_name);
566: END IF;
567: FND_MSG_PUB.Count_And_Get

Line 567: FND_MSG_PUB.Count_And_Get

563: FND_MSG_PUB.Add_Exc_Msg
564: ( G_PKG_NAME ,
565: l_api_name);
566: END IF;
567: FND_MSG_PUB.Count_And_Get
568: ( p_count => x_msg_count ,
569: p_data => x_msg_data
570: );
571: END Create_From_CommLine;

Line 619: FND_MSG_PUB.initialize;

615: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
616: END IF;
617: -- Initialize message list if p_init_msg_list is set to TRUE.
618: IF FND_API.to_Boolean( p_init_msg_list ) THEN
619: FND_MSG_PUB.initialize;
620: END IF;
621: -- Initialize API return status to success
622: x_return_status := FND_API.G_RET_STS_SUCCESS;
623: l_loading_status := 'CN_INSERTED';

Line 660: FND_MSG_PUB.Count_And_Get

656: IF FND_API.To_Boolean( p_commit ) THEN
657: COMMIT WORK;
658: END IF;
659: -- Standard call to get message count and if count is 1, get message info.
660: FND_MSG_PUB.Count_And_Get
661: ( p_count => x_msg_count ,
662: p_data => x_msg_data
663: );
664: EXCEPTION --create posting detail

Line 668: FND_MSG_PUB.Count_And_Get

664: EXCEPTION --create posting detail
665: WHEN FND_API.G_EXC_ERROR THEN
666: ROLLBACK TO Create_PrePostDetails_Loop;
667: x_return_status := FND_API.G_RET_STS_ERROR ;
668: FND_MSG_PUB.Count_And_Get
669: ( p_count => x_msg_count ,
670: p_data => x_msg_data
671: );
672: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 675: FND_MSG_PUB.Count_And_Get

671: );
672: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
673: ROLLBACK TO Create_PrePostDetails;
674: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
675: FND_MSG_PUB.Count_And_Get
676: ( p_count => x_msg_count ,
677: p_data => x_msg_data
678: );
679: WHEN OTHERS THEN

Line 682: IF FND_MSG_PUB.Check_Msg_Level

678: );
679: WHEN OTHERS THEN
680: ROLLBACK TO Create_PrePostDetails;
681: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
682: IF FND_MSG_PUB.Check_Msg_Level
683: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
684: FND_MSG_PUB.Add_Exc_Msg
685: ( G_PKG_NAME ,
686: l_api_name);

Line 683: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

679: WHEN OTHERS THEN
680: ROLLBACK TO Create_PrePostDetails;
681: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
682: IF FND_MSG_PUB.Check_Msg_Level
683: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
684: FND_MSG_PUB.Add_Exc_Msg
685: ( G_PKG_NAME ,
686: l_api_name);
687: END IF;

Line 684: FND_MSG_PUB.Add_Exc_Msg

680: ROLLBACK TO Create_PrePostDetails;
681: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
682: IF FND_MSG_PUB.Check_Msg_Level
683: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
684: FND_MSG_PUB.Add_Exc_Msg
685: ( G_PKG_NAME ,
686: l_api_name);
687: END IF;
688: FND_MSG_PUB.Count_And_Get

Line 688: FND_MSG_PUB.Count_And_Get

684: FND_MSG_PUB.Add_Exc_Msg
685: ( G_PKG_NAME ,
686: l_api_name);
687: END IF;
688: FND_MSG_PUB.Count_And_Get
689: ( p_count => x_msg_count ,
690: p_data => x_msg_data
691: );
692: END Create_PrePostDetails;

Line 786: FND_MSG_PUB.initialize;

782: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
783: END IF;
784: -- Initialize message list if p_init_msg_list is set to TRUE.
785: IF FND_API.to_Boolean( p_init_msg_list ) THEN
786: FND_MSG_PUB.initialize;
787: END IF;
788: -- Initialize API return status to success
789: x_return_status := FND_API.G_RET_STS_SUCCESS;
790: -- API body

Line 799: FND_MSG_PUB.ADD;

795:
796: IF CN_PREPOSTBATCHES.G_BATCH_ID is NULL THEN
797: FND_MESSAGE.SET_NAME('CN', 'CN_POSTING_BATCH_UNINITIALIZED');
798: --FND_MESSAGE.SET_TOKEN('COMMISSION_LINE_ID', TO_CHAR(p_commission_line_id));
799: FND_MSG_PUB.ADD;
800: l_loading_status := 'CN_POSTING_BATCH_UNINITIALIZED';
801: l_status := 'EARLY EXIT BECAUSE POSTING BATCH NOT INITIALIZED';
802: RAISE FND_API.G_EXC_ERROR;
803: END IF;

Line 1037: FND_MSG_PUB.Count_And_Get

1033: IF FND_API.To_Boolean( p_commit ) THEN
1034: COMMIT WORK;
1035: END IF;
1036: -- Standard call to get message count and if count is 1, get message info.
1037: FND_MSG_PUB.Count_And_Get
1038: ( p_count => x_msg_count ,
1039: p_data => x_msg_data
1040: );
1041: EXCEPTION -- post payws

Line 1045: FND_MSG_PUB.Count_And_Get

1041: EXCEPTION -- post payws
1042: WHEN FND_API.G_EXC_ERROR THEN
1043: ROLLBACK TO PrePost_PayWorksheets;
1044: x_return_status := FND_API.G_RET_STS_ERROR ;
1045: FND_MSG_PUB.Count_And_Get
1046: ( p_count => x_msg_count ,
1047: p_data => x_msg_data
1048: );
1049: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1052: FND_MSG_PUB.Count_And_Get

1048: );
1049: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1050: ROLLBACK TO PrePost_PayWorksheets;
1051: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1052: FND_MSG_PUB.Count_And_Get
1053: ( p_count => x_msg_count ,
1054: p_data => x_msg_data
1055: );
1056: WHEN OTHERS THEN

Line 1059: IF FND_MSG_PUB.Check_Msg_Level

1055: );
1056: WHEN OTHERS THEN
1057: ROLLBACK TO PrePost_PayWorksheets;
1058: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1059: IF FND_MSG_PUB.Check_Msg_Level
1060: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1061: FND_MSG_PUB.Add_Exc_Msg
1062: ( G_PKG_NAME ,
1063: l_api_name);

Line 1060: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1056: WHEN OTHERS THEN
1057: ROLLBACK TO PrePost_PayWorksheets;
1058: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1059: IF FND_MSG_PUB.Check_Msg_Level
1060: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1061: FND_MSG_PUB.Add_Exc_Msg
1062: ( G_PKG_NAME ,
1063: l_api_name);
1064: END IF;

Line 1061: FND_MSG_PUB.Add_Exc_Msg

1057: ROLLBACK TO PrePost_PayWorksheets;
1058: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1059: IF FND_MSG_PUB.Check_Msg_Level
1060: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1061: FND_MSG_PUB.Add_Exc_Msg
1062: ( G_PKG_NAME ,
1063: l_api_name);
1064: END IF;
1065: FND_MSG_PUB.Count_And_Get

Line 1065: FND_MSG_PUB.Count_And_Get

1061: FND_MSG_PUB.Add_Exc_Msg
1062: ( G_PKG_NAME ,
1063: l_api_name);
1064: END IF;
1065: FND_MSG_PUB.Count_And_Get
1066: ( p_count => x_msg_count ,
1067: p_data => x_msg_data
1068: );
1069: END PrePost_PayWorksheets;