DBA Data[Home] [Help]

APPS.GR_PROCESS_ORDERS dependencies on FND_MESSAGE

Line 720: FND_MESSAGE.SET_NAME('GR',

716:
717: l_oracle_error := SQLCODE;
718: /*l_code_block := SUBSTR(SQLERRM, 1, 200);*/
719: l_code_block := l_code_block || ' ' || TO_CHAR(l_oracle_error);
720: FND_MESSAGE.SET_NAME('GR',
721: 'GR_UNEXPECTED_ERROR');
722: FND_MESSAGE.SET_TOKEN('TEXT',
723: l_code_block||sqlerrm,
724: FALSE);

Line 722: FND_MESSAGE.SET_TOKEN('TEXT',

718: /*l_code_block := SUBSTR(SQLERRM, 1, 200);*/
719: l_code_block := l_code_block || ' ' || TO_CHAR(l_oracle_error);
720: FND_MESSAGE.SET_NAME('GR',
721: 'GR_UNEXPECTED_ERROR');
722: FND_MESSAGE.SET_TOKEN('TEXT',
723: l_code_block||sqlerrm,
724: FALSE);
725: --utl_file.fflush(pg_fp);
726: --utl_file.fclose(pg_fp);

Line 1745: FND_MESSAGE.SET_NAME('GR',

1741: WHEN OTHERS THEN
1742: l_oracle_error := SQLCODE;
1743: /*l_code_block := SUBSTR(SQLERRM, 1, 200);*/
1744: l_code_block := l_code_block || ' ' || TO_CHAR(l_oracle_error);
1745: FND_MESSAGE.SET_NAME('GR',
1746: 'GR_UNEXPECTED_ERROR');
1747: FND_MESSAGE.SET_TOKEN('TEXT',
1748: l_code_block||sqlerrm,
1749: FALSE);

Line 1747: FND_MESSAGE.SET_TOKEN('TEXT',

1743: /*l_code_block := SUBSTR(SQLERRM, 1, 200);*/
1744: l_code_block := l_code_block || ' ' || TO_CHAR(l_oracle_error);
1745: FND_MESSAGE.SET_NAME('GR',
1746: 'GR_UNEXPECTED_ERROR');
1747: FND_MESSAGE.SET_TOKEN('TEXT',
1748: l_code_block||sqlerrm,
1749: FALSE);
1750: APP_EXCEPTION.Raise_Exception;
1751: /*utl_file.fflush(pg_fp);

Line 2186: FND_MESSAGE.SET_NAME('GR', 'GR_NULL_BATCH_NUMBER');

2182: END IF;
2183: END IF; /* NOT FND_API.TO_BOOLEAN(l_key_exists) */
2184: END IF; /* l_item_code IS NOT NULL */
2185: ELSE
2186: FND_MESSAGE.SET_NAME('GR', 'GR_NULL_BATCH_NUMBER');
2187: FND_FILE.PUT(FND_FILE.LOG, FND_MESSAGE.GET);
2188: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
2189: END IF; /* BatchDetails.document_code IS NOT NULL */
2190: /*

Line 2187: FND_FILE.PUT(FND_FILE.LOG, FND_MESSAGE.GET);

2183: END IF; /* NOT FND_API.TO_BOOLEAN(l_key_exists) */
2184: END IF; /* l_item_code IS NOT NULL */
2185: ELSE
2186: FND_MESSAGE.SET_NAME('GR', 'GR_NULL_BATCH_NUMBER');
2187: FND_FILE.PUT(FND_FILE.LOG, FND_MESSAGE.GET);
2188: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
2189: END IF; /* BatchDetails.document_code IS NOT NULL */
2190: /*
2191: ** Update the line status

Line 2360: FND_MESSAGE.SET_NAME('GR',

2356: WHEN OTHERS THEN
2357: ROLLBACK TO SAVEPOINT Update_Dispatch_History;
2358: l_oracle_error := SQLCODE;
2359: l_code_block := l_code_block || ' ' || TO_CHAR(l_oracle_error);
2360: FND_MESSAGE.SET_NAME('GR',
2361: 'GR_UNEXPECTED_ERROR');
2362: FND_MESSAGE.SET_TOKEN('TEXT',
2363: l_code_block||sqlerrm,
2364: FALSE);

Line 2362: FND_MESSAGE.SET_TOKEN('TEXT',

2358: l_oracle_error := SQLCODE;
2359: l_code_block := l_code_block || ' ' || TO_CHAR(l_oracle_error);
2360: FND_MESSAGE.SET_NAME('GR',
2361: 'GR_UNEXPECTED_ERROR');
2362: FND_MESSAGE.SET_TOKEN('TEXT',
2363: l_code_block||sqlerrm,
2364: FALSE);
2365: END Update_Dispatch_History;
2366: /*

Line 3750: FND_MESSAGE.SET_NAME('GR',

3746: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
3747: l_oracle_error := SQLCODE;
3748: /*l_code_block := SUBSTR(SQLERRM, 1, 200);*/
3749: l_code_block := l_code_block || ' ' || TO_CHAR(l_oracle_error);
3750: FND_MESSAGE.SET_NAME('GR',
3751: 'GR_UNEXPECTED_ERROR');
3752: FND_MESSAGE.SET_TOKEN('TEXT',
3753: l_code_block||sqlerrm,
3754: FALSE);

Line 3752: FND_MESSAGE.SET_TOKEN('TEXT',

3748: /*l_code_block := SUBSTR(SQLERRM, 1, 200);*/
3749: l_code_block := l_code_block || ' ' || TO_CHAR(l_oracle_error);
3750: FND_MESSAGE.SET_NAME('GR',
3751: 'GR_UNEXPECTED_ERROR');
3752: FND_MESSAGE.SET_TOKEN('TEXT',
3753: l_code_block||sqlerrm,
3754: FALSE);
3755:
3756: END Print_Recipients;

Line 3821: FND_MESSAGE.SET_NAME('GR',

3817: /*
3818: ** Get the message string
3819: */
3820: IF p_message_code IS NOT NULL THEN
3821: FND_MESSAGE.SET_NAME('GR',
3822: p_message_code);
3823: IF p_token_name IS NOT NULL THEN
3824: FND_MESSAGE.SET_TOKEN(p_token_name,
3825: p_token_value,

Line 3824: FND_MESSAGE.SET_TOKEN(p_token_name,

3820: IF p_message_code IS NOT NULL THEN
3821: FND_MESSAGE.SET_NAME('GR',
3822: p_message_code);
3823: IF p_token_name IS NOT NULL THEN
3824: FND_MESSAGE.SET_TOKEN(p_token_name,
3825: p_token_value,
3826: FALSE);
3827: END IF;
3828: l_selection_message := FND_MESSAGE.Get;

Line 3828: l_selection_message := FND_MESSAGE.Get;

3824: FND_MESSAGE.SET_TOKEN(p_token_name,
3825: p_token_value,
3826: FALSE);
3827: END IF;
3828: l_selection_message := FND_MESSAGE.Get;
3829: END IF;
3830: /*
3831: ** Set the status based on the print flag.
3832: ** If the print flag is set to 'Y' the line status

Line 4199: FND_MESSAGE.SET_NAME('GR', 'GR_ORDER_ALREADY_SELECTED');

4195: RAISE Selection_Insert_Error;
4196: END IF;
4197: ELSE /* added for 2286375 rework*/
4198: --utl_file.put_line(pg_fp, 'else ');
4199: FND_MESSAGE.SET_NAME('GR', 'GR_ORDER_ALREADY_SELECTED');
4200: FND_MESSAGE.SET_TOKEN('CODE', '');
4201: FND_FILE.PUT(FND_FILE.LOG, FND_MESSAGE.GET);
4202: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
4203: END IF;

Line 4200: FND_MESSAGE.SET_TOKEN('CODE', '');

4196: END IF;
4197: ELSE /* added for 2286375 rework*/
4198: --utl_file.put_line(pg_fp, 'else ');
4199: FND_MESSAGE.SET_NAME('GR', 'GR_ORDER_ALREADY_SELECTED');
4200: FND_MESSAGE.SET_TOKEN('CODE', '');
4201: FND_FILE.PUT(FND_FILE.LOG, FND_MESSAGE.GET);
4202: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
4203: END IF;
4204: ELSIF GlobalRecipient.document_print_frequency = 'S' THEN

Line 4201: FND_FILE.PUT(FND_FILE.LOG, FND_MESSAGE.GET);

4197: ELSE /* added for 2286375 rework*/
4198: --utl_file.put_line(pg_fp, 'else ');
4199: FND_MESSAGE.SET_NAME('GR', 'GR_ORDER_ALREADY_SELECTED');
4200: FND_MESSAGE.SET_TOKEN('CODE', '');
4201: FND_FILE.PUT(FND_FILE.LOG, FND_MESSAGE.GET);
4202: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
4203: END IF;
4204: ELSIF GlobalRecipient.document_print_frequency = 'S' THEN
4205: --utl_file.put_line(pg_fp, 'S');

Line 4224: FND_MESSAGE.SET_NAME('GR', 'GR_ORDER_ALREADY_SELECTED');

4220: IF l_return_status <> 'S' THEN
4221: RAISE Selection_Insert_Error;
4222: END IF;
4223: ELSE /* added for 2286375 rework*/
4224: FND_MESSAGE.SET_NAME('GR', 'GR_ORDER_ALREADY_SELECTED');
4225: FND_MESSAGE.SET_TOKEN('CODE', '');
4226: FND_FILE.PUT(FND_FILE.LOG, FND_MESSAGE.GET);
4227: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
4228: END IF;

Line 4225: FND_MESSAGE.SET_TOKEN('CODE', '');

4221: RAISE Selection_Insert_Error;
4222: END IF;
4223: ELSE /* added for 2286375 rework*/
4224: FND_MESSAGE.SET_NAME('GR', 'GR_ORDER_ALREADY_SELECTED');
4225: FND_MESSAGE.SET_TOKEN('CODE', '');
4226: FND_FILE.PUT(FND_FILE.LOG, FND_MESSAGE.GET);
4227: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
4228: END IF;
4229: ELSIF GlobalRecipient.document_print_frequency = 'Y' THEN

Line 4226: FND_FILE.PUT(FND_FILE.LOG, FND_MESSAGE.GET);

4222: END IF;
4223: ELSE /* added for 2286375 rework*/
4224: FND_MESSAGE.SET_NAME('GR', 'GR_ORDER_ALREADY_SELECTED');
4225: FND_MESSAGE.SET_TOKEN('CODE', '');
4226: FND_FILE.PUT(FND_FILE.LOG, FND_MESSAGE.GET);
4227: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
4228: END IF;
4229: ELSIF GlobalRecipient.document_print_frequency = 'Y' THEN
4230: --utl_file.put_line(pg_fp, 'Y');

Line 4249: FND_MESSAGE.SET_NAME('GR', 'GR_ORDER_ALREADY_SELECTED');

4245: IF l_return_status <> 'S' THEN
4246: RAISE Selection_Insert_Error;
4247: END IF;
4248: ELSE /* added for 2286375 rework*/
4249: FND_MESSAGE.SET_NAME('GR', 'GR_ORDER_ALREADY_SELECTED');
4250: FND_MESSAGE.SET_TOKEN('CODE', '');
4251: FND_FILE.PUT(FND_FILE.LOG, FND_MESSAGE.GET);
4252: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
4253: END IF;

Line 4250: FND_MESSAGE.SET_TOKEN('CODE', '');

4246: RAISE Selection_Insert_Error;
4247: END IF;
4248: ELSE /* added for 2286375 rework*/
4249: FND_MESSAGE.SET_NAME('GR', 'GR_ORDER_ALREADY_SELECTED');
4250: FND_MESSAGE.SET_TOKEN('CODE', '');
4251: FND_FILE.PUT(FND_FILE.LOG, FND_MESSAGE.GET);
4252: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
4253: END IF;
4254: /* GK B1253943 - added in code for testing print freq for different time periods*/

Line 4251: FND_FILE.PUT(FND_FILE.LOG, FND_MESSAGE.GET);

4247: END IF;
4248: ELSE /* added for 2286375 rework*/
4249: FND_MESSAGE.SET_NAME('GR', 'GR_ORDER_ALREADY_SELECTED');
4250: FND_MESSAGE.SET_TOKEN('CODE', '');
4251: FND_FILE.PUT(FND_FILE.LOG, FND_MESSAGE.GET);
4252: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
4253: END IF;
4254: /* GK B1253943 - added in code for testing print freq for different time periods*/
4255: /*ELSIF GlobalRecipient.document_print_frequency = 'R' THEN

Line 4315: FND_MESSAGE.SET_NAME('GR',

4311: WHEN OTHERS THEN
4312: l_oracle_error := SQLCODE;
4313: /*l_code_block := SUBSTR(SQLERRM, 1, 200); */
4314: l_code_block := l_code_block || ' ' || TO_CHAR(l_oracle_error);
4315: FND_MESSAGE.SET_NAME('GR',
4316: 'GR_UNEXPECTED_ERROR');
4317: FND_MESSAGE.SET_TOKEN('TEXT',
4318: l_code_block||sqlerrm,
4319: FALSE);

Line 4317: FND_MESSAGE.SET_TOKEN('TEXT',

4313: /*l_code_block := SUBSTR(SQLERRM, 1, 200); */
4314: l_code_block := l_code_block || ' ' || TO_CHAR(l_oracle_error);
4315: FND_MESSAGE.SET_NAME('GR',
4316: 'GR_UNEXPECTED_ERROR');
4317: FND_MESSAGE.SET_TOKEN('TEXT',
4318: l_code_block||sqlerrm,
4319: FALSE);
4320: --utl_file.fflush(pg_fp);
4321: -- utl_file.fclose(pg_fp);

Line 5536: FND_MESSAGE.SET_NAME('GR',

5532:
5533: BEGIN
5534:
5535: x_return_status := FND_API.G_RET_STS_ERROR;
5536: FND_MESSAGE.SET_NAME('GR',
5537: p_message_code);
5538: IF p_token_name IS NOT NULL THEN
5539: FND_MESSAGE.SET_TOKEN(p_token_name,
5540: p_token_value,

Line 5539: FND_MESSAGE.SET_TOKEN(p_token_name,

5535: x_return_status := FND_API.G_RET_STS_ERROR;
5536: FND_MESSAGE.SET_NAME('GR',
5537: p_message_code);
5538: IF p_token_name IS NOT NULL THEN
5539: FND_MESSAGE.SET_TOKEN(p_token_name,
5540: p_token_value,
5541: FALSE);
5542: END IF;
5543: