DBA Data[Home] [Help]

APPS.OKL_FUNDING_PVT dependencies on FND_MSG_PUB

Line 229: FND_MSG_PUB.initialize;

225: END IF;
226:
227: -- Initialize message list if requested
228: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
229: FND_MSG_PUB.initialize;
230: END IF;
231:
232: -- Initialize API status to success
233: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 452: FND_MSG_PUB.Count_And_Get

448: --*** End API body ******************************************************
449:
450: -- Get message count and if count is 1, get message info
451:
452: FND_MSG_PUB.Count_And_Get
453: (p_count => x_msg_count,
454: p_data => x_msg_data);
455:
456: EXCEPTION

Line 627: FND_MSG_PUB.initialize;

623: END IF;
624:
625: -- Initialize message list if requested
626: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
627: FND_MSG_PUB.initialize;
628: END IF;
629:
630: -- Initialize API status to success
631: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 829: FND_MSG_PUB.Count_And_Get

825:
826: /*** End API body ******************************************************/
827:
828: -- Get message count and if count is 1, get message info
829: FND_MSG_PUB.Count_And_Get
830: (p_count => x_msg_count,
831: p_data => x_msg_data);
832:
833: EXCEPTION

Line 973: FND_MSG_PUB.initialize;

969: END IF;
970:
971: -- Initialize message list if requested
972: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
973: FND_MSG_PUB.initialize;
974: END IF;
975:
976: -- Initialize API status to success
977: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 1154: FND_MSG_PUB.Count_And_Get

1150:
1151: /*** End API body ******************************************************/
1152:
1153: -- Get message count and if count is 1, get message info
1154: FND_MSG_PUB.Count_And_Get
1155: (p_count => x_msg_count,
1156: p_data => x_msg_data);
1157:
1158: EXCEPTION

Line 1162: FND_MSG_PUB.Count_And_Get

1158: EXCEPTION
1159: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1160: ROLLBACK TO UPDATE_FUNDING_LINES_PVT;
1161: x_return_status := OKL_API.G_RET_STS_ERROR;
1162: FND_MSG_PUB.Count_And_Get
1163: (p_count => x_msg_count,
1164: p_data => x_msg_data);
1165:
1166: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1169: FND_MSG_PUB.Count_And_Get

1165:
1166: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1167: ROLLBACK TO UPDATE_FUNDING_LINES_PVT;
1168: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1169: FND_MSG_PUB.Count_And_Get
1170: (p_count => x_msg_count,
1171: p_data => x_msg_data);
1172:
1173: WHEN OTHERS THEN

Line 1182: FND_MSG_PUB.Count_And_Get

1178: p_token1 => G_SQLCODE_TOKEN,
1179: p_token1_value => SQLCODE,
1180: p_token2 => G_SQLERRM_TOKEN,
1181: p_token2_value => SQLERRM);
1182: FND_MSG_PUB.Count_And_Get
1183: (p_count => x_msg_count,
1184: p_data => x_msg_data);
1185:
1186: END refresh_fund_chklst;

Line 5319: FND_MSG_PUB.initialize;

5315: END IF;
5316:
5317: -- Initialize message list if requested
5318: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
5319: FND_MSG_PUB.initialize;
5320: END IF;
5321:
5322: -- Initialize API status to success
5323: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 5492: FND_MSG_PUB.Count_And_Get

5488:
5489: /*** End API body ******************************************************/
5490:
5491: -- Get message count and if count is 1, get message info
5492: FND_MSG_PUB.Count_And_Get
5493: (p_count => x_msg_count,
5494: p_data => x_msg_data);
5495:
5496: EXCEPTION

Line 5501: FND_MSG_PUB.Count_And_Get

5497: WHEN OKL_API.G_EXCEPTION_ERROR THEN
5498: ROLLBACK TO CREATE_FUNDING_HEADER_PVT;
5499: x_return_status := OKL_API.G_RET_STS_ERROR;
5500:
5501: FND_MSG_PUB.Count_And_Get
5502: (p_count => x_msg_count,
5503: p_data => x_msg_data);
5504:
5505: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 5508: FND_MSG_PUB.Count_And_Get

5504:
5505: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
5506: ROLLBACK TO CREATE_FUNDING_HEADER_PVT;
5507: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
5508: FND_MSG_PUB.Count_And_Get
5509: (p_count => x_msg_count,
5510: p_data => x_msg_data);
5511:
5512: WHEN OTHERS THEN

