DBA Data[Home] [Help]

APPS.OKC_REP_CONTRACT_IMP_PVT dependencies on FND_MESSAGE

Line 520: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_INV_PARTY_NAME');

516: AND party_name_txt = p_party_contacts_tbl(i).party_name_txt;
517: EXCEPTION
518: WHEN No_Data_Found THEN
519: --PARTY_NOT_EXIST - Party doesn't exist
520: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_INV_PARTY_NAME');
521: fnd_message.set_token(TOKEN => 'PARTY_INDEX',
522: VALUE => p_party_contacts_tbl(i).contact_index);
523: l_error_msg := fnd_message.get;
524:

Line 521: fnd_message.set_token(TOKEN => 'PARTY_INDEX',

517: EXCEPTION
518: WHEN No_Data_Found THEN
519: --PARTY_NOT_EXIST - Party doesn't exist
520: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_INV_PARTY_NAME');
521: fnd_message.set_token(TOKEN => 'PARTY_INDEX',
522: VALUE => p_party_contacts_tbl(i).contact_index);
523: l_error_msg := fnd_message.get;
524:
525: END;

Line 523: l_error_msg := fnd_message.get;

519: --PARTY_NOT_EXIST - Party doesn't exist
520: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_INV_PARTY_NAME');
521: fnd_message.set_token(TOKEN => 'PARTY_INDEX',
522: VALUE => p_party_contacts_tbl(i).contact_index);
523: l_error_msg := fnd_message.get;
524:
525: END;
526:
527: INSERT INTO okc_rep_imp_contacts_t(imp_contract_id,

Line 768: FND_MESSAGE.SET_NAME(G_APP_NAME, 'OKC_REP_IMP_INV_ORG');

764: IF (l_row_notfound) THEN
765: IF (l_debug = 'Y') THEN
766: okc_debug.log('200: Org row not found', 2);
767: END IF;
768: FND_MESSAGE.SET_NAME(G_APP_NAME, 'OKC_REP_IMP_INV_ORG');
769: FND_MSG_PUB.add;
770: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(1, p_encoded =>FND_API.G_FALSE ));
771: retcode := 2;
772: return;

Line 787: FND_MESSAGE.SET_NAME(G_APP_NAME, 'OKC_REP_INV_CONTRACT_TYPE');

783: IF (l_row_notfound) THEN
784: IF (l_debug = 'Y') THEN
785: okc_debug.log('300: Contract Type not found', 2);
786: END IF;
787: FND_MESSAGE.SET_NAME(G_APP_NAME, 'OKC_REP_INV_CONTRACT_TYPE');
788: FND_MSG_PUB.add;
789: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(1, p_encoded =>FND_API.G_FALSE ));
790: retcode := 2;
791: return;

Line 839: FND_MESSAGE.SET_NAME(G_APP_NAME, 'OKC_REP_IMP_NO_VALID_ROWS');

835: IF l_count <= 0 THEN
836: IF (l_debug = 'Y') THEN
837: okc_debug.log('600: No Rows found to import');
838: END IF;
839: FND_MESSAGE.SET_NAME(G_APP_NAME, 'OKC_REP_IMP_NO_VALID_ROWS');
840: FND_MSG_PUB.add;
841: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(1, p_encoded =>FND_API.G_FALSE ));
842: retcode := 1;
843: return;

Line 1012: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_MISS_RISK_EVENT');

