eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSP_RECEIVE_PVT dependencies on FND_MSG_PUB

Line 12: If fnd_msg_pub.count_msg > 0 Then

8: l_msg_index_out NUMBER;
9: x_msg_data_temp Varchar2(2000);
10: x_msg_data Varchar2(4000);
11: Begin
12: If fnd_msg_pub.count_msg > 0 Then
13: FOR i IN REVERSE 1..fnd_msg_pub.count_msg Loop
14: fnd_msg_pub.get(p_msg_index => i,
15: p_encoded => 'F',
16: p_data => x_msg_data_temp,

Line 13: FOR i IN REVERSE 1..fnd_msg_pub.count_msg Loop

9: x_msg_data_temp Varchar2(2000);
10: x_msg_data Varchar2(4000);
11: Begin
12: If fnd_msg_pub.count_msg > 0 Then
13: FOR i IN REVERSE 1..fnd_msg_pub.count_msg Loop
14: fnd_msg_pub.get(p_msg_index => i,
15: p_encoded => 'F',
16: p_data => x_msg_data_temp,
17: p_msg_index_out => l_msg_index_out);

Line 14: fnd_msg_pub.get(p_msg_index => i,

10: x_msg_data Varchar2(4000);
11: Begin
12: If fnd_msg_pub.count_msg > 0 Then
13: FOR i IN REVERSE 1..fnd_msg_pub.count_msg Loop
14: fnd_msg_pub.get(p_msg_index => i,
15: p_encoded => 'F',
16: p_data => x_msg_data_temp,
17: p_msg_index_out => l_msg_index_out);
18: x_msg_data := x_msg_data || x_msg_data_temp;

Line 21: -- fnd_msg_pub.delete_msg;

17: p_msg_index_out => l_msg_index_out);
18: x_msg_data := x_msg_data || x_msg_data_temp;
19: End Loop;
20: x_message := substr(x_msg_data,1,2000);
21: -- fnd_msg_pub.delete_msg;
22: End if;
23: End;
24:
25: PROCEDURE gen_receipt_num(

Line 66: fnd_msg_pub.add;

62:
63: IF (l_receipt_exists = 1) THEN
64: fnd_message.set_name('CSP','CSP_RECEIPT_NUM_EXISTS');
65: fnd_message.set_token('RECEIPT',x_receipt_num,false);
66: fnd_msg_pub.add;
67: RAISE FND_API.G_EXC_ERROR;
68: END IF;
69:
70: EXCEPTION

Line 75: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

71: WHEN FND_API.G_EXC_ERROR THEN
72: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
73: P_API_NAME => L_API_NAME
74: ,P_PKG_NAME => G_PKG_NAME
75: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
76: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
77: ,X_MSG_COUNT => X_MSG_COUNT
78: ,X_MSG_DATA => X_MSG_DATA
79: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 84: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

80: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
81: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
82: P_API_NAME => L_API_NAME
83: ,P_PKG_NAME => G_PKG_NAME
84: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
85: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
86: ,X_MSG_COUNT => X_MSG_COUNT
87: ,X_MSG_DATA => X_MSG_DATA
88: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 93: fnd_msg_pub.add;

89: WHEN OTHERS THEN
90: fnd_message.set_name('CSP','CSP_UNEXPECTED_EXEC_ERRORS');
91: fnd_message.set_token('ROUTINE',l_api_name,false);
92: fnd_message.set_token('SQLERRM',sqlerrm,false);
93: fnd_msg_pub.add;
94: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
95: P_API_NAME => L_API_NAME
96: ,P_PKG_NAME => G_PKG_NAME
97: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

Line 133: fnd_msg_pub.add;

129:
130: FND_PROFILE.GET('USER_ID', X_user_id);
131: if X_user_id is null then
132: fnd_message.set_name('CSP','CSP_INVALID_USER_ID');
133: fnd_msg_pub.add;
134: return False;
135: end if;
136: BEGIN
137: SELECT HR.EMPLOYEE_ID,

Line 238: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

234: WHEN FND_API.G_EXC_ERROR THEN
235: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
236: P_API_NAME => L_API_NAME
237: ,P_PKG_NAME => G_PKG_NAME
238: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
239: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
240: ,X_MSG_COUNT => X_MSG_COUNT
241: ,X_MSG_DATA => X_MSG_DATA
242: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 248: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

244: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
245: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
246: P_API_NAME => L_API_NAME
247: ,P_PKG_NAME => G_PKG_NAME
248: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
249: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
250: ,X_MSG_COUNT => X_MSG_COUNT
251: ,X_MSG_DATA => X_MSG_DATA
252: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 258: fnd_msg_pub.add;

254: WHEN OTHERS THEN
255: fnd_message.set_name('CSP','CSP_UNEXPECTED_EXEC_ERRORS');
256: fnd_message.set_token('ROUTINE',l_api_name,false);
257: fnd_message.set_token('SQLERRM',sqlerrm,false);
258: fnd_msg_pub.add;
259: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
260: P_API_NAME => L_API_NAME
261: ,P_PKG_NAME => G_PKG_NAME
262: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

Line 345: fnd_msg_pub.initialize;

341:
342:
343: -- Initialize message list
344: IF fnd_api.to_boolean(p_init_msg_list) THEN
345: fnd_msg_pub.initialize;
346: END IF;
347:
348:
349: -- Initialize API return status to SUCCESS

Line 502: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

498: WHEN FND_API.G_EXC_ERROR THEN
499: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
500: P_API_NAME => L_API_NAME
501: ,P_PKG_NAME => G_PKG_NAME
502: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
503: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
504: ,X_MSG_COUNT => X_MSG_COUNT
505: ,X_MSG_DATA => X_MESSAGE
506: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 511: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

507: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
508: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
509: P_API_NAME => L_API_NAME
510: ,P_PKG_NAME => G_PKG_NAME
511: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
512: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
513: ,X_MSG_COUNT => X_MSG_COUNT
514: ,X_MSG_DATA => X_MESSAGE
515: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 520: fnd_msg_pub.add;

516: WHEN OTHERS THEN
517: fnd_message.set_name('CSP','CSP_UNEXPECTED_EXEC_ERRORS');
518: fnd_message.set_token('ROUTINE',l_api_name,false);
519: fnd_message.set_token('SQLERRM',sqlerrm,false);
520: fnd_msg_pub.add;
521: get_messages(x_msg_data);
522: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
523: P_API_NAME => L_API_NAME
524: ,P_PKG_NAME => G_PKG_NAME

Line 587: fnd_msg_pub.initialize;

583: END IF;
584:
585: -- Initialize message list if p_init_msg_list is set to TRUE.
586: IF fnd_api.to_boolean(p_init_msg_list) THEN
587: fnd_msg_pub.initialize;
588: END IF;
589:
590: x_return_status := FND_API.G_RET_STS_SUCCESS;
591:

Line 696: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

692: WHEN FND_API.G_EXC_ERROR THEN
693: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
694: P_API_NAME => L_API_NAME
695: ,P_PKG_NAME => G_PKG_NAME
696: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
697: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
698: ,X_MSG_COUNT => X_MSG_COUNT
699: ,X_MSG_DATA => X_MSG_DATA
700: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 705: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

701: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
702: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
703: P_API_NAME => L_API_NAME
704: ,P_PKG_NAME => G_PKG_NAME
705: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
706: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
707: ,X_MSG_COUNT => X_MSG_COUNT
708: ,X_MSG_DATA => X_MSG_DATA
709: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 714: fnd_msg_pub.add;

710: WHEN OTHERS THEN
711: fnd_message.set_name('CSP','CSP_UNEXPECTED_EXEC_ERRORS');
712: fnd_message.set_token('ROUTINE',l_api_name,false);
713: fnd_message.set_token('SQLERRM',sqlerrm,false);
714: fnd_msg_pub.add;
715: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
716: P_API_NAME => L_API_NAME
717: ,P_PKG_NAME => G_PKG_NAME
718: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

Line 856: fnd_msg_pub.initialize;

852: END IF;
853:
854: -- Initialize message list if p_init_msg_list is set to TRUE.
855: IF fnd_api.to_boolean(p_init_msg_list) THEN
856: fnd_msg_pub.initialize;
857: END IF;
858:
859: x_return_status := FND_API.G_RET_STS_SUCCESS;
860:

Line 932: fnd_msg_pub.add;

928: WHEN OTHERS THEN
929: fnd_message.set_name('CSP','CSP_UNEXPECTED_EXEC_ERRORS');
930: fnd_message.set_token('ROUTINE','rcv_receipts_query_sv.post_query',false);
931: fnd_message.set_token('SQLERRM',sqlerrm,false);
932: fnd_msg_pub.add;
933: get_messages(x_msg_data);
934: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
935: END;
936:

Line 955: fnd_msg_pub.add;

951: WHEN OTHERS THEN
952: fnd_message.set_name('CSP','CSP_UNEXPECTED_EXEC_ERRORS');
953: fnd_message.set_token('ROUTINE','get receiving flag',false);
954: fnd_message.set_token('SQLERRM',sqlerrm,false);
955: fnd_msg_pub.add;
956: get_messages(x_msg_data);
957: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
958: END;
959:

Line 1426: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1422: WHEN FND_API.G_EXC_ERROR THEN
1423: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1424: P_API_NAME => L_API_NAME
1425: ,P_PKG_NAME => G_PKG_NAME
1426: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1427: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1428: ,X_MSG_COUNT => X_MSG_COUNT
1429: ,X_MSG_DATA => X_MESSAGE
1430: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1435: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

1431: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1432: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1433: P_API_NAME => L_API_NAME
1434: ,P_PKG_NAME => G_PKG_NAME
1435: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1436: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1437: ,X_MSG_COUNT => X_MSG_COUNT
1438: ,X_MSG_DATA => X_MESSAGE
1439: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1444: fnd_msg_pub.add;

1440: WHEN OTHERS THEN
1441: fnd_message.set_name('CSP','CSP_UNEXPECTED_EXEC_ERRORS');
1442: fnd_message.set_token('ROUTINE',l_api_name,false);
1443: fnd_message.set_token('SQLERRM',sqlerrm,false);
1444: fnd_msg_pub.add;
1445: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1446: P_API_NAME => L_API_NAME
1447: ,P_PKG_NAME => G_PKG_NAME
1448: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

Line 1639: fnd_msg_pub.initialize;

1635: END IF;
1636:
1637: -- Initialize message list if p_init_msg_list is set to TRUE.
1638: IF fnd_api.to_boolean(p_init_msg_list) THEN
1639: fnd_msg_pub.initialize;
1640: END IF;
1641:
1642: --Initialize the return status
1643: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1901: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1897: WHEN FND_API.G_EXC_ERROR THEN
1898: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1899: P_API_NAME => L_API_NAME
1900: ,P_PKG_NAME => G_PKG_NAME
1901: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1902: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1903: ,X_MSG_COUNT => X_MSG_COUNT
1904: ,X_MSG_DATA => X_MESSAGE
1905: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1910: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

1906: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1907: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1908: P_API_NAME => L_API_NAME
1909: ,P_PKG_NAME => G_PKG_NAME
1910: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1911: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1912: ,X_MSG_COUNT => X_MSG_COUNT
1913: ,X_MSG_DATA => X_MESSAGE
1914: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1919: fnd_msg_pub.add;

1915: WHEN OTHERS THEN
1916: fnd_message.set_name('CSP','CSP_UNEXPECTED_EXEC_ERRORS');
1917: fnd_message.set_token('ROUTINE',l_api_name,false);
1918: fnd_message.set_token('SQLERRM',sqlerrm,false);
1919: fnd_msg_pub.add;
1920: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1921: P_API_NAME => L_API_NAME
1922: ,P_PKG_NAME => G_PKG_NAME
1923: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

Line 2006: fnd_msg_pub.initialize;

2002: END IF;
2003:
2004: -- Initialize message list if p_init_msg_list is set to TRUE.
2005: IF fnd_api.to_boolean(p_init_msg_list) THEN
2006: fnd_msg_pub.initialize;
2007: END IF;
2008:
2009: --Initialize the return status
2010: x_return_status := fnd_api.g_ret_sts_success;

Line 2059: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

2055: WHEN FND_API.G_EXC_ERROR THEN
2056: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2057: P_API_NAME => L_API_NAME
2058: ,P_PKG_NAME => G_PKG_NAME
2059: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2060: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
2061: ,X_MSG_COUNT => X_MSG_COUNT
2062: ,X_MSG_DATA => X_MESSAGE
2063: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2068: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

2064: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2065: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2066: P_API_NAME => L_API_NAME
2067: ,P_PKG_NAME => G_PKG_NAME
2068: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2069: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
2070: ,X_MSG_COUNT => X_MSG_COUNT
2071: ,X_MSG_DATA => X_MESSAGE
2072: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2077: fnd_msg_pub.add;

2073: WHEN OTHERS THEN
2074: fnd_message.set_name('CSP','CSP_UNEXPECTED_EXEC_ERRORS');
2075: fnd_message.set_token('ROUTINE',l_api_name,false);
2076: fnd_message.set_token('SQLERRM',sqlerrm,false);
2077: fnd_msg_pub.add;
2078: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2079: P_API_NAME => L_API_NAME
2080: ,P_PKG_NAME => G_PKG_NAME
2081: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

Line 2148: fnd_msg_pub.ADD;

2144: FND_MESSAGE.set_name('FND','CONC-Error running standalone');
2145: fnd_message.set_token('PROGRAM', 'Receiving Transaction Manager - RCVOLTM');
2146: fnd_message.set_token('REQUEST', p_group_id);
2147: fnd_message.set_token('REASON', x_str);
2148: fnd_msg_pub.ADD;
2149: x_return_status := fnd_api.g_ret_sts_error;
2150: ELSIF (rc = 2) THEN
2151: fnd_message.set_name('FND', 'TM-SVC LOCK HANDLE FAILED');
2152: FND_MESSAGE.set_name('FND','CONC-Error running standalone');

Line 2156: fnd_msg_pub.ADD;

2152: FND_MESSAGE.set_name('FND','CONC-Error running standalone');
2153: fnd_message.set_token('PROGRAM', 'Receiving Transaction Manager - RCVOLTM');
2154: fnd_message.set_token('REQUEST', p_group_id);
2155: fnd_message.set_token('REASON', x_str);
2156: fnd_msg_pub.ADD;
2157: x_return_status := fnd_api.g_ret_sts_error;
2158: ELSIF (rc = 3 or
2159: (l_outcome IN ('WARNING', 'ERROR'))) THEN
2160: BEGIN

Line 2170: fnd_msg_pub.ADD;

2166: and pie.interface_header_id = rhi.header_interface_id
2167: and PROCESSING_STATUS_CODE = 'ERROR' ;
2168: FND_MESSAGE.set_name('CSP','CSP_PO_RECEIVE_ERROR');
2169: fnd_message.set_token('ERROR_MESSAGE', po_message );
2170: fnd_msg_pub.ADD;
2171: x_return_status := fnd_api.g_ret_sts_error;
2172: Exception
2173: when NO_DATA_FOUND THEN
2174:

Line 2195: FND_MSG_PUB.get(p_data => x_msg_data,

2191: UTL_FILE.PUT_LINE(debug_handler,'r_val8 ' || r_val18);
2192: UTL_FILE.PUT_LINE(debug_handler,'r_val9 ' || r_val19);
2193: UTL_FILE.PUT_LINE(debug_handler,'r_va20 ' || r_val20);
2194:
2195: FND_MSG_PUB.get(p_data => x_msg_data,
2196: p_msg_index_out => x_msg_count);
2197: UTL_FILE.PUT_LINE(debug_handler,'meesage count' || FND_MSG_PUB.Count_Msg);
2198: UTL_FILE.PUT_LINE(debug_handler,'x_msg_data ' || x_msg_data);
2199: UTL_FILE.PUT_LINE(debug_handler,'x_msg_data ' || x_msg_count);

Line 2197: UTL_FILE.PUT_LINE(debug_handler,'meesage count' || FND_MSG_PUB.Count_Msg);

2193: UTL_FILE.PUT_LINE(debug_handler,'r_va20 ' || r_val20);
2194:
2195: FND_MSG_PUB.get(p_data => x_msg_data,
2196: p_msg_index_out => x_msg_count);
2197: UTL_FILE.PUT_LINE(debug_handler,'meesage count' || FND_MSG_PUB.Count_Msg);
2198: UTL_FILE.PUT_LINE(debug_handler,'x_msg_data ' || x_msg_data);
2199: UTL_FILE.PUT_LINE(debug_handler,'x_msg_data ' || x_msg_count);
2200: UTL_FILE.FCLOSE(debug_handler);
2201: END IF;*/

Line 2264: fnd_msg_pub.ADD;

2260: FND_MESSAGE.set_name('FND','CONC-Error running standalone');
2261: fnd_message.set_token('PROGRAM', 'Receiving Transaction Manager - RCVOLTM');
2262: fnd_message.set_token('REQUEST', p_group_id);
2263: fnd_message.set_token('REASON', x_str);
2264: fnd_msg_pub.ADD;
2265: x_return_status := fnd_api.g_ret_sts_error;
2266: END;
2267: END IF;
2268: EXCEPTION

Line 2273: fnd_msg_pub.add;

2269: WHEN OTHERS THEN
2270: fnd_message.set_name('CSP','CSP_UNEXPECTED_EXEC_ERRORS');
2271: fnd_message.set_token('ROUTINE',l_api_name,FALSE);
2272: fnd_message.set_token('SQLERRM',sqlerrm,FALSE);
2273: fnd_msg_pub.add;
2274: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2275: END rcv_online_request;
2276:
2277: /*