Line 5522: FND_MSG_PUB.Count_And_Get

5518: p_token1_value => SQLCODE,
5519: p_token2 => G_SQLERRM_TOKEN,
5520: p_token2_value => SQLERRM);
5521:
5522: FND_MSG_PUB.Count_And_Get
5523: (p_count => x_msg_count,
5524: p_data => x_msg_data);
5525:
5526: END create_funding_header;

Line 5590: FND_MSG_PUB.initialize;

5586:
5587: -- Initialize message list if requested
5588:
5589: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
5590: FND_MSG_PUB.initialize;
5591: END IF;
5592:
5593: -- Initialize API status to success
5594: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 5882: FND_MSG_PUB.Count_And_Get

5878:
5879: /*** End API body ******************************************************/
5880:
5881: -- Get message count and if count is 1, get message info
5882: FND_MSG_PUB.Count_And_Get
5883: (p_count => x_msg_count,
5884: p_data => x_msg_data);
5885:
5886: EXCEPTION

Line 5890: FND_MSG_PUB.Count_And_Get

5886: EXCEPTION
5887: WHEN OKL_API.G_EXCEPTION_ERROR THEN
5888: ROLLBACK TO UPDATE_FUNDING_HEADER_PVT;
5889: x_return_status := OKL_API.G_RET_STS_ERROR;
5890: FND_MSG_PUB.Count_And_Get
5891: (p_count => x_msg_count,
5892: p_data => x_msg_data);
5893:
5894: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 5897: FND_MSG_PUB.Count_And_Get

5893:
5894: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
5895: ROLLBACK TO UPDATE_FUNDING_HEADER_PVT;
5896: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
5897: FND_MSG_PUB.Count_And_Get
5898: (p_count => x_msg_count,
5899: p_data => x_msg_data);
5900:
5901: WHEN OTHERS THEN

Line 5910: FND_MSG_PUB.Count_And_Get

5906: p_token1 => G_SQLCODE_TOKEN,
5907: p_token1_value => SQLCODE,
5908: p_token2 => G_SQLERRM_TOKEN,
5909: p_token2_value => SQLERRM);
5910: FND_MSG_PUB.Count_And_Get
5911: (p_count => x_msg_count,
5912: p_data => x_msg_data);
5913:
5914: END update_funding_header;

Line 5980: FND_MSG_PUB.initialize;

5976: END IF;
5977:
5978: -- Initialize message list if requested
5979: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
5980: FND_MSG_PUB.initialize;
5981: END IF;
5982:
5983: -- Initialize API status to success
5984: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 6119: FND_MSG_PUB.Count_And_Get

6115:
6116: /*** End API body ******************************************************/
6117:
6118: -- Get message count and if count is 1, get message info
6119: FND_MSG_PUB.Count_And_Get
6120: (p_count => x_msg_count,
6121: p_data => x_msg_data);
6122:
6123: EXCEPTION

Line 6128: FND_MSG_PUB.Count_And_Get

6124: WHEN OKL_API.G_EXCEPTION_ERROR THEN
6125:
6126: ROLLBACK TO CREATE_FUNDING_LINES_PVT;
6127: x_return_status := OKL_API.G_RET_STS_ERROR;
6128: FND_MSG_PUB.Count_And_Get
6129: (p_count => x_msg_count,
6130: p_data => x_msg_data);
6131:
6132:

Line 6136: FND_MSG_PUB.Count_And_Get

6132:
6133: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
6134: ROLLBACK TO CREATE_FUNDING_LINES_PVT;
6135: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
6136: FND_MSG_PUB.Count_And_Get
6137: (p_count => x_msg_count,
6138: p_data => x_msg_data);
6139:
6140: WHEN OTHERS THEN

Line 6149: FND_MSG_PUB.Count_And_Get

6145: p_token1 => G_SQLCODE_TOKEN,
6146: p_token1_value => SQLCODE,
6147: p_token2 => G_SQLERRM_TOKEN,
6148: p_token2_value => SQLERRM);
6149: FND_MSG_PUB.Count_And_Get
6150: (p_count => x_msg_count,
6151: p_data => x_msg_data);
6152:
6153: END create_funding_lines;

Line 6267: FND_MSG_PUB.Count_And_Get

6263: RAISE OKL_API.G_EXCEPTION_ERROR;
6264: END IF;
6265:
6266: -- Get message count and if count is 1, get message info
6267: FND_MSG_PUB.Count_And_Get
6268: (p_count => x_msg_count,
6269: p_data => x_msg_data);
6270:
6271: EXCEPTION