1008: END IF;
1009: IF (l_valid_flag = 'Y' AND (p_risks_tbl(i).risk_event_txt IS NULL OR LENGTH(p_risks_tbl(i).risk_event_txt)=0)) THEN
1010: l_valid_flag := 'N';
1011:
1012: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_MISS_RISK_EVENT');
1013: fnd_message.set_token(TOKEN => 'RISK_INDEX',
1014: VALUE => p_risks_tbl(i).risk_index);
1015: l_error_msg := fnd_message.get;
1016: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1013: fnd_message.set_token(TOKEN => 'RISK_INDEX',

1009: IF (l_valid_flag = 'Y' AND (p_risks_tbl(i).risk_event_txt IS NULL OR LENGTH(p_risks_tbl(i).risk_event_txt)=0)) THEN
1010: l_valid_flag := 'N';
1011:
1012: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_MISS_RISK_EVENT');
1013: fnd_message.set_token(TOKEN => 'RISK_INDEX',
1014: VALUE => p_risks_tbl(i).risk_index);
1015: l_error_msg := fnd_message.get;
1016: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1017: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 1015: l_error_msg := fnd_message.get;

1011:
1012: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_MISS_RISK_EVENT');
1013: fnd_message.set_token(TOKEN => 'RISK_INDEX',
1014: VALUE => p_risks_tbl(i).risk_index);
1015: l_error_msg := fnd_message.get;
1016: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1017: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1018: 'Party Name is missing');
1019: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 1042: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_INV_RISK_PROB');

1038:
1039: IF (l_valid_flag = 'Y') THEN
1040: l_valid_flag := 'N';
1041:
1042: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_INV_RISK_PROB');
1043: fnd_message.set_token(TOKEN => 'RISK_INDEX',
1044: VALUE => l_import_risks_rec.risk_index);
1045: l_error_msg := fnd_message.get;
1046: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1043: fnd_message.set_token(TOKEN => 'RISK_INDEX',

1039: IF (l_valid_flag = 'Y') THEN
1040: l_valid_flag := 'N';
1041:
1042: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_INV_RISK_PROB');
1043: fnd_message.set_token(TOKEN => 'RISK_INDEX',
1044: VALUE => l_import_risks_rec.risk_index);
1045: l_error_msg := fnd_message.get;
1046: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1047: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 1045: l_error_msg := fnd_message.get;

1041:
1042: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_INV_RISK_PROB');
1043: fnd_message.set_token(TOKEN => 'RISK_INDEX',
1044: VALUE => l_import_risks_rec.risk_index);
1045: l_error_msg := fnd_message.get;
1046: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1047: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1048: 'Risk Event is not valid ');
1049: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 1081: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_RISK_NOT_AVAIL');

1077:
1078: IF (l_valid_flag = 'Y') THEN
1079: l_valid_flag := 'N';
1080:
1081: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_RISK_NOT_AVAIL');
1082: fnd_message.set_token(TOKEN => 'RISK_INDEX',
1083: VALUE => l_import_risks_rec.risk_index);
1084: l_error_msg := fnd_message.get;
1085: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1082: fnd_message.set_token(TOKEN => 'RISK_INDEX',

1078: IF (l_valid_flag = 'Y') THEN
1079: l_valid_flag := 'N';
1080:
1081: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_RISK_NOT_AVAIL');
1082: fnd_message.set_token(TOKEN => 'RISK_INDEX',
1083: VALUE => l_import_risks_rec.risk_index);
1084: l_error_msg := fnd_message.get;
1085: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1086: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 1084: l_error_msg := fnd_message.get;

1080:
1081: fnd_message.set_name(G_APP_NAME,'OKC_REP_IMP_RISK_NOT_AVAIL');
1082: fnd_message.set_token(TOKEN => 'RISK_INDEX',
1083: VALUE => l_import_risks_rec.risk_index);
1084: l_error_msg := fnd_message.get;
1085: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1086: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1087: 'Risk Event is not valid ');
1088: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 1534: fnd_message.set_name(G_APP_NAME,'OKC_REP_INV_CON_STS');

1530: 'Contract ID: '||p_contract_id);
1531: END IF;
1532:
1533: l_valid_flag := 'N';
1534: fnd_message.set_name(G_APP_NAME,'OKC_REP_INV_CON_STS');
1535: l_error_msg := fnd_message.get;
1536:
1537: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1538: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 1535: l_error_msg := fnd_message.get;

1531: END IF;
1532:
1533: l_valid_flag := 'N';
1534: fnd_message.set_name(G_APP_NAME,'OKC_REP_INV_CON_STS');
1535: l_error_msg := fnd_message.get;
1536:
1537: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1538: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1539: 'Contract not in valid status for creating new version');