Line 6276: FND_MSG_PUB.Count_And_Get

6272: WHEN OKL_API.G_EXCEPTION_ERROR THEN
6273:
6274: ROLLBACK TO CREATE_FUNDING_LINES_PVT;
6275: x_return_status := OKL_API.G_RET_STS_ERROR;
6276: FND_MSG_PUB.Count_And_Get
6277: (p_count => x_msg_count,
6278: p_data => x_msg_data);
6279:
6280:

Line 6284: FND_MSG_PUB.Count_And_Get

6280:
6281: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
6282: ROLLBACK TO CREATE_FUNDING_LINES_PVT;
6283: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
6284: FND_MSG_PUB.Count_And_Get
6285: (p_count => x_msg_count,
6286: p_data => x_msg_data);
6287:
6288: WHEN OTHERS THEN

Line 6297: FND_MSG_PUB.Count_And_Get

6293: p_token1 => G_SQLCODE_TOKEN,
6294: p_token1_value => SQLCODE,
6295: p_token2 => G_SQLERRM_TOKEN,
6296: p_token2_value => SQLERRM);
6297: FND_MSG_PUB.Count_And_Get
6298: (p_count => x_msg_count,
6299: p_data => x_msg_data);
6300:
6301:

Line 6366: FND_MSG_PUB.initialize;

6362: END IF;
6363:
6364: -- Initialize message list if requested
6365: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
6366: FND_MSG_PUB.initialize;
6367: END IF;
6368:
6369: -- Initialize API status to success
6370: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 6464: FND_MSG_PUB.Count_And_Get

6460:
6461: /*** End API body ******************************************************/
6462:
6463: -- Get message count and if count is 1, get message info
6464: FND_MSG_PUB.Count_And_Get
6465: (p_count => x_msg_count,
6466: p_data => x_msg_data);
6467:
6468: EXCEPTION

Line 6472: FND_MSG_PUB.Count_And_Get

6468: EXCEPTION
6469: WHEN OKL_API.G_EXCEPTION_ERROR THEN
6470: ROLLBACK TO UPDATE_FUNDING_LINES_PVT;
6471: x_return_status := OKL_API.G_RET_STS_ERROR;
6472: FND_MSG_PUB.Count_And_Get
6473: (p_count => x_msg_count,
6474: p_data => x_msg_data);
6475:
6476: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 6479: FND_MSG_PUB.Count_And_Get

6475:
6476: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
6477: ROLLBACK TO UPDATE_FUNDING_LINES_PVT;
6478: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
6479: FND_MSG_PUB.Count_And_Get
6480: (p_count => x_msg_count,
6481: p_data => x_msg_data);
6482:
6483:

Line 6493: FND_MSG_PUB.Count_And_Get

6489: p_token1 => G_SQLCODE_TOKEN,
6490: p_token1_value => SQLCODE,
6491: p_token2 => G_SQLERRM_TOKEN,
6492: p_token2_value => SQLERRM);
6493: FND_MSG_PUB.Count_And_Get
6494: (p_count => x_msg_count,
6495: p_data => x_msg_data);
6496:
6497: END update_funding_lines;

Line 6601: FND_MSG_PUB.initialize;

6597: END IF;
6598:
6599: -- Initialize message list if requested
6600: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
6601: FND_MSG_PUB.initialize;
6602: END IF;
6603:
6604: -- Initialize API status to success
6605: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 6711: FND_MSG_PUB.Count_And_Get

6707:
6708: /*** End API body ******************************************************/
6709:
6710: -- Get message count and if count is 1, get message info
6711: FND_MSG_PUB.Count_And_Get
6712: (p_count => x_msg_count,
6713: p_data => x_msg_data);
6714:
6715: EXCEPTION

Line 6719: FND_MSG_PUB.Count_And_Get

6715: EXCEPTION
6716: WHEN OKL_API.G_EXCEPTION_ERROR THEN
6717: ROLLBACK TO CREATE_FUNDING_ASSETS_PVT;
6718: x_return_status := OKL_API.G_RET_STS_ERROR;
6719: FND_MSG_PUB.Count_And_Get
6720: (p_count => x_msg_count,
6721: p_data => x_msg_data);
6722:
6723: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 6727: FND_MSG_PUB.Count_And_Get

6723: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
6724: ROLLBACK TO CREATE_FUNDING_ASSETS_PVT;
6725: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
6726:
6727: FND_MSG_PUB.Count_And_Get
6728: (p_count => x_msg_count,
6729: p_data => x_msg_data);
6730:
6731: WHEN OTHERS THEN

Line 6740: FND_MSG_PUB.Count_And_Get

6736: p_token1 => G_SQLCODE_TOKEN,
6737: p_token1_value => SQLCODE,
6738: p_token2 => G_SQLERRM_TOKEN,
6739: p_token2_value => SQLERRM);
6740: FND_MSG_PUB.Count_And_Get
6741: (p_count => x_msg_count,
6742:
6743: p_data => x_msg_data);
6744:

Line 6848: FND_MSG_PUB.initialize;

6844: END IF;
6845:
6846: -- Initialize message list if requested
6847: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
6848: FND_MSG_PUB.initialize;
6849: END IF;
6850:
6851: -- Initialize API status to success
6852: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 7000: FND_MSG_PUB.Count_And_Get

6996:
6997: /*** End API body ******************************************************/
6998:
6999: -- Get message count and if count is 1, get message info
7000: FND_MSG_PUB.Count_And_Get
7001: (p_count => x_msg_count,
7002: p_data => x_msg_data);
7003:
7004: EXCEPTION

Line 7008: FND_MSG_PUB.Count_And_Get

7004: EXCEPTION
7005: WHEN OKL_API.G_EXCEPTION_ERROR THEN
7006: ROLLBACK TO CREATE_FUNDING_ASSETS_PVT;
7007: x_return_status := OKL_API.G_RET_STS_ERROR;
7008: FND_MSG_PUB.Count_And_Get
7009: (p_count => x_msg_count,
7010: p_data => x_msg_data);
7011:
7012: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 7015: FND_MSG_PUB.Count_And_Get

7011:
7012: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
7013: ROLLBACK TO CREATE_FUNDING_ASSETS_PVT;
7014: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
7015: FND_MSG_PUB.Count_And_Get
7016: (p_count => x_msg_count,
7017: p_data => x_msg_data);
7018:
7019: WHEN OTHERS THEN

Line 7029: FND_MSG_PUB.Count_And_Get

7025: p_token1 => G_SQLCODE_TOKEN,
7026: p_token1_value => SQLCODE,
7027: p_token2 => G_SQLERRM_TOKEN,
7028: p_token2_value => SQLERRM);
7029: FND_MSG_PUB.Count_And_Get
7030: (p_count => x_msg_count,
7031: p_data => x_msg_data);
7032:
7033:

Line 8379: FND_MSG_PUB.initialize;

8375: END IF;
8376:
8377: -- Initialize message list if requested
8378: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
8379: FND_MSG_PUB.initialize;
8380: END IF;
8381:
8382: -- Initialize API status to success
8383: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 8395: FND_MSG_PUB.Count_And_Get

8391:
8392: /*** End API body ******************************************************/
8393:
8394: -- Get message count and if count is 1, get message info
8395: FND_MSG_PUB.Count_And_Get
8396: (p_count => x_msg_count,
8397: p_data => x_msg_data);
8398:
8399: EXCEPTION

Line 8403: FND_MSG_PUB.Count_And_Get

8399: EXCEPTION
8400: WHEN OKL_API.G_EXCEPTION_ERROR THEN
8401: ROLLBACK TO contract_fee_canbe_funded;
8402: x_return_status := OKL_API.G_RET_STS_ERROR;
8403: FND_MSG_PUB.Count_And_Get
8404: (p_count => x_msg_count,
8405: p_data => x_msg_data);
8406:
8407: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 8410: FND_MSG_PUB.Count_And_Get

8406:
8407: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
8408: ROLLBACK TO contract_fee_canbe_funded;
8409: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
8410: FND_MSG_PUB.Count_And_Get
8411: (p_count => x_msg_count,
8412: p_data => x_msg_data);
8413:
8414: WHEN OTHERS THEN

Line 8424: FND_MSG_PUB.Count_And_Get

8420: p_token1 => G_SQLCODE_TOKEN,
8421: p_token1_value => SQLCODE,
8422: p_token2 => G_SQLERRM_TOKEN,
8423: p_token2_value => SQLERRM);
8424: FND_MSG_PUB.Count_And_Get
8425: (p_count => x_msg_count,
8426: p_data => x_msg_data);
8427:
8428:

Line 8721: FND_MSG_PUB.initialize;

8717: END IF;
8718:
8719: -- Initialize message list if requested
8720: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
8721: FND_MSG_PUB.initialize;
8722: END IF;
8723:
8724: -- Initialize API status to success
8725: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 8735: FND_MSG_PUB.Count_And_Get

8731:
8732: /*** End API body ******************************************************/
8733:
8734: -- Get message count and if count is 1, get message info
8735: FND_MSG_PUB.Count_And_Get
8736: (p_count => x_msg_count,
8737: p_data => x_msg_data);
8738:
8739: EXCEPTION

Line 8743: FND_MSG_PUB.Count_And_Get

8739: EXCEPTION
8740: WHEN OKL_API.G_EXCEPTION_ERROR THEN
8741: ROLLBACK TO is_contract_fully_funded;
8742: x_return_status := OKL_API.G_RET_STS_ERROR;
8743: FND_MSG_PUB.Count_And_Get
8744: (p_count => x_msg_count,
8745: p_data => x_msg_data);
8746:
8747: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 8750: FND_MSG_PUB.Count_And_Get

8746:
8747: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
8748: ROLLBACK TO is_contract_fully_funded;
8749: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
8750: FND_MSG_PUB.Count_And_Get
8751: (p_count => x_msg_count,
8752: p_data => x_msg_data);
8753:
8754: WHEN OTHERS THEN

Line 8764: FND_MSG_PUB.Count_And_Get

8760: p_token1 => G_SQLCODE_TOKEN,
8761: p_token1_value => SQLCODE,
8762: p_token2 => G_SQLERRM_TOKEN,
8763: p_token2_value => SQLERRM);
8764: FND_MSG_PUB.Count_And_Get
8765: (p_count => x_msg_count,
8766: p_data => x_msg_data);
8767:
8768:

Line 8962: FND_MSG_PUB.initialize;

8958: END IF;
8959:
8960: -- Initialize message list if requested
8961: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
8962: FND_MSG_PUB.initialize;
8963: END IF;
8964:
8965: -- Initialize API status to success
8966: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 9001: FND_MSG_PUB.Count_And_Get

8997:
8998: EXCEPTION
8999: WHEN OKL_API.G_EXCEPTION_ERROR THEN
9000: lp_fund_rst := 'ERROR';
9001: FND_MSG_PUB.Count_And_Get
9002: (p_count => x_msg_count,
9003: p_data => x_msg_data);
9004: lp_msg_data := substr('Application error: ' || x_msg_data, 240);
9005:

Line 9008: FND_MSG_PUB.Count_And_Get

9004: lp_msg_data := substr('Application error: ' || x_msg_data, 240);
9005:
9006: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
9007: lp_fund_rst := 'ERROR';
9008: FND_MSG_PUB.Count_And_Get
9009: (p_count => x_msg_count,
9010: p_data => x_msg_data);
9011: lp_msg_data := substr('Unexpected application error: ' || x_msg_data, 240);
9012:

Line 9047: FND_MSG_PUB.Count_And_Get

9043:
9044: /*** End API body ******************************************************/
9045:
9046: -- Get message count and if count is 1, get message info
9047: FND_MSG_PUB.Count_And_Get
9048: (p_count => x_msg_count,
9049: p_data => x_msg_data);
9050:
9051: EXCEPTION

Line 9055: FND_MSG_PUB.Count_And_Get

9051: EXCEPTION
9052: WHEN OKL_API.G_EXCEPTION_ERROR THEN
9053: ROLLBACK TO update_checklist_function;
9054: x_return_status := OKL_API.G_RET_STS_ERROR;
9055: FND_MSG_PUB.Count_And_Get
9056: (p_count => x_msg_count,
9057: p_data => x_msg_data);
9058:
9059: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 9062: FND_MSG_PUB.Count_And_Get

9058:
9059: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
9060: ROLLBACK TO update_checklist_function;
9061: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
9062: FND_MSG_PUB.Count_And_Get
9063: (p_count => x_msg_count,
9064: p_data => x_msg_data);
9065:
9066: WHEN OTHERS THEN

Line 9076: FND_MSG_PUB.Count_And_Get

9072: p_token1 => G_SQLCODE_TOKEN,
9073: p_token1_value => SQLCODE,
9074: p_token2 => G_SQLERRM_TOKEN,
9075: p_token2_value => SQLERRM);
9076: FND_MSG_PUB.Count_And_Get
9077: (p_count => x_msg_count,
9078: p_data => x_msg_data);
9079:
9080: end update_checklist_